Question 1

What is the main advantage of using one of Access's control layouts when designing a form?

Accepted Answer

A)   Control layouts provide structure.
B)   Control layouts let you easily insert all of the fields in your data source into your form.
C)   Control layouts provide visual appeal with varied themes.
D)   Control layouts are compatible with other software applications.E) A) and D)
F) A) and C)

Question 2

What are some of the tasks you might perform when customizing a report in Layout view?

Accepted Answer

You can perform several tasks in Layout ...

Question 3

Which of the following can you use to select the desired settings to limit actions available in a form?

Accepted Answer

A)   Conditional Formatting Rules Manager
B)   control layouts
C)   Property Sheet
D)   Command Button WizardE) None of the above
F) B) and C)

Question 4

When viewing a report,Design view is a more visually-oriented mode you can use to alter the design of a report and see the effects of the changes in real time.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is used to perform an action such as Close Form,Open Form,Delete Record,and so on?

Accepted Answer

A)   text box
B)   label
C)   command button
D)   check boxE) A) and C)
F) None of the above

Question 6

After you create a report using the Report Wizard,it's possible to modify the layout of the report in Design view.

Accepted Answer

A) True 
 B)False

Question 7

On the Design tab,selecting the Title button adds a title into the header section of the report.

Accepted Answer

A) True 
 B)False

Question 8

In a stacked form layout,all of the fields have the same width.

Accepted Answer

A) True 
 B)False

Question 9

When using multiple conditional formatting rules,which of the following statements is true?

Accepted Answer

A)   The order of the rules is unimportant.
B)   The order of the rules is important.
C)   Access continues to evaluate rules after a match is found.
D)   all of the aboveE) All of the above
F) A) and D)

Question 10

In Access,what are the fields,labels,and buttons called?

Accepted Answer

A)   objects
B)   controls
C)   commands
D)   layoutsE) B) and C)
F) A) and D)

Question 11

What is a split form and why is it useful?

Accepted Answer

A split form allows you to view data in ...

Question 12

Which of the following indicates that a control has been selected?

Accepted Answer

A)   an orange border
B)   a green border
C)   a red border
D)   a red dashed borderE) B) and C)
F) C) and D)

Question 13

In Access,fields,labels,and buttons are called objects.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is true about blank reports?

Accepted Answer

A)   They use the tabular layout.
B)   They use the stacked layout.
C)   They don't contain any controls.
D)   The header area contains a default title.E) B) and D)
F) B) and C)

Question 15

Which of the following views is good for resizing fields or labels,changing colors or text alignment,or applying different formats?

Accepted Answer

A)   Report view
B)   Print Preview view
C)   Design view
D)   Layout viewE) C) and D)
F) B) and C)

Question 16

What does Access call a form that doesn't have a connection to a data source?

Accepted Answer

A)   bound form
B)   connected form
C)   unbound form
D)   disconnected formE) All of the above
F) B) and D)

Question 17

The Control Wizards tool directs Access to launch an available wizard when adding controls to an object.

Accepted Answer

A) True 
 B)False

Question 18

When a new blank form is created,there are no controls initially placed on the form.

Accepted Answer

A) True 
 B)False

Question 19

When adding totals to a report,which of the following calculation options counts up the number of records that meet a certain condition?

Accepted Answer

A)   Sum
B)   Count Values
C)   Max
D)   Standard DeviationE) B) and C)
F) A) and C)

Question 20

You can have a maximum of one conditional formatting rule in a report.

Accepted Answer

A) True 
 B)False

Exam 7: Creating Advanced Forms

In Access,fields,labels,and buttons are called objects.

Correct AnswerverifiedShow Answer

What does Access call a form that doesn't have a connection to a data source?

Correct AnswerverifiedShow Answer

What is the main advantage of using one of Access's control layouts when designing a form?

Correct AnswerverifiedShow Answer

After you create a report using the Report Wizard,it's possible to modify the layout of the report in Design view.

Correct AnswerverifiedShow Answer

In Access,what are the fields,labels,and buttons called?

Correct AnswerverifiedShow Answer

Which of the following can you use to select the desired settings to limit actions available in a form?

Correct AnswerverifiedShow Answer

Which of the following is true about blank reports?

Correct AnswerverifiedShow Answer

When using multiple conditional formatting rules,which of the following statements is true?

Correct AnswerverifiedShow Answer

Which of the following indicates that a control has been selected?

Correct AnswerverifiedShow Answer

The Control Wizards tool directs Access to launch an available wizard when adding controls to an object.

Correct AnswerverifiedShow Answer

Which of the following is used to perform an action such as Close Form,Open Form,Delete Record,and so on?

Correct AnswerverifiedShow Answer

On the Design tab,selecting the Title button adds a title into the header section of the report.

Correct AnswerverifiedShow Answer

Which of the following views is good for resizing fields or labels,changing colors or text alignment,or applying different formats?

Correct AnswerverifiedShow Answer

When viewing a report,Design view is a more visually-oriented mode you can use to alter the design of a report and see the effects of the changes in real time.

Correct AnswerverifiedShow Answer

What is a split form and why is it useful?

Correct AnswerverifiedA split form allows you to view data in ...View AnswerShow Answer

In a stacked form layout,all of the fields have the same width.

Correct AnswerverifiedShow Answer

You can have a maximum of one conditional formatting rule in a report.

Correct AnswerverifiedShow Answer

When a new blank form is created,there are no controls initially placed on the form.

Correct AnswerverifiedShow Answer

When adding totals to a report,which of the following calculation options counts up the number of records that meet a certain condition?

Correct AnswerverifiedShow Answer

What are some of the tasks you might perform when customizing a report in Layout view?

Correct AnswerverifiedYou can perform several tasks in Layout ...View AnswerShow 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
A split form allows you to view data in ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
You can perform several tasks in Layout ...
View Answer