Question 1

You can add fields to a form in either Layout View or Design View.

Accepted Answer

A) True 
 B)False  True

Question 2

Form View lets you make design changes while you are browsing the data. ____________________

Accepted Answer

A) True 
 B)False  False

Question 3

In an expression, you must type the field name exactly as it was created in Table Design View; you also need to match the capitalization.

Accepted Answer

A) True 
 B)False  False

Question 4

You can press an arrow key to move a selected control.

Accepted Answer

A) True 
 B)False

Question 5

Click in the text box of the field you want to sort after clicking a sort button. _________________________

Accepted Answer

A) True 
 B)False

Question 6

Case 3-1 
You are just starting to create a new form and have begun to realize that there are a variety of mouse pointer shapes in use. In order to make creating the form easier, you decide to familiarize yourself with a few of them. 
Which of the following displays when you point to any unselected control on the form?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 7

The Font Color list arrow in the Font group is available on the ____ tab.

Accepted Answer

A)  Arrange 
B)  Options 
C)  Home 
D)  Format 
A)  Arrange 
B)  Options 
C)  Home 
D)  Format

Question 8

The Size/Space button is in the Alignment group on the Arrange tab. _________________________

Accepted Answer

A) True 
 B)False

Question 9

Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?

Accepted Answer

A)  Form Wizard 
B)  More Forms 
C)  Split Form 
D)  Navigation 
A)  Form Wizard 
B)  More Forms 
C)  Split Form 
D)  Navigation

Question 10

On a form, ____________________ View can be used to move and modify controls while viewing live data.

Accepted Answer

The answer of On a form, ____________________ View can be...

Question 11

Which of the following would NOT be considered a graphic image?

Accepted Answer

A)  Picture 
B)  Logo 
C)  Text 
D)  Clip art 
A)  Picture 
B)  Logo 
C)  Text 
D)  Clip art

Question 12

Controls placed in this form section print once for every record.

Accepted Answer

A)  Form Records 
B)  Form Header 
C)  Form Footer 
D)  Detail 
A)  Form Records 
B)  Form Header 
C)  Form Footer 
D)  Detail

Question 13

____ View lets you make some design changes to a form while you are browsing the data.

Accepted Answer

A)  Layout 
B)  Design 
C)  Browse 
D)  Data 
A)  Layout 
B)  Design 
C)  Browse 
D)  Data

Question 14

Which of the following would most likely be used to display a Yes/No field on a form?

Accepted Answer

A)  Check box 
B)  Command button 
C)  Combo box 
D)  Label 
A)  Check box 
B)  Command button 
C)  Combo box 
D)  Label

Question 15

Differentiate between bound and unbound controls.

Accepted Answer

Controls are either bound or unbound. Bo

Question 16

When you add a new field to a form, two controls are usually created: a(n) caption and a text box. _________________________

Accepted Answer

A) True 
 B)False

Question 17

In a(n) ____________________ form, the upper pane shows the fields of one record while the lower pane maintains a datasheet view of the first few records.

Accepted Answer

The answer of In a(n) ____________________ form, the upper pane...

Question 18

Which control is used to provide consistent descriptive text as you navigate from record to record?

Accepted Answer

A)  Text box 
B)  Combo box 
C)  List box 
D)  Label 
A)  Text box 
B)  Combo box 
C)  List box 
D)  Label

Question 19

Referential integrity prevents the creation of ____ records.

Accepted Answer

A)  indexed 
B)  split 
C)  unlicensed 
D)  orphan 
A)  indexed 
B)  split 
C)  unlicensed 
D)  orphan

Question 20

On a form, ____________________ View is used to enter, edit, and delete data.

Accepted Answer

The answer of On a form, ____________________ View is used...

You can add fields to a form in either Layout View or Design View.

Form View lets you make design changes while you are browsing the data. ____________________

In an expression, you must type the field name exactly as it was created in Table Design View; you also need to match the capitalization.

You can press an arrow key to move a selected control.

Click in the text box of the field you want to sort after clicking a sort button. _________________________

The Font Color list arrow in the Font group is available on the ____ tab.

The Size/Space button is in the Alignment group on the Arrange tab. _________________________

Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?

On a form, ____________________ View can be used to move and modify controls while viewing live data.

Which of the following would NOT be considered a graphic image?

Controls placed in this form section print once for every record.

____ View lets you make some design changes to a form while you are browsing the data.

Which of the following would most likely be used to display a Yes/No field on a form?

Differentiate between bound and unbound controls.

When you add a new field to a form, two controls are usually created: a(n) caption and a text box. _________________________

In a(n) ____________________ form, the upper pane shows the fields of one record while the lower pane maintains a datasheet view of the first few records.

Which control is used to provide consistent descriptive text as you navigate from record to record?

Referential integrity prevents the creation of ____ records.

On a form, ____________________ View is used to enter, edit, and delete data.

Getting Started With Access

Building and Using Queries

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 3: Using Forms

You can add fields to a form in either Layout View or Design View.

Form View lets you make design changes while you are browsing the data. ____________________

In an expression, you must type the field name exactly as it was created in Table Design View; you also need to match the capitalization.

You can press an arrow key to move a selected control.

Click in the text box of the field you want to sort after clicking a sort button. _________________________

The Font Color list arrow in the Font group is available on the ____ tab.

The Size/Space button is in the Alignment group on the Arrange tab. _________________________

Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?

On a form, ____________________ View can be used to move and modify controls while viewing live data.

Which of the following would NOT be considered a graphic image?

Controls placed in this form section print once for every record.

____ View lets you make some design changes to a form while you are browsing the data.

Which of the following would most likely be used to display a Yes/No field on a form?

Differentiate between bound and unbound controls.

When you add a new field to a form, two controls are usually created: a(n) caption and a text box. _________________________

In a(n) ____________________ form, the upper pane shows the fields of one record while the lower pane maintains a datasheet view of the first few records.

Which control is used to provide consistent descriptive text as you navigate from record to record?

Referential integrity prevents the creation of ____ records.

On a form, ____________________ View is used to enter, edit, and delete data.

Getting Started With Access

Building and Using Queries

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters