I am adjunct currently teaching Intro to Databases. An example in the text books for creating new views in SQL in Access 2013 is as follows
CREATE VIEW Games AS
SELECT ItemNum, Description, OnHand, Price
FROM ITEM
WHERE Category='GME'
When I run the query it gives me a syntax error in the...