Deck 4: Creating Forms and Reports

Question 1

The Report Wizard allows detail records to be sorted by up to four fields.____________________

Answer 1

True

Question 2

The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon.____________________

Answer 2

False - Font

Question 3

Data in a form may only be modified in ____ view.

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

Answer 3

A

Question 4

A form's object name appears on the tab for the form in the Access window.____________________

Question 5

Query elements may be added to a form to improve its appearance or add visual appeal.___________________

Question 6

When using a wildcard character in the Find and Replace dialog box,it is necessary to select the Any Part of Field Match option.____________________

Question 7

The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field.
____________________

Question 8

The Tabular and Justified form report layouts display the fields from multiple records at one time.____________________

Question 9

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table.
____________________

Question 10

A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.____________________

Question 11

Layout view shows both the form and its data while allowing the form to be modified.____________________

Question 12

When a form is created based on two or more tables,a relationship must be defined between queries.____________________

Question 13

Access allows all pages,a range of pages,or a currently selected record to be printed from Form view.____________________

Question 14

Design changes cannot be made to a form in Form view.____________________

Question 15

Report fields and field value boxes may be repositioned while viewing the report in Layout view.____________________

Question 16

The Form Wizard limits fields to be used in a form to one table or one query.____________________

Question 17

The Columnar form layout displays the fields from one record at a time.____________________

Question 18

A form created from more than one table uses the primary table for the main form.____________________

Question 19

The most detailed view of a form's structure is available the Layout view.____________________

Question 20

Field values edited in Form view are also changed in the form's underlying table.____________________

Question 21

Data in Date/Time fields are automatically ____-aligned.

A)left
B)right
C)center
D)top

Question 22

Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting.

A)report
B)field
C)conditional
D)criteria

Question 23

To design a form using the Form Wizard,begin by clicking on the ____ tab on the Access Ribbon.

A)HOME
B)CREATE
C)FILE
D)EDIT

Question 24

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

A)Changing page orientation
B)Changing the report name
C)Adding conditional formatting
D)Changing font colors

Question 25

One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."

A)condition type
B)rule type
C)field format
D)field value

Question 26

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern.

A)control
B)design box
C)replace character
D)wildcard character

Question 27

Before applying a conditional format in a report,the ____ box must be selected.

A)field label
B)caption
C)field value
D)design

Question 28

A form created from two tables that have a ____ relationship creates a main form and a subform.

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

Question 29

After a conditional formatting rule is created using the ____ dialog box,the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box.

A)New Formatting Rule
B)Conditional Formatting Manager
C)Report Rules Manager
D)Field Conditions Formatting

Question 30

The less precise way to move objects in report Layout view is to ____.

A)use the Move command to move objects
B)use the arrow keys on the keyboard to move objects
C)drag objects
D)use the insert key on the keyboard to move objects

Question 31

To select both a field label and field value to move in a report design,after selecting the field label press the ____ key to select the field value box.

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

Question 32

A report formatted where the page is taller than it is wide is formatted in ____.

A)landscape orientation
B)primary datasheet orientation
C)portrait orientation
D)Wizard orientation

Question 33

Which of the following may be used as a wildcard character when searching for a value in Access?

A)%
B)#
C)^
D)&

Question 34

Options for modifying the format of report objects are found on the ____ tab in Layout view when the contextual REPORT LAYOUT TOOLS tab is available.

A)FORMAT
B)MODIFY
C)DESIGN
D)PAGE SETUP

Question 35

In addition to standard colors,the font color gallery displays ____ colors.

A)Pantone
B)graphic
C)theme
D)print

Question 36

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

A)resize the object
B)delete the object and recreate it
C)move the object to another location
D)change the caption

Question 37

Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?

A)table
B)form
C)query
D)subdatasheet

Question 38

An item on a form or report object that can be manipulated to modify an object's appearance is a(n)____.

A)element
B)property
C)control
D)layout

Question 39

The appearance of fields in a report that is created using the Report Wizard is determined by ____.

A)the order of the fields in the table being used for the report
B)the data type of each field in the table
C)the size of each field in the table
D)the order the fields are selected in the Report Wizard

Question 40

Viewing and printing options for forms and records are available on the ____ tab.

A)HOME
B)PRINT PREVIEW
C)DESIGN
D)FILE

Question 41

Alignment of text in a field value may be changed using the ____________________ tab in the REPORT LAYOUT TOOLS contextual tabs when designing a report.

Question 42

Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?

A)?
B)*
C)-
D)#

Question 43

A report formatted in _____________________ is wider than it is tall.

Question 44

Data in a form created from the primary table is contained in the ____.

A)subform
B)subdatasheet
C)main datasheet
D)main form

Question 45

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

A)primary record
B)detail record
C)secondary table
D)record values

Question 46

The default theme for a new form that is created is the ____________________ theme.

Question 47

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

A)#
B)+
C)?
D)*

Question 48

The default theme for a form as well as additional themes may be found in the ____________________ when viewing a form in Layout view.

Question 49

To resize an image without changing its proportions,simply drag  ____ of the image.

A)the left side
B)the top
C)any corner
D)the bottom

Question 50

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

A)single table
B)datasheet layout
C)single record
D)subform layout

Question 51

A report layout may be changed using options on the ____________________ tab.

Question 52

To print two records from a form,select the ____ option in the Print dialog box.

A)Selected Page(s)
B)Current Page
C)Range
D)Selected Record(s)

Question 53

The ____ is located to the right of the navigation buttons and is used to locate a specific record in a form.

A)Record number
B)Search box
C)Find box
D)Locate box

Question 54

Print All,Pages,and Selected Record(s)are options available from the ____ for printing forms.

A)PRINT PREVIEW tab
B)Print dialog box
C)PRINT LAYOUT tab
D)Print layout options dialog box

Question 55

Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.

Question 56

A placeholder used in a value search when only part of a value is known is called a ____________________ character.

Question 57

A form must be displayed in ____________________ view to navigate,view,and edit data.

Question 58

When using the Report Wizard,the report title entered in the Wizard is also the name of the report ____________________.

Question 59

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n)____________________.

Question 60

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

Question 61

Insert the letter of the choice that best matches the phrase or definition.
a.?
b.Themes
c.Design view
d.control layout
e.Report Wizard
f.Pencil symbol
g.Find
h.Layout view
i.shading
j.#
k.​!
The wildcard character that will match any single numeric character.

Question 62

Briefly explain options available for applying a theme to a form or report and other database objects.

Question 63

Insert the letter of the choice that best matches the phrase or definition.
a.?
b.Themes
c.Design view
d.control layout
e.Report Wizard
f.Pencil symbol
g.Find
h.Layout view
i.shading
j.#
k.​!
The button used to change the theme of a form from the default theme to another theme in Layout view.

Question 64

Insert the letter of the choice that best matches the phrase or definition.
a.?
b.Themes
c.Design view
d.control layout
e.Report Wizard
f.Pencil symbol
g.Find
h.Layout view
i.shading
j.#
k.​!
The Access feature that asks a series of questions and creates a report based on the answers to those questions.

Question 65

Insert the letter of the choice that best matches the phrase or definition.
a.?
b.Themes
c.Design view
d.control layout
e.Report Wizard
f.Pencil symbol
g.Find
h.Layout view
i.shading
j.#
k.​!
​The wildcard character that will match any character not within brackets.

Question 66

Insert the letter of the choice that best matches the phrase or definition.
a.?
b.Themes
c.Design view
d.control layout
e.Report Wizard
f.Pencil symbol
g.Find
h.Layout view
i.shading
j.#
k.​!
Indicates editing mode.

Question 67

Insert the letter of the choice that best matches the phrase or definition.
a.?
b.Themes
c.Design view
d.control layout
e.Report Wizard
f.Pencil symbol
g.Find
h.Layout view
i.shading
j.#
k.​!
The feature used to distinguish one record from another in a form.

Question 68

Insert the letter of the choice that best matches the phrase or definition.
a.?
b.Themes
c.Design view
d.control layout
e.Report Wizard
f.Pencil symbol
g.Find
h.Layout view
i.shading
j.#
k.​!
The button used to display the Find and Replace dialog box.

Question 69

To generate a report with exact results based on specific criteria it is best to base the report on a(n)____________________ created in the database.

Question 70

Insert the letter of the choice that best matches the phrase or definition.
a.?
b.Themes
c.Design view
d.control layout
e.Report Wizard
f.Pencil symbol
g.Find
h.Layout view
i.shading
j.#
k.​!
The view that gives the most detailed view of the structure of a form or report.

Question 71

Insert the letter of the choice that best matches the phrase or definition.
a.?
b.Themes
c.Design view
d.control layout
e.Report Wizard
f.Pencil symbol
g.Find
h.Layout view
i.shading
j.#
k.​!
The wildcard character used to match any single alphabetic character.

Question 72

The first,last,next,or previous page in a report may be displayed using the ____________________ buttons.

Question 73

Insert the letter of the choice that best matches the phrase or definition.
a.?
b.Themes
c.Design view
d.control layout
e.Report Wizard
f.Pencil symbol
g.Find
h.Layout view
i.shading
j.#
k.​!
The easiest way to move a picture on a form is to first remove the picture from the ____.

Question 74

Insert the letter of the choice that best matches the phrase or definition.
a.?
b.Themes
c.Design view
d.control layout
e.Report Wizard
f.Pencil symbol
g.Find
h.Layout view
i.shading
j.#
k.​!
A report must be in Design view or this view to apply conditional formatting.

Question 75

Discuss three considerations that are important to form design for the form to convey written information clearly and effectively.