Question 1

You manage default startup options using the features in the _____ Database category of the Access Options dialog box.

Accepted Answer

The answer of You manage default startup options using the...

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

The figure shows a form with Horizontal Tabs.

Accepted Answer

A) True 
 B)False

Question 4

Use the Split Table Manager to manage a split database.

Accepted Answer

A) True 
 B)False

Question 5

Closing all applications that you don't currently need to free up memory is a relatively easy way to improve performance.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is NOT a way to display the objects in the Navigation Pane?

Accepted Answer

A)  by Ownership 
B)  by Object Type 
C)  by Created Date 
D)  by Custom Groups 
A)  by Ownership 
B)  by Object Type 
C)  by Created Date 
D)  by Custom Groups

Question 7

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

Accepted Answer

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

Question 8

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

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 11

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 12

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 13

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

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

Accepted Answer

The Answer of Current Database and Trust Center and Datasheet is...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

In the figure above, the Compact on Close option is checked. This helps you ____.

Accepted Answer

A)  set a startup switchboard 
B)  make sure the windows are tabbed 
C)  keep the database as small and efficient as possible 
D)  secure the database with a password 
A)  set a startup switchboard 
B)  make sure the windows are tabbed 
C)  keep the database as small and efficient as possible 
D)  secure the database with a password

Question 18

Set the Program Title startup option to add a custom title to the title bar instead of the database name and path.

Accepted Answer

A) True 
 B)False

Question 19

The .laccdb file is a temporary file.

Accepted Answer

A) True 
 B)False

Question 20

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

You manage default startup options using the features in the _____ Database category of the Access Options dialog box.

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

The figure shows a form with Horizontal Tabs.

Use the Split Table Manager to manage a split database.

Closing all applications that you don't currently need to free up memory is a relatively easy way to improve performance.

Which of the following is NOT a way to display the objects in the Navigation Pane?

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

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

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

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?

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

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

In the figure above, the Compact on Close option is checked. This helps you ____.

Set the Program Title startup option to add a custom title to the title bar instead of the database name and path.

The .laccdb file is a temporary file.

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

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

You manage default startup options using the features in the _____ Database category of the Access Options dialog box.

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

The figure shows a form with Horizontal Tabs.

Use the Split Table Manager to manage a split database.

Closing all applications that you don't currently need to free up memory is a relatively easy way to improve performance.

Which of the following is NOT a way to display the objects in the Navigation Pane?

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

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

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

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?

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

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

In the figure above, the Compact on Close option is checked. This helps you ____.

Set the Program Title startup option to add a custom title to the title bar instead of the database name and path.

The .laccdb file is a temporary file.

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

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