Deck 4: Creating Forms and Reports

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

Clicking the button moves all fields from the Available Fields box to the Selected Fields box using the Report Wizard.

Question 12

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

Question 13

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 14

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

Question 15

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

Question 16

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 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

In the accompanying figure, which numbered arrow indicates the button that moves the Form Wizard to the second dialog box where a form layout may be chosen.

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

Question 22

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 23

In the accompany figure, editing mode is indicated by which numbered arrow?

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

Question 24

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 25

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

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

Question 26

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

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

Question 27

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 28

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 29

In the accompanying figure, arrow number 1 identifies the button which indicates the form is displayed in ____ view.

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

Question 30

In the accompanying figure, which numbered arrow corresponds to the button which, when clicked, moves all Available Fields to the Selected Fields box?

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

Question 31

In the accompanying figure, the arrow number 2 indicates the form is displayed in the ____ view.

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

Question 32

In the accompanying figure, the fields indicated by the green brackets are fields to be included in the ____.

A) subform
B) main form
C) related table
D) primary table

Question 33

In the accompanying figure, which record number is the current record?

A) 51
B) 22539
C) 33
D) 06117

Question 34

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 35

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

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

Question 36

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 37

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

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

Question 38

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

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

Question 39

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 40

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 41

____ 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 42

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 43

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 44

In the accompanying figure, the icons and titles shown in bracket number 1 represent which Access database object?

A) Reports
B) Forms
C) Queries
D) Tables

Question 45

The REPORT LAYOUT TOOLS tabs are ____ tabs available only when working with report objects.

A) formatting
B) design
C) alignment
D) contextual

Question 46

In the accompanying figure, the icons and titles shown in bracket number 2 represent the ____ Access database object.

A) Form
B) Query
C) Report
D) Table

Question 47

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 48

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 49

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 50

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 51

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 52

In the accompanying figure, the ____ Access database object is indicated by the icons shown in bracket number 3.

A) Forms
B) Reports
C) Tables
D) Queries

Question 53

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

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

Question 54

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 55

In the accompanying figure, which Access database object is represented by the icons and titles shown in bracket number 4?

A) Tables
B) Queries
C) Reports
D) Forms

Question 56

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 57

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 58

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 59

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

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

Question 60

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 61

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 62

Before printing the report, Carmen uses ____ to view the page breaks and make sure that no records are split across pages.

A) Print Preview
B) Layout view
C) Design view
D) Print Data Only

Question 63

Which field is the common field for the two tables Sergio used to create the form?

A) LocationSite
B) AmountDue
C) ParticipantID
D) Other

Question 64

The Facet theme is currently the theme for the form Sergio has created. He wants to change the theme to the Slice theme and apply the Slice theme to all of the database objects. To apply the new theme, Sergio must be in the ____ or Design view.

A) Create
B) Arrange
C) Format
D) Layout

Question 65

The faculty sponsor has asked Carmen to email all participants with a balance greater than zero and remind those participants of the due date for payment. Carmen wants to generate a report with participant email addresses only for those participants with a balance greater than zero. Which method would be best for Carmen to use to generate the report?

A) create a form and base the report on the form
B) create a report with all participants and manually highlight those with a balance greater than zero
C) create a report with only the balance field included
D) create a query using a criterion for the balance then create a report based on the query

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

By default, data in the reports created by Carmen will be grouped by ____.

A) ParticipantID
B) LocationSite
C) table
D) subtable

Question 71

A button with the subform's name on it appears on the main form when the ____________________ option is chosen in the Form Wizard.

Question 72

Carmen and Sergio have created a database for the Spring Fling event at their college. Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event. The tables and fields for the database along with established relationships are illustrated in the figure below.

The first report Carmen would like to create will include all participants and the balance due to participate in the Spring Fling. Which two tables should Carmen use to create the report?

A) ParticipantAccount and RequestedResources
B) ParticipantAccount and Location
C) ParticipantInformation and ParticpantAccount
D) Location and RequestedResources

Question 73

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

Question 74

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

Question 75

Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling. The tables in the database and the fields for each table are illustrated in the figure below.

Sergio would like to create a form for Carmen to use to enter information about the participants. Which table should Sergio use to create the form?

A) ParticipantInformation
B) ParticipantAccount
C) RequestedResources
D) Location

Question 76

Sergio wants the form layout to display the fields for only one record at a time. Which form layout should Sergio select?

A) Tabular
B) Columnar
C) Aligned
D) Datasheet

Question 77

After reviewing the form Sergio decides he wants to create a form that will allow Carmen to enter both the participant information and the amount due by the participant. Sergio will need to use two tables to accomplish this. The second table will be the ___ in the form.

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

Question 78

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 79

The faculty sponsor has asked Carmen to create a report that includes the participant email address and the location site assigned to the participant. He would also like to know how many tables and chairs each participant needs. Which tables and fields does Carmen need to use to create the report?

A) ParticipantInformation:Email
ParticipantAccount:ParticipantID
RequestedResources:TableQuantity
RequestedResources:ChairQuantity
B) ParticipantInformation:Email
ParticipantAccount:LocationSite
RequestedResources:TableQuantity
RequestedResources:ChairQuantity
C) ParticipantInformation:ParticipantID
Location:LocationSite
RequestedResources:TableQuantity
RequestedResources:ChairQuantity
D) PatientAccount:LocationSite
Location:ParticipantID
RequestedResources:TableQuantity
RequestedResources:ChairQuantity

Question 80

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