Question 1

Item 8 in the figure above is:

Accepted Answer

A) Where a new record would be entered 
B) Where a new field would be entered 
C) A field name 
D) The navigation pane

Question 2

A(n)____________________ key field contains unique data for each record.

Accepted Answer

The answer of A(n)____________________ key field contains unique data for...

Question 3

"Focus" refers to which data you would edit if you started typing.

Accepted Answer

A) True 
 B)False

Question 4

Which data type stores Web addresses?

Accepted Answer

A) Lookup Wizard 
B) Hyperlink 
C) www address 
D) HTML

Question 5

A(n)____________________ field automatically assigns a new number each time you add a record.

Accepted Answer

The answer of A(n)____________________ field automatically assigns a new number...

Question 6

Press this keystroke combination to move 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 7

While editing a record, pressing [Esc] a second time ____.

Accepted Answer

A) Deletes the current field 
B) Deletes the current datasheet 
C) Removes all data from the current record 
D) Removes all changes made to the record you are currently editing

Question 8

Which of the following is NOT a way to open Access?

Accepted Answer

A) From the Start menu 
B) From Internet Explorer 
C) From a pinned program on the taskbar 
D) From a shortcut on the desktop

Question 9

Which is NOT a feature of Access reports?

Accepted Answer

A) Headers 
B) Footers 
C) Calculations on groups of records 
D) Easy-to-use data entry screen

Question 10

Which shortcut key moves focus to the previous field of the current record?

Accepted Answer

A) [Home] 
B) [Shift][Tab] 
C) [Up Arrow] 
D) [F5]

Question 11

In the figure above, use item number 1 to:

Accepted Answer

A) Create a database from a template 
B) Open an existing database 
C) Search Microsoft online templates 
D) Exit Access

Question 12

A foreign key field is always on the "one" side of a one-to-many relationship between two tables.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is not a data type?

Accepted Answer

A) Number 
B) Formula 
C) Date/Time 
D) Text

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

More than one person can be entering, updating, and using an Access database at the same time.

Accepted Answer

A) True 
 B)False

Question 16

Lauren wants to create an Access database of the musical instruments she owns. A Purchase Price field should be which data type?

Accepted Answer

A) Text 
B) Number 
C) Monetary 
D) Currency

Question 17

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

Question 18

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

Accepted Answer

A) Edit mode 
B) Navigation mode 
C) Update mode 
D) Form mode

Question 19

____________________ View is a spreadsheet-like grid that displays a table's fields and records.

Accepted Answer

The answer of ____________________ View is a spreadsheet-like grid that...

Question 20

Microsoft Access can best be described as ____ software.

Accepted Answer

A) Spreadsheet 
B) Presentation 
C) Database 
D) Systems

Exam 10: Getting Started With Access 2.0

Item 8 in the figure above is:

A(n)____________________ key field contains unique data for each record.

"Focus" refers to which data you would edit if you started typing.

Which data type stores Web addresses?

A(n)____________________ field automatically assigns a new number each time you add a record.

Press this keystroke combination to move focus to the last field of the last record.

While editing a record, pressing [Esc] a second time ____.

Which of the following is NOT a way to open Access?

Which is NOT a feature of Access reports?

Which shortcut key moves focus to the previous field of the current record?

In the figure above, use item number 1 to:

A foreign key field is always on the "one" side of a one-to-many relationship between two tables.

Which of the following is not a data type?

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

More than one person can be entering, updating, and using an Access database at the same time.

Lauren wants to create an Access database of the musical instruments she owns. A Purchase Price field should be which data type?

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

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

____________________ View is a spreadsheet-like grid that displays a table's fields and records.

Microsoft Access can best be described as ____ software.