Exam 4: Access: Querying a Database

To sort records by amount paid within recruiter number, specify Recruiter Number as the ____________________ key.

Figure 2-1 In the accompanying figure, you can delete the table by right-clicking the field list and clicking ____ on the shortcut menu.

A question that is asked of Access or any other database management system is called a(n)____________________.

To find all clients whose amount paid is greater than $20,000.00 and whose recruiter is recruiter 21, enter each criterion on the same line.

When tables are joined in a query, it is not possible to restrict retrieval by using criteria.

If you specify more than one sort key, the sort key on the left will be the minor sort key and the one on the right will be the major sort key.

To sort records in a query, specify the sort order in the _____ row of the design grid below the field that is the sort key.

To organize the Navigation Pane by type of object rather than table, click Organize by Object on the Navigation Pane menu.

Figure 2-2 In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is greater than $10,000.00, erase the 0 and enter _____ in the Criteria row of the Current Due column.

Figure 2-1 In the accompanying figure, you can enter FD89 in the ____ row of the Client Number field to find all clients whose client number is FD89.

To quit Access, click the ____ button on the right side of the Access title bar.

A group function is a function that performs some mathematical function against a group of records.

Less than ( ), and NOT (not equal to)are examples of _____.

The field or fields on which records are sorted is called the sort key.

____________________ properties are the properties that indicate which records appear in a join.

Figure 2-1 In the accompanying figure, the lower pane in the window where you enter criteria is called the ____.

A(n)____ join is the default join in Access

Figure 2-1 In the accompanying figure, the Client table was added to the query by selecting the table and clicking the Add button in the ____ dialog box.

Grouping means creating groups of records that share some common characteristic.