Exam 12: Managing and Securing a Database

Which Access feature is used to change the filename or drive location for linked tables in an Access database?

The process of linking an outside data source to an Access database begins by clicking on the Access button in the Import & Link group on the ____ tab.

Case-Based Critical Thinking Questions Case 12-1 Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager. He has been given specific requirements to narrow the data based on the information the manager needs. Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information. -Sheng needs to determine which vendors provide the most options for floor mats that are compatible with the specific car model. To do this, he will apply a filter that is based on multiple selection criteria and that sorts the records that are selected by vendor name alphabetically.  Which type of filter will Sheng apply to the datasheet?

When a database is encrypted, data that is modified is encrypted ____.

Startup options for a database may be bypassed when opening a database by pressing the ____ key while clicking on the database name.

When shared access is allowed to a database, ____ occurs when one user is updating a record (or row)in the database and another user is denied access to that table row.

A database must be opened using ____ meaning that only one copy of the database is open in order to set a password for the database.

Case-Based Critical Thinking Questions Case 12-2 Marissa's monogram business has expanded exponentially since she added an online catalog and ordering to her business.  Her database needs to be expanded and changed to meet the needs of the growing business.  Her database includes tables for monogram styles, catalog products, orders, billing, customers, and vendors. -Marissa's assistant suggested other changes be made to the database. After the changes were made, Marissa used the ____ Access tool to optimize the database by having the tool implement recommendations and suggestions.

The data in the tables of a split database is modified by the back-end database.

Case-Based Critical Thinking Questions Case 12-2 Marissa's monogram business has expanded exponentially since she added an online catalog and ordering to her business.  Her database needs to be expanded and changed to meet the needs of the growing business.  Her database includes tables for monogram styles, catalog products, orders, billing, customers, and vendors. -There are occasions when Marissa has orders from one customer for different monogram styles for the same product. Rather than creating separate orders for each item, she might use a(n)____ field to store the different monogram styles for the product in the Orders table.

When using a Filter By Form to filter records, all criteria on one line must be met by a record for the record to appear in the filtered data datasheet.____________________

Case-Based Critical Thinking Questions Case 12-1 Sheng has been asked to provide data from the Inventory database of a regional auto parts store to the store's regional manager. He has been given specific requirements to narrow the data based on the information the manager needs. Sheng will apply filters to the tables in the Inventory database to provide his manager with the requested information. -Sheng's regional manager may ask for the same information again at a later date so Sheng would like to save one of his filters for use later.  What is the best option for saving the filter?

The Advanced button in the Sort & Filter group on the Home tab allows the user to verify that a filter is working properly.