Exam 11: Access_Module_1

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

____________________ refers to the process of determining the tables and fields that make up the database.

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

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

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.

You can place an insertion point by tapping or clicking in the field or by pressing ____.

The Currency data type is used for fields that contain only monetary data.

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

The Navigation Pane contains a list of all the objects in the database.

Critical Thinking Questions 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?

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

File names cannot contain a(n) ____.

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.

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 Insert Column on the shortcut menu. ____________________

Society encourages users to contribute to ____________________ computing, which involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.

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

A(n)____________________ is software that can be used to create a database; add, change, and delete data in the database; ask and answer questions concerning the data in the database; and create forms and reports using the data.

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

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.

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.