Question 1

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

Accepted Answer

The answer of A(n) ____________________ contains a specific piece of...

Question 2

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

Accepted Answer

A)  CTRL+DELETE 
B)  CTRL+Y 
C)  DELETE 
D)  CTRL+K

Question 3

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

Accepted Answer

A)  row selector 
B)  field selector 
C)  field bar 
D)  current field bar

Question 4

In Access, field names cannot contain digits.

Accepted Answer

A) True 
 B)False

Question 5

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.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  256 
B)  128 
C)  64 
D)  32

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A)  Navigation Pane 
B)  Content pane 
C)  Object tabs 
D)  Quick Access Toolbar

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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.

Accepted Answer

A)  Memo 
B)  Long Text 
C)  Variable 
D)  Character

Question 12

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.

Accepted Answer

A)  Insert Column 
B)  Insert Field 
C)  Add Column 
D)  Add Field

Question 13

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

Accepted Answer

The answer of To define an additional field in Datasheet...

Question 14

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

Accepted Answer

The answer of When you create a database, you should...

Question 15

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.

Accepted Answer

The answer of To insert a field between existing fields,...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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.

Accepted Answer

The answer of A(n)____________________ is software that can be used...

Question 18

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.

Accepted Answer

A)  alternate 
B)  caption 
C)  abbreviation 
D)  tag

Question 19

Form view displays a single record at a time.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  question mark (?) 
B)  colon (:) 
C)  space 
D)  underscore (_)

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

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

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

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

In Access, field names cannot contain digits.

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.

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

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

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

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

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

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.

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 define an additional field in Datasheet view, tap or click the ____________________ column heading, select the data type, and then type the field name.

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

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.

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.

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.

Form view displays a single record at a time.

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