FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) True/False
B) One/Zero
C) Yes/No
D) On/Off

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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 save the changes to the layout of a table, tap or click the Save button on the ____.

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.

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

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

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

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) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

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

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

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

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 import data to a table, tap or click the ____ tab on the ribbon.

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

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

Form view displays a single record at a time.

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

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.