Deck 3: Create Forms

Question 1

A ________ is a form that contains a Navigation Control.

A) Single Form
B) stacked layout
C) Navigation Form
D) tabular layout

Answer 1

C

Question 2

A(n) ________ is a control in a form that describes other objects in the form.

A) list box
B) label
C) icon
D) text box

Answer 2

B

Question 3

To change text in a control, you need to be in ________.

A) Ready mode
B) Edit view
C) Edit mode
D) Design view

Answer 3

C

Question 4

To deselect one of the selected multiple controls, press and hold ________ while clicking with the pointer.

A) [Tab]
B) [Ctrl]
C) [Alt]
D) [Esc]

Question 5

When a form is used to input or modify data in a table, the data is saved to the table ________.

A) automatically
B) only when the user saves a record
C) only when the user saves the table
D) only when the user saves the form

Question 6

An object in a form such as a label or text box is called a(n) ________.

A) control
B) grid
C) icon
D) placeholder

Question 7

When a form is selected, the Conditional Formatting button is found in the ________ group under the Format tab.

A) Control Formatting
B) Font
C) Number
D) Background

Question 8

In a ________ layout, controls are arranged in rows and columns like a spreadsheet.

A) tabular
B) stacked
C) columnar
D) justified

Question 9

The symbols in an input mask that are replaced as the user types data into the field are called ________ characters.

A) masked
B) placeholder
C) data
D) layout

Question 10

One way to move from one field to another in a form is by using ________.

A) arrows
B) Home
C) Enter
D) Page Down

Question 11

When a form is selected, the Property Sheet button is found in the ________ group under the Design tab.

A) Controls
B) Tools
C) Themes
D) Views

Question 12

One way to create a form in Access is to use the ________, which can be used to select multiple tables and specific fields for the form.

A) Form Wizard
B) Navigation Pane
C) Input Mask Wizard
D) control grid

Question 13

The New Formatting Rule dialog box provides a(n) ________ list that shows the comparisons that can be used.

A) operators
B) keys
C) conditions
D) prototypes

Question 14

The Form Wizard button is found in the Forms group under the ________ tab.

A) Home
B) Database Tools
C) Create
D) External Data

Question 15

To select multiple controls, press and hold ________ while clicking with the pointer.

A) [Shift]
B) [Tab]
C) [Alt]
D) [Esc]

Question 16

When the Conditional Formatting button is clicked, the ________ displays.

A) Conditional Formatting Rules Manager
B) Conditional Formatting Wizard
C) Conditional Formatting Input Manager
D) Conditional Formatting Property

Question 17

Which of the following is not displayed on the first screen of the Form Wizard?

A) Tables/Queries
B) Layout
C) Available Fields
D) Selected Fields

Question 18

The Form Wizard allows the user to choose ________, Datasheet, Justified, or Columnar layout.

A) Mixed
B) Fixed
C) Stacked
D) Tabular

Question 19

A form has a ________ at the bottom so you can move from one record to another.

A) Menu bar
B) Find box
C) Navigation bar
D) GoTo feature

Question 20

A ________ determines how data and labels are arranged in a form.

A) grid
B) layout
C) template
D) map

Question 21

In a one-to-many form, the subform shows data from the ________ side of the relationship.

A) one
B) many
C) some
D) every

Question 22

The first screen of the Form Wizard is where you select the layout for your form.

Question 23

The second screen of the Form Wizard is where you select the fields you want your form to display.

Question 24

When formatting a form in Layout view, only one control can be selected and formatted at a time.

Question 25

A ________ form allows the user to add records to two tables at once.

A) one-to-many
B) many-to-many
C) some-to-some
D) some-to-one

Question 26

A ________ is an example of a placeholder character.

A) caret
B) hyphen
C) tilde
D) plus sign

Question 27

In a one-to-many form, the main form shows data from the ________ side of the relationship.

A) one
B) many
C) some
D) every

Question 28

Operators such as greater than and less than that compare two values are ________.

A) comparison operators
B) conditional operators
C) contrasting operators
D) provisional operators

Question 29

When a ________ form opens, the Navigation Pane is collapsed.

A) modal
B) pop-up
C) bicentric
D) convex

Question 30

In a one-to-many form, the related records display in a subform.

Question 31

You can create a form that is based on a query that displays only the records returned by the query's ________.

A) sort
B) conditions
C) criteria
D) placeholders

Question 32

If a user needs to edit data for a specific subset of data, a form can be based on a query instead of a table.

Question 33

When data is changed using a form, the changes are automatically saved.

Question 34

Social Security Number is an input mask provided by Access.

Question 35

Controls such as logos and titles can be added to forms.

Question 36

Vertical Tabs Left is an example of a Navigation Form layout.

Question 37

A ________ provides a visual summary of the layouts available in a Navigation form.

A) wizard
B) menu
C) module
D) gallery

Question 38

Which of the following is NOT an Input Mask provided by Access?

A) Street Address
B) Social Security Number
C) Phone Number
D) Zip Code

Question 39

In a one-to-many form, the main form displays in Single Form view, and the related records display in a subform in ________ view.

A) Design
B) Layout
C) Double Form
D) Datasheet

Question 40

You CANNOT rearrange controls in a tabular layout.

Question 41

Using conditional formatting causes a value to be formatted one way when a condition is true and another way when the condition is false.

Question 42

To format a form while viewing a sample of the data, use the Form view.

Question 43

You can enter data in forms without having to take your hands off the keyboard.

Question 44

Forms can be used to edit table data while viewing records.

Question 45

If a field has a caption property assigned, that value will display in the label in Single Form view.

Question 46

You can apply conditional formatting to a control on a form if its value meets specific criteria.

Question 47

A form created using tabular layout will have labels in the first column and data in the second column.

Question 48

Single Form view displays one record at a time.

Question 49

You can insert more than one line of text in a Title control.

Question 50

Access supports conditional formatting.

Question 51

A form and subform are saved as two separate forms.

Question 52

On a form, a text box displays the data from a field in a table or query.

Question 53

In Double Form view, field names display in the first column and field values in the second column.

Question 54

Move from one field to another in a form using [End].

Question 55

Using the Form Wizard is the only way to create a form in Access 2013.

Question 56

A many-to-many form is created when you use the Form Tool.

Question 57

The arrangement of data and labels on a form is called the layout.

Question 58

Conditional formatting does not allow you to highlight certain data on your form.

Question 59

The Form Wizard allows only the user to select one table for use with the form.

Question 60

Forms are designed to input data into tables.

Question 61

One technique to select fields to be included in your form is to ________ each field.

Question 62

One way to create a form in Access is to use the ________, which can be used to select specific fields for the form.

Question 63

You CANNOT see your data while you are modifying your form configured in tabular layout.

Question 64

A form that is contained within another form is called a(n) ________.

Question 65

It does not matter whether you establish table relationships before creating a one-to-many form.

Question 66

You CANNOT move a control within a layout to the location you want.

Question 67

An input mask is a set of special characters that control what can and cannot be entered in a field.

Question 68

A form is used to enter data into a(n) ________.

Question 69

A one-to-many form allows the user to work with data from two tables on a single screen.

Question 70

A(n) ________ layout places labels in the first column and data in the second column.

Question 71

When a modal form opens, the ________ is collapsed.

Question 72

There is only one layout available in Navigation forms.

Question 73

An object on a form such as a label or text box is called a(n) ________.

Question 74

In a form created with a tabular layout, you can insert, delete, and merge columns as needed.

Question 75

A(n) ________form can add records to two tables.

Question 76

In the Applications Options dialog box, you can pick one form that opens automatically when the database is opened.

Question 77

An input mask can be created to allow a user to enter a Social Security number as 831867180, but store it in the table as 831-86-7180.

Question 78

As you drag a field within a layout, a horizontal or vertical bar indicates where it will be placed when you release the mouse button.

Question 79

A set of special characters that control what can and cannot be entered in a field is called a(n) ________.

Question 80

The New Formatting Rule dialog box provides a list of ________ that compare two values.