Question 1

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

Question 2

Only one file attachment is allowed for a field with the Attachment data type selected.

Accepted Answer

A) True 
 B)False

Question 3

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?

Accepted Answer

Student answers will vary but should con

Question 4

Which type of filter filters records containing a selection displayed in a menu of values and context-sensitive choices for the selected 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 5

An Access tool used to optimize the performance of an Access 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 6

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 7

The New Values property setting for a field with the AutoNumber data type uses the ____ setting to specify sequential numbering.

Accepted Answer

A) Sequential 
B) Next 
C) Random 
D) Increment 
A) Sequential 
B) Next 
C) Random 
D) Increment

Question 8

The ____ method is used to copy a table and copies both the design of the table and the data from the table.

Accepted Answer

A) Structure Only 
B) Append Data to Existing Table 
C) Append Design to Existing Table 
D) Structure and Data 
A) Structure Only 
B) Append Data to Existing Table 
C) Append Design to Existing Table 
D) Structure and Data

Question 9

Performance Analyzer can only run on one Access database object at a time.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) viewing 
B) sharing access 
C) reading 
D) locking 
A) viewing 
B) sharing access 
C) reading 
D) locking

Question 11

​A lookup eld that allows you to store more than one value in a field in each record

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 12

When a database is encrypted,data that is modified is encrypted ____.

Accepted Answer

A) after the database is updated 
B) when the database is closed 
C) before the database is updated 
D) when the database is opened 
A) after the database is updated 
B) when the database is closed 
C) before the database is updated 
D) when the database is opened

Question 13

The ____ data type allows external files to be attached to a table record and stored as part of the database.

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

A database must be opened using ____ meaning that only one copy of the database is open in order to set a password for the database.

Accepted Answer

A) shared access 
B) exclusive access 
C) encrypted access 
D) locked access 
A) shared access 
B) exclusive access 
C) encrypted access 
D) locked access

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

Only one file attachment is allowed for a field with the Attachment data type selected.

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?

Which type of filter filters records containing a selection displayed in a menu of values and context-sensitive choices for the selected field?

An Access tool used to optimize the performance of an Access database.

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 New Values property setting for a field with the AutoNumber data type uses the ____ setting to specify sequential numbering.

The ____ method is used to copy a table and copies both the design of the table and the data from the table.

Performance Analyzer can only run on one Access database object at a time.

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

A lookup eld that allows you to store more than one value in a field in each record

When a database is encrypted,data that is modified is encrypted ____.

The ____ data type allows external files to be attached to a table record and stored as part of the database.

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

A database must be opened using ____ meaning that only one copy of the database is open in order to set a password for the database.

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

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

Only one file attachment is allowed for a field with the Attachment data type selected.

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?

Which type of filter filters records containing a selection displayed in a menu of values and context-sensitive choices for the selected field?

An Access tool used to optimize the performance of an Access database.

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 New Values property setting for a field with the AutoNumber data type uses the ____ setting to specify sequential numbering.

The ____ method is used to copy a table and copies both the design of the table and the data from the table.

Performance Analyzer can only run on one Access database object at a time.

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

​A lookup eld that allows you to store more than one value in a field in each record

When a database is encrypted,data that is modified is encrypted ____.

The ____ data type allows external files to be attached to a table record and stored as part of the database.

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

A database must be opened using ____ meaning that only one copy of the database is open in order to set a password for the database.

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

A lookup eld that allows you to store more than one value in a field in each record