Question 1

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

Accepted Answer

A)  Hierarchical 
B)  Network 
C)  Schematic 
D)  Referential 
A)  Hierarchical 
B)  Network 
C)  Schematic 
D)  Referential

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Match the shortcut keystrokes to the correct action.
-Previous field of the current record

Accepted Answer

A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home] 
A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home]

Question 5

-In the accompanying figure, CustomerRoster is a ____ tab.

Accepted Answer

A)  report 
B)  query 
C)  form 
D)  table 
A)  report 
B)  query 
C)  form 
D)  table

Question 6

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 
A)  record 
B)  table 
C)  database 
D)  object

Question 7

Which data type stores Web addresses?

Accepted Answer

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

Question 8

____ View provides the most options for defining fields.

Accepted Answer

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

Question 9

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 
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 10

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

Accepted Answer

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

Question 11

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

A) True 
 B)False

Question 12

A primary key field uniquely identifies each record.

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] 
A)  [Alt][Ctrl][Up Arrow] 
B)  [Ctrl][Up Arrow] 
C)  [Ctrl][End] 
D)  [Ctrl][Page Up]

Question 14

Match the shortcut keystrokes to the correct action.
-Next field of the current record

Accepted Answer

A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home] 
A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home]

Question 15

In Navigation mode, press [Tab] or ____ to move to the next field within the same record.

Accepted Answer

A)  [End] 
B)  [Page Down] 
C)  [Down Arrow] 
D)  [Enter] 
A)  [End] 
B)  [Page Down] 
C)  [Down Arrow] 
D)  [Enter]

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

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

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

Match the shortcut keystrokes to the correct action. -Previous field of the current record

-In the accompanying figure, CustomerRoster is a ____ tab.

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

Which data type stores Web addresses?

____ View provides the most options for defining fields.

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

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

Values in an AutoNumber field are automatically created by Access.

A primary key field uniquely identifies each record.

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

Match the shortcut keystrokes to the correct action. -Next field of the current record

In Navigation mode, press [Tab] or ____ to move to the next field within the same record.

Getting Started With Microsoft Office 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 2: Getting Started With Exam Access 2013

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

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

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

Match the shortcut keystrokes to the correct action. -Previous field of the current record

-In the accompanying figure, CustomerRoster is a ____ tab.

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

Which data type stores Web addresses?

____ View provides the most options for defining fields.

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

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

Values in an AutoNumber field are automatically created by Access.

A primary key field uniquely identifies each record.

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

Match the shortcut keystrokes to the correct action. -Next field of the current record

In Navigation mode, press [Tab] or ____ to move to the next field within the same record.

Getting Started With Microsoft Office 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters