Question 1

In the accompanying figure, which numbered arrow indicates the property that must be changed for the selected control to display "Guest Last Name?"

Accepted Answer

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

Question 2

Describe the various methods of setting properties for a control using the Property Sheet.

Accepted Answer

Properties may be set by typing a value

Question 3

Access assigns names to control boxes if the Name property for the control is not set when the form is created. _________________________

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: A control that displays a value that is the result of an expression.

Accepted Answer

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

Question 5

A subform may be added to a main form by using the Subform/Subreport tool or by using the ____.

Accepted Answer

A)  Subform control 
B)  Subform Wizard 
C) Subform/Subreport dialog box 
D)  Subform property 
A)  Subform control 
B)  Subform Wizard 
C) Subform/Subreport dialog box 
D)  Subform property

Question 6

The Tab Order button, which quickly displays the Tab Order dialog box, is located on the ____ tab in Form Design view.

Accepted Answer

A)  FORMAT 
B)  ARRANGE 
C)  LAYOUT 
D)  DESIGN 
A)  FORMAT 
B)  ARRANGE 
C)  LAYOUT 
D)  DESIGN

Question 7

A(n) ____________________ control in a form design is created using a field selected from the table or query used as the record source for the form.

Accepted Answer

The answer of A(n) ____________________ control in a form design...

Question 8

A tool used to form a group of related controls or to separate the group from other controls is the ____ tool.

Accepted Answer

A)  Rectangle 
B)  Bound Object Frame 
C)  Unbound Object Frame 
D)  Line 
A)  Rectangle 
B)  Bound Object Frame 
C)  Unbound Object Frame 
D)  Line

Question 9

Set the ____ property to No to prevent users from using the Tab key to navigate to a control.

Accepted Answer

A)  Tab Stop 
B)  On Tab 
C)  Tab Index 
D)  Text Align 
A)  Tab Stop 
B)  On Tab 
C)  Tab Index 
D)  Text Align

Question 10

When resizing controls in Design view, the user can see actual field values while resizing the controls. _________________________

Accepted Answer

A) True 
 B)False

Question 11

Which symbol is used to distinguish an expression from a fieldname in a calculated control?

Accepted Answer

A)  # 
B)  ! 
C)  = 
D)  + 
A)  # 
B)  ! 
C)  = 
D)  +

Question 12

The default Form Footer section Height property is set to ____ when the Form Footer is added in Design view.

Accepted Answer

A)  one inch 
B)  one-half inch 
C)  one-quarter inch 
D)  zero 
A)  one inch 
B)  one-half inch 
C)  one-quarter inch 
D)  zero

Question 13

Only a field name or an expression may be used for the ____ property in a calculated control.

Accepted Answer

A)  Source 
B)  Control Source 
C)  Visible 
D)  Calculate 
A)  Source 
B)  Control Source 
C)  Visible 
D)  Calculate

Question 14

Match between columns
                        Premises: A control that is not connected to a field in the database.

Accepted Answer

The Answer of Sum function and Count function and control is...

Question 15

Match between columns
                        Premises: A function that calculates the total of an expression.

Accepted Answer

The Answer of Sum function and control layout and Form is...

Question 16

A(n) ____________________ is an unbound control that displays text.

Accepted Answer

The answer of A(n) ____________________ is an unbound control that...

Question 17

Text that appears in a ScreenTip when the mouse pointer is positioned above a control in a form is determined by the ____ property.

Accepted Answer

A)  Control Source 
B)  ControlTip Text 
C)  Text Format 
D)  Visible 
A)  Control Source 
B)  ControlTip Text 
C)  Text Format 
D)  Visible

Question 18

A selected column of controls may be aligned to the left or right edges of the controls using the ARRANGE tab on the ribbon.

Accepted Answer

A) True 
 B)False

Question 19

A control that combines the features of a text box and a list box is a ____.

Accepted Answer

A)  text box 
B)  lookup box 
C)  custom box 
D)  combo box 
A)  text box 
B)  lookup box 
C)  custom box 
D)  combo box

Question 20

The ____________________ property for a control will automatically resize the control and place it in the same relative position on the screen regardless of monitor size and screen resolution.

Accepted Answer

The answer of The ____________________ property for a control will...

In the accompanying figure, which numbered arrow indicates the property that must be changed for the selected control to display "Guest Last Name?"

Describe the various methods of setting properties for a control using the Property Sheet.

Access assigns names to control boxes if the Name property for the control is not set when the form is created. _________________________

A subform may be added to a main form by using the Subform/Subreport tool or by using the ____.

The Tab Order button, which quickly displays the Tab Order dialog box, is located on the ____ tab in Form Design view.

A(n) ____________________ control in a form design is created using a field selected from the table or query used as the record source for the form.

A tool used to form a group of related controls or to separate the group from other controls is the ____ tool.

Set the ____ property to No to prevent users from using the Tab key to navigate to a control.

When resizing controls in Design view, the user can see actual field values while resizing the controls. _________________________

Which symbol is used to distinguish an expression from a fieldname in a calculated control?

The default Form Footer section Height property is set to ____ when the Form Footer is added in Design view.

Only a field name or an expression may be used for the ____ property in a calculated control.

A(n) ____________________ is an unbound control that displays text.

Text that appears in a ScreenTip when the mouse pointer is positioned above a control in a form is determined by the ____ property.

A selected column of controls may be aligned to the left or right edges of the controls using the ARRANGE tab on the ribbon.

A control that combines the features of a text box and a list box is a ____.

The ____________________ property for a control will automatically resize the control and place it in the same relative position on the screen regardless of monitor size and screen resolution.

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

In the accompanying figure, which numbered arrow indicates the property that must be changed for the selected control to display "Guest Last Name?"

Describe the various methods of setting properties for a control using the Property Sheet.

Access assigns names to control boxes if the Name property for the control is not set when the form is created. _________________________

A subform may be added to a main form by using the Subform/Subreport tool or by using the ____.

The Tab Order button, which quickly displays the Tab Order dialog box, is located on the ____ tab in Form Design view.

A(n) ____________________ control in a form design is created using a field selected from the table or query used as the record source for the form.

A tool used to form a group of related controls or to separate the group from other controls is the ____ tool.

Set the ____ property to No to prevent users from using the Tab key to navigate to a control.

When resizing controls in Design view, the user can see actual field values while resizing the controls. _________________________

Which symbol is used to distinguish an expression from a fieldname in a calculated control?

The default Form Footer section Height property is set to ____ when the Form Footer is added in Design view.

Only a field name or an expression may be used for the ____ property in a calculated control.

A(n) ____________________ is an unbound control that displays text.

Text that appears in a ScreenTip when the mouse pointer is positioned above a control in a form is determined by the ____ property.

A selected column of controls may be aligned to the left or right edges of the controls using the ARRANGE tab on the ribbon.

A control that combines the features of a text box and a list box is a ____.

The ____________________ property for a control will automatically resize the control and place it in the same relative position on the screen regardless of monitor size and screen resolution.

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