Exam 13: Managing and Sharing a 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?

To display all fields from the record source without all fields being added to the design of a query, set the ____________________ property to Yes.

The Performance Analyzer can automatically complete the recommendations and ____________________ listed after the analysis.

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

When deciding whether or not to use a multivalued filed in an Access database, what limitations of using multivalued fields should be given careful thought?

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.

Using the Product Vendor form, Sheng would like to filter records that match multiple selection criteria; however, he does not need the filtered records to be sorted.  Which type of filter should Sheng use for this task?

Which filter type allows the use of comparison operators such as =, , and Like?

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.

The objects in a front-end database use tables in the ____.

The ____ filter allows multiple criteria to be selected and a sort order to be defined for the selected records.

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

Attachments associated with a field whose data type is Attachment may be exported using the Remove button from the Attachments dialog box.____________________

The Database Splitter creates two Access database files; the database that contains the database tables is the ____________________.

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.

Users may be prevented from viewing and editing VBA code by saving the database as a(n) ____ file version.