Exam 4: Access: Querying a Database

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

You can use a filter in either Datasheet view or Form view.

To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.

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

Computations available for the Total row in a column that contains currency include ____.

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

To filter records using complex criteria, click the ____ button on the Home tab and then click Advanced Filter/Sort on the menu that appears.

A ____ field allows the user to select from a list of values.

To add the Business Analyst and Client tables to the Relationships window shown in the accompanying figure, click the Add button in the ___________________ dialog box.

When specifying referential integrity, one way to handle deletions is to _________________________; that is, have Access allow the deletion but then automatically delete any related records in other tables.

The button on the Access Status bar that displays a form in Form view is Form View.

Validation rules can indicate a ____.

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

Validation rules ensure validity of the data in the database, while entity integrity ensures the validity of the relationships.

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

To use the shortcut menu to create an update query, right-click any open area in the upper pane, point to ____ on the shortcut menu, and then click Query Type on the submenu that appears.

To include all fields for a table in the design grid, click the ____________________ in the field list .

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid.The parameter must be enclosed in _____.