Chapter 2 - Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Returns only records that meet all criteria.

AND logical operator

A data type that is a number that automatically increments each time a record is added.

AutoNumber

All of the following are suggested guidelines for table design except: Link tables using common fields. Avoid date arithmetic. Include all necessary data. Store data in its smallest parts.

Avoid date arithmetic.

Uses no spaces in multiword field names, but uses uppercase letters to distinguish the first letter of each new word.

CamelCase notation

Used to create a more readable label that displays in the top row in Datasheet view and in forms and reports.

Caption property

An option that directs Access to automatically update all foreign key values in a related table when the primary key value is modified in a primary table.

Cascade Update Related Fields

A row in the Query Design view that determines which records will be selected.

Criteria row

A query's specifications providing instructions about which records to include must be entered on the: Table row of the query design grid. Criteria row of the query design grid. Sort row of the query design grid. Show row of the query design grid.

Criteria row of the query design grid.

An illustration of a one-to-many relationship would be a: Bank branch location has an internal BranchID code. Customer may have multiple orders. Person changes his/her primary address. Balance field is totaled for all accounts for each person.

Customer may have multiple orders.

The unnecessary storing of duplicate data in two or more tables.

Data redundancy

Determines the type of data that can be entered and the operations that can be performed on that data.

Data type

Which of the following determines the type of data that can be entered and the operations that can be performed on that data? Normalization Data type Field properties Caption property

Data type

A characteristic of a field that determines how a field looks and behaves.

Field property

A field in one table that is also the primary key of another table.

Foreign key

The main reason to enforce referential integrity in Access is to: Limit the number of records in a table. Keep invalid data from being entered into a table. Keep your database safe from unauthorized users. Make it possible to delete records.

Keep invalid data from being entered into a table.

Contains two or more tables, enabling you to take advantage of the relationships that have been set in your database.

Multitable query

Which of the following is true for the Query Wizard? You do not need a summary. No criteria can be added. Fields from multiple tables are not allowed. You can only select tables as a source.

No criteria can be added.

When adding Value criteria to the Query Design view, the value you enter must be delimited by: At signs (@). Nothing (). Pound signs (#). Quotes (" ").

Nothing ().

The term Access uses to describe a blank field.

Null

A data type that can store only numerical data.

Number data type

Returns records meeting any of the specified criteria.

OR logical operator

A relationship established when the primary key value in the primary table can match many of the foreign key values in the related table.

One-to-many relationship

Enables you to ask questions about the data stored in a database.

Query

Rules in a database that are used to preserve relationships between tables when records are changed.

Referential Integrity

Provides dialog boxes to guide you through the query design process.

Simple Query Wizard

A row in the Query Design view that enables you to reorder data in ascending or descending order.

Sort row

It is more efficient to make a copy of an existing query rather than create a new query when which of the following is true? The existing query and the new query have the exact same criteria. The existing query and the new query use the same tables and fields. The existing query contains only one table. The original query is no longer being used.

The existing query and the new query use the same tables and fields.

When entering, deleting, or editing table data: ( The table must be in Design view. The table must be in Datasheet view. Data may only be entered in a form. The table may be in either Datasheet or Design view.

The table must be in Datasheet view.

A special character that can represent one or more characters in the criterion of a query.

Wildcard

When importing data into Access, which of the following statements is true? The wizard will import the data in one step after you select the file. The Import Wizard is found on the Create tab. The Import Wizard only works for Excel files. You can assign a primary key while you are importing Excel data.

You can assign a primary key while you are importing Excel data.