Exam 8: Access

If the focus in a form moves from left to right and you want the focus to move from top to bottom, change the _____.

Use the _____ Table Manager to manage a split database.

Clicking a command button or making an entry in a field is considered a(n) ____.

You use the Performance Analyzer to analyze tables only.

The _____ property creates an easy-to-use visual guide to help users enter accurate data.

A _____ is a grid that displays fields as columns and records as rows.

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.

In Table Datasheet view, you must use a property sheet to increase the decimal places in a Number field.

You can create an Access report by selecting fields from one or more tables or _____.

In a macro, arguments provide _____.

Which of the following tools can you use to create a query?

If you set 100 as the Default Value property for the Rate field, 100 is inserted in the Rate field for all new records only.

In a database with a Products table and Orders table, you want to see which products have not been ordered.What type of query should you create?

Which of the following are views you can use to display a query? Select all the options that apply.

A field's Required property determines whether users must enter a value in the field.

In a datasheet, what do you click to select a record for deletion?

If you want the State field to display "Iowa" in each new form record, you set the Control Value property for the State field.

What button do you use on the Query Tools Design tab to add a field list to a query?

Which of the following are common report enhancements?

Which of the following controls would you use to describe another control on a report?