I notice that you have spaces in the column names. Object names which include spaces or other special characters must be enclosed in square brackets, e.g.
SELECT [item id], [item name], [item description]
FROM Items
ORDER BY [item name];
It is better not to use spaces in object names, however, but to use CamelCase, e.g.
SELECT ItemId, ItemName, ItemDescription
FROM Items
ORDER BY ItemName;
or to represent spaces by underscore characters:
SELECT item_id, item_name, item_description
FROM Items
ORDER BY item_name;
Ken Sheridan, Stafford, England