Zara should use a form to display one record at a time on her screen.

True

False

A primary key uniquely identifies each record in a table.

True

False

A filter is used to arrange records in either ascending or descending order.

True

False

Excel worksheets can be imported into an Access database as new tables.

True

False

Referential integrity is a set of rules that prevents changes from being made to records that are related to other records.

True

False

1.Which database object is best for viewing and editing one record at a time?

Table

Form

Query

Report

2.What are short text, hyperlink, and numeric examples of?

Primary keys

Records

Queries

Data types

3.Which feature is used to display a subset of records?

Sort

Form

Property sheet

Filter

4.An Access relationship occurs between which of the following?

Tables

Forms

Queries

Reports

5.Breaking the field Name into two smaller fields, Firstname and Lastname, is part of which process?

Referential integrity

Establishing a relationship

Data normalization

None of these options

1.The names, addresses, and phone numbers for 5,000 customers are stored in a database as which of the following?

5,000 fields

5,000 records

5,000 tables

A single object

1.The names, addresses, and phone numbers for 5,000 customers are stored in a database as which of the following?

5,000 fields

5,000 records

5,000 tables

A single object