Question 1

For date fields,what is the default sort order?

Accepted Answer

A)   newest to oldest
B)   oldest to newest
C)   largest to smallest
D)   smallest to largestE) C) and D)
F) B) and D)

Question 2

When working with multiple conditional formatting rules,Access stops evaluating when a match is found.

Accepted Answer

A) True 
 B)False

Question 3

What does Access call a form that is directly connected to a table or query,the source of the data?

Accepted Answer

A)   bound form
B)   connected form
C)   unbound form
D)   split formE) B) and C)
F) A) and B)

Question 4

When working with forms,which of the following views would you use if you want to view the completed structure of the form so you can modify any aspect of the form?

Accepted Answer

A)   Form view
B)   Design view
C)   Layout view
D)   Datasheet viewE) A) and D)
F) B) and C)

Question 5

Which of the following buttons adds two controls into the header section,an Auto_Header control which contains the title and an Auto_Logo control which can contain a logo?

Accepted Answer

A)   Date and Time button
B)   Logo button
C)   Page Numbers button
D)   Title buttonE) A) and D)
F) B) and C)

Question 6

Which of the following should you use to create a report if you are short on time?

Accepted Answer

A)   Report view
B)   Report Wizard
C)   Form Wizard
D)   Command Button WizardE) B) and C)
F) None of the above

Question 7

When adding totals to a report,which of the following calculation options tracks the highest value in a field?

Accepted Answer

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

Question 8

What can you use to ensure that your report prints as desired?

Accepted Answer

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

Question 9

To organize controls vertically on a form,use a tabular layout.

Accepted Answer

A) True 
 B)False

Question 10

Once created,why is it important to test a form? What is involved with testing a form?

Accepted Answer

After you have built your form,it is imp...

Question 11

Which of the following can be added to a report independent of grouping or sorting being used?

Accepted Answer

A)   unbound form
B)   bound form
C)   totals
D)   control layoutE) A) and B)
F) C) and D)

Question 12

A check box is a database object that allows you to write and attach code to different objects and controls in your database.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following control layouts organizes data vertically?

Accepted Answer

A)   tabular layout
B)   datasheet layout
C)   stacked layout
D)   vertical layoutE) C) and D)
F) None of the above

Question 14

When defining multiple conditional formatting rules,the order in which the rules are listed is not important.

Accepted Answer

A) True 
 B)False

Question 15

When would you want to use Access's grouping options? What are the three layout choices for a grouped report?

Accepted Answer

Grouping is useful when you want to orga...

Question 16

If you are displaying a form in Design view,what can you press to display the form in Form view?

Accepted Answer

A)   F3
B)   F5
C)   F7
D)   F8E) A) and B)
F) A) and C)

Question 17

In a report,which of the following controls gets its value from an expression?

Accepted Answer

A)   bound control
B)   unbound control
C)   calculated control
D)   stacked controlE) None of the above
F) A) and C)

Question 18

Which of the following options in the Group,Sort,and Total pane calculates overall totals for all records?

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) C) and D)
F) B) and D)

Question 19

Which of the following would you change in order to view a report using a landscape orientation?

Accepted Answer

A)   page size
B)   margins
C)   page orientation
D)   headers and footersE) A) and B)
F) A) and C)

Question 20

The Form Wizard steps you through the process of quickly creating a form.

Accepted Answer

A) True 
 B)False

Exam 7: Creating Advanced Forms

If you are displaying a form in Design view,what can you press to display the form in Form view?

Correct AnswerverifiedShow Answer

Which of the following control layouts organizes data vertically?

Correct AnswerverifiedShow Answer

What does Access call a form that is directly connected to a table or query,the source of the data?

Correct AnswerverifiedShow Answer

Once created,why is it important to test a form? What is involved with testing a form?

Correct AnswerverifiedAfter you have built your form,it is imp...View AnswerShow Answer

When defining multiple conditional formatting rules,the order in which the rules are listed is not important.

Correct AnswerverifiedShow Answer

When working with forms,which of the following views would you use if you want to view the completed structure of the form so you can modify any aspect of the form?

Correct AnswerverifiedShow Answer

Which of the following should you use to create a report if you are short on time?

Correct AnswerverifiedShow Answer

The Form Wizard steps you through the process of quickly creating a form.

Correct AnswerverifiedShow Answer

A check box is a database object that allows you to write and attach code to different objects and controls in your database.

Correct AnswerverifiedShow Answer

Which of the following buttons adds two controls into the header section,an Auto_Header control which contains the title and an Auto_Logo control which can contain a logo?

Correct AnswerverifiedShow Answer

When adding totals to a report,which of the following calculation options tracks the highest value in a field?

Correct AnswerverifiedShow Answer

Which of the following would you change in order to view a report using a landscape orientation?

Correct AnswerverifiedShow Answer

Which of the following options in the Group,Sort,and Total pane calculates overall totals for all records?

Correct AnswerverifiedShow Answer

For date fields,what is the default sort order?

Correct AnswerverifiedShow Answer

To organize controls vertically on a form,use a tabular layout.

Correct AnswerverifiedShow Answer

What can you use to ensure that your report prints as desired?

Correct AnswerverifiedShow Answer

Which of the following can be added to a report independent of grouping or sorting being used?

Correct AnswerverifiedShow Answer

When would you want to use Access's grouping options? What are the three layout choices for a grouped report?

Correct AnswerverifiedGrouping is useful when you want to orga...View AnswerShow Answer

In a report,which of the following controls gets its value from an expression?

Correct AnswerverifiedShow Answer

When working with multiple conditional formatting rules,Access stops evaluating when a match is found.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
After you have built your form,it is imp...
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
Grouping is useful when you want to orga...
View Answer

Correct Answer
verified

Correct Answer
verified