Question 1

The Database Documenter provides step-by-step help for using an Access database.

Accepted Answer

The Database Documenter in Access creates detailed reports about the objects in a database, but it does not provide step-by-step help for using the database.

Question 2

In a Navigation form, you reorder tabs by dragging them to a new location on the form.

Accepted Answer

This is true, in a Navigation form you can reorder tabs by selecting and dragging them to a new location on the form.

Question 3

One reason to split a database is to improve performance.

Accepted Answer

Splitting a database can improve performance by reducing the amount of data that needs to be processed or retrieved in any given operation. This can lead to faster queries, better scalability, and improved overall system performance.

Question 4

_____ passwords are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.
A) Split
B) Strong
C) Combination
D) Exclusive

Accepted Answer

Strong passwords are the ones that are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.

Question 5

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.

Accepted Answer

- front-end
 - front end
 - Front-End
 - Front End
 - Front-end
- Front end
 - FRONT-END
 - FRONT END

Question 6

You set the opening Display Form for a database using the Access Preferences dialog box.

Accepted Answer

- Options
 - options
 - OPTIONS

Question 7

You can select a particular form, such as a Navigation form, to display when Access starts.

Accepted Answer

This can be done by going to File > Options > Current Database and selecting the desired form in the "Display Form" drop-down menu.

Question 8

Database passwords are case sensitive, which means that IOWA and iowa are different passwords.

Accepted Answer

Passwords in databases are case-sensitive, meaning that even a small difference in the capitalization, such as "IOWA" and "iowa," will be considered two separate passwords.

Question 9

Exception mode means that you are the only person who has the database open, and others cannot open the file during this time.

Accepted Answer

- Exclusive
 - exclusive
 - EXCLUSIVE

Question 10

For a table, the _____ produces a report listing the field names, property values for each field, and table relationships.
A) Linked Table Manager
B) Database Documenter
C) Performance Analyzer
D) Object Dependencies pane

Accepted Answer

The Database Documenter produces a report listing the field names, property values for each field, and table relationships for a table in Access. The Linked Table Manager is used to manage linked tables, the Performance Analyzer is used to analyze performance issues, and the Object Dependencies pane displays all objects that depend on a selected object.

Question 11

The Performance Analyzer recommends how you can improve database performance.

Accepted Answer

The Performance Analyzer is a tool that analyzes database performance and recommends ways to improve it.

Question 12

What happens when you drag a tab on a Navigation form in Form Layout View?
A) You delete the tab from the Navigation form.
B) You reorder the tabs on the Navigation form.
C) You increase the width of the Navigation form.
D) You make a copy of the tab on the Navigation form.

Accepted Answer

When you drag a tab on a Navigation form in Form Layout View, you can reorder the tabs on the Navigation form. The other options listed (deleting the tab, increasing the width of the form, and making a copy of the tab) do not occur when dragging a tab.

Question 13

You use the Performance Analyzer to analyze tables only.

Accepted Answer

The Performance Analyzer can be used to analyze both tables and indexes.

Question 14

When you split an Access database, how many copies of the back-end database do you have?
A) One copy for each user
B) One copy for each object in the database
C) One copy
D) Two copies

Accepted Answer

When you split an Access database, only one copy of the back-end database is created. It is shared among all users who access the front-end database.

Question 15

Set the Database Title property of a database to change the text displayed in the title bar.

Accepted Answer

- Application
 - application
 - APPLICATION

Question 16

What must you do before setting a password for a database?
A) Split the database.
B) Open the database in Exclusive mode.
C) Remove any linked tables from the database.
D) 'Set a password for each object in the database.

Accepted Answer

Before setting a password for a database, it is recommended to open the database in Exclusive mode. This ensures that no other users are accessing the database while you are making changes to the passwords or security settings. It is not necessary to split the database, remove linked tables or set passwords for each object in the database before setting a password for the database.

Question 17

_____ a database means to identify the database file as safe to open.
A) Securing
B) Enabling
C) Trusting
D) Splitting

Accepted Answer

Trusting a database means to establish it as a trusted source, allowing it to be opened and accessed without security warnings or prompts. This is often necessary when working with files downloaded from the internet or received from another source, as they may initially be considered unsafe by the operating system or security software.

Question 18

The most important items in the Performance Analyzer results are the _____ and the suggestions.
A) recommendations
B) ideas
C) lightbulb icons
D) proposals

Accepted Answer

The recommendations are the most important items in the Performance Analyzer results because they provide specific actions that can be taken to improve website performance. The other options (ideas, lightbulb icons, proposals) are not as significant as they do not offer actionable suggestions.

Question 19

A database in a trusted folder enables all database content, including all macros and VBA.

Accepted Answer

When a database is in a trusted folder, all content is trusted by default, including macros and VBA. This can pose a security risk and should be carefully considered before setting up trusted folders.

Question 20

_____ means to make the data in a database unreadable by other software.
A) Encrypting
B) Backing up
C) Compacting
D) Trusting

Accepted Answer

Encrypting means to scramble the data in a way that only authorized parties with a key can read it. This ensures data security and privacy, especially when sensitive information is stored in a database.

Quiz 8: Access

The Database Documenter provides step-by-step help for using an Access database.

In a Navigation form, you reorder tabs by dragging them to a new location on the form.

One reason to split a database is to improve performance.

_____ passwords are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.

You set the opening Display Form for a database using the Access Preferences dialog box.

You can select a particular form, such as a Navigation form, to display when Access starts.

Database passwords are case sensitive, which means that IOWA and iowa are different passwords.

Exception mode means that you are the only person who has the database open, and others cannot open the file during this time.

For a table, the _____ produces a report listing the field names, property values for each field, and table relationships.

The Performance Analyzer recommends how you can improve database performance.

What happens when you drag a tab on a Navigation form in Form Layout View?

You use the Performance Analyzer to analyze tables only.

When you split an Access database, how many copies of the back-end database do you have?

Set the Database Title property of a database to change the text displayed in the title bar.

What must you do before setting a password for a database?

_____ a database means to identify the database file as safe to open.

The most important items in the Performance Analyzer results are the _____ and the suggestions.

A database in a trusted folder enables all database content, including all macros and VBA.

_____ means to make the data in a database unreadable by other software.