Question 1

The only people who really need to test new forms are the end users.

Accepted Answer

A) True 
 B)False

Question 2

What can you not easily do using a form?

Accepted Answer

A)  Enter data
B)  Edit data
C)  Move data
D)  Delete dataE) A) and C)
F) A) and D)

Question 3

Match between columns
                        Premises:  Control
Theme
Form
Report
 Record Source

Accepted Answer

The Answer of Helpful way of displaying data from multiple is...

Question 4

What is not a group on the Report Layout Tools Format tab?

Accepted Answer

A)  Fields
B)  Font
C)  Number
D)  BackgroundE) All of the above
F) C) and D)

Question 5

If you want more freedom as to where your controls are located on a form you need to remove the ________ control.

Accepted Answer

The answer of If you want more freedom as to...

Question 6

The easiest way to find information is to search the table directly.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is not a primary consideration when designing a report?

Accepted Answer

A)  The purpose of the report
B)  Who will use the report
C)  What information will be needed in the report
D)  How many pages long the report will beE) C) and D)
F) A) and C)

Question 8

Pressing the Ctrl key plus what other key enables you to select all the controls on a form?

Accepted Answer

A)  A
B)  X
C)  C
D)  YE) C) and D)
F) A) and D)

Question 9

Which of the following is not considered one of the most common methods to create a form?

Accepted Answer

A)  Default Form
B)  Form Wizard
C)  Blank Form
D)  Form DesignE) B) and C)
F) C) and D)

Question 10

Which of the following is not a form tool that is available in Access 2016?

Accepted Answer

A)  Form
B)  Multiple Form
C)  Form Design
D)  Split FormE) A) and C)
F) B) and C)

Question 11

Which of the following can you not do if you use a query as the record source for a form?

Accepted Answer

A)  Lock your form so that it cannot be edited
B)  Filter the records
C)  Combine records from multiple tables
D)  Limit the number of fields in the table which are displayedE) B) and C)
F) A) and D)

Question 12

Match between columns
                        Premises:  Form
Application Parts
Record source
Stacked layout
 Tabular layout

Accepted Answer

The Answer of Used to build database objects and Fields is...

Question 13

If a sort has been added to a table it takes precedence over a sort applied to a form even if you are in form view.

Accepted Answer

A) True 
 B)False

Question 14

Mailing labels are considered reports in Access 2016.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is not a good reason for using a form for data entry?

Accepted Answer

A)  Data you enter in a form must then be transferred to the table.
B)  You probably will not edit the wrong record.
C)  You can show data from more than one table at a time.
D)  Your form can resemble paper forms.E) All of the above
F) A) and D)

Question 16

The sort order in a report's source overrides any sort order applied to the report.

Accepted Answer

A) True 
 B)False

Question 17

Match the following form tools with their description:
I. Form
II. Form Design
III. Split Form
IV. Datasheet
V. Switchboard
A. Immediately creates a blank form with a stacked layout
B. Immediately creates a blank form in Design view
C. Creates a form that looks like a table in its normal view
D. Includes a stacked layout and a tabular layout in two different sections of the form
E. This is not an Access Form tool.

Accepted Answer

The answer of Match the following form tools with their...

Question 18

Match between columns
                        Premises:  Print area
Print order
Page break
Freezing
 Conditional formatting

Accepted Answer

The Answer of Where data will print on the next is...

Question 19

Match between columns
                        Premises:  Header Row
Total Row
First Column
Last Column
 Banded Rows

Accepted Answer

The Answer of The formatting of this row/these rows take/takes is...

Question 20

You can edit data in form layout view.

Accepted Answer

A) True 
 B)False

Exam 4: Access: Creating and Using Professional Forms and Reports

The sort order in a report's source overrides any sort order applied to the report.

Correct Answer
verified

Match the following terms with their description:

Pressing the Ctrl key plus what other key enables you to select all the controls on a form?

Correct Answer
verified

The easiest way to find information is to search the table directly.

Correct Answer
verified

Which of the following is not a good reason for using a form for data entry?

Correct Answer
verified

Match the following terms with their description:

Mailing labels are considered reports in Access 2016.

Correct Answer
verified

If a sort has been added to a table it takes precedence over a sort applied to a form even if you are in form view.

Correct Answer
verified

Correct Answer
verified

If you want more freedom as to where your controls are located on a form you need to remove the ________ control.

Correct Answer
verified

You can edit data in form layout view.

Correct Answer
verified

What is not a group on the Report Layout Tools Format tab?

Correct Answer
verified

Which of the following is not a primary consideration when designing a report?

Correct Answer
verified

What can you not easily do using a form?

Correct Answer
verified

Which of the following can you not do if you use a query as the record source for a form?

Correct Answer
verified

Which of the following is not a form tool that is available in Access 2016?

Correct Answer
verified

Match the following terms with their description:

Match the following table style options with their description:

Which of the following is not considered one of the most common methods to create a form?

Correct Answer
verified

The only people who really need to test new forms are the end users.

Correct Answer
verified

Exam 4: Access: Creating and Using Professional Forms and Reports

The sort order in a report's source overrides any sort order applied to the report.

Correct AnswerverifiedShow Answer

Match the following terms with their description:

Pressing the Ctrl key plus what other key enables you to select all the controls on a form?

Correct AnswerverifiedShow Answer

The easiest way to find information is to search the table directly.

Correct AnswerverifiedShow Answer

Which of the following is not a good reason for using a form for data entry?

Correct AnswerverifiedShow Answer

Match the following terms with their description:

Mailing labels are considered reports in Access 2016.

Correct AnswerverifiedShow Answer

If a sort has been added to a table it takes precedence over a sort applied to a form even if you are in form view.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

If you want more freedom as to where your controls are located on a form you need to remove the ________ control.

Correct AnswerverifiedShow Answer

You can edit data in form layout view.

Correct AnswerverifiedShow Answer

What is not a group on the Report Layout Tools Format tab?

Correct AnswerverifiedShow Answer

Which of the following is not a primary consideration when designing a report?

Correct AnswerverifiedShow Answer

What can you not easily do using a form?

Correct AnswerverifiedShow Answer

Which of the following can you not do if you use a query as the record source for a form?

Correct AnswerverifiedShow Answer

Which of the following is not a form tool that is available in Access 2016?

Correct AnswerverifiedShow Answer

Match the following terms with their description:

Match the following table style options with their description:

Which of the following is not considered one of the most common methods to create a form?

Correct AnswerverifiedShow Answer

The only people who really need to test new forms are the end users.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified