Question 1

The ____ data type allows external files to be attached to a table record and stored as part of the database.
A)Attachment
B)OLE object
C)Text
D)Memo

Accepted Answer

The Attachment data type allows external files such as photos, spreadsheets, and other documents to be attached to a table record and stored as part of the database. The OLE object data type is used for embedding objects such as pictures or videos within a field, while the Text and Memo data types are used for storing text in varying lengths.

Question 2

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.
A)Lookup
B)Value
C)Row Source
D)Validation Rule

Accepted Answer

The Value property determines the value or values displayed for a field in a query, form, or report. By setting the Value property to a multivalued field, each value will be displayed on a separate row in a query result. The Lookup property is used to display a list of values to choose from, the Row Source property specifies the source of the data for a control on a form, and the Validation Rule property sets a rule that determines whether data entered into a field is valid.

Question 3

Where is an Access database password stored?
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

Accepted Answer

Access database passwords are not stored anywhere in the database or in a separate file. They are encrypted and stored in memory while the database is open, and the encryption key is derived from the password entered by the user.

Question 4

Which of the following is an example of a database containing the database tables created by the Database Splitter for the Sales database?
A)Sales_back-end
B)Sales_be
C)SalesBackEnd
D)SalesTables.accdb

Accepted Answer

The Database Splitter automatically adds "_be" to the end of the original database name to create a new back-end database file. Therefore, "Sales_be" would be the expected name of the back-end database created by the Database Splitter for the Sales database. The other options are not consistent with the naming convention used by the Database Splitter.

Question 5

The primary purpose of the ____ is to optimize the performance of an Access database.
A)Table Analyzer
B)SQL Server
C)Relationships Analyzer
D)Performance Analyzer

Accepted Answer

The Performance Analyzer is specifically designed to analyze and optimize the performance of an Access database. It provides recommendations for improving database performance, such as modifying indexing and optimizing queries. Table Analyzer, Relationships Analyzer, and SQL Server are not specifically designed for optimizing performance in Access databases.

Question 6

Which Access feature is used to change the filename or drive location for linked tables in an Access database?
A)Data Services
B)ODBC Database
C)Linked Table Manager
D)Link Tables dialog box

Accepted Answer

Linked Table Manager is the Access feature used to change the filename or drive location for linked tables in an Access database. This feature allows you to easily manage and update the connections between your Access database and external data sources. Options for changing the location or filename of linked tables can be found within the Linked Table Manager.

Question 7

The objects in a front-end database use tables in the ____.
A)modules list
B)ODBC database
C)back-end database
D)relationships window

Accepted Answer

The back-end database is where the tables reside that store the data for the front-end database. The front-end database uses forms, reports, queries, and other objects to interact with this data through the tables in the back-end database.

Question 8

Which Access feature is used to divide an Access database into two files: one file contains the tables of the database and the other file contains the queries, forms, reports, and other database objects.
A)Linked Table Manager
B)Relationships
C)Database Splitter
D)ODBC database

Accepted Answer

The Database Splitter feature is used to split a database into two separate files, one containing the tables and the other with all other objects (queries, forms, reports, etc.). This is typically done to improve performance in a multi-user environment or to easily upgrade the database objects without affecting the data. The Linked Table Manager is used to update or re-link tables in the database to an external data source, Relationships are used to establish connections between tables in the database, and ODBC databases are used to connect to external data sources using Open Database Connectivity (ODBC) drivers. None of these features are used to split a database into two separate files.

Question 9

The ____ filter allows multiple criteria to be selected and a sort order to be defined for the selected records.
A)AutoFilter
B)Filter by Selection
C)Filter B Form
D)Advanced Filter/Sort

Accepted Answer

The Advanced Filter/Sort allows for multiple criteria to be selected and a sort order to be defined. The other options do not offer this functionality.

Question 10

Which type of filter selects records that equal or contain (or do not equal or do not contain)a selected value in a field?
A)AutoFilter
B)Filter By Selection
C)Filter By Form
D)Advanced Filter/Sort

Accepted Answer

The answer of Which type of filter selects records that...

Question 11

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.
A)OLE object
B)Attachment
C)Memo
D)Hyperlink

Accepted Answer

The answer of Access versions prior to 2007 do not...

Question 12

____ filters records that match multiple criteria using the same Access logical and comparison operators used in queries.
A)AutoFilter
B)Filter by Selection
C)Filter By Form
D)Advanced Filter/Sort

Accepted Answer

The answer of ____ filters records that match multiple criteria...

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 ____.
A)tables
B)modules
C)macros
D)database tools

Accepted Answer

The Database Splitter splits an Access database into two files where one file contains queries, forms, reports, and other database objects and the other file contains the database tables.

Question 14

The protection of a database against intentional or accidental unauthorized access is known as database ____.
A)security
B)encryption
C)protection
D)oversight

Accepted Answer

Database security includes various measures and techniques to ensure that data stored in a database is protected against intentional or accidental unauthorized access, modification, or destruction. This involves implementing authentication and authorization mechanisms, encryption, firewalls, intrusion detection and prevention systems, and regularly monitoring and auditing the database access and activity. Encryption (B) is a specific technique within database security that involves transforming plaintext data into ciphertext to prevent unauthorized access to the data. Protection (C) and oversight (D) are broad terms that may cover various aspects of database security but are not specific enough to be the best choice.

Question 15

When a database is encrypted, data that is modified is encrypted ____.
A)after the database is updated
B)when the database is closed
C)before the database is updated
D)when the database is opened

Accepted Answer

When a database is encrypted, data that is modified is encrypted before the database is updated. This ensures that the data remains encrypted and protected even when it is being modified or updated.

Question 16

A database may be split by using the Access Database button in the ____ group on the Database Tools tab.
A)Tools
B)Macro
C)Relationships
D)Move Data

Accepted Answer

The answer of A database may be split by using...

Question 17

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.
A)External Data
B)Database Tools
C)Create
D)Home

Accepted Answer

The External Data tab in Access contains options for importing and linking data from outside sources, including other Access databases, Excel spreadsheets, and text files. Therefore, the correct choice is to click on the Access button in the Import & Link group on the External Data tab to begin linking an outside data source to an Access database.

Question 18

Which filter type allows the use of comparison operators such as =, , and Like?
A)AutoFilter
B)Filter By Form
C)Filter By Selection
D)Advanced Filter/Sort

Accepted Answer

The answer of Which filter type allows the use of...

Question 19

The ____ method is used to copy a table and copies both the design of the table and the data from the table.
A)Structure Only
B)Append Data to Existing Table
C)Append Design to Existing Table
D)Structure and Data

Accepted Answer

The Structure and Data method allows for the complete copying of a table, including both its design and data. Option A only copies the structure of the table without any data, while options B and C are used to add data or design to an existing table, respectively.

Question 20

The New Values property setting for a field with the AutoNumber data type uses the ____ setting to specify sequential numbering.
A)Sequential
B)Next
C)Random
D)Increment

Accepted Answer

The answer of The New Values property setting for a...

Quiz 12: Managing and Securing a Database

The ____ data type allows external files to be attached to a table record and stored as part of the 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.

Where is an Access database password stored?

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

The primary purpose of the ____ is to optimize the performance of an Access database.

Which Access feature is used to change the filename or drive location for linked tables in an Access database?

The objects in a front-end database use tables in the ____.

Which Access feature is used to divide an Access database into two files: one file contains the tables of the database and the other file contains the queries, forms, reports, and other database objects.

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

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

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.

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

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

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

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

A database may be split by using the Access Database button in the ____ group on the Database Tools tab.

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.

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

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

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