Exam 11: Working With Data

The most common type of relationship to set up is a(n) ____ relationship, in which the primary key field in one table is associated with multiple records in a second table.

The simplest way to sort a table is to select a field that matches your criterion, and then use the Equals command to display those records that match the selection

One way to modify a(n) query is to set criteria for the fields

Because a(n) filter is a database object, you can save it for later use

Explain the importance of good database design.

You can save a filter as part of the table or form you are working on.

A filter can be toggled on and off to remove it and then reapply it.

The Enforce Referential ___________ feature tells Access to reject any attempts to enter data that would be inconsistent.

In the accompanying figure, item 5 points to the ____.

You can set up a ____ between two tables so that you can use the fields from both tables in a query.

You can apply a(n) ____ Filter to a selected field to filter records that are greater than, less than, or equal to a specific number, or between two different numbers.

Sorting in order alphabetically from A to Z or numerically from 0 to 9 is known as ____ order.

The simplest way to create a query is to use the Query Wizard

When you click Click to Add, point to Calculated Field, and then click Currency, the _______________ Builder dialog box opens so that you can easily create the expression you want by specifying fields, values, and operators.

One difference between opening an Access database and opening a file in Word or Excel is that you can only open two Access database files at a time.

In the accompanying figure, item 3 points to the ____.

In the accompanying figure, there are how many tables?

Records resulting from a(n) sort look like a table but are actually a view

In the accompanying figure, item 1 points to the ____ button.

In a customer database you could _____________ records by the Sales field in descending order to quickly identify the customers who purchased the most products.