Exam 31: Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

The data type of a field determines the type of operations that can be performed on that field.

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

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

A ________ query is a type of query that displays on records that match criteria entered in Query Design view.

A(n)________ produces a value from an expression or function that uses one or more fields in a database.

A(n)________ operator,such as the greater than or less than symbol,can be used in a query criterion to limits the results produced by the query.

A text field may contain numbers,text,and special characters.

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

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

An example of a ________ field is a field for sales associates' bonus--.05 multiplied by quarterly sales.

Comparison operators include *,?,and [ ].

A query is a question asked about the data in a database.

Calculated fields are frequently created with ________ data.

The ________ data type is used for fields that will be used in mathematical calculations except those involving money.

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

Freezing fields disallows any user from changing the field name or any data within the field.

Would you want to save every query that you create? Why or why not?

Good database design begins with the forms of the database.