Question 1

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

Accepted Answer

query

Question 2

In the figure above, use item number 2 to:

Accepted Answer

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

Question 3

A collection of records for a single subject, such as all of the customer records, is called a(n) ____.

Accepted Answer

A)   Table
B)   Control
C)   Element
D)   Object A

Question 4

Which data type stores only one of two values?

Accepted Answer

A)   Attachment
B)   Hyperlink
C)   Yes/No
D)   Null

Question 5

This Access object contains all of the raw data within the database.

Accepted Answer

A)   Query
B)   Form
C)   Table
D)   Module

Question 6

Which data type stores Web addresses?

Accepted Answer

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

Question 7

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 8

When creating a database using an Access template, you must remember that the database cannot be altered later.

Accepted Answer

A) True 
 B)False

Question 9

____________________ View is a view in which you create and manipulate the structure of an object.

Accepted Answer

The answer of ____________________ View is a view in which...

Question 10

The [F2] key switches between Edit and Navigation modes.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is not a data type?

Accepted Answer

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

Question 12

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 13

A primary key field uniquely identifies each record.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

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

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

A) True 
 B)False

Question 18

The Navigation buttons on a datasheet display the total number of fields in the datasheet.

Accepted Answer

A) True 
 B)False

Question 19

Tables contain all of the data in the database.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

Exam 1: Getting Started With Access 2.0

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

In the figure above, use item number 2 to:

A collection of records for a single subject, such as all of the customer records, is called a(n) ____.

Which data type stores only one of two values?

This Access object contains all of the raw data within the database.

Which data type stores Web addresses?

Item 8 in the figure above is:

When creating a database using an Access template, you must remember that the database cannot be altered later.

____________________ View is a view in which you create and manipulate the structure of an object.

The [F2] key switches between Edit and Navigation modes.

Which of the following is not a data type?

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

A primary key field uniquely identifies each record.

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

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

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

Values in an AutoNumber field are automatically created by Access.

The Navigation buttons on a datasheet display the total number of fields in the datasheet.

Tables contain all of the data in the database.

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