Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 3

Which of the following is NOT a method to help secure an Access database?

Accepted Answer

A)  Password 
B)  Encryption 
C)  Show/hide objects 
D)  Attachment fields 
A)  Password 
B)  Encryption 
C)  Show/hide objects 
D)  Attachment fields

Question 4

A power surge is often referred to as a ____.

Accepted Answer

A)  brown-out 
B)  black-out 
C)  dim 
D)  spike 
A)  brown-out 
B)  black-out 
C)  dim 
D)  spike

Question 5

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 6

Which Access database file format supports multivalued fields?

Accepted Answer

A)  2000 
B)  2002-2003 
C)  2007 
D)  2012 
A)  2000 
B)  2002-2003 
C)  2007 
D)  2012

Question 7

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 8

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

Question 9

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 10

The .laccdb file is a temporary file.

Accepted Answer

A) True 
 B)False

Question 11

The Access 2007 database format works with Access 2007, 2010,  ____, and 2016.

Accepted Answer

A)  2000 
B)  2002 
C)  2003 
D)  2013 
A)  2000 
B)  2002 
C)  2003 
D)  2013

Question 12

Set the Initial Form startup option to specify which form opens when the database application opens.

Accepted Answer

A) True 
 B)False

Question 13

Match between columns
                        Premises: Provides a way to manage trusted publishers, locations, documents, and macro settings
Determines default Design View settings; also provides default error-checking options
Sets default interface, file format, default database folder, and user name options
Determines whether the windows are overlapping or tabbed and whether the database compacts on close
Determines the default gridlines, cell effects, and fonts

Accepted Answer

The Answer of Datasheet and General and Current Database and is...

Question 14

Use a(n) ____ to maintain constant power to a file server in the event of a power problem.

Accepted Answer

A)  UPS 
B)  surge protector 
C)  power strip 
D)  encryption program 
A)  UPS 
B)  surge protector 
C)  power strip 
D)  encryption program

Question 15

A(n) ____ can cause a vast number of damaging actions ranging from profane messages to destruction of files.

Accepted Answer

A)  spike 
B)  brown-out 
C)  UPS 
D)  virus 
A)  spike 
B)  brown-out 
C)  UPS 
D)  virus

Question 16

Which of the following Access options sets defaults for cursor action, margins, and date formatting?

Accepted Answer

A)  Object Designers 
B)  Quick Access Toolbar 
C)  Customize Ribbon 
D)  Client Settings 
A)  Object Designers 
B)  Quick Access Toolbar 
C)  Customize Ribbon 
D)  Client Settings

Question 17

Once a database is open, ____ is one way to improve 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 18

When you type a password in the Set Database Password dialog box, question marks (?) appear instead of the actual keystroke.

Accepted Answer

A) True 
 B)False

Question 19

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 20

Navigation forms can be used with any Access database, even if you don't publish it to a SharePoint server.

Accepted Answer

A) True 
 B)False

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

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

Which of the following is NOT a method to help secure an Access database?

A power surge is often referred to as a ____.

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

Which Access database file format supports multivalued fields?

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

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

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

The .laccdb file is a temporary file.

The Access 2007 database format works with Access 2007, 2010, ____, and 2016.

Set the Initial Form startup option to specify which form opens when the database application opens.

Use a(n) ____ to maintain constant power to a file server in the event of a power problem.

A(n) ____ can cause a vast number of damaging actions ranging from profane messages to destruction of files.

Which of the following Access options sets defaults for cursor action, margins, and date formatting?

Once a database is open, ____ is one way to improve overall performance.

When you type a password in the Set Database Password dialog box, question marks (?) appear instead of the actual keystroke.

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

Navigation forms can be used with any Access database, even if you don't publish it to a SharePoint server.

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

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

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

Which of the following is NOT a method to help secure an Access database?

A power surge is often referred to as a ____.

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

Which Access database file format supports multivalued fields?

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

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

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

The .laccdb file is a temporary file.

The Access 2007 database format works with Access 2007, 2010, ____, and 2016.

Set the Initial Form startup option to specify which form opens when the database application opens.

Use a(n) ____ to maintain constant power to a file server in the event of a power problem.

A(n) ____ can cause a vast number of damaging actions ranging from profane messages to destruction of files.

Which of the following Access options sets defaults for cursor action, margins, and date formatting?

Once a database is open, ____ is one way to improve overall performance.

When you type a password in the Set Database Password dialog box, question marks (?) appear instead of the actual keystroke.

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

Navigation forms can be used with any Access database, even if you don't publish it to a SharePoint server.

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