graphic2
graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.2 Modify a Query: Modify a Query in Design View

More Questions, More Fields

This Report needs the customer's address as well as the name and phone number. Please take this Query into Design View and add two new Fields.

 

4. Try it: Go to Design View

The Query is still open in Datasheet View.

Go to Home ->Views->View.

Select a View: Design View.

 

What Do You See? There is one table at the top: tblCustomers. There are 4 Fields in the QBE Grid on the bottom:

CustomerID

FirstName

LastName

HomePhone

 

The HomePhone Field has a Parameter in the Criteria Row: [Enter the phone number].

 

Keep going...

Home ->Views->View->Design View

pic1