Exam 1: Access 1 Databases and Database Objects: an Introduction

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

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 ____.

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

Redundancy means storing the same fact in more than one place.

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

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

Form view displays a single record at a time.

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 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 delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field 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 ____ on the shortcut menu.

To save the changes to the layout of a table, tap or click the Save button on the ____.

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.

The Navigation Pane contains a list of all the objects in 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.

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

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.

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

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