Exam 14: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

The Simple Query Wizard displays a series of dialog boxes that guide users through the query design process.

Quotation marks before and after text in a text field and pound signs before and after a date in a date field are example of ________.

Two or more tables that contain duplicate data are an example of:

Storing the date of birth of clinic patients should be a ________ field.

A relationship cannot be established between two tables unless a primary key has been set in the first table.

In a query,which of the following statements is TRUE regarding delimiters in the criterion of a field?

It is more efficient to copy and use an existing query for a new query when:

Once a table is created,you cannot change an existing field in that table.

The value in a field with the ________ data type will be automatically increased each time a new record is entered.

You can set a(n)________ to create a label more readable than a field.

Which field property type should be used to enter a predefined value into a field when most of the records will have the same value?

Which of the following is TRUE about the NOT operator?

Which of the following statements is TRUE regarding multitable queries?

________ is the value used to describe a blank field in an Access table.

When referential integrity is enforced,you cannot enter a(n)________ key in a related table unless the primary key exists in the primary table.

All Excel spreadsheets are ready to import into an Access database.

The Run command appears as a red exclamation point in Design view.

Why should you strive to avoid data redundancy in a database?

A(n)________ relationship consists of a primary key value in a primary table and numerous foreign key values in a related table.