Question 1

Sally has created a report where the totals display as a bold red font with a light red background when dollar values go below $0. This is an example of ________.

Accepted Answer

The answer of Sally has created a report where the...

Question 2

To switch between a filtered table and a whole table, use the ________ or the Filtered indicator.
A)change view button
B)Change Filter button
C)switch button
D)Toggle Filter

Accepted Answer

The "Toggle Filter" option is typically used to switch between a filtered view and the entire dataset in many software applications.

Question 3

The ________ allows you to print the whole report or a range of pages in the report.

Accepted Answer

The answer of The ________ allows you to print the...

Question 4

To calculate totals for smaller groups of records, you can add ________ to the report.

Accepted Answer

The answer of To calculate totals for smaller groups of...

Question 5

To see what the report will look like when it is printed, you should change to the ________ view.

Accepted Answer

The answer of To see what the report will look...

Question 6

You CANNOT select a(n)________ other than Office while using the Report Wizard.

Accepted Answer

The answer of You CANNOT select a(n)________ other than Office...

Question 7

A condition applied temporarily to a table or query is called a(n)________
A)filter
B)input mask
C)format
D)calculation

Accepted Answer

A filter is a condition applied temporarily to a table or query to display only the data that meets certain criteria.

Question 8

Because Jose is not sure his supplier has Access 2010, he has decided to publish his report as an Adobe ________ file, rather than saving it.

Accepted Answer

The answer of Because Jose is not sure his supplier...

Question 9

If you need to have calculations performed on a group in a report, they are added to the ________ section.

Accepted Answer

The answer of If you need to have calculations performed...

Question 10

When you want to describe one field in terms of two or more other fields in a table you use a(n)________.
A)matched query
B)find unmatched query
C)find duplicates query
D)cross-tab query

Accepted Answer

A cross-tab query is used to describe one field in terms of two or more other fields by summarizing data in a matrix format.

Question 11

The ________ is the section of the report to which groups are added.

Accepted Answer

The answer of The ________ is the section of the...

Question 12

A(n)________ is a foreign key in one table that does not have a value in the primary key field of a related table.
A)widow
B)orphan
C)stray
D)duplicate

Accepted Answer

An orphan is a foreign key in one table that does not have a value in the primary key field of a related table.

Question 13

The final result of a report is usually a(n)________.

Accepted Answer

The answer of The final result of a report is...

Question 14

Because saving a report as a PDF file is publishing the file, you will use the ________ option to save the report as a PDF instead of Save or Print.

Accepted Answer

The answer of Because saving a report as a PDF...

Question 15

The default theme used by Access when you create a report using the Report Wizard is the ________ theme.

Accepted Answer

The answer of The default theme used by Access when...

Question 16

Before printing your report, you should view it in ________, since Layout view and Report view do not show you the page breaks and other features of the report as they will look when the report is printed.

Accepted Answer

The answer of Before printing your report, you should view...

Question 17

When looking for specific values in a record, you should use the ________ command to keep from scrolling.
A)Update
B)Replace
C)Cascade
D)Find

Accepted Answer

The Find command allows you to search for specific values in a record without having to scroll through the entire record.

Question 18

________ in a report created using the Report wizard are in the order that the fields are added to the report.

Accepted Answer

The answer of ________ in a report created using the...

Question 19

When you suspect that you have multiple instances of a record in a table, you should use the ________ query wizard.
A)Orphan
B)Find Duplicates
C)Find Unmatched
D)Cross-Tab

Accepted Answer

The Find Duplicates query wizard is used to find duplicate records in a table.

Question 20

To view all the table records at one time, use the ________ view.
A)worksheet
B)design
C)datasheet
D)spreadsheet

Accepted Answer

The datasheet view is used to display all the records in a table at once, similar to a spreadsheet format.

Quiz 6: Access

Sally has created a report where the totals display as a bold red font with a light red background when dollar values go below $0. This is an example of ________.

To switch between a filtered table and a whole table, use the ________ or the Filtered indicator.

The ________ allows you to print the whole report or a range of pages in the report.

To calculate totals for smaller groups of records, you can add ________ to the report.

To see what the report will look like when it is printed, you should change to the ________ view.

You CANNOT select a(n)________ other than Office while using the Report Wizard.

A condition applied temporarily to a table or query is called a(n) ________

Because Jose is not sure his supplier has Access 2010, he has decided to publish his report as an Adobe ________ file, rather than saving it.

If you need to have calculations performed on a group in a report, they are added to the ________ section.

When you want to describe one field in terms of two or more other fields in a table you use a(n) ________.

The ________ is the section of the report to which groups are added.

A(n) ________ is a foreign key in one table that does not have a value in the primary key field of a related table.

The final result of a report is usually a(n)________.

Because saving a report as a PDF file is publishing the file, you will use the ________ option to save the report as a PDF instead of Save or Print.

The default theme used by Access when you create a report using the Report Wizard is the ________ theme.

Before printing your report, you should view it in ________, since Layout view and Report view do not show you the page breaks and other features of the report as they will look when the report is printed.

When looking for specific values in a record, you should use the ________ command to keep from scrolling.

________ in a report created using the Report wizard are in the order that the fields are added to the report.

When you suspect that you have multiple instances of a record in a table, you should use the ________ query wizard.

To view all the table records at one time, use the ________ view.