Exam 6: Access_Module_1

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

In Access, the columns in a table are called records.

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

Access is a ____.

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

To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

Case 1-2 Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. -What data type should Joe use for the Completion Date field?

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).

The ____________________ data type in Access is referred to as Money in SQL Server.

The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ____________________

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 Employee table should be the primary key and why?

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

One way to undo changes to a field is to click the Undo button on the status bar.

Designing to omit ____________________ will help to produce good and valid database designs.

When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

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

To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu.

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

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.