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

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

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

Question 5

Access allows all pages, a range of pages, or a currently selected record to be printed from 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

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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 23

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 24

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 25

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 26

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

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

Question 27

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

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

Question 28

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

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

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

Question 31

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 32

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

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

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

Question 34

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

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

Question 35

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 36

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 37

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 38

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 39

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 40

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 41

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 42

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

Question 43

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 44

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

Question 45

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

Question 46

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 47

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 48

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 49

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

Question 50

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 51

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

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

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

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

Question 54

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 55

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 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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 65

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

Question 71

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

Question 72

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 73

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