Question 1

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 2

Which Access object contains all of the raw data within the database?

Accepted Answer

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

Question 3

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]

Question 4

Relational ____________________ software is used to manage data that can be organized into lists, such as information about customers, products, vendors, employees, projects, or sales.

Accepted Answer

The answer of Relational ____________________ software is used to manage...

Question 5

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator. _________________________

Accepted Answer

A) True 
 B)False

Question 6

Press [Esc] once to undo a change to the current field.

Accepted Answer

A) True 
 B)False

Question 7

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

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

Question 10

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

Question 11

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 12

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 13

Which data type stores only one of two values?

Accepted Answer

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

Question 14

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 15

Critical Thinking Questions Case 1-2
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 16

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

A) True 
 B)False

Question 17

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 18

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 19

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)  FILE 
B)  VIEW 
C)  PREVIEW 
D)  REPORT

Question 20

You can use the Calendar Box to enter dates in a Date/Time field. _________________________

Accepted Answer

A) True 
 B)False

Which of the following is NOT a data type?

Which Access object contains all of the raw data within the database?

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

Relational ____________________ software is used to manage data that can be organized into lists, such as information about customers, products, vendors, employees, projects, or sales.

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator. _________________________

Press [Esc] once to undo a change to the current field.

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

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

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

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

Which data type stores Web addresses?

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

Which data type stores only one of two values?

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

Critical Thinking Questions Case 1-2 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.

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

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

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

You can use the Calendar Box to enter dates in a Date/Time field. _________________________

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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 1: Getting Started With Access 2013

Which of the following is NOT a data type?

Which Access object contains all of the raw data within the database?

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

Relational ____________________ software is used to manage data that can be organized into lists, such as information about customers, products, vendors, employees, projects, or sales.

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator. _________________________

Press [Esc] once to undo a change to the current field.

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

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

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

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

Which data type stores Web addresses?

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

Which data type stores only one of two values?

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

Critical Thinking Questions Case 1-2 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.

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

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

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

You can use the Calendar Box to enter dates in a Date/Time field. _________________________

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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters