Question 1

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 2

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.

Accepted Answer

A) External Data 
B) Database Tools 
C) Create 
D) Home 
A) External Data 
B) Database Tools 
C) Create 
D) Home

Question 3

The database created when using the Database Splitter that includes the tables of the database.

Accepted Answer

A) front-end database 
B) AutoFilter 
C) Performance Analyzer 
D) inner query 
E) linked table
F)back-end database
G)outer query
H)subquery
I)parent query
J)Filter by Selection
K)multivalued field
L)Use Access Special Keys option
M)Display Form option 
A) front-end database 
B) AutoFilter 
C) Performance Analyzer 
D) inner query 
E) linked table
F)back-end database
G)outer query
H)subquery
I)parent query
J)Filter by Selection
K)multivalued field
L)Use Access Special Keys option
M)Display Form option

Question 4

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 5

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 6

The protection of a database against intentional or accidental unauthorized access is known as database ____.

Accepted Answer

A) security 
B) encryption 
C) protection 
D) oversight 
A) security 
B) encryption 
C) protection 
D) oversight

Question 7

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

Accepted Answer

Student answers will vary.
Access treats

Question 8

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.

Accepted Answer

A) OLE object 
B) Attachment 
C) Memo 
D) Hyperlink 
A) OLE object 
B) Attachment 
C) Memo 
D) Hyperlink

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Another name for a parent query.

Accepted Answer

A) front-end database 
B) AutoFilter 
C) Performance Analyzer 
D) inner query 
E) linked table
F)back-end database
G)outer query
H)subquery
I)parent query
J)Filter by Selection
K)multivalued field
L)Use Access Special Keys option
M)Display Form option 
A) front-end database 
B) AutoFilter 
C) Performance Analyzer 
D) inner query 
E) linked table
F)back-end database
G)outer query
H)subquery
I)parent query
J)Filter by Selection
K)multivalued field
L)Use Access Special Keys option
M)Display Form option

Question 11

____ filters records that match multiple criteria using the same Access logical and comparison operators used in queries.

Accepted Answer

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

Question 12

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

Accepted Answer

A) *.accdb 
B) *.mdbe 
C) *.accde 
D) *.accmdbe 
A) *.accdb 
B) *.mdbe 
C) *.accde 
D) *.accmdbe

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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?

Accepted Answer

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

Question 16

The filter type that filters records containing one of the selections displayed in a menu of values and context-sensitive choices for the selected field.

Accepted Answer

A) front-end database 
B) AutoFilter 
C) Performance Analyzer 
D) inner query 
E) linked table
F)back-end database
G)outer query
H)subquery
I)parent query
J)Filter by Selection
K)multivalued field
L)Use Access Special Keys option
M)Display Form option 
A) front-end database 
B) AutoFilter 
C) Performance Analyzer 
D) inner query 
E) linked table
F)back-end database
G)outer query
H)subquery
I)parent query
J)Filter by Selection
K)multivalued field
L)Use Access Special Keys option
M)Display Form option

Question 17

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

Accepted Answer

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

Question 18

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

A) front-end database 
B) AutoFilter 
C) Performance Analyzer 
D) inner query 
E) linked table
F)back-end database
G)outer query
H)subquery
I)parent query
J)Filter by Selection
K)multivalued field
L)Use Access Special Keys option
M)Display Form option 
A) front-end database 
B) AutoFilter 
C) Performance Analyzer 
D) inner query 
E) linked table
F)back-end database
G)outer query
H)subquery
I)parent query
J)Filter by Selection
K)multivalued field
L)Use Access Special Keys option
M)Display Form option

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

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

Where is an Access database password stored?

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.

The database created when using the Database Splitter that includes the tables of the database.

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

The protection of a database against intentional or accidental unauthorized access is known as database ____.

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

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.

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

Another name for a parent query.

____ filters records that match multiple criteria using the same Access logical and comparison operators used in queries.

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

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

The filter type that filters records containing one of the selections displayed in a menu of values and context-sensitive choices for the selected field.

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

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.

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

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

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 Formsmodule

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

Relational Databases and Database Design

Filters

Exam 12: Managing and Securing a Database

Where is an Access database password stored?

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.

The database created when using the Database Splitter that includes the tables of the database.

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

The protection of a database against intentional or accidental unauthorized access is known as database ____.

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

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.

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

Another name for a parent query.

____ filters records that match multiple criteria using the same Access logical and comparison operators used in queries.

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

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

The filter type that filters records containing one of the selections displayed in a menu of values and context-sensitive choices for the selected field.

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

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.

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

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

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 Formsmodule

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

Relational Databases and Database Design

Filters