Access Test

65,535

A Long Text field can hold up to ____________ characters

255

A Short Text field can hold up to ___________ characters

Access Tables

Access ______ are the essential building blocks of the database

Fields

Access is a relational database. Objects in your database are related to one another through relationships defined by common _______ betweeen tables,

Record

Each row in a table contains all the data for a single ________.

Content

The Input Mask Wizard offers a variety of common input masks including all the following except:

Three

There are ___________ types of relationships that can be established in Access.

Underlying table design will not be changed

When rearranging fields in Datasheet view, the _________

Relational

A ____________ database is a group of tables related to one another by common fields.

Currency

A ________________ field stores a numerical value with a high degree of accuracy (up to four decimal places to the right of the decimal.) Access will not round these fields.

Objects

Although you create and work with a single Access database file, inside the file, there are multiple _________.

Layout View

Forms and Reports also offer _________ where you can modify some (but not all) structural elements.

Form view

Forms open in _________, which provides a user-friendly interface for entering data.

Input Mask

Some fields require a specific input format called a(n) ______________.

Primary Key

The __________ is the field that contains data unique to that record.

Navigation Pane

To create a Single Record form based on a table or query, you must first select the table or query in the ______________.

Print Preview view

Use the _________ to adjust margins and page orientation of your reports

Relationship Tools Design

You can display all the database relationships at once by click the All Relationships button on the __________ tab.

move to

When you enter data in a table, Access saves it each you _____________ a new field or begin a new record.

Table

When you use a form to enter data, you are actually adding data to the underlying __________.

Left

If you right-click any field name and select Insert Field to insert a new blank text field, it is inserted to the ____________ of the field you selected

Tables

The database ___________ store all the data.

Two

The design view window is divided into ___________ planes.

Report

The easiest way to create a new report is to use the ____________ button.

Click to Add

To add a new field to a table in Datasheet view, click the arrow in the _______________ column to expand the list of available field types.

Create the database file

To begin a new Access database from scratch, you must first _________.

Table Tools Fields

To delete a field in Datasheet view, one method is to click anywhere in the field you want to delete and, on the ________ tab in the Add & Delete group, click the Delete button.

Home

To switch to another view, click the ____________ tab and then select your view from the View button arrow.

Forms

____ allow users to input data through a friendly interface.

Design View

___________ is used to modify the structure of the database object.