Access: Final Exam Review #1

The figure illustrates the ____ view which allows the user to modify a table structure.

• datasheet

• design

• grid

• relationship

In the figure, the top portion of the table window indicated by the red bracket is the

• Field Property Grid

• Table Design Grid

• General Grid

• Primary Grid

What is the maximum character length of a field name?

• 64

• 48

• 255

• 240

In the figure, the highlighted record entries illustrate a database design with ____.

• extremely long character widths

• data redundancy

• a composite primary key

• no field properties

____ is the default name for a new table in an Access database.

• My table

• Table 1

• ADB table

• TableA

The ____ property allows the designer to explain the purpose of a field or how a field is used.

• Data Type

• Required

• Field Size

• Description

A database management system is a useful tool only if it meets which of the following criteria?

• Produces report

• Meets the needs of its users

• contains simple records

• meets the needs of the designer

A field used to connect one table logically with another table is called a ____ field

• common

• primary

• composite

• data

A database system determines how to store, display, & process field values based on?

• field names

• field properties

• field captions

• field size

When choosing field names, it is best to choose names that ____.

• include both numbers and letters in the name

• use only uppercase characters

• describe the content or purpose of the field

• use only lowercase letters and no spaces