Question 1

When you split an Access database, how many copies of the back-end database do you use?

Accepted Answer

A)  1 
B)  2 
C)  One copy for each user 
D)  One copy for each PC that accesses the database 
A)  1 
B)  2 
C)  One copy for each user 
D)  One copy for each PC that accesses the database

Question 2

Identify three benefits of the Access 2007 database file format over its predecessors.

Accepted Answer

1.  It supports multivalued fi

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

You can recover a forgotten database password by opening the database in exclusive mode.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Accepted Answer

The answer of _____ options are a series of commands...

Question 7

Which of the following Access options sets AutoCorrect and Spelling options?

Accepted Answer

A)  Proofing 
B)  Language 
C)  Datasheet 
D)  Client Settings 
A)  Proofing 
B)  Language 
C)  Datasheet 
D)  Client Settings

Question 8

Default database options are provided in the Access Options dialog box.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

External hard drives typically have more storage capacity than USB drives.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following Access options provides a way to set security, macro, and other privacy settings?

Accepted Answer

A)  Trust Center 
B)  Add-ins 
C)  Customize Ribbon 
D)  Client Settings 
A)  Trust Center 
B)  Add-ins 
C)  Customize Ribbon 
D)  Client Settings

Question 12

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 13

One of the reasons to split a database is to improve performance.

Accepted Answer

A) True 
 B)False

Question 14

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 15

What is the file extension for the Access 2002-2003 file format?

Accepted Answer

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

Question 16

A(n) _____ form is a special Access form that provides an easy-to-use database interface that is also web compatible.

Accepted Answer

The answer of A(n) _____ form is a special Access...

Question 17

In Access 2016, the default file extension for a relational database is  _____

Accepted Answer

The answer of In Access 2016, the default file extension...

Question 18

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

Accepted Answer

A)  The computer where the database is stored 
B)  The user's PC 
C)  The database itself 
D)  The network itself 
A)  The computer where the database is stored 
B)  The user's PC 
C)  The database itself 
D)  The network itself

Question 19

If you split an Access database, what is the name of the database that is stored on the client's machine?

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

When you split an Access database, how many copies of the back-end database do you use?

Identify three benefits of the Access 2007 database file format over its predecessors.

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.

You can recover a forgotten database password by opening the database in exclusive mode.

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.

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

Which of the following Access options sets AutoCorrect and Spelling options?

Default database options are provided in the Access Options dialog box.

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

External hard drives typically have more storage capacity than USB drives.

Which of the following Access options provides a way to set security, macro, and other privacy settings?

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

One of the reasons to split a database is to improve performance.

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

What is the file extension for the Access 2002-2003 file format?

A(n) _____ form is a special Access form that provides an easy-to-use database interface that is also web compatible.

In Access 2016, the default file extension for a relational database is _____

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

If you split an Access database, what is the name of the database that is stored on the client's machine?

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

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

When you split an Access database, how many copies of the back-end database do you use?

Identify three benefits of the Access 2007 database file format over its predecessors.

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.

You can recover a forgotten database password by opening the database in exclusive mode.

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.

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

Which of the following Access options sets AutoCorrect and Spelling options?

Default database options are provided in the Access Options dialog box.

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

External hard drives typically have more storage capacity than USB drives.

Which of the following Access options provides a way to set security, macro, and other privacy settings?

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

One of the reasons to split a database is to improve performance.

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

What is the file extension for the Access 2002-2003 file format?

A(n) _____ form is a special Access form that provides an easy-to-use database interface that is also web compatible.

In Access 2016, the default file extension for a relational database is _____

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

If you split an Access database, what is the name of the database that is stored on the client's machine?

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

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