Exam 16: Administering the Database

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.

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

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

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

Client/server computing is defined as ____.

_____ options are a series of commands that execute when the database is opened.

If you split an Access database, what is the name of the database that is stored on the client's machine?

____ are installed to link multiple PCs together so they can share hardware and software resources.

Use the Split Table Manager to manage a split database.

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

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

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

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

Which of the following Access options provides a way to set security, macro, and other privacy settings?

Access to queries, forms, and reports may all be added to a navigation form.

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

-Doug is not familiar with the file extensions of .mdb, .accdt, or .accde referenced in the figure shown above. Explain the purpose of each.

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

The .laccdb file is a temporary file.

Which of the following is NOT a level of advice regarding performance as analyzed by the Performance Analyzer?