Question 1

No two records can have the same value in the primary key field.

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

AutoNumber

Question 4

Tables contain all of the data in the database.

Accepted Answer

A) True 
 B)False

Question 5

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 
A)  Field Name and Data Type 
B)  Field Name and Field Size 
C)  Data Type and Format 
D)  Field Size and Format

Question 6

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode. _________________________

Accepted Answer

A) True 
 B)False

Question 7

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

Question 8

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

Accepted Answer

A)  [Home] 
B)  [End] 
C)  [F4] 
D)  [F5] 
A)  [Home] 
B)  [End] 
C)  [F4] 
D)  [F5]

Question 9

In Access, data entry screens are called forms. _________________________

Accepted Answer

A) True 
 B)False

Question 10

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 
A)  Text 
B)  Number 
C)  Monetary 
D)  Currency

Question 11

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

Accepted Answer

A table contains all of the raw data wit

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

-In the accompanying figure, the rightmost TourSales tab is a ____ tab.

Accepted Answer

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

Question 14

The ____________________ refers to which data you would edit if you started typing.

Accepted Answer

The answer of The ____________________ refers to which data you...

Question 15

-In the accompanying figure, the leftmost TourSales is a ____ tab.

Accepted Answer

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

Question 16

Which of the following is NOT a data type?

Accepted Answer

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

Question 17

Microsoft Access can best be described as ____ software.

Accepted Answer

A)  spreadsheet 
B)  presentation 
C)  database 
D)  systems 
A)  spreadsheet 
B)  presentation 
C)  database 
D)  systems

Question 18

Pressing [Ctrl][;] will insert the current date in a Date field.

Accepted Answer

A) True 
 B)False

Question 19

Match the shortcut keystrokes to the correct action.
-Current field of the previous 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 20

A(n) ____________________ object provides an easy-to-use data entry screen.

Accepted Answer

The answer of A(n) ____________________ object provides an easy-to-use data...

No two records can have the same value in the primary key field.

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

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

Tables contain all of the data in the database.

Which two properties are required for every field?

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode. _________________________

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

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

In Access, data entry screens are called forms. _________________________

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

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

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

-In the accompanying figure, the rightmost TourSales tab is a ____ tab.

The ____________________ refers to which data you would edit if you started typing.

-In the accompanying figure, the leftmost TourSales is a ____ tab.

Which of the following is NOT a data type?

Microsoft Access can best be described as ____ software.

Pressing [Ctrl][;] will insert the current date in a Date field.

Match the shortcut keystrokes to the correct action. -Current field of the previous record

A(n) ____________________ object provides an easy-to-use data entry screen.

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

No two records can have the same value in the primary key field.

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

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

Tables contain all of the data in the database.

Which two properties are required for every field?

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode. _________________________

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

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

In Access, data entry screens are called forms. _________________________

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

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

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

-In the accompanying figure, the rightmost TourSales tab is a ____ tab.

The ____________________ refers to which data you would edit if you started typing.

-In the accompanying figure, the leftmost TourSales is a ____ tab.

Which of the following is NOT a data type?

Microsoft Access can best be described as ____ software.

Pressing [Ctrl][;] will insert the current date in a Date field.

Match the shortcut keystrokes to the correct action. -Current field of the previous record

A(n) ____________________ object provides an easy-to-use data entry screen.

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