Question 1

To display a multivalued field in expanded form so that each value is displayed on a separate row in a query, set the ____ property for the field.

Accepted Answer

A)  Lookup 
B)  Value 
C)  Row Source 
D)  Validation Rule 
A)  Lookup 
B)  Value 
C)  Row Source 
D)  Validation Rule B

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

Match between columns
                        Premises: The filter type used to filter records that equal or contain (or do not equal or do not contain) a selected value in a field.

Accepted Answer

The Answer of AutoFilter and back-end database and Performance Analyzer is...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

The three types of analysis results listed by the ____________________ are recommendation, suggestion, and idea.

Accepted Answer

Performanc

Question 7

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

Accepted Answer

A)  Display Status Bar 
B)  Application Title 
C)  Application Icon 
D)  Document Window Options 
A)  Display Status Bar 
B)  Application Title 
C)  Application Icon 
D)  Document Window Options

Question 8

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?

Accepted Answer

A)  save the filter as a datasheet 
B)  save the filter with the form 
C)  save the filter as a query 
D)  save the filter as a separate file 
A)  save the filter as a datasheet 
B)  save the filter with the form 
C)  save the filter as a query 
D)  save the filter as a separate file

Question 9

Where is an Access database password stored?

Accepted Answer

A)  in an Access module 
B)  in an Access table named tblPW 
C)  it is not stored anywhere 
D)  in a separate database created by Access 
A)  in an Access module 
B)  in an Access table named tblPW 
C)  it is not stored anywhere 
D)  in a separate database created by Access

Question 10

Match between columns
                        Premises: An Access tool used to optimize the performance of an Access database.

Accepted Answer

The Answer of outer query and linked table and subquery is...

Question 11

Match between columns
                        Premises: A table that is stored in a file outside of the open database that can be updated from the open database.

Accepted Answer

The Answer of outer query and inner query and Performance is...

Question 12

In the accompanying figure, the user has been restricted to using only the ____ and ____ tabs on the Access Ribbon.

Accepted Answer

A)  Forms and Queries 
B)  Queries and Reports 
C)  File and Home 
D)  Records and Find 
A)  Forms and Queries 
B)  Queries and Reports 
C)  File and Home 
D)  Records and Find

Question 13

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

Accepted Answer

A)  tables 
B)  modules 
C)  macros 
D)  database tools 
A)  tables 
B)  modules 
C)  macros 
D)  database tools

Question 14

Using the accompanying figure, which field property is set to allow more than one value to be added to the field?

Accepted Answer

A)  Row Source 
B)  Allow Multiple Values 
C)  Allow Value List Edits 
D)  Row Source Type 
A)  Row Source 
B)  Allow Multiple Values 
C)  Allow Value List Edits 
D)  Row Source Type

Question 15

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.

Accepted Answer

A)  ODBC Database 
B)  Object Dependencies 
C)  Performance Analyzer 
D)  Compact and Repair 
A)  ODBC Database 
B)  Object Dependencies 
C)  Performance Analyzer 
D)  Compact and Repair

Question 16

In the accompanying figure, which numbered arrow indicates that a filter has been applied to the current datasheet?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 17

The AutoNumber data type allows the option to specify either sequential numbering or random numbering for a field.____________________

Accepted Answer

A) True 
 B)False

Question 18

To display each value of a multivalued field in a separate row use the ____________________ property for the multivalued field.

Accepted Answer

The answer of To display each value of a multivalued...

Question 19

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?

Accepted Answer

A)  Advanced Filter/Sort 
B)  AutoFilter 
C)  Filter by Form 
D)  Filter by Selection 
A)  Advanced Filter/Sort 
B)  AutoFilter 
C)  Filter by Form 
D)  Filter by Selection

Question 20

Which of the following is an example of sensitive data that would warrant the database being encrypted and protected with a password?

Accepted Answer

A)  health record information 
B)  course schedule 
C)  employee addresses 
D)  customer ID numbers 
A)  health record information 
B)  course schedule 
C)  employee addresses 
D)  customer ID numbers

To display a multivalued field in expanded form so that each value is displayed on a separate row in a query, set the ____ property for the field.

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

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

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

The three types of analysis results listed by the ____________________ are recommendation, suggestion, and idea.

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

Where is an Access database password stored?

In the accompanying figure, the user has been restricted to using only the and tabs on the Access Ribbon.

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

Using the accompanying figure, which field property is set to allow more than one value to be added to the field?

In the accompanying figure, which numbered arrow indicates that a filter has been applied to the current datasheet?

The AutoNumber data type allows the option to specify either sequential numbering or random numbering for a field.____________________

To display each value of a multivalued field in a separate row use the ____________________ property for the multivalued field.

Which of the following is an example of sensitive data that would warrant the database being encrypted and protected with a password?

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Filters

Exam 13: Managing and Sharing a Database

To display a multivalued field in expanded form so that each value is displayed on a separate row in a query, set the ____ property for the field.

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

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

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

The three types of analysis results listed by the ____________________ are recommendation, suggestion, and idea.

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

Where is an Access database password stored?

In the accompanying figure, the user has been restricted to using only the ____ and ____ tabs on the Access Ribbon.

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

Using the accompanying figure, which field property is set to allow more than one value to be added to the field?

In the accompanying figure, which numbered arrow indicates that a filter has been applied to the current datasheet?

The AutoNumber data type allows the option to specify either sequential numbering or random numbering for a field.____________________

To display each value of a multivalued field in a separate row use the ____________________ property for the multivalued field.

Which of the following is an example of sensitive data that would warrant the database being encrypted and protected with a password?

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Filters

In the accompanying figure, the user has been restricted to using only the and tabs on the Access Ribbon.