Question 1

A control text box displays the actual data from the table.

Accepted Answer

A control text box can display the actual data from the table.

Question 2

Match between columns
                        Premises: Use the ____ block link in the Mail Merge task pane to add an address to the letter in the location of the insertion point.

Accepted Answer

The Answer of Merge and Insert and Mailings and Edit is...

Question 3

By selecting multiple controls, you have the ability to apply formats to several controls at one time.

Accepted Answer

By selecting multiple controls, you can apply formats such as font and color to all of them simultaneously.

Question 4

Match between columns
                        Premises: You can add merge fields individually at the location of the insertion point by clicking the Insert Merge Field button in the Write & Insert Fields group on the ____ tab.

Accepted Answer

The Answer of Merge and Mailings and Edit and Insert is...

Question 5

Avg is one of the functions available in a summary report.

Accepted Answer

The average (avg) is commonly included in summary reports in order to show the mean value of a set of data.

Question 6

Access can only create pie charts.

Accepted Answer

Access can create various types of charts including pie charts, column charts, line charts, and many others.

Question 7

Charts are simple to make and format.

Accepted Answer

Charts can be easily created using spreadsheet software and a variety of formatting options are available to customize the appearance of the chart.

Question 8

You can specify up to three conditions for a field.

Accepted Answer

This statement is true. In many database systems, you can specify up to three criteria or conditions for a field in a query or search.

Question 9

Discuss how to size and align a control.

Accepted Answer

The answer of Discuss how to size and align a...

Question 10

When creating a report, you add a currency format before you apply themes.

Accepted Answer

You can apply the currency format to a cell or range of cells at any time, even after applying themes to the report.

Question 11

You access the Report Wizard by clicking the Create tab on the Ribbon.

Accepted Answer

The Report Wizard is accessed by clicking the Create tab on the Ribbon, and selecting the Report Wizard option in the Reports section.

Question 12

The feature that allows you to see how your form would look with a theme applied is called ____________________.

Accepted Answer

The answer of The feature that allows you to see...

Question 13

When using a report based on a parameter query, you need to create several reports.

Accepted Answer

False. You only need to create one report based on the parameter query, and the user will input the parameter value when prompted to generate customized reports.

Question 14

Match between columns
                        Premises: If you click the Address block link in the Mail Merge task pane, the ____ Address Block dialog box opens and shows a preview of the address information.

Accepted Answer

The Answer of Insert and Mailings and Address and Edit is...

Question 15

A(n) ____________________ displays a list of values and lets you select one from the list.

Accepted Answer

The answer of A(n) ____________________ displays a list of values...

Question 16

A(n) ____________________ button is a button that users can click to perform common tasks.

Accepted Answer

The answer of A(n) ____________________ button is a button that...

Question 17

Match between columns
                        Premises: To merge selected records in the data source, click the ____ recipient list link in the Mail Merge task pane to open the Mail Merge Recipients dialog box.

Accepted Answer

The Answer of Address and Mailings and Edit and Merge is...

Question 18

Match between columns
                        Premises: Click the Print link in the ____ section of the Mail Merge task pane to print the letters.

Accepted Answer

The Answer of Address and Mailings and Edit and Insert is...

Question 19

You can add grouping options to a report.

Accepted Answer

Yes, grouping options can be added to a report. This allows for data to be organized and presented in a more meaningful way. For example, data can be grouped by a specific field, like date, location, or category, to better understand trends and patterns.

Question 20

A(n) ____________________ is a graphic or picture that can be placed in a form.

Accepted Answer

The answer of A(n) ____________________ is a graphic or picture...

Quiz 1: Microsoft Access Basics

A control text box displays the actual data from the table.

Identify the letter of the choice that best matches the phrase or definition.

By selecting multiple controls, you have the ability to apply formats to several controls at one time.

Identify the letter of the choice that best matches the phrase or definition.

Avg is one of the functions available in a summary report.

Access can only create pie charts.

Charts are simple to make and format.

You can specify up to three conditions for a field.

Discuss how to size and align a control.

When creating a report, you add a currency format before you apply themes.

You access the Report Wizard by clicking the Create tab on the Ribbon.

The feature that allows you to see how your form would look with a theme applied is called ____________________.

When using a report based on a parameter query, you need to create several reports.

Identify the letter of the choice that best matches the phrase or definition.

A(n) ____________________ displays a list of values and lets you select one from the list.

A(n) ____________________ button is a button that users can click to perform common tasks.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

You can add grouping options to a report.

A(n) ____________________ is a graphic or picture that can be placed in a form.