Deck 4: Access Lesson 4: Creating and Modifying Forms

Question 1

An unbound control is connected to a field in the record source and is used to display, enter, and update data.

Answer 1

False

Question 2

In the Form Wizard, the ____ layout displays fields with the labels at the top of a column that contains the field values.

A) Justified
B) Tabular
C) Stacked
D) Columnar

Answer 2

B

Question 3

A workbook is a database object that displays data from one or more tables or queries in a format that has a similar appearance to a paper form.

Answer 3

False

Question 4

You can use the Undo button on the Quick Access Toolbar to restore a deleted field value, but deleting a record permanently deletes it from the record source.

Question 5

In the bottom pane of the Split Form tool, you will see a ____ that contains the form data.

A) worksheet
B) workbook
C) spreadsheet
D) datasheet

Question 6

When you create a form, it contains one section called the Title section.

Question 7

When a form is displayed in Query view, you will see each record in the record source in a form.

Question 8

The Form Footer section displays information at the top of each form.

Question 9

When you resize controls in a control layout in Layout view, reducing the width of one control reduces all the widths of all other controls in the control layout at the same time.

Question 10

To select a group of controls, click the first control, press and hold down the Tab key, click the other controls, and then release the Tab key.

Question 11

When you need to create a form to match a paper form that you are already using-or when you need to create a form that doesn't match the appearance of a form that you can create with a form tool or the Form Wizard-you can create a blank form in Query view.

Question 12

When fields appear in a form, they appear in ____.

A) ascending order
B) commands
C) controls
D) lists

Question 13

You must be in Design view to add controls such as lines, rectangles, and labels to a form.

Question 14

The Many Fields tool creates a form that lists all the fields in a datasheet format, but using a style that is similar to the form created by the Form tool.

Question 15

The ____ tool creates a simple form that includes all the fields in the selected table or query, uses a simple format, and includes a title with the same name as the record source.

A) Form
B) Database
C) Query
D) Workbook

Question 16

The Form Wizard provides four form layouts from which to choose. The ____ layout displays fields in a stacked column format, with labels to the left of their controls.

A) Columnar
B) Stacked
C) Controlled
D) Tabular

Question 17

Most database experts agree that users should make all database updates by using a form, instead of by using table datasheets.

Question 18

A control layout is a "container" that groups together the controls in a form so that you can change them as a group.

Question 19

The Split Form tool creates a form using all the fields in the selected table or query and splits the window into four panes.

Question 20

Table, form, and report objects in the database can have the same name.

Question 21

Case AC 4-1 Jessica wants to find and replace some data in her database. If Jessica types S in the Find What list box, and then selects the Any Part of Field option in the Match menu, she'll find values that ____.

A) contain the letter S anywhere in the value
B) contain only the letter S
C) begin with the letter S
D) none of the above

Question 22

The ____________________ tool creates a form that looks just like a datasheet.

Question 23

FIGURE AC 4-1 Referring to Figure AC 4-1 above, to create this type of form, click the More Forms button in the Forms group on the ____ tab.

A) File
B) Create
C) Home
D) Format

Question 24

You can use a form to ____.

A) update the record source
B) add new records
C) delete existing records
D) all of the above

Question 25

In the Form Wizard, the ____ layout displays fields across the screen in the order in which they occur.

A) Justified
B) Tabular
C) Stacked
D) Columnar

Question 26

To remove one or more selected controls from a control layout, ____ the control to open the shortcut menu, point to Layout, and then click Remove Layout.

A) right-click
B) single-click
C) double-click
D) select

Question 27

You can also resize a control precisely by watching the lower-left corner of the ____ to see the width of the control in characters as you drag it.

A) Control Dialog box
B) task bar
C) Ribbon
D) status bar

Question 28

Another option for finding data quickly is to use the ____ command, which is available when you are using a table or query datasheet, form, or report.

A) Find
B) Look
C) Hunt
D) Replace

Question 29

Case AC 4-2 Zack wants to create a custom form to match a paper form that he uses everyday in the office. To create a blank form, Zack needs to click the Create tab on the Ribbon, and then click the Blank Form button in the ____ group.

A) Data
B) Forms
C) Edit
D) Query

Question 30

Case AC 4-1 Jessica wants to find and replace some data in her database. If Jessica types S in the Find What list box, and then selects the Whole Field option in the Match menu, she'll find values that ____.

A) contain the letter S anywhere in the value
B) contain only the letter S
C) begin with the letter S
D) none of the above

Question 31

To add a title to a form, which adds an unbound control to the form, click the ____ button in the Header/Footer group on the Design tab.

A) Title
B) Heading
C) Header
D) Text

Question 32

When a field is selected in the form, "Current field" appears in the ____ list box when you open the Find and Replace dialog box.

A) Look In
B) Look Out
C) Search In
D) Search Now

Question 33

A(n) ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures.

A) bound
B) unbound
C) either a. or b.
D) neither a. nor b.

Question 34

The ____ section displays information at the bottom of each form.

A) Form Header
B) Form Footer
C) Query Footer
D) Query Header

Question 35

Case AC 4-2 Zack wants to create a custom form to match a paper form that he uses everyday in the office. Zack has opened the Field List pane and wants to add a field to the form. What should he do?

A) Double-click a field in the Field List
B) Click Create Field on the Ribbon
C) Both a. and b.
D) Neither a. nor b.

Question 36

FIGURE AC 4-1 Referring to Figure AC 4-1 above, the form shown was created by using the ____ tool.

A) Double Form
B) Double View
C) Split Form
D) Split View

Question 37

To print the form with the current record displayed, you must be in ____ view and navigate to the desired record.

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

Question 38

You can see the position of objects in Design view as you are moving them, and you can position controls precisely by looking at the horizontal and vertical ____ that appear on the top and left sides of the form.

A) grids
B) rulers
C) guides
D) rows

Question 39

When you need to find and replace data, click the ____ button in the Find group on the Home tab. The Find and Replace dialog box opens with the Replace tab activated.

A) Transform
B) Find
C) Replace
D) Change

Question 40

When you add a control to only one of these sections, the Form Header and Form Footer sections are added to the form ____.

A) individually
B) as a pair
C) either a. or b.
D) neither a. nor b.

Question 42

A form's style, also called a(n) ____________________, formats the form and its controls using a predefined color, font, and design scheme.

Question 43

When you need to create a simple form quickly, you can use the ____________________, which helps you create a form by letting you select options in dialog boxes to specify the form's record source and layout.

Question 44

To delete a control from a form, click the control to select it, and then press ____________________.

Question 45

The Form Wizard provides four form layouts from which to choose. Name and briefly describe each layout, including an example of a situation of where you would use each layout.

Question 46

The ____________________ pane contains the tables in the database and displays the fields they contain.