Exam 12: Managing and Securing a Database

After splitting a database using the Database Splitter, if the back-end database is moved to a different drive location, the Linked Table Manager must be used to change the physical drive locations of the tables located in the back-end database for the front-end database to be able to use them.____________________

(True/False)

4.8/5

(35)

Question 21

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.

(Multiple Choice)

4.7/5

(35)

Question 22

Table design for tables in a split database may only be modified in the front-end database.____________________

(True/False)

4.8/5

(35)

Question 23

Which of the following is an example of a database containing the database tables created by the Database Splitter for the Sales database?

(Multiple Choice)

4.9/5

(37)

Question 24

A filter may be saved as a query for a specific form or datasheet.

(True/False)

4.8/5

(51)

Question 25

Matching

Premises:

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

Responses:

multivalued field

Filter by Selection

outer query

Correct Answer:

Verified

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

(Matching)

4.8/5

(30)

Question 26

Matching

Premises:

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

Responses:

front-end database

Use Access Special Keys option

subquery

Correct Answer:

Verified

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

(Matching)

4.7/5

(34)

Question 27

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

(True/False)

4.8/5

(32)

Question 28

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

(Multiple Choice)

4.8/5

(38)

Question 29

It is recommended that the user interface of a database be displayed using the ____ when a database opens with the Display Navigation Pane property disabled.

(Multiple Choice)

4.9/5

(39)

Question 30

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

(Multiple Choice)

4.9/5

(35)

Question 31

Matching

Premises:

A table that is stored in a file outside of the open database that can be updated from the open database.

Responses:

inner query

Display Form option

Performance Analyzer

Correct Answer:

Verified

A table that is stored in a file outside of the open database that can be updated from the open database.

(Matching)

4.9/5

(41)

Question 32

The contents of an encrypted database cannot be recovered if the password for the database is not available.

(True/False)

4.8/5

(38)

Question 33

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

(True/False)

4.9/5

(46)

Question 34

Matching

Premises:

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

Responses:

Filter by Selection

parent query

back-end database

Correct Answer:

Verified

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

(Matching)

4.8/5

(26)

Question 35

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?

(Essay)

4.8/5

(34)

Question 36

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

(Multiple Choice)

4.7/5

(26)

Question 37

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

(Multiple Choice)

4.8/5

(36)

Question 38

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

(Multiple Choice)

4.9/5

(36)

Question 39

Which type of field is a lookup field that allows more than one value to be stored in a field in each record?

(Multiple Choice)

4.8/5

(38)

Question 40

Showing 21 - 40 of 75

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.

Table design for tables in a split database may only be modified in the front-end database.____________________

Which of the following is an example of a database containing the database tables created by the Database Splitter for the Sales database?

A filter may be saved as a query for a specific form or datasheet.

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

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

It is recommended that the user interface of a database be displayed using the ____ when a database opens with the Display Navigation Pane property disabled.

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

The contents of an encrypted database cannot be recovered if the password for the database is not available.

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

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?

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

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

Which type of field is a lookup field that allows more than one value to be stored in a field in each record?

Access-Module 1: 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

Relational Databases and Database Design

Filters