graphic2
graphci1

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

Hello, Query Design

2. Try it: Review the Query Design

The best feature in Microsoft Access is the Query Design. The Query By Example (QBE) is a visual format for programming.

 

At the top of the Query are the Record Sources. In this example, the Record Source is a Table: tblMovies.

 

The bottom of the Query is the QBE Grid. These are the three Fields that were selected in the Query Wizard:

MovieID

Movie

Year

 

What Else Do You See? The QBE Grid lists the name of the Table that each Field comes from.

 

Keep going...

Query Tools ->Design