Question 1

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 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 view 
A)  Form view 
B)  Design view 
C)  Layout view 
D)  Datasheet view C

Question 3

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 boxes 
A)  text box 
B)  label 
C)  command button 
D)  check boxes D

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A)  columnar 
B)  tabular 
C)  justified 
D)  stepped 
A)  columnar 
B)  tabular 
C)  justified 
D)  stepped

Question 6

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 7

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 layout 
A)  Allow Edits property 
B)  Allow Deletions property 
C)  Data Entry property 
D)  Tabular control layout

Question 8

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 9

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 10

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 view 
A)  Report view 
B)  Print Preview view 
C)  Design view 
D)  Layout view

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 sort 
A)  By entire value 
B)  By partial value 
C)  Custom 
D)  Ascending or descending sort

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 view 
A)  Report view 
B)  Print Preview view 
C)  Design view 
D)  Layout view

Question 16

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+F9 
A)  Shift+F8 
B)  Ctrl+F8 
C)  Alt+F8 
D)  Shift+F9

Question 17

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)  grouping 
A)  sorting 
B)  conditional formatting 
C)  a split form 
D)  grouping

Question 18

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

Accepted Answer

A)  columnar 
B)  tabular 
C)  justified 
D)  stepped 
A)  columnar 
B)  tabular 
C)  justified 
D)  stepped

Question 19

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 view 
A)  Form view 
B)  Design view 
C)  Layout view 
D)  Datasheet view

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 control 
A)  bound control 
B)  unbound control 
C)  calculated control 
D)  stacked control

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

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?

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

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

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

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

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?

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

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

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

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

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

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

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

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?

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

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

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

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?

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

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters

Exam 7: Creating Advanced Forms

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

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?

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

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

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

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

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?

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

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

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

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

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

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

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

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?

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

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

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

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?

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

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters