Question 1

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

split

Question 2

Differentiate between bound and unbound controls.

Accepted Answer

Controls are either bound or unbound. Bound controls display values from a field such as text boxes and combo boxes. Unbound controls do not display data; unbound controls describe data or enhance the appearance of the form. Labels are the most common type of unbound control, but other types include lines, images, tabs, and command buttons. Another way to distinguish bound from unbound controls is to observe the form as you move from record to record. Because bound controls display data, their contents change as you move through the records, displaying the entry in the field of the current record. Unbound controls such as labels and lines do not change as you move through the records in a form.

Question 3

Which control is used to create a three-dimensional aspect to a form?

Accepted Answer

A)  Command button 
B)  Toggle button 
C)  Rectangle control 
D)  Tab control 
A)  Command button 
B)  Toggle button 
C)  Rectangle control 
D)  Tab control D

Question 4

Match between columns
                        Premises: Used to provide a list of options for a field plus the ability for the user to enter a new value

Accepted Answer

The Answer of Toggle button and Tab control and List is...

Question 5

Deleting a field from a form does not delete it from the underlying table or have any effect on the data contained in the field.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Bound controls exist only to describe or enhance the appearance of the form.

Accepted Answer

A) True 
 B)False

Question 8

The lower pane of a split form displays a(n) datasheet view. _________________________

Accepted Answer

A) True 
 B)False

Question 9

On a form, text box controls display data from an underlying record source.

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

Match between columns
                        Premises: Used to visually separate information on a form

Accepted Answer

The Answer of Combo box and Option button and Label is...

Question 12

The Align button in the Sizing and Ordering 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 13

Match between columns
                        Premises: Best choice to display a field such as Veteran that has only two options, Yes or No

Accepted Answer

The Answer of Line and Command button and List box is...

Question 14

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 15

____ records are those on the many side of a relationship that do not have a match on the one side.

Accepted Answer

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

Question 16

On a form, ____________________ View is used to modify controls and does not display data.

Accepted Answer

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

Question 17

The Navigation tab on the Property Sheet allows you to change the tab stop or tab order properties. _________________________

Accepted Answer

A) True 
 B)False

Question 18

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 19

It would make sense to set the Tab Stop property of a text box that will not be used for data entry to No.

Accepted Answer

A) True 
 B)False

Question 20

Match between columns
                        Premises: Used to provide a list of possible data entries

Accepted Answer

The Answer of Toggle button and Option button and Combo is...

Exam 3: Access 3: Using Forms

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.

Differentiate between bound and unbound controls.

Which control is used to create a three-dimensional aspect to a form?

Deleting a field from a form does not delete it from the underlying table or have any effect on the data contained in the field.

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

Bound controls exist only to describe or enhance the appearance of the form.

The lower pane of a split form displays a(n) datasheet view. _________________________

On a form, text box controls display data from an underlying record source.

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.​

The Align button in the Sizing and Ordering group is available on the ____ tab.

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

____ records are those on the many side of a relationship that do not have a match on the one side.

On a form, ____________________ View is used to modify controls and does not display data.

The Navigation tab on the Property Sheet allows you to change the tab stop or tab order properties. _________________________

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

It would make sense to set the Tab Stop property of a text box that will not be used for data entry to No.

Access 1: Getting Started With Access

Access 2: Building and Using Queries

Access 4: Using Reports

Essential: Understanding Essential Computer Concepts

Excel 1: Getting Started With Excel 2016

Excel 2: Working With Formulas and Functions

Excel 3: Formatting a Worksheet

Excel 4: Working With Charts

Integration 1: Integrating Word and Excel

Integration 2: Integrating Word Excel and Access

Integration 3: Integrating Word Excel Access and Powerpoint

Office: Getting Started With Office 2016

Outlook 1: Getting Started With Email

Outlook 2: Managing Information Using Outlook

Powerpoint 1: Creating a Presentation in Powerpoint 2016

Powerpoint 2: Modifying a Presentation

Powerpoint 3: Inserting Objects Into a Presentation

Powerpoint 4: Finishing a Presentation

Windows 1: Getting Started With Windows 10

Windows 2: Understanding File Management

Word 1: Creating Documents With Word 2016

Word 2: Editing Documents

Word 3: Formatting Text and Paragraphs

Word 4: Formatting Documents

Filters

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.