Deck 2: Access: Using Form Tools and Creating Custom Forms

Question 1

If your form does not need a particular section you can remove it by setting its height to -1 which is the same method you would use to remove any form section.

Answer 1

False

Question 2

When a field changes from a lookup field to a text box an arrow will appear in the field.

Answer 2

False

Question 3

You can design a custom form to match a paper form to display some fields side by side and others top to bottom or to add special buttons and list boxes.

Answer 3

True

Question 4

Controls placed in the Form Header or Form Footer sections do not remain on the screen when the form is displayed.

Question 5

You would use a bound control for a form title or instructions.

Question 6

The text box that Access adds when you add a bound control to a form displays the field values from the record source.

Question 7

A numerical control displays a value calculated using data from one or more fields.

Question 8

You cannot use the same name for a report as you do for a table or query.

Question 9

When you use the Anchor property Access scales the control's font size to match the screen size and resolution.

Question 10

A selected control displays six sizing handles.

Question 11

When you add an unbound control for a form Access adds a text box and a label.

Question 12

A bound control that displays text is called a label.

Question 13

The item indicated in the accompanying figure shows a many-to-one relationship.

Question 14

You would use an unbound control to display graphics and pictures created using other software programs.

Question 15

Scroll bars are productive for users leading to good form design.

Question 16

You create a custom form from scratch in Form view.

Question 17

Controls placed in the Form Header and Form Footer sections do not change when the contents of the Detail section change.

Question 18

You would use an unbound control to display lines and rectangles.

Question 19

Whether you want to create a simple or complex custom form planning the form's content and appearance first is always best.

Question 20

An unbound control is linked to a field in the underlying table or query.

Question 21

One guideline for working with forms is to design a form to match a ____ document closely if users will refer to one while working with the form.

A)main
B)control
C)source
D)destination

Question 22

Moving one control in a control layout moves all controls in the set.

Question 23

After minimizing the Ribbon if you double-click any tab on the Ribbon the full Ribbon appears and then minimizes again as soon as you click anywhere outside the Ribbon.

Question 24

One guideline for working with forms is to display ____ fields in a distinctive way and prevent users from changing and updating them.

A)bound
B)unbound
C)calculated
D)both a and b

Question 25

When you drag a(n)sizing handle you resize the control.

Question 26

An unbound control that displays text is called a(n)caption .

Question 27

The Format property specifies the type of special effect applied to a control on a form or report.

Question 28

The join line indicated in the accompanying figure indicates a many-to-one relationship.

Question 29

Form Headers and Footers display in Datasheet view.

Question 30

To remove the lookup feature from a field you would change the Default Control property which specifies the default control used to display a field.

Question 31

One guideline for working with forms is to align field values with ____ for readability.

A)labels
B)records
C)tabs
D)All of the above

Question 32

The section selector is the selector at the intersection of the horizontal and vertical rulers.

Question 33

You can click one of the view buttons on the left side of the status bar to switch to another view.

Question 34

One guideline for working with forms is to use a consistent ____ for all forms in a database.

A)style
B)size
C)resolution
D)index

Question 35

A form's Background property specifies the table or query that provides the fields for the form.

Question 36

If you want to ensure that you draw a straight horizontal or vertical line hold down the Ctrl key before and during the drag operation.

Question 37

You can print the Documenter window to document the fields tables and relationships in a database.

Question 38

Bound forms are forms that do not have a record source and are usually used for forms that help users navigate among the objects in a database.

Question 39

You can change the size of the Detail section by dragging its move handle .

Question 40

One guideline for working with forms is to ____ related fields and position them in a meaningful logical order.

A)aggregate
B)sort
C)index
D)group

Question 41

The kind of join line indicated in the accompanying figure reflects that ____ integrity is enforced.

A)deferential
B)referential
C)sequential
D)indexed

Question 42

The Documenter is available in the Analyze group on the ____ tab.

A)Format
B)Database Tools
C)File
D)Window

Question 43

One guideline for working with forms is to use ____ values whenever possible to reduce user errors.

A)base
B)default
C)consistent
D)color-coded

Question 44

The item marked 2 in the accompanying figure includes the ____ documentation.

A)table
B)relationship
C)field
D)record

Question 45

For each selected object the ____ lets you print documentation such as the object's properties and relationships and the fields used by the object and their properties.

A)Relationships Wizard
B)Property Manager
C)Documenter
D)Control Wizard

Question 46

A form ____ provides the same functionality as a lookup field in a clearer more flexible way.

A)control box
B)combo box
C)value box
D)entry box

Question 47

____ view allows you to view and update data for a form created with the Datasheet tool.

A)Datasheet
B)Layout
C)Form
D)all of the above

Question 48

The ____ Control property specifies the default control used to display a field.

A)Display
B)Default
C)Dynamic
D)Standard

Question 49

A form created by the Datasheet tool cannot be displayed in ____ view.

A)Datasheet
B)Design
C)Layout
D)Any of the above

Question 50

When you use the ____ tool the record source for the form must either be open or selected in the Navigation Pane.

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

Question 51

To minimize the Ribbon ____ any tab on the Ribbon.

A)click
B)double-click
C)hover over
D)any of the above

Question 52

A form ____ lets you choose a value from a list or type an entry.

A)control box
B)combo box
C)value box
D)entry box

Question 53

All of the following are included on the report in the accompanying figure EXCEPT ____ documentation.

A)table
B)field
C)record
D)relationship

Question 54

When you use the Split Form tool the ____ views are synchronized with each other at all times.

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

Question 55

You can press the ____ key to open or close the Navigation Pane.

A)F3
B)F4
C)F11
D)F12

Question 56

Each object you place on a form is called a(n)____.

A)index
B)icon
C)label
D)control

Question 57

Double-clicking the item marked 1 in the accompanying figure restores the ____.

A)Ribbon
B)status bar
C)Mini toolbar
D)Quick Launch toolbar

Question 58

The Row Source property is usually set to any of the following EXCEPT a(n)____.

A)table name
B)SQL statement
C)query name
D)XML statement

Question 59

A Multiple Items form cannot be displayed in ____ view.

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

Question 60

The item marked 3 in the accompanying figure includes the ____ documentation.

A)relationship
B)field
C)table
D)record

Question 61

____ are available for each control in the Controls group.

A)Design hints
B)Help labels
C)ScreenTips
D)Support tables

Question 62

The ____ consists of the area with dotted and solid lines that helps you position controls precisely on a form.

A)background
B)graph
C)grid
D)screen

Question 63

An unbound control that displays text is called a(n)____.

A)index
B)label
C)roster
D)listing

Question 64

With a split form when the datasheet is active the options in the group marked ____ in the accompanying figure do not apply except for the Add Existing Fields button which applies to both the form and the datasheet.

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

Question 65

With a split form when the datasheet is active the selected option in the group marked ____ in the accompanying figure applies to every field value in the active column which must be a Currency Date or Number field.

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

Question 66

Which of the following serve as guides for positioning controls in a form?

A)Rulers
B)Detail sections
C)Control Wizards
D)Object frames

Question 67

You use a(n)____ control to display text.

A)bound
B)unbound
C)graphical
D)freeform

Question 68

With a split form when the form is active the selected choice in the group marked ____ in the accompanying figure applies only to the form.

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

Question 69

With a split form when the form is active the selected option in the group marked ____ in the accompanying figure applies to every label and text box in the form.

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

Question 70

With a split form when the datasheet is active the options in the group marked ____ in the accompanying figure are unavailable.

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

Question 71

With a split form when the form is active the selected option in the group marked ____ in the accompanying figure applies to the selected labels and text boxes.

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

Question 72

____ at the top and left edge of the Detail section define the horizontal and vertical dimensions of the form and serve as guides for placing controls on a form.

A)Bars
B)Toolbars
C)Menus
D)Rulers

Question 73

To select several controls in a form press and hold down the ____ key while clicking each control.

A)Esc
B)Alt
C)Shift
D)Ctrl

Question 74

With a split form when the form is active the selected option in the group marked ____ in the accompanying figure applies to the selected text box which must be a Currency Date or Number field.

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

Question 75

The ____ layout arranges text box controls in a datasheet format with labels above each column.

A)tabular
B)datasheet
C)stacked
D)lateral

Question 76

Design view for a form contains a ____ section which is a rectangular area consisting of a grid with a section bar above the grid.

A)Record
B)Field
C)Contents
D)Detail

Question 77

The ____ layout for a form arranges text box controls vertically with a label to the left of each control.

A)tabular
B)datasheet
C)stacked
D)lateral

Question 78

A(n)____ control is not linked to a field in the underlying table or query.

A)unbound
B)bound
C)freeform
D)object

Question 79

With a split form when the datasheet is active the selected option in the group marked ____ in the accompanying figure applies to every field value in the datasheet.

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

Question 80

A(n)____ control is linked to a field in the underlying table or query.

A)unbound
B)bound
C)label
D)object