graphic2
graphic1

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

pic1

Spelling Counts

3. Try it: Spell the Field Name Wrong

Right click the FullName Field and Zoom to see the code. Please edit the expression as follows:

Delete the last brace: }
Type a bracket: ]

Edit the Field Name. Type: Last Name

Click OK to close the Zoom Window. You should return to the Query.

 

Try This, Too: Run the Query

Go to Query Design Tools ->Design->Results

Click on Run.

 

What Do You See? Microsoft Access will ask you to Enter Parameter Value for Last Name. This means that the database could not find Field for Last Name in tblCustomers. The Table has a Field for LastName. They do not match. 

Click Cancel.

 

OK. OK. That's enough error testing for now. Close the sample Select Query without saving.

Query Design Tools ->Design->Results->Run