Question 1

Which file extension is associated with the file that coordinates the multiuser capabilities of Access 2010?

Accepted Answer

A)  .mdb 
B)  .laccdb 
C)  .ddb 
D)  .mud 
A)  .mdb 
B)  .laccdb 
C)  .ddb 
D)  .mud B

Question 2

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

Accepted Answer

Encrypting
Encryption

Question 3

-The figure shows a form with Horizontal Tabs.

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

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 6

Being Web compatible means that a form can be opened and used with Internet Explorer when the database is published to a(n) _____ server.

Accepted Answer

The answer of Being Web compatible means that a form...

Question 7

-Daniel needs to create a backup of his database. In the figure above, which two options could he use?

Accepted Answer

Daniel could use the Save Data

Question 8

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 9

-Which category of options in the figure shown would Brad use to set AutoCorrect and Spelling options for his database application?

Accepted Answer

Brad would

Question 10

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 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

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 roo

Question 16

-In the figure shown, one option to make a copy of the entire database is to use the Back Up Database option.

Accepted Answer

A) True 
 B)False

Question 17

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 18

Match the Access options dialog box category with the best choice.
-Determines default Design View settings; also provides default error-checking options

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

Question 19

Match the Access options dialog box category with the best choice.
-Determines whether the windows are overlapping or tabbed and whether the database compacts on close

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

Question 20

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

Which file extension is associated with the file that coordinates the multiuser capabilities of Access 2010?

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

-The figure shows a form with Horizontal Tabs.

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

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

Being Web compatible means that a form can be opened and used with Internet Explorer when the database is published to a(n) _____ server.

-Daniel needs to create a backup of his database. In the figure above, which two options could he use?

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

-Which category of options in the figure shown would Brad use to set AutoCorrect and Spelling options for his database application?

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

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

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

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

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

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

-In the figure shown, one option to make a copy of the entire database is to use the Back Up Database option.

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

Match the Access options dialog box category with the best choice. -Determines default Design View settings; also provides default error-checking options

Match the Access options dialog box category with the best choice. -Determines whether the windows are overlapping or tabbed and whether the database compacts on close

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

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

Which file extension is associated with the file that coordinates the multiuser capabilities of Access 2010?

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

-The figure shows a form with Horizontal Tabs.

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

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

Being Web compatible means that a form can be opened and used with Internet Explorer when the database is published to a(n) _____ server.

-Daniel needs to create a backup of his database. In the figure above, which two options could he use?

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

-Which category of options in the figure shown would Brad use to set AutoCorrect and Spelling options for his database application?

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

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

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

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

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

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

-In the figure shown, one option to make a copy of the entire database is to use the Back Up Database option.

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

Match the Access options dialog box category with the best choice. -Determines default Design View settings; also provides default error-checking options

Match the Access options dialog box category with the best choice. -Determines whether the windows are overlapping or tabbed and whether the database compacts on close

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

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