Question 1

The Attachment data type is used ____.

Accepted Answer

A)  when only two values can be chosen 
B)  often as a primary key field 
C)  to store links such as Web addresses 
D)  to store supported file types such as images, documents, and charts

Question 2

You can change the structure of an Access table by inserting blank rows or columns.

Accepted Answer

A) True 
 B)False

Question 3

By default, tables in a a database are displayed in a format called a(n) ____________________.

Accepted Answer

The answer of By default, tables in a a database...

Question 4

You can assign a data type when creating a field by clicking the ____ column header and selecting the data type from the menu.

Accepted Answer

A)  Data Type 
B)  Add Field 
C)  Click to Add 
D)  Assign Value

Question 5

The key value is the field that uniquely identifies each record.

Accepted Answer

A) True 
 B)False

Question 6

To close a database, you can click the ____ and then click Close Database.

Accepted Answer

A)  Navigation Pane 
B)  File tab 
C)  Object tab 
D)  Start button

Question 7

The icon that you click to create a new blank database is located ____.

Accepted Answer

A)  on the Ribbon 
B)  in the Navigation Pane 
C)  in Backstage view 
D)  on the record navigation bar

Question 8

FIGURE AC 1-1  What does the pencil icon in Figure AC 1-1 indicate?

Accepted Answer

A)  A new blank record. 
B)  The record has been saved. 
C)  The record is being edited. 
D)  The record contains a primary key.

Question 9

Access does not organize commands on Ribbon tabs like other Office programs.

Accepted Answer

A) True 
 B)False

Question 10

You can set the ____ field property when you want to make sure that a certain field is required to contain a value in every record.

Accepted Answer

A)  Required 
B)  Unique 
C)  Data Type 
D)  Format

Question 11

To rename a table, you can ____ the table name in the Navigation Pane and then click Rename on the shortcut menu.

Accepted Answer

A)  select 
B)  click 
C)  double-click 
D)  right-click

Question 12

Fields are the place in a database where all the data is stored.

Accepted Answer

A) True 
 B)False

Question 13

How can you rearrange the order of fields in Datasheet view?

Accepted Answer

A)  Right-click the field and then click Rearrange. 
B)  Click the Order button on the Datasheet tab. 
C)  Select a field and drag it to a new position. 
D)  You cannot rearrange the order of fields.

Question 14

How is storing information in a database similar to using a filing cabinet? Be specific in your comparison. What would be the advantage to using an electronic database management system instead of a manual system like a filing cabinet?

Accepted Answer

The answer of How is storing information in a database...

Question 15

Access automatically saves data as you enter it in a table.

Accepted Answer

A) True 
 B)False

Question 16

A ____ is all of the related information about a particular item in a database table.

Accepted Answer

A)  record 
B)  field 
C)  primary key 
D)  field value

Question 17

FIGURE AC 1-1  What does the asterisk in Figure AC 1-1 indicate?

Accepted Answer

A)  A new blank record. 
B)  The record has been saved. 
C)  The record is being edited. 
D)  The record contains a primary key.

Question 18

The Text data type stores text and/or numbers up to 65,535 characters.

Accepted Answer

A) True 
 B)False

Question 19

Multiple database objects can be open at one time.

Accepted Answer

A) True 
 B)False

Question 20

Every table in a database will have a primary key.

Accepted Answer

A) True 
 B)False

Exam 1: Access Lesson 1: Understanding Access Fundamentals

The Attachment data type is used ____.

You can change the structure of an Access table by inserting blank rows or columns.

By default, tables in a a database are displayed in a format called a(n) ____________________.

You can assign a data type when creating a field by clicking the ____ column header and selecting the data type from the menu.

The key value is the field that uniquely identifies each record.

To close a database, you can click the ____ and then click Close Database.

The icon that you click to create a new blank database is located ____.

FIGURE AC 1-1 What does the pencil icon in Figure AC 1-1 indicate?

Access does not organize commands on Ribbon tabs like other Office programs.

You can set the ____ field property when you want to make sure that a certain field is required to contain a value in every record.

To rename a table, you can ____ the table name in the Navigation Pane and then click Rename on the shortcut menu.

Fields are the place in a database where all the data is stored.

How can you rearrange the order of fields in Datasheet view?

How is storing information in a database similar to using a filing cabinet? Be specific in your comparison. What would be the advantage to using an electronic database management system instead of a manual system like a filing cabinet?

Access automatically saves data as you enter it in a table.

A ____ is all of the related information about a particular item in a database table.

FIGURE AC 1-1 What does the asterisk in Figure AC 1-1 indicate?

The Text data type stores text and/or numbers up to 65,535 characters.

Multiple database objects can be open at one time.

Every table in a database will have a primary key.