Question 1

Both Access 2002 and 2000 databases have the same file extension, ____.

Accepted Answer

A)  .accdb 
B)  .mcb 
C)  .mdb 
D)  .ldb 
A)  .accdb 
B)  .mcb 
C)  .mdb 
D)  .ldb

Question 2

Encryption is primarily a(n) ____ issue.

Accepted Answer

A)  performance 
B)  data accuracy 
C)  security 
D)  ease-of-use 
A)  performance 
B)  data accuracy 
C)  security 
D)  ease-of-use

Question 3

A(n) ____ option is a special set of characters added to the end of the path name to a database which execute a command when the database file is opened.

Accepted Answer

command-li

Question 4

Which of the following Access options provides a way to modify the buttons and tabs on the Ribbon?

Accepted Answer

A)  Trust Center 
B)  Quick Access Toolbar 
C)  Customize Ribbon 
D)  Client Settings 
A)  Trust Center 
B)  Quick Access Toolbar 
C)  Customize Ribbon 
D)  Client Settings

Question 5

Set the Program Title startup option to add a custom title to the title bar instead of the database name and path.

Accepted Answer

A) True 
 B)False

Question 6

Horizontal Tabs is a navigation system theme that determines how the navigation buttons are displayed on the form.

Accepted Answer

A) True 
 B)False

Question 7

-In the figure above, to save only the current object, use the Save Object As option.

Accepted Answer

A) True 
 B)False

Question 8

Differentiate between the Save Database As and Save Object As commands on the FILE tab.

Accepted Answer

The Save Database As option sa

Question 9

-In the figure above, if you save to a database template file, you will create a file with a .accde file extension.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is NOT a way to display the objects in the Navigation Pane?

Accepted Answer

A)  by Ownership 
B)  by Object Type 
C)  by Created Date 
D)  by Custom Groups 
A)  by Ownership 
B)  by Object Type 
C)  by Created Date 
D)  by Custom Groups

Question 11

The ____ file extension is for a temporary file that keeps track of record-locking information when an older Access database is open. This is useful when there are several users of a database.

Accepted Answer

A)  .accdb 
B)  .mcb 
C)  .mdb 
D)  .ldb 
A)  .accdb 
B)  .mcb 
C)  .mdb 
D)  .ldb

Question 12

Use the Access ____ file format for databases you need to work with Access 2000, 2002, and 2003.

Accepted Answer

A)  97 
B)  2000 
C)  2002 
D)  2003 
A)  97 
B)  2000 
C)  2002 
D)  2003

Question 13

A power surge is often referred to as a ____.

Accepted Answer

A)  brown-out 
B)  black-out 
C)  dim 
D)  spike 
A)  brown-out 
B)  black-out 
C)  dim 
D)  spike

Question 14

More than one person can work with the data in an Access database at the same time.

Accepted Answer

A) True 
 B)False

Question 15

To add a new tab to the form shown in the figure, click the [Add New] tab.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following Access options sets defaults for cursor action, margins, and date formatting?

Accepted Answer

A)  Object Designers 
B)  Quick Access Toolbar 
C)  Customize Ribbon 
D)  Client Settings 
A)  Object Designers 
B)  Quick Access Toolbar 
C)  Customize Ribbon 
D)  Client Settings

Question 17

In client/server computing, what is a typical task for the client?

Accepted Answer

A)  Storing objects and files used by that particular user 
B)  Managing data storage 
C)  Managing security for the network 
D)  Handling connectivity to other networks 
A)  Storing objects and files used by that particular user 
B)  Managing data storage 
C)  Managing security for the network 
D)  Handling connectivity to other networks

Question 18

When you _____ a database, you change the database file into one that can be opened in a previous version of Access.

Accepted Answer

The answer of When you _____ a database, you change...

Question 19

-The figure shows an example of a switchboard form.

Accepted Answer

A) True 
 B)False

Question 20

_____ a database refers to making a copy of it in a secure location.

Accepted Answer

Backing up

Both Access 2002 and 2000 databases have the same file extension, ____.

Encryption is primarily a(n) ____ issue.

A(n) ____ option is a special set of characters added to the end of the path name to a database which execute a command when the database file is opened.

Which of the following Access options provides a way to modify the buttons and tabs on the Ribbon?

Set the Program Title startup option to add a custom title to the title bar instead of the database name and path.

Horizontal Tabs is a navigation system theme that determines how the navigation buttons are displayed on the form.

-In the figure above, to save only the current object, use the Save Object As option.

Differentiate between the Save Database As and Save Object As commands on the FILE tab.

-In the figure above, if you save to a database template file, you will create a file with a .accde file extension.

Which of the following is NOT a way to display the objects in the Navigation Pane?

The ____ file extension is for a temporary file that keeps track of record-locking information when an older Access database is open. This is useful when there are several users of a database.

Use the Access ____ file format for databases you need to work with Access 2000, 2002, and 2003.

A power surge is often referred to as a ____.

More than one person can work with the data in an Access database at the same time.

To add a new tab to the form shown in the figure, click the [Add New] tab.

Which of the following Access options sets defaults for cursor action, margins, and date formatting?

In client/server computing, what is a typical task for the client?

When you _____ a database, you change the database file into one that can be opened in a previous version of Access.

-The figure shows an example of a switchboard form.

_____ a database refers to making a copy of it in a secure location.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 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

Chapter Access and the Web

Filters

Exam 16: Administering the Database

Both Access 2002 and 2000 databases have the same file extension, ____.

Encryption is primarily a(n) ____ issue.

A(n) ____ option is a special set of characters added to the end of the path name to a database which execute a command when the database file is opened.

Which of the following Access options provides a way to modify the buttons and tabs on the Ribbon?

Set the Program Title startup option to add a custom title to the title bar instead of the database name and path.

Horizontal Tabs is a navigation system theme that determines how the navigation buttons are displayed on the form.

-In the figure above, to save only the current object, use the Save Object As option.

Differentiate between the Save Database As and Save Object As commands on the FILE tab.

-In the figure above, if you save to a database template file, you will create a file with a .accde file extension.

Which of the following is NOT a way to display the objects in the Navigation Pane?

The ____ file extension is for a temporary file that keeps track of record-locking information when an older Access database is open. This is useful when there are several users of a database.

Use the Access ____ file format for databases you need to work with Access 2000, 2002, and 2003.

A power surge is often referred to as a ____.

More than one person can work with the data in an Access database at the same time.

To add a new tab to the form shown in the figure, click the [Add New] tab.

Which of the following Access options sets defaults for cursor action, margins, and date formatting?

In client/server computing, what is a typical task for the client?

When you _____ a database, you change the database file into one that can be opened in a previous version of Access.

-The figure shows an example of a switchboard form.

_____ a database refers to making a copy of it in a secure location.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 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

Chapter Access and the Web

Filters