Question 1

Encryption is primarily a(n) ____ issue.

Accepted Answer

A)  performance 
B)  data accuracy 
C)  security 
D)  ease-of-use 
A)  performance 
B)  data accuracy 
C)  security 
D)  ease-of-use

Question 2

The form in the figure displays the frmEmployees form on the first tab.

Accepted Answer

A) True 
 B)False

Question 3

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 4

A front-end database will contain _____ to the tables in the back-end database.

Accepted Answer

The answer of A front-end database will contain _____ to...

Question 5

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

Accepted Answer

1.  It supports the Attachment

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

The dialog box in the figure is accessed from which tab on the Ribbon?

Accepted Answer

A)  VIEW 
B)  BACKSTAGE 
C)  FILE 
D)  TOOLS 
A)  VIEW 
B)  BACKSTAGE 
C)  FILE 
D)  TOOLS

Question 10

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 11

Use the Access ____ file format for databases you need to work with Access 2000, 2002, and 2003.

Accepted Answer

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

Question 12

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

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 15

This startup command-line option starts Access and runs the specified macro.

Accepted Answer

A)  /x macro 
B)  /run macro 
C)  /start macro 
D)  /execute macro 
A)  /x macro 
B)  /run macro 
C)  /start macro 
D)  /execute macro

Question 16

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 17

Command-line options follow which character in the path to the file?

Accepted Answer

A)  Forward slash (/) 
B)  Backslash (\) 
C)  Pound sign (#) 
D)  Exclamation point (!) 
A)  Forward slash (/) 
B)  Backslash (\) 
C)  Pound sign (#) 
D)  Exclamation point (!)

Question 18

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 19

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 20

This startup command-line option repairs the database.

Accepted Answer

A)  /repair 
B)  /compact 
C)  /fix 
D)  /rep 
A)  /repair 
B)  /compact 
C)  /fix 
D)  /rep

Encryption is primarily a(n) ____ issue.

The form in the figure displays the frmEmployees form on the first tab.

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

A front-end database will contain _____ to the tables in the back-end database.

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

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

A power surge is often referred to as a ____.

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

The dialog box in the figure is accessed from which tab on the Ribbon?

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

Use the Access ____ file format for databases you need to work with Access 2000, 2002, and 2003.

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

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

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

This startup command-line option starts Access and runs the specified macro.

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

Command-line options follow which character in the path to the file?

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.

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

This startup command-line option repairs 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

Encryption is primarily a(n) ____ issue.

The form in the figure displays the frmEmployees form on the first tab.

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

A front-end database will contain _____ to the tables in the back-end database.

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

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

A power surge is often referred to as a ____.

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

The dialog box in the figure is accessed from which tab on the Ribbon?

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

Use the Access ____ file format for databases you need to work with Access 2000, 2002, and 2003.

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

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

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

This startup command-line option starts Access and runs the specified macro.

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

Command-line options follow which character in the path to the file?

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.

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

This startup command-line option repairs 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