Access Quiz

A good example of a primary key field for an animal table would be __________.

AnimalNumber

You can manage your database by making space available and increasing the speed of data retrieval by__________.

Compacting the Database

An Access _____________is a computerized filing system that is used to organize and maintain a collection of information for future use.

Database

To add properties to a table field you must be in________________.

Design View

Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.

Fields

In a database form, the blanks in which information is entered are called ________. When the blanks are filled in, the form becomes a _________.

Fields, Records

The quickest way to create a form is to use the_____.

Form Wizard

One way to quickly add data to a table in Access is to ____________ from another source.

Import

A _______ is a field whose values uniquely identify each record in a table.

Primary Key

The _________ _______ is used to identify each record in the table with a number.

Primary Key

The key symbol next to a field name indicates______________________.

Primary Key

A ___________ is a question you ask about the data stored in a database.

Query

A set of field values containing information on a single entity is known as a ________________.

Record

In a database table, rows are called __________

Records

A __________________ exists when one field in the first table is joined to at least one field in another table.

Relationship

When assigning a field data type you must consider what data you will use. If you were to add a field to describe the type of animal each person had, you would choose the _____________ data type.

Short Text

The _______ feature is responsible for controlling the sequence, or order, of the records.

Sort

Forms, queries, and reports are created based on the information in the _________

Table

Which Access object contains all of the data in the database?

Table

What are the access database objects?

Tables, Queries, Forms, Reports

When you start access, the first screen that appears and allows you to create a blank database or use a predesigned template is know as_____________ .

The Backstage View

When you copy records from one table in a database to another table in a different database, the two tables must have________________.

The Same Table Structure