Exam 12: Managing and Securing a Database

Specifies the form that opens automatically when you open the database

After splitting a database using the Database Splitter,if the back-end database is moved to a different drive location,the Linked Table Manager must be used to change the physical drive locations of the tables located in the back-end database for the front-end database to be able to use them.____________________

Which type of field is a lookup field that allows more than one value to be stored in a field in each record?

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. -Each number in the ItemNumber field for all catalog products were created manually by Marissa.Her new assistant pointed out that she could have the database create the ItemNumber automatically by changing the field's data type to ____.

The Database Splitter splits an Access database into two separate files.One file contains queries,forms,reports,and other database objects and the other file contains the database ____.

The Access default is that databases allow ____ of the database meaning that two or more users can open and use the same database at the same time.

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.

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?

A database may be split by using the Access Database button in the ____ group on the Database Tools tab.

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.

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. -Finally,Marissa wants to secure the database because she does not want all of her new employees to access sensitive customer information such as credit card information.Her assistant suggests she ____ the database which translates the data to a scrambled format and requires a password to access the database.

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

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

A filter may be saved as a query for a specific form or datasheet.

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

Alicia wants a database to open using the frmNavigation object only.To do this,she must disable the ____ option from Backstage View using Options and the Current Database.

It is recommended that the user interface of a database be displayed using the ____ when a database opens with the Display Navigation Pane property disabled.

The contents of an encrypted database cannot be recovered if the password for the database is not available.

Filters applied to query datasheets are saved when the table is saved and may be applied anytime the table datasheet is open.____________________

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