Question 1

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Accepted Answer

Design

Question 2

Which data type stores Web addresses?

Accepted Answer

A)   Lookup Wizard
B)   Hyperlink
C)   URL
D)   HTML B

Question 3

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

Accepted Answer

A)   File
B)   View
C)   Preview
D)   Report A

Question 4

Which two properties are required for every field?

Accepted Answer

A)   Field Name and Data Type
B)   Field Name and Field Size
C)   Data Type and Format
D)   Field Size and Format

Question 5

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

Accepted Answer

The answer of A(n) ____________________ relationship describes when a record...

Question 6

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

Accepted Answer

The answer of A(n) ____________________ object allows a user to...

Question 7

Match between columns
                        Premises: Last field of the last record

Accepted Answer

The Answer of [Down Arrow] and [End] and [Ctrl][Home] and is...

Question 8

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

A) True 
 B)False

Question 9

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 10

Which editing keystroke deletes one character to the right of the insertion point?

Accepted Answer

A)   [Backspace]
B)   [Delete]
C)   [F2]
D)   [F7]

Question 11

A(n) ____________________ is a fundamental building block of a relational database because this object stores all of the data.

Accepted Answer

The answer of A(n) ____________________ is a fundamental building block...

Question 12

In Access, two users can edit the same record at the same time.

Accepted Answer

A) True 
 B)False

Question 13

Which keystroke combination moves focus to the last field of the last record?

Accepted Answer

A)   [Alt][Ctrl][Up Arrow]
B)   [Ctrl][Up Arrow]
C)   [Ctrl][End]
D)   [Ctrl][Page Up]

Question 14

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Accepted Answer

A)   record
B)   table
C)   database
D)   object

Question 15

Match between columns
                        Premises: First field of the first record

Accepted Answer

The Answer of [Left Arrow] and [Home] and [Ctrl][Home] and is...

Question 16

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

Accepted Answer

A)   object
B)   record
C)   field
D)   table

Question 17

Match between columns
                        Premises: Last field of the current record

Accepted Answer

The Answer of [End] and [Home] and [Up Arrow] and is...

Question 18

Which Access object provides an easy-to-use data entry screen?

Accepted Answer

A)   macro
B)   form
C)   table
D)   module

Question 19

____ View provides the most options for defining fields.

Accepted Answer

A)   Table Design
B)   Table Creation
C)   Field Definition
D)   Definition

Question 20

More than one person can enter, update, and analyze data in an Access database at the same time.

Accepted Answer

A) True 
 B)False

Exam 5: Module 1 Getting Started With Access

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Which data type stores Web addresses?

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

Which two properties are required for every field?

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

Match the shortcut keystrokes to the correct action.

Values in an AutoNumber field are automatically created by Access.

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

Which editing keystroke deletes one character to the right of the insertion point?

A(n) ____________________ is a fundamental building block of a relational database because this object stores all of the data.

In Access, two users can edit the same record at the same time.

Which keystroke combination moves focus to the last field of the last record?

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Match the shortcut keystrokes to the correct action.

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

Match the shortcut keystrokes to the correct action.

Which Access object provides an easy-to-use data entry screen?

____ View provides the most options for defining fields.

More than one person can enter, update, and analyze data in an Access database at the same time.