Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.1 Create a Query : Edit Queries

Common Query Errors There are several common Query errors. Each mistake has it a different error message. The following pages will look at two Query mistakes: punctuation and spelling.   1. Try This: Create a Sample Query Go to Create ->Queries-> Query Design. Select a Table: tblCustomers Click Add. Click Close   Try it: Add Fields to the Query Go to tblCustomer. Double click to select the following Fields: CustomerID FirstName LastName   Try it: Concatenate Two Name Fields Place your cursor in Column 4. Type: FullName:[FirstName]&" "&[LastName] Fullname is the label, or alias, for the new field. [FirstName] and [LastName] are Fields from tblCustomer. The two quotes have a space between them. Query Design Tools ->Design->Results->Run