Question 1

What are control layouts? What are the two primary control layout options?

Accepted Answer

Control layouts provide a structure that...

Question 2

What are forms used for? What is the difference between a bound form and an unbound form?

Accepted Answer

A form is an object you can use to creat...

Question 3

What does it mean to group,sort,and add totals to a report?

Accepted Answer

Grouping is useful when you want to orga...

Question 4

Access allows you to sort on multiple fields only if each field is sorted in ascending order.

Accepted Answer

A) True 
 B)False

Question 5

When creating a form using the Form Wizard,which of the following layout options would you use to display the fields in a table (row and column) format?

Accepted Answer

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

Question 6

Like forms,reports allow you to modify the underlying data source.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following would you want to use in a report to include all properties from the same city together in a real estate database?

Accepted Answer

A)   sorting
B)   conditional formatting
C)   a split form
D)   groupingE) B) and D)
F) None of the above

Question 8

Which of the following is true of the Conditional Formatting Rules Manager?

Accepted Answer

A)   It displays a single rule for a single field at a time.
B)   It displays one or more rules for a single field at a time.
C)   You cannot edit a rule using the Conditional Formatting Rules Manager.
D)   You cannot delete a rule using the Conditional Formatting Rules Manager.E) B) and D)
F) B) and C)

Question 9

For number 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) All of the above
F) A) and B)

Question 10

Which of the following layouts places labels above the data values?

Accepted Answer

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

Question 11

What is a text box that gets its value from a field in a table?

Accepted Answer

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

Question 12

Which of the following allows you to view data in two different ways at the same time,with the top section showing one record in a columnar mode and the bottom section displaying in Datasheet view?

Accepted Answer

A)   bound form
B)   connected form
C)   unbound form
D)   split formE) None of the above
F) C) and D)

Question 13

Which of the following report layouts displays fields in a horizontal layout?

Accepted Answer

A)   columnar
B)   tabular
C)   justified
D)   steppedE) C) and D)
F) A) and B)

Question 14

A text box that gets its value from an expression is a calculated control.

Accepted Answer

A) True 
 B)False

Question 15

A bound form contains a link to the data source.

Accepted Answer

A) True 
 B)False

Question 16

When adding totals to a report,which of the following calculation options totals up the values in a particular field?

Accepted Answer

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

Question 17

A split form allows you to see many records at once in the Datasheet view while giving you access to edit a single record.

Accepted Answer

A) True 
 B)False

Question 18

The Command Button Wizard creates a button and attaches all of the necessary functionality to the button.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following views 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)   Report view
B)   Print Preview view
C)   Design view
D)   Layout viewE) A) and C)
F) All of the above

Question 20

Which of the following grouping options would you want to use to group records by the first character of a field?

Accepted Answer

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

Exam 7: Creating Advanced Forms

What does it mean to group,sort,and add totals to a report?

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

For number fields,what is the default sort order?

Correct AnswerverifiedShow Answer

Like forms,reports allow you to modify the underlying data source.

Correct AnswerverifiedShow Answer

A bound form contains a link to the data source.

Correct AnswerverifiedShow Answer

Which of the following is true of the Conditional Formatting Rules Manager?

Correct AnswerverifiedShow Answer

What is a text box that gets its value from a field in a table?

Correct AnswerverifiedShow Answer

What are forms used for? What is the difference between a bound form and an unbound form?

Correct AnswerverifiedA form is an object you can use to creat...View AnswerShow Answer

The Command Button Wizard creates a button and attaches all of the necessary functionality to the button.

Correct AnswerverifiedShow Answer

What are control layouts? What are the two primary control layout options?

Correct AnswerverifiedControl layouts provide a structure that...View AnswerShow Answer

When creating a form using the Form Wizard,which of the following layout options would you use to display the fields in a table (row and column) format?

Correct AnswerverifiedShow Answer

Which of the following allows you to view data in two different ways at the same time,with the top section showing one record in a columnar mode and the bottom section displaying in Datasheet view?

Correct AnswerverifiedShow Answer

Which of the following grouping options would you want to use to group records by the first character of a field?

Correct AnswerverifiedShow Answer

Which of the following would you want to use in a report to include all properties from the same city together in a real estate database?

Correct AnswerverifiedShow Answer

A split form allows you to see many records at once in the Datasheet view while giving you access to edit a single record.

Correct AnswerverifiedShow Answer

Which of the following layouts places labels above the data values?

Correct AnswerverifiedShow Answer

Access allows you to sort on multiple fields only if each field is sorted in ascending order.

Correct AnswerverifiedShow Answer

Which of the following views 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

Which of the following report layouts displays fields in a horizontal layout?

Correct AnswerverifiedShow Answer

A text box that gets its value from an expression is a calculated control.

Correct AnswerverifiedShow Answer

When adding totals to a report,which of the following calculation options totals up the values in a particular field?

Correct AnswerverifiedShow Answer

Correct Answer
verified
Grouping is useful when you want to orga...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A form is an object you can use to creat...
View Answer

Correct Answer
verified

Correct Answer
verified
Control layouts provide a structure that...
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