Question 1

The Arrange tab displays in both Layout and ________ views.

Accepted Answer

The answer of The Arrange tab displays in both Layout...

Question 2

The ________ asks a series of questions and then uses the answers to generate a customized report.

Accepted Answer

The answer of The ________ asks a series of questions...

Question 3

When viewing a form in Layout view,you realize that the text boxes containing the fields are too wide.Explain how you would narrow the width of the text boxes.

Accepted Answer

The answer of When viewing a form in Layout view,you...

Question 4

Explain the differences between a form with a subform and a split form.

Accepted Answer

The answer of Explain the differences between a form with...

Question 5

When viewing a report in Layout view,you see that the records are displayed in order based on the primary key field.You prefer print the records in alphabetical order by last names and then by first names.Explain how to sort the report to display records using the last name and first name fields.

Accepted Answer

The answer of When viewing a report in Layout view,you...

Question 6

________ view is useful for testing the functionality of the form and adjusting sizes of fields as needed.

Accepted Answer

The answer of ________ view is useful for testing the...

Question 7

The ________ creates a customizable form that displays the data in a form in both Form view and Datasheet view at the same time.

Accepted Answer

The answer of The ________ creates a customizable form that...

Question 8

A(n)________ is a defined set of colors,fonts,and graphics that can enhance the appearance of the a form or report by giving a uniform appearance.

Accepted Answer

The answer of A(n)________ is a defined set of colors,fonts,and...

Question 9

________ view allows users to make changes to the layout while viewing the data on a form.

Accepted Answer

The answer of ________ view allows users to make changes...

Question 10

After creating a report,you view it in Layout view,you see that the report is extremely wide.You decide to narrow the state field,since the states are displayed using two-letter abbreviations.Explain how you would narrow the width of the state field.

Accepted Answer

The answer of After creating a report,you view it in...

Question 11

________ is used to see exactly what a report will look like when it is printed.

Accepted Answer

The answer of ________ is used to see exactly what...

Question 12

________ view allows a background image to be added to a form

Accepted Answer

The answer of ________ view allows a background image to...

Question 13

When viewing a form in Form view,you see that the records are displayed in order based on the primary key field.You prefer to temporarily view the records in alphabetical order by last names.Explain how to change the form to display records using the last name field,and how to return the form to display records in primary key order.

Accepted Answer

The answer of When viewing a form in Form view,you...

Question 14

To sort a report,click ________ in the Grouping & Totals group to display the Group,Sort,and Total section.

Accepted Answer

The answer of To sort a report,click ________ in the...

Question 15

PDF stands for ________.

Accepted Answer

The answer of PDF stands for ________....

Question 16

When the form tool is used to create a form with related tables,Access automatically adds a(n)________ to the main form

Accepted Answer

The answer of When the form tool is used to...

Question 17

The Ascending and Descending buttons are located in the ________ group on the HOME tab.

Accepted Answer

The answer of The Ascending and Descending buttons are located...

Question 18

A(n)________ form displays all fields from a record source in a tabular layout similar to a table's Datasheet view.

Accepted Answer

The answer of A(n)________ form displays all fields from a...

Question 19

Give two reasons why using a form is better than using a table when adding,updating,and deleting data.

Accepted Answer

The answer of Give two reasons why using a form...

Question 20

When modifying a report,the ________ tab is used to change the layout of a report.

Accepted Answer

The answer of When modifying a report,the ________ tab is...

Quiz 16: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries