Question 1

What is the main advantage of using one of Access's control layouts when designing a form?

Accepted Answer

A)  Control layouts provide structure. 
B)  Control layouts let you easily insert all of the fields in your data source into your form. 
C)  Control layouts provide visual appeal with varied themes. 
D)  Control layouts are compatible with other software applications. 
A)  Control layouts provide structure. 
B)  Control layouts let you easily insert all of the fields in your data source into your form. 
C)  Control layouts provide visual appeal with varied themes. 
D)  Control layouts are compatible with other software applications.

Question 2

In Access,what are the fields,labels,and buttons called?

Accepted Answer

A)  objects 
B)  controls 
C)  commands 
D)  layouts 
A)  objects 
B)  controls 
C)  commands 
D)  layouts

Question 3

The Control Wizards tool directs Access to launch an available wizard when adding controls to an object.

Accepted Answer

A) True 
 B)False

Question 4

When a new blank form is created,there are no controls initially placed on the form.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following views is good for resizing fields or labels,changing colors or text alignment,or applying different formats?

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 6

In Access,fields,labels,and buttons are called objects.

Accepted Answer

A) True 
 B)False

Question 7

What is a split form and why is it useful?

Accepted Answer

A split form allows you to view data in

Question 8

Which of the following is true about blank reports?

Accepted Answer

A)  They use the tabular layout. 
B)  They use the stacked layout. 
C)  They don't contain any controls. 
D)  The header area contains a default title. 
A)  They use the tabular layout. 
B)  They use the stacked layout. 
C)  They don't contain any controls. 
D)  The header area contains a default title.

Question 9

What does Access call a form that doesn't have a connection to a data source?

Accepted Answer

A)  bound form 
B)  connected form 
C)  unbound form 
D)  disconnected form 
A)  bound form 
B)  connected form 
C)  unbound form 
D)  disconnected form

Question 10

After you create a report using the Report Wizard,it's possible to modify the layout of the report in Design view.

Accepted Answer

A) True 
 B)False

Question 11

In a stacked form layout,all of the fields have the same width.

Accepted Answer

A) True 
 B)False

Question 12

You can have a maximum of one conditional formatting rule in a report.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following can you use to select the desired settings to limit actions available in a form?

Accepted Answer

A)  Conditional Formatting Rules Manager 
B)  control layouts 
C)  Property Sheet 
D)  Command Button Wizard 
A)  Conditional Formatting Rules Manager 
B)  control layouts 
C)  Property Sheet 
D)  Command Button Wizard

Question 14

When viewing a report,Design view 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) True 
 B)False

Question 15

On the Design tab,selecting the Title button adds a title into the header section of the report.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is used to perform an action such as Close Form,Open Form,Delete Record,and so on?

Accepted Answer

A)  text box 
B)  label 
C)  command button 
D)  check box 
A)  text box 
B)  label 
C)  command button 
D)  check box

Question 17

What are some of the tasks you might perform when customizing a report in Layout view?

Accepted Answer

You can perform several tasks in Layout

Question 18

When adding totals to a report,which of the following calculation options counts up the number of records that meet a certain condition?

Accepted Answer

A)  Sum 
B)  Count Values 
C)  Max 
D)  Standard Deviation 
A)  Sum 
B)  Count Values 
C)  Max 
D)  Standard Deviation

Question 19

When using multiple conditional formatting rules,which of the following statements is true?

Accepted Answer

A)  The order of the rules is unimportant. 
B)  The order of the rules is important. 
C)  Access continues to evaluate rules after a match is found. 
D)  all of the above 
A)  The order of the rules is unimportant. 
B)  The order of the rules is important. 
C)  Access continues to evaluate rules after a match is found. 
D)  all of the above

Question 20

Which of the following indicates that a control has been selected?

Accepted Answer

A)  an orange border 
B)  a green border 
C)  a red border 
D)  a red dashed border 
A)  an orange border 
B)  a green border 
C)  a red border 
D)  a red dashed border

What is the main advantage of using one of Access's control layouts when designing a form?

In Access,what are the fields,labels,and buttons called?

The Control Wizards tool directs Access to launch an available wizard when adding controls to an object.

When a new blank form is created,there are no controls initially placed on the form.

Which of the following views is good for resizing fields or labels,changing colors or text alignment,or applying different formats?

In Access,fields,labels,and buttons are called objects.

What is a split form and why is it useful?

Which of the following is true about blank reports?

What does Access call a form that doesn't have a connection to a data source?

After you create a report using the Report Wizard,it's possible to modify the layout of the report in Design view.

In a stacked form layout,all of the fields have the same width.

You can have a maximum of one conditional formatting rule in a report.

Which of the following can you use to select the desired settings to limit actions available in a form?

When viewing a report,Design view 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.

On the Design tab,selecting the Title button adds a title into the header section of the report.

Which of the following is used to perform an action such as Close Form,Open Form,Delete Record,and so on?

What are some of the tasks you might perform when customizing a report in Layout view?

When adding totals to a report,which of the following calculation options counts up the number of records that meet a certain condition?

When using multiple conditional formatting rules,which of the following statements is true?

Which of the following indicates that a control has been selected?

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

What is the main advantage of using one of Access's control layouts when designing a form?

In Access,what are the fields,labels,and buttons called?

The Control Wizards tool directs Access to launch an available wizard when adding controls to an object.

When a new blank form is created,there are no controls initially placed on the form.

Which of the following views is good for resizing fields or labels,changing colors or text alignment,or applying different formats?

In Access,fields,labels,and buttons are called objects.

What is a split form and why is it useful?

Which of the following is true about blank reports?

What does Access call a form that doesn't have a connection to a data source?

After you create a report using the Report Wizard,it's possible to modify the layout of the report in Design view.

In a stacked form layout,all of the fields have the same width.

You can have a maximum of one conditional formatting rule in a report.

Which of the following can you use to select the desired settings to limit actions available in a form?

When viewing a report,Design view 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.

On the Design tab,selecting the Title button adds a title into the header section of the report.

Which of the following is used to perform an action such as Close Form,Open Form,Delete Record,and so on?

What are some of the tasks you might perform when customizing a report in Layout view?

When adding totals to a report,which of the following calculation options counts up the number of records that meet a certain condition?

When using multiple conditional formatting rules,which of the following statements is true?

Which of the following indicates that a control has been selected?

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