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

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Add a Field