Exam 17: Creating a Database

When using the Simple Query Wizard, you will be asked "Would you like a detail or summary query?" Selecting the ____ option shows all of the specified fields for the records.

Before you can enter data in a database, you must specify the structure of the tables, charts, and fields in your database._________________________

A ____ contains criteria that specify what you would like to find.

A(n) ____________________ database is very flexible because it can store data for several different but related categories.

Use the ____ data type for fields that contain numeric data.

To delete an entire record, right-click the column header containing the record.Click Delete Record on the shortcut menu, then click the Yes button._________________________

After a search is saved, you can run it repeatedly to display all the records-including new and updated data-that match the criteria you've specified._________________________

To sort records, right-click the column that holds data you want to use as the ____ key.

To import a list, begin by selecting ____ from the External Data tab and then select the file that currently holds the list.

To open an existing database, you can use the recent databases list, the Recent button, or the Open button on the Access ____________________ tab.

You can modify the ID field to accommodate primary keys, such as SKUs, Social Security numbers, or telephone numbers, by changing the ____ as necessary.

-Referring to the figure above, to open this table, you would double-click the name of the table in the ____.

It is okay to have up to two records with the same value as the primary key.

An example of data that can be found in a CSV file is ____.

Columns represent ____.

To modify data, click the field you'd like to modify.Use the Backspace, Delete, and typing keys to change the data.Press the ____ key to complete the modification.

Click the Run button in the ____ group on the Query Tools Design contextual tab to display the query results.

When you allow Access to define the primary key, the ID field is created using the ____________________ data type.

An empty record is not always displayed at the bottom of a table.

A ____ is composed of fields and records.