FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

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

A) DATABASE TOOLS
B) FILE
C) EXTERNAL DATA
D) IMPORT

E) B) and D)
F) All of the above

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

In Access, field names cannot contain digits.

A) True
B) False

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

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

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.

When you create a database, you should follow some general guidelines for database design.What are these nine guidelines?

To define an additional field in Datasheet view, tap or click the ____________________ column heading, select the data type, and then type the field name.

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.

Changing the column width in a datasheet changes the structure of a table.

Form view displays a single record at a time.

Modified Multiple Choice File names cannot contain a(n) ____.

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

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

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.

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.

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

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

In the accompanying figure, the small box or bar to the left of each field is called the ____.

The DATABASE TOOLS tab provides commands to save a database with another name.

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