Question 1

What is a control and how are they used on forms? Describe what bound,unbound,and calculated controls are and provide an example of each.

Accepted Answer

In Access,the fields,labels,buttons,and ...

Question 2

Which of the following allows you to add,modify,and delete rules?

Accepted Answer

A)   Conditional Formatting Rules Manager
B)   Report Wizard
C)   Design tab
D)   Format tabE) None of the above
F) B) and C)

Question 3

It is a good design practice to add a title to a form.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following allows you to format only values that meet a specified condition?

Accepted Answer

A)   Rules Manager
B)   conditional formatting
C)   split form
D)   Report WizardE) A) and B)
F) A) and C)

Question 5

A stepped report layout displays the fields in a horizontal,justified layout.

Accepted Answer

A) True 
 B)False

Question 6

Some form controls are unbound,which means that they are not linked to a data source.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following options in the Group,Sort,and Total pane determines which section displays the totals?

Accepted Answer

A)   Select the field and type of calculation
B)   Show grand totals
C)   Show group totals as percent of grand total
D)   Show in header or footer sectionE) A) and C)
F) C) and D)

Question 8

In addition to selecting the rule type and conditions,what else must you select when building a rule?

Accepted Answer

A)   command buttons
B)   bound controls
C)   a control layout
D)   desired formattingE) B) and C)
F) B) and D)

Question 9

Which of the following grouping options would you want to use to group records based on a specific number of characters that you provide?

Accepted Answer

A)   By entire value
B)   By partial value
C)   Custom
D)   Ascending or descending sortE) B) and C)
F) A) and B)

Question 10

When creating a form using the Form Wizard,which of the following layout options would you use to display just one record at a time?

Accepted Answer

A)   Columnar
B)   Tabular
C)   Datasheet
D)   JustifiedE) A) and B)
F) None of the above

Question 11

When working with forms,which of the following views would you use if you want to enter and view data?

Accepted Answer

A)   Form view
B)   Design view
C)   Layout view
D)   Datasheet viewE) All of the above
F) A) and B)

Question 12

Which of the following layouts places labels to the left of the data control?

Accepted Answer

A)   tabular layout
B)   stacked layout
C)   justified layout
D)   grouped layoutE) C) and D)
F) A) and C)

Question 13

Which of the following is true of adding conditional formatting to a report?

Accepted Answer

A)   The order of rules is not important.
B)   Access continues evaluating rules even when a match is found.
C)   You can only set rules one field at a time.
D)   You can select multiple fields and apply the same rule to all selected fields.E) None of the above
F) C) and D)

Question 14

Which of the following can you use to print the current form,close the current form,navigate to the next record,or open another form?

Accepted Answer

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

Question 15

Which of the following creates a button and attaches all of the necessary functionality to the button?

Accepted Answer

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

Question 16

To select multiple controls at once,what must you press and hold down while selecting controls?

Accepted Answer

A)   F3
B)   Alt
C)   Ctrl
D)   ShiftE) None of the above
F) All of the above

Question 17

Where are a report's title,the current date,and page numbers typically placed in a report?

Accepted Answer

A)   Detail area
B)   Page Header area
C)   Page Footer area
D)   Page Header and Page Footer areasE) B) and D)
F) A) and B)

Question 18

When modifying a form,Design view allows you to make changes to the design of a form while seeing how the form looks with data displaying.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following can you add to a form to automate user tasks?

Accepted Answer

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

Question 20

The Conditional Formatting Rules Manager only displays rules for one field at a time.

Accepted Answer

A) True 
 B)False

Exam 7: Creating Advanced Forms

Some form controls are unbound,which means that they are not linked to a data source.

Correct AnswerverifiedShow Answer

Which of the following layouts places labels to the left of the data control?

Correct AnswerverifiedShow Answer

Which of the following can you add to a form to automate user tasks?

Correct AnswerverifiedShow Answer

A stepped report layout displays the fields in a horizontal,justified layout.

Correct AnswerverifiedShow Answer

What is a control and how are they used on forms? Describe what bound,unbound,and calculated controls are and provide an example of each.

Correct AnswerverifiedIn Access,the fields,labels,buttons,and ...View AnswerShow Answer

Which of the following allows you to add,modify,and delete rules?

Correct AnswerverifiedShow Answer

Which of the following can you use to print the current form,close the current form,navigate to the next record,or open another form?

Correct AnswerverifiedShow Answer

Which of the following is true of adding conditional formatting to a report?

Correct AnswerverifiedShow Answer

The Conditional Formatting Rules Manager only displays rules for one field at a time.

Correct AnswerverifiedShow Answer

Where are a report's title,the current date,and page numbers typically placed in a report?

Correct AnswerverifiedShow Answer

When creating a form using the Form Wizard,which of the following layout options would you use to display just one record at a time?

Correct AnswerverifiedShow Answer

To select multiple controls at once,what must you press and hold down while selecting controls?

Correct AnswerverifiedShow Answer

When modifying a form,Design view allows you to make changes to the design of a form while seeing how the form looks with data displaying.

Correct AnswerverifiedShow Answer

It is a good design practice to add a title to a form.

Correct AnswerverifiedShow Answer

In addition to selecting the rule type and conditions,what else must you select when building a rule?

Correct AnswerverifiedShow Answer

Which of the following creates a button and attaches all of the necessary functionality to the button?

Correct AnswerverifiedShow Answer

Which of the following grouping options would you want to use to group records based on a specific number of characters that you provide?

Correct AnswerverifiedShow Answer

When working with forms,which of the following views would you use if you want to enter and view data?

Correct AnswerverifiedShow Answer

Which of the following allows you to format only values that meet a specified condition?

Correct AnswerverifiedShow Answer

Which of the following options in the Group,Sort,and Total pane determines which section displays the totals?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
In Access,the fields,labels,buttons,and ...
View 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