Exam 1: Access: Introduction to Access

Match the following with their description: I. <>, =., >, < II. AND, OR, NOT III. Contains "Bill" IV. Tabs Documents interface V. Oracle A. Could be used in a selection filter B. Objects open in their own area under the Ribbon. C. Comparison operators D. A more advanced DBMS E. Boolean operators

What type of filter displays records based on a criterion you choose?

Reports cannot change ________, they only display it.

Searching a website to help you find just the right product involves database technology.

When you close a table after using a selection filter and then reopen it, what happens to the filter?

A primary key can be a combination of several fields.

The ________ command helps you locate specific records.

Using a template to create a database is not an effective use of time because of all the modifications you need to make so the database will fit your needs.

Using the Compact and Repair Database utility on a regular basis is good practice.

Unlike other Office applications, Access works mostly from ________.

Match the following terms with their description: I. Table II. Record III. Form IV. Report V. Query A. A collection of records B. A collection of fields C. Selecting, organizing, sorting and filtering fields from one or more tables D. Displaying data in a way that the data can't be edited E. Used to enter data