Question 1

Match the Access options dialog box category with the best choice.
-Sets default interface, file format, default database folder, and user name options
A)General
B)Current Database
C)Datasheet
D)Object Designers
E)Trust Center

Accepted Answer

The "General" category in the Access options dialog box is where you can set default interface options, file format, default database folder, and user name options.

Question 2

-Julia needs to share a database she created in Access 2013 with Jacob who is still working with Access 2003. In the figure above, what option must Julia choose in order to create a copy of the database that will work for Jacob?

Accepted Answer

The answer of 
-Julia needs to share a database she...

Question 3

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
A)General
B)Current Database
C)Datasheet
D)Object Designers
E)Trust Center

Accepted Answer

This option is found in the Current Database category under the "Document Window Options" section. It allows the user to choose whether the windows are overlapping or tabbed and whether the database should compact on close.

Question 4

-The figure shows an example of a switchboard form.

Accepted Answer

navigation

Question 5

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

Accepted Answer

The answer of 
-Which category of options in the figure...

Question 6

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

Accepted Answer

.accde
accde

Question 7

Match the Access options dialog box category with the best choice.
-Determines the default gridlines, cell effects, and fonts
A)General
B)Current Database
C)Datasheet
D)Object Designers
E)Trust Center

Accepted Answer

The options for gridlines, cell effects, and fonts can be found under the Datasheet category in the Access options dialog box.

Question 8

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

Accepted Answer

The answer of 
-Daniel needs to create a backup of...

Question 9

Match the Access options dialog box category with the best choice.
-Provides a way to manage trusted publishers, locations, documents, and macro settings
A)General
B)Current Database
C)Datasheet
D)Object Designers
E)Trust Center

Accepted Answer

The Trust Center dialog box provides options to manage trusted publishers, locations, documents, and macro settings.

Question 10

Match the Access options dialog box category with the best choice.
-Determines default Design View settings; also provides default error-checking options
A)General
B)Current Database
C)Datasheet
D)Object Designers
E)Trust Center

Accepted Answer

The "Object Designers" category in Access options dialog box is used to set default Design View settings and error-checking options for database objects.

Question 11

To add a new tab to the form shown in the figure, click the [Add New] tab.

Accepted Answer

The statement is correct, to add a new tab to the form, click the [Add New] tab.

Question 12

-Which options would Wendy use in the figure shown to set the opening form and also make sure that the database was compacted and repaired every time it was closed?

Accepted Answer

The answer of 
-Which options would Wendy use in the...

Question 13

-In the figure above, if you save to a database template file, you will create a file with a .accde file extension.

Accepted Answer

.accdt
accdt

Quiz 16: Administering the Database

Match the Access options dialog box category with the best choice. -Sets default interface, file format, default database folder, and user name options

-Julia needs to share a database she created in Access 2013 with Jacob who is still working with Access 2003. In the figure above, what option must Julia choose in order to create a copy of the database that will work for Jacob?

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