Deck 5: Creating Forms and Reports

Question 1

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

Answer 1

False

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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 19

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

Question 20

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

Question 21

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

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

Question 22

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

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

Question 23

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 24

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 25

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 26

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 27

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 28

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

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

Question 29

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 30

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 31

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

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

Question 32

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 33

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 34

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 35

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

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

Question 36

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 37

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 38

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

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

Question 39

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

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

Question 40

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 41

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 42

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

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

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

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 48

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

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 51

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

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

Question 52

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

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

Question 53

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

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 57

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 58

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

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 61

Case-Based Critical Thinking Questions Case 4-2
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 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 62

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

Question 63

Case-Based Critical Thinking Questions Case 4-1
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 64

Case-Based Critical Thinking Questions Case 4-1
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.

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 65

Case-Based Critical Thinking Questions Case 4-2
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 66

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

Question 67

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

Question 68

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

Question 69

Case-Based Critical Thinking Questions Case 4-2
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.

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 70

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

Question 71

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

Question 72

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 73

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

Question 74

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

Question 75

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 76

Case-Based Critical Thinking Questions Case 4-1
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.

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 77

Case-Based Critical Thinking Questions Case 4-1
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 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 78

Case-Based Critical Thinking Questions Case 4-2
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.

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

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

Question 79

Case-Based Critical Thinking Questions Case 4-2
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 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

Case-Based Critical Thinking Questions Case 4-1
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.

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