Question 1

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 2

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 3

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 4

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 5

Field properties change depending on the data type of the field.

Accepted Answer

A) True 
 B)False

Question 6

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Accepted Answer

The answer of If you use ____________________ View to design...

Question 7

Which is NOT true about Access?

Accepted Answer

A)  It can be used to create forms 
B)  It relates lists of information in a relational database. 
C)  Reporting is limited to 20 saved reports. 
D)  Multiple users can simultaneously enter and update data within Access. 
A)  It can be used to create forms 
B)  It relates lists of information in a relational database. 
C)  Reporting is limited to 20 saved reports. 
D)  Multiple users can simultaneously enter and update data within Access.

Question 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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]

Question 13

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 
A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode

Question 14

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 15

Critical Thinking Questions Case 1-1
Hannah wants to create a record keeping system to track the inventory needed to efficiently run her lawn and landscape business, such as spare parts, gas cans, string trimmers, etc. Her crew manager will also be using the system.
Hannah is considering whether to use Excel or Access. Which one of the following is NOT a benefit of using Access?

Accepted Answer

A)  More data storage 
B)  Multiuser capability 
C)  Easier setup 
D)  Additional reporting features 
A)  More data storage 
B)  Multiuser capability 
C)  Easier setup 
D)  Additional reporting features

Question 16

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

Accepted Answer

A)  View Button 
B)  Open/Close Navigation Button 
C)  View Database Objects Button 
D)  Shutter Bar Open/Close Button 
A)  View Button 
B)  Open/Close Navigation Button 
C)  View Database Objects Button 
D)  Shutter Bar Open/Close Button

Question 17

The navigation buttons are found at the top of the datasheet. _________________________

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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

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

Which of the following is NOT a data type?

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

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

Field properties change depending on the data type of the field.

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Which is NOT true about Access?

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

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

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

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?

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

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

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

The navigation buttons are found at the top of the datasheet. _________________________

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

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

Which two properties are required for every field?

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 1: Getting Started With Access

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

Which of the following is NOT a data type?

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

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

Field properties change depending on the data type of the field.

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Which is NOT true about Access?

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

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

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

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?

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

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

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

The navigation buttons are found at the top of the datasheet. _________________________

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

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

Which two properties are required for every field?

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters