Exam 11: Access_Module_1

To import data to a table, tap or click the ____ tab on the ribbon.

A field with a Yes/No data type can store only one of two values. The choices are ____.

When Access first creates a database, it automatically creates a table.

In Access, table and field names can be up to ____ characters in length.

A unique identifier is also called a primary key.

____ words are words that have a special meaning to Access and cannot be used for the names of fields.

To define an additional field in Datasheet view, tap or click the ____ column heading.

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.

Layout view shows a report on the screen and allows the user to make changes to the report.

Critical Thinking Questions Case 1-1 Joe has been asked to create a Special Projects database for his company. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. He has determined that he needs the following tables: Employee (Social Security Number, Last Name, First Name, Street Address, City, State, Postal Code, Hourly Pay Rate, Project Code) Project (Project Code, Project Name, Total Hours, Completion Date) -Which field in the Project table should be the primary key and why?

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu. ____________________

The determination of database requirements is part of a process known as ____________________.

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

____________________ view has more functionality for creating a table than Datasheet view.

A(n) ____________________ contains a specific piece of information within a record.

The Access window consists of a variety of components. These include the ____.

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

To preview and then print the contents of a table, use Table Preview.

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

A field whose data type is ____ can contain any characters.