Exam 12: Managing and Securing a Database

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?

Any database action that does not involve updating the database is known as ____ the database.

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. -The first set of data Sheng needs to provide is the names of all floor mat manufacturers who provide floor mats that fit a specific car model.  Which type of filter should Sheng apply to the FloorMatCapatibility field that will allow the display of context-sensitive values for this single field?

Using Backstage View and Access Options, set the ____ property to change the title of the database that appears in the Access window title bar.

Access versions prior to 2007 do not have the capability to open Access 2016 databases even if saved as a previous version file if the database contains a(n)____ field type for a field.

Values designated for a multivalue field cannot be changed after the field is created and the table is saved.

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

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. -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 ____.

In order to isolate a subset of records from an open form or datasheet that will be needed only temporarily, a set of criteria may be placed on the records using a(n)____.

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

An outer query may also be referred to as a subquery.____________________

A filter may be saved as a query from the Advanced button in the Sort & Filter group on the Home tab.

It is good practice to make a backup copy of a database before using the Database Splitter to split the database into two files.

Which type of filter selects records that equal or contain (or do not equal or do not contain)a selected value in a field?

Why is it a good idea to set the Allow Zero Length property to No for fields with the Text or Memo data types?

Where is an Access database password stored?

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.