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