Exam 2: Building a Database and Defining Table Relationships

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.

-In the accompanying figure, the ____ field has been selected to be moved in the Design view.

-In the accompanying figure, fields inserted into the table using the Address Quick Start fields will be inserted prior to the ____ field.

-In the accompanying figure, the ____ is indicated by the red brackets.

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables: • Participant Information • Parent Information • Employees • Activities -Several participants registered for activities late as other participants cancelled. These participants need to be added to the Participants table. What is the most expedient way to add these participants and their paid status to the Participants table?

The default character length for the Short Text data type is ____ characters.

-In the accompanying figure, once the selected field is moved it will appear above which field in Design view?

The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view.

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

Field value maximum storage size is defined by the Field Size property for the data types including Short Text, Number, and ____________________ only.

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

-Which table in the Chatham database is illustrated in the accompanying figure?

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

A primary key that consists of two or more fields is called a(n) redundant key. _________________________

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

Akae plans to develop a database for his small DJ business that will include his music catalog, artists, clients, purchases, equipment, and vendors. Akae has identified that the following information will be included in the database: · artist · song and year · client name · client address · client contact information · vendor · purchases · equipment · equipment inventory and rental -Client contact information should include several fields. Which of the following field choices would allow client contact data to be separated into the smallest useful parts and provide Akae with the most options for contacting a client?

The Currency data type is accurate up to 4 digits on the right side of the decimal point. _________________________

Field names in a table may only be changed in Design view.

The data type that allows both sequential and random numbering is the ____ data type.

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