Question 1

The figure shows an example of a switchboard form.

Accepted Answer

A) True 
 B)False  False

Question 2

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 A

Question 3

In the figure above, if you save to an executable database file, you will create a file with a .accdt file extension.

Accepted Answer

A) True 
 B)False  False

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

This startup command-line option opens the database with the specified password.

Accepted Answer

A)  /excl password 
B)  /pwd password 
C)  /pass password 
D)  x password 
A)  /excl password 
B)  /pwd password 
C)  /pass password 
D)  x password

Question 7

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

Accepted Answer

The answer of _____ means to make the data in...

Question 8

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

Accepted Answer

A)  .mddb 
B)  .accdb 
C)  .laccdb 
D)  .dbf 
A)  .mddb 
B)  .accdb 
C)  .laccdb 
D)  .dbf

Question 9

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 10

Doug is not familiar with the file extensions of .mdb, .accdt, or .accde referenced in the figure shown above.  Explain the purpose of each.

Accepted Answer

.mdb is the file extension for

Question 11

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 12

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 13

Identify four things that you can do to deter or minimize the impact of theft or intentional damage to your computer?

Accepted Answer

1.  Place the file server in a locked ro

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

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 18

The Workgroup Administrator tool is used to recover forgotten passwords.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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

The figure shows an example of a switchboard form.

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

In the figure above, if you save to an executable database file, you will create a file with a .accdt file extension.

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

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

This startup command-line option opens the database with the specified password.

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

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

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

Doug is not familiar with the file extensions of .mdb, .accdt, or .accde referenced in the figure shown above. Explain the purpose of each.

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

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

Identify four things that you can do to deter or minimize the impact of theft or intentional damage to your computer?

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

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

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

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

The Workgroup Administrator tool is used to recover forgotten passwords.

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

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

Getting Started With 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 Macros

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 15: Administering the Database

The figure shows an example of a switchboard form.

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

In the figure above, if you save to an executable database file, you will create a file with a .accdt file extension.

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

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

This startup command-line option opens the database with the specified password.

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

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

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

Doug is not familiar with the file extensions of .mdb, .accdt, or .accde referenced in the figure shown above. Explain the purpose of each.

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

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

Identify four things that you can do to deter or minimize the impact of theft or intentional damage to your computer?

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

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

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

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

The Workgroup Administrator tool is used to recover forgotten passwords.

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

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

Getting Started With 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 Macros

Access and the Web

Getting Started With Microsoft Office 2013

Filters