Question 1

If you set a database _____ all users must enter that combination of characters before they are allowed to open the database.

Accepted Answer

The answer of If you set a database _____ all...

Question 2

-In the figure above, the Compact on Close option is checked. This helps you ____.

Accepted Answer

A)  set a startup switchboard 
B)  make sure the windows are tabbed 
C)  keep the database as small and efficient as possible 
D)  secure the database with a password 
A)  set a startup switchboard 
B)  make sure the windows are tabbed 
C)  keep the database as small and efficient as possible 
D)  secure the database with a password

Question 3

The Performance Analyzer makes a variety of recommendations on how you can improve database performance.

Accepted Answer

A) True 
 B)False

Question 4

____ 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 5

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

Question 6

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 7

Database passwords are case sensitive which means that IOWA and iowa are different passwords.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Once a database is open, ____ is generally the single most important determinant of overall performance.

Accepted Answer

A)  Memory 
B)  Modem speed 
C)  Network connection 
D)  Java version 
A)  Memory 
B)  Modem speed 
C)  Network connection 
D)  Java version

Question 10

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

Accepted Answer

1. Data storage and

Question 11

Which of the following is NOT a tip for optimizing database performance?

Accepted Answer

A)  Close any other open applications not needed. 
B)  Convert the database to the Access 2002-2003 format. 
C)  Use Compact on Close to regularly compact the database. 
D)  Add more memory. 
A)  Close any other open applications not needed. 
B)  Convert the database to the Access 2002-2003 format. 
C)  Use Compact on Close to regularly compact the database. 
D)  Add more memory.

Question 12

The Workgroup Administrator tool is used to recover forgotten passwords.

Accepted Answer

A) True 
 B)False

Question 13

Match the Access options dialog box category with the best choice.
-Provides a way to manage trusted publishers, locations, documents, and macro settings

Accepted Answer

A) General 
B) Current Database 
C) Datasheet 
D) Object Designers 
E) Trust Center 
A) General 
B) Current Database 
C) Datasheet 
D) Object Designers 
E) Trust Center

If you set a database _____ all users must enter that combination of characters before they are allowed to open the database.

-In the figure above, the Compact on Close option is checked. This helps you ____.

The Performance Analyzer makes a variety of recommendations on how you can improve database performance.

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

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

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

Database passwords are case sensitive which means that IOWA and iowa are different passwords.

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

Once a database is open, ____ is generally the single most important determinant of overall performance.

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

Which of the following is NOT a tip for optimizing database performance?

The Workgroup Administrator tool is used to recover forgotten passwords.

Match the Access options dialog box category with the best choice. -Provides a way to manage trusted publishers, locations, documents, and macro settings

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

If you set a database _____ all users must enter that combination of characters before they are allowed to open the database.

-In the figure above, the Compact on Close option is checked. This helps you ____.

The Performance Analyzer makes a variety of recommendations on how you can improve database performance.

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

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

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

Database passwords are case sensitive which means that IOWA and iowa are different passwords.

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

Once a database is open, ____ is generally the single most important determinant of overall performance.

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

Which of the following is NOT a tip for optimizing database performance?

The Workgroup Administrator tool is used to recover forgotten passwords.

Match the Access options dialog box category with the best choice. -Provides a way to manage trusted publishers, locations, documents, and macro settings

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