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 Report Wizard allows detail records to be sorted by up to four fields.____________________

Answer 2

  True

Question 3

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

Answer 3

  True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

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

Question 20

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

Question 21

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

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

Question 22

 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 23

 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 24

 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 25

 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 26

 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 27

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

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

Question 28

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

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

Question 29

 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 30

 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 31

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

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

 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 35

 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 36

 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 37

 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 38

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

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

Question 39

 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 40

 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 41

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

Question 42

 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 43

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

Question 44

 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 45

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

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

 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 48

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

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

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

 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 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

 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 58

 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 59

 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 60

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

Question 61

 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 62

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

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 Access feature that asks a series of questions and creates a report based on the answers to those questions.

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 wildcard character used to match any single alphabetic character.

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 feature used to distinguish one record from another in a form.

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

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

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 easiest way to move a picture on a form is to first remove the picture from the ____.

Question 69

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 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 button used to change the theme of a form from the default theme to another theme in Layout view.

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 that will match any single numeric character.

Question 72

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 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 view that gives the most detailed view of the structure of a form or report.

Question 74

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

Question 75

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.