Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

________ 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 11

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 12

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 13

PDF stands for ________.

Accepted Answer

The answer of PDF stands for ________....

Question 14

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 15

________ 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 16

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

Question 17

Match between columns
                        Premises: Form Wizard
Form Design
Blank Form
Split Form
Form

Accepted Answer

The Answer of Creates an empty form in Layout view is...

Question 18

Match between columns
                        Premises: Report
Report Design
Report Wizard
Labels
Blank Report

Accepted Answer

The Answer of Creates a tabular report showing all of is...

Question 19

Match between columns
                        Premises: Layout
Form
Design
Print Preview
Report

Accepted Answer

The Answer of Displays a report onscreen in a continuous is...

Question 20

Match between columns
                        Premises: Form
Report
Wizard
Theme
Record Source

Accepted Answer

The Answer of Used to add data into or edit is...

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