Exam 4: Access: Querying a Database

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

You can include ____ in calculations to indicate which calculation should be done first.

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

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 save a query, the query design must appear on the screen.

To include the Total row in the design grid, click the _____ button on the Design tab.

When you create a query, you should follow some general guidelines for query design. What are these six guidelines?