Question 1

The number of occurrences of an expression is determined using the ____ function in a form or report.

Accepted Answer

A)  SUM 
B)  AVERAGE 
C)  COUNT 
D)  MAX 
A)  SUM 
B)  AVERAGE 
C)  COUNT 
D)  MAX

Question 2

To select and set properties for an entire section, click on the ____.

Accepted Answer

A)  Property Sheet 
B)  section selector 
C)  section tab 
D)  Layout view 
A)  Property Sheet 
B)  section selector 
C)  section tab 
D)  Layout view

Question 3

In the accompanying figure, the control type for the selected control is a ____.

Accepted Answer

A)  Combo box 
B)  Label 
C)  Calculated field 
D)  Text box 
A)  Combo box 
B)  Label 
C)  Calculated field 
D)  Text box

Question 4

The accompanying figure illustrates a form created using the ____________________ Tool which contains all fields in the source table or query.

Accepted Answer

The answer of   
The accompanying figure illustrates a...

Question 5

The Bound Column property specifies the default control used to display a field. _________________________

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: The area in form Design view with dotted and solid lines that assists with positioning controls precisely in a form.

Accepted Answer

The Answer of Count function and Form Footer and control is...

Question 7

Which form tool displays data in both Form view and Datasheet view at the same time?

Accepted Answer

A)  Multiple Items 
B)  Datasheet 
C)  Split Form 
D)  Standard 
A)  Multiple Items 
B)  Datasheet 
C)  Split Form 
D)  Standard

Question 8

Tab order may only be changed in form Design view.

Accepted Answer

A) True 
 B)False

Question 9

In the accompanying figure, which arrow indicates the Detail section bar?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 10

A combo box control may only be modified in form Design view.

Accepted Answer

A) True 
 B)False

Question 11

Which type of report does the accompanying figure illustrate?

Accepted Answer

A)  Custom report 
B)  Relationships report 
C)  Object Definition report 
D)  Object Properties report 
A)  Custom report 
B)  Relationships report 
C)  Object Definition report 
D)  Object Properties report

Question 12

Describe at least five of the nine form design guidelines presented in the text that should be followed when planning a form.

Accepted Answer

1. Determine the fields and record sourc

Question 13

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.

Accepted Answer

A)  tab alignment 
B)  tab stop 
C)  tab order 
D)  tab focus 
A)  tab alignment 
B)  tab stop 
C)  tab order 
D)  tab focus

Question 14

When a control is active and waiting for user action, the control has focus . _________________________

Accepted Answer

A) True 
 B)False

Question 15

Spacing around the text inside a control is determined using the ____ property.

Accepted Answer

A)  Control Margins 
B)  Control Padding 
C)  Anchor 
D)  Text Format 
A)  Control Margins 
B)  Control Padding 
C)  Anchor 
D)  Text Format

Question 16

List five suggestions that help prevent common problems and recover from errors while building forms.

Accepted Answer

1. Use the Undo button one or more times

Question 17

The ____________________ function calculates the total of an expression in a form or report.

Accepted Answer

The answer of The ____________________ function calculates the total of...

Question 18

Match between columns
                        Premises: A function that determines the number of occurrences of an expression.

Accepted Answer

The Answer of bound form and Sum function and Count is...

Question 19

Match between columns
                        Premises: The type of form that does not have a record source and is usually a form that helps users navigate among the objects in a database.

Accepted Answer

The Answer of Form Header and grid and Count function is...

Question 20

A(n) ____________________ asks a series of questions and uses the answers to the questions to create a control in a form or report.

Accepted Answer

The answer of A(n) ____________________ asks a series of questions...

The number of occurrences of an expression is determined using the ____ function in a form or report.

To select and set properties for an entire section, click on the ____.

In the accompanying figure, the control type for the selected control is a ____.

The accompanying figure illustrates a form created using the ____________________ Tool which contains all fields in the source table or query.

The Bound Column property specifies the default control used to display a field. _________________________

Which form tool displays data in both Form view and Datasheet view at the same time?

Tab order may only be changed in form Design view.

In the accompanying figure, which arrow indicates the Detail section bar?

A combo box control may only be modified in form Design view.

Which type of report does the accompanying figure illustrate?

Describe at least five of the nine form design guidelines presented in the text that should be followed when planning a form.

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.

When a control is active and waiting for user action, the control has focus . _________________________

Spacing around the text inside a control is determined using the ____ property.

List five suggestions that help prevent common problems and recover from errors while building forms.

The ____________________ function calculates the total of an expression in a form or report.

A(n) ____________________ asks a series of questions and uses the answers to the questions to create a control in a form or report.

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters

Exam 7: Using Form Tools and Creating Custom Forms

The number of occurrences of an expression is determined using the ____ function in a form or report.

To select and set properties for an entire section, click on the ____.

In the accompanying figure, the control type for the selected control is a ____.

The accompanying figure illustrates a form created using the ____________________ Tool which contains all fields in the source table or query.

The Bound Column property specifies the default control used to display a field. _________________________

Which form tool displays data in both Form view and Datasheet view at the same time?

Tab order may only be changed in form Design view.

In the accompanying figure, which arrow indicates the Detail section bar?

A combo box control may only be modified in form Design view.

Which type of report does the accompanying figure illustrate?

Describe at least five of the nine form design guidelines presented in the text that should be followed when planning a form.

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.

When a control is active and waiting for user action, the control has focus . _________________________

Spacing around the text inside a control is determined using the ____ property.

List five suggestions that help prevent common problems and recover from errors while building forms.

The ____________________ function calculates the total of an expression in a form or report.

A(n) ____________________ asks a series of questions and uses the answers to the questions to create a control in a form or report.

Managing Your Files

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Creating Custom Reports

Sharing Integrating and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Sharing a Database

Filters