Exam 16: Access: Querying a Database

Case 2-2 Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013. -What criteria should Bavant enter in the Start Date column of the design grid?

Crosstab queries are useful for summarizing data by category or group.

Joining tables in a query creates an ad hoc relationship,that is,a relationship between tables created for a specific purpose.

Identify the letter of the choice that best matches the phrase or definition. -Represents any individual character.

For group calculations,Microsoft Access supports ____ built-in statistics.

To include all fields in the design grid,double-click the question mark (?)in the field list.____________________

To include the Total row in the design grid,click the ____ button on the DESIGN tab.

To find all customers whose names begin with S,enter S? in the Criteria row of the design grid.

-In the accompanying figure,you can remove a column by tapping or clicking just above the field name to select the column and then tapping or clicking the ____ key(s).

In ____________________ files,the width of any field is the same on every record.

To find all individuals whose name is Robin or Robyn,enter ____ in the Criteria row of the appropriate column.

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar.____________________

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

The ____________________ is an Access tool that helps you create complex expressions.

You can export data from Access to the standard Word format.

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 find all customers whose returns are greater than $0.00 or whose book rep is book rep number 42,enter each criterion on the same row.

Identify the letter of the choice that best matches the phrase or definition. -Use to select values in a given range.

To include calculated fields in queries,enter a name for the calculated field,a(n)____,and then the expression in one of the columns in the Field row.

To find all customers whose returns are greater than $0.00 and whose book rep is book rep number 42,enter each criterion on the same row.