graphic2
graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.2 Modify a Query: Add New Fields

Add Fields to the Query

There is a Table at the top of the Query: tblCustomers. However, the QBE grid is still blank. Let's add the names.

 

2. Try it: Add Fields to the Query

Go to tblCustomers.

Double click to select the following Fields:

CustomerID

FirstName

LastName

 

What Do You See? By default, all of these Fields has a check mark for Show. That means they will be visible when you Run the Query.

 

It's a start.

Keep going...

Query Tools ->Design