Question 1

Use the Property Sheet of the form to select the desired settings to limit actions available in a form.

Accepted Answer

A) True 
 B)False

Question 2

When modifying a form,which of the following views is best when you want to resize a field or label,change colors or text alignment,or apply different formats?

Accepted Answer

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

Question 3

An ascending sort for a date field is "from oldest to newest."

Accepted Answer

A) True 
 B)False

Question 4

Which of the following views divides a report into the following three sections: Page Header,the Detail,and the Page Footer?

Accepted Answer

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

Question 5

When working with forms,Form view allows you to make changes to the form.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is used to display or accept data for a field with a Yes/ No data type?

Accepted Answer

A)   text box
B)   label
C)   command button
D)   check boxesE) A) and D)
F) A) and C) D

Question 7

Which of the following views lets you see how the report will look in print and also allows you to make modifications to the print settings?

Accepted Answer

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

Question 8

Which of the following should you use to restrict a form to only allow data entry when you don't want the user to be able to view data already in the database?

Accepted Answer

A)   Allow Edits property
B)   Allow Deletions property
C)   Data Entry property
D)   Tabular control layoutE) None of the above
F) A) and B)

Question 9

Which of the following report layouts displays fields in one column?

Accepted Answer

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

Question 10

When adding fields to a form,which of the following keyboard shortcuts lets you show or hide the Field List?

Accepted Answer

A)   Shift+F8
B)   Ctrl+F8
C)   Alt+F8
D)   Shift+F9E) A) and B)
F) None of the above

Question 11

When using the Form Wizard to create a form based on one table,what four layout options can you choose from?

Accepted Answer

When using the Form Wizard to create a f...

Question 12

After you create a form,you can edit the form in Layout view or Design view.

Accepted Answer

A) True 
 B)False

Question 13

When adding fields to a form,press Ctrl+F8 to show or hide the Field List.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following grouping options would you want to use to group records based on the entire value in a selected field?

Accepted Answer

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

Question 15

What is conditional formatting and why is it useful? How do you apply conditional formatting to a report?

Accepted Answer

Conditional formatting allows you to for...

Question 16

Which of the following is useful when you want to organize and summarize you data?

Accepted Answer

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

Question 17

It is possible to click and drag a field into the report window to add it into the control layout.

Accepted Answer

A) True 
 B)False  True

Question 18

When working with forms,which of the following views would you use if you want to alter the design of a form and see the effects of the changes in real time?

Accepted Answer

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

Question 19

Which of the following report layouts displays fields in a row and column format?

Accepted Answer

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

Question 20

What is a text box that 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)

Exam 7: Creating Advanced Forms

Use the Property Sheet of the form to select the desired settings to limit actions available in a form.

Correct AnswerverifiedShow Answer

When modifying a form,which of the following views is best when you want to resize a field or label,change colors or text alignment,or apply different formats?

Correct AnswerverifiedC

An ascending sort for a date field is "from oldest to newest."

Correct AnswerverifiedShow Answer

Which of the following views divides a report into the following three sections: Page Header,the Detail,and the Page Footer?

Correct AnswerverifiedShow Answer

When working with forms,Form view allows you to make changes to the form.

Correct AnswerverifiedShow Answer

Which of the following is used to display or accept data for a field with a Yes/ No data type?

Correct AnswerverifiedD

Which of the following views lets you see how the report will look in print and also allows you to make modifications to the print settings?

Correct AnswerverifiedShow Answer

Which of the following should you use to restrict a form to only allow data entry when you don't want the user to be able to view data already in the database?

Correct AnswerverifiedShow Answer

Which of the following report layouts displays fields in one column?

Correct AnswerverifiedShow Answer

When adding fields to a form,which of the following keyboard shortcuts lets you show or hide the Field List?

Correct AnswerverifiedShow Answer

When using the Form Wizard to create a form based on one table,what four layout options can you choose from?

Correct AnswerverifiedWhen using the Form Wizard to create a f...View AnswerShow Answer

After you create a form,you can edit the form in Layout view or Design view.

Correct AnswerverifiedShow Answer

When adding fields to a form,press Ctrl+F8 to show or hide the Field List.

Correct AnswerverifiedShow Answer

Which of the following grouping options would you want to use to group records based on the entire value in a selected field?

Correct AnswerverifiedShow Answer

What is conditional formatting and why is it useful? How do you apply conditional formatting to a report?

Correct AnswerverifiedConditional formatting allows you to for...View AnswerShow Answer

Which of the following is useful when you want to organize and summarize you data?

Correct AnswerverifiedShow Answer

It is possible to click and drag a field into the report window to add it into the control layout.

Correct AnswerverifiedTrue

When working with forms,which of the following views would you use if you want to alter the design of a form and see the effects of the changes in real time?

Correct AnswerverifiedShow Answer

Which of the following report layouts displays fields in a row and column format?

Correct AnswerverifiedShow Answer

What is a text box that gets its value from an expression?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
When using the Form Wizard to create a f...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Conditional formatting allows you to for...
View Answer

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified