Question 1

What are three typical duties of the server in a client/server environment?

Accepted Answer

1.  Data storage and

Question 2

In a client/server environment, what would be the client?

Accepted Answer

A)  The network itself 
B)  The database that is being shared 
C)  The user's PC 
D)  The file server where the database is stored 
A)  The network itself 
B)  The database that is being shared 
C)  The user's PC 
D)  The file server where the database is stored

Question 3

If you split an Access database, what is the name of the database that is stored on the file server?

Accepted Answer

A)  The server database 
B)  The back-end database 
C)  The client/server database 
D)  The front-end database 
A)  The server database 
B)  The back-end database 
C)  The client/server database 
D)  The front-end database

Question 4

3.5-inch disks with roughly 1 MB of storage capacity are a common portable storage device today.

Accepted Answer

A) True 
 B)False

Question 5

____ means that you are the only person who has the database open and others will not be able to open the file during this time.

Accepted Answer

A)  Private mode 
B)  Exclusive mode 
C)  Encrypted 
D)  Splitting 
A)  Private mode 
B)  Exclusive mode 
C)  Encrypted 
D)  Splitting

Question 6

You manage default startup options using the features in the _____ Database category of the Access Options dialog box.

Accepted Answer

The answer of You manage default startup options using the...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

_____ means to make the data in the database unreadable by other software.

Accepted Answer

Encrypting

Question 9

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.

Accepted Answer

A) True 
 B)False

Question 10

Closing all applications that you don't currently need to free up memory is a relatively easy way to improve performance.

Accepted Answer

A) True 
 B)False

Question 11

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

What are three typical duties of the server in a client/server environment?

In a client/server environment, what would be the client?

If you split an Access database, what is the name of the database that is stored on the file server?

3.5-inch disks with roughly 1 MB of storage capacity are a common portable storage device today.

____ means that you are the only person who has the database open and others will not be able to open the file during this time.

You manage default startup options using the features in the _____ Database category of the Access Options dialog box.

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

_____ means to make the data in the database unreadable by other software.

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.

Closing all applications that you don't currently need to free up memory is a relatively easy way to improve performance.

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

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

What are three typical duties of the server in a client/server environment?

In a client/server environment, what would be the client?

If you split an Access database, what is the name of the database that is stored on the file server?

3.5-inch disks with roughly 1 MB of storage capacity are a common portable storage device today.

____ means that you are the only person who has the database open and others will not be able to open the file during this time.

You manage default startup options using the features in the _____ Database category of the Access Options dialog box.

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

_____ means to make the data in the database unreadable by other software.

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.

Closing all applications that you don't currently need to free up memory is a relatively easy way to improve performance.

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

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