Question 1

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 A

Question 2

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 C

Question 3

This startup command-line option opens the database for exclusive access.

Accepted Answer

A)  /excl 
B)  /ro 
C)  /exclusive 
D)  /read only 
A)  /excl 
B)  /ro 
C)  /exclusive 
D)  /read only A

Question 4

Client/server computing is defined as ____.

Accepted Answer

A)  Two or more computers communicating 
B)  Two or more information systems cooperatively processing to solve a problem 
C)  A database using OLE Object fields 
D)  A database using Web enabling technologies 
A)  Two or more computers communicating 
B)  Two or more information systems cooperatively processing to solve a problem 
C)  A database using OLE Object fields 
D)  A database using Web enabling technologies

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

____ passwords are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.

Accepted Answer

A)  Split 
B)  Encrypted 
C)  Combination 
D)  Strong 
A)  Split 
B)  Encrypted 
C)  Combination 
D)  Strong

Question 7

Which of the following is a startup command-line option?

Accepted Answer

A)  /excl 
B)  /repair 
C)  /x macro 
D)  /wrkgrp workgroup 
A)  /excl 
B)  /repair 
C)  /x macro 
D)  /wrkgrp workgroup

Question 8

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 9

The Workgroup Administrator tool is used to recover forgotten passwords.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is NOT a level of advice regarding performance as analyzed by the Performance Analyzer?

Accepted Answer

A)  Issue 
B)  Recommendation 
C)  Suggestion 
D)  Idea 
A)  Issue 
B)  Recommendation 
C)  Suggestion 
D)  Idea

Question 11

What is the file extension for the Access 2000 file format?

Accepted Answer

A)  .mdb 
B)  .acb 
C)  .ldb 
D)  .dbf 
A)  .mdb 
B)  .acb 
C)  .ldb 
D)  .dbf

Question 12

Doug is not familiar with the file extensions of .mdb, .accdt, or .accde.  Explain the purpose of each.

Accepted Answer

.mdb is the file extension for

Question 13

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

Accepted Answer

The Save Database As option sa

Question 14

You can _____ an Access database into a back-end database and front-end database.

Accepted Answer

The answer of You can _____ an Access database into...

Question 15

A front-end database will contain _____ to the tables in the back-end database.

Accepted Answer

The answer of A front-end database will contain _____ to...

Question 16

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

Accepted Answer

Backing up

Question 17

_____ options are a series of commands that execute when the database is opened.

Accepted Answer

A)  Autoexec 
B)  Startup 
C)  Autodefault 
D)  Autocommand 
A)  Autoexec 
B)  Startup 
C)  Autodefault 
D)  Autocommand

Question 18

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 19

Use the Split Table Manager to manage a split database.

Accepted Answer

A) True 
 B)False

Question 20

____ are installed to link multiple PCs together so they can share hardware and software resources.

Accepted Answer

A)  WANs 
B)  LANs 
C)  Clients 
D)  Servers 
A)  WANs 
B)  LANs 
C)  Clients 
D)  Servers

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

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

This startup command-line option opens the database for exclusive access.

Client/server computing is defined as ____.

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

____ passwords are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.

Which of the following is a startup command-line option?

Encryption is primarily a(n) ____ issue.

The Workgroup Administrator tool is used to recover forgotten passwords.

Which of the following is NOT a level of advice regarding performance as analyzed by the Performance Analyzer?

What is the file extension for the Access 2000 file format?

Doug is not familiar with the file extensions of .mdb, .accdt, or .accde. Explain the purpose of each.

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

You can _____ an Access database into a back-end database and front-end database.

A front-end database will contain _____ to the tables in the back-end database.

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

_____ options are a series of commands that execute when the database is opened.

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

Use the Split Table Manager to manage a split database.

____ are installed to link multiple PCs together so they can share hardware and software resources.

Getting Started With Access

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

Using Acess and the Web

Completing a Database Application

Filters

Exam 14: Administering the Database

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

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

This startup command-line option opens the database for exclusive access.

Client/server computing is defined as ____.

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

____ passwords are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.

Which of the following is a startup command-line option?

Encryption is primarily a(n) ____ issue.

The Workgroup Administrator tool is used to recover forgotten passwords.

Which of the following is NOT a level of advice regarding performance as analyzed by the Performance Analyzer?

What is the file extension for the Access 2000 file format?

Doug is not familiar with the file extensions of .mdb, .accdt, or .accde. Explain the purpose of each.

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

You can _____ an Access database into a back-end database and front-end database.

A front-end database will contain _____ to the tables in the back-end database.

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

_____ options are a series of commands that execute when the database is opened.

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

Use the Split Table Manager to manage a split database.

____ are installed to link multiple PCs together so they can share hardware and software resources.

Getting Started With Access

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

Using Acess and the Web

Completing a Database Application

Filters