4

10 September 2022
4.7 (114 reviews)
32 test answers

Unlock all answers in this set

Unlock answers (28)
question
Print All, Pages, and Selected Record(s) are options available from the ____ for printing forms.
answer
Print dialog box
question
The ____ is located to the right of the navigation buttons and is used to locate a specific record in a form.
answer
Search box
question
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
answer
Shift
question
Data in a form created from the primary table is contained in the ____.
answer
main form
question
To design a form using the Form Wizard, begin by clicking on the ____ tab on the Access Ribbon.
answer
CREATE
question
____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.
answer
Changing page orientation
question
Viewing and printing options for forms and records are available on the ____ tab.
answer
PRINT PREVIEW
question
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.
answer
New Formatting Rule
question
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.
answer
FORMAT
question
The less precise way to move objects in report Layout view is to ____.
answer
drag objects
question
A form created from two tables that have a ____ relationship creates a main form and a subform.
answer
one-to-many
question
A report formatted where the page is taller than it is wide is formatted in ____.
answer
portrait orientation
question
Data in Date/Time fields are automatically ____-aligned.
answer
right
question
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.
answer
Shift
question
Before applying a conditional format in a report, the ____ box must be selected.
answer
field value
question
Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting.
answer
conditional
question
The appearance of fields in a report that is created using the Report Wizard is determined by ____.
answer
the order the fields are selected in the Report Wizard
question
The REPORT LAYOUT TOOLS tabs are ____ tabs available only when working with report objects.
answer
contextual
question
An item on a form or report object that can be manipulated to modify an object's appearance is a(n) ____.
answer
control
question
It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.
answer
single record
question
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.
answer
detail record
question
Which of the following may be used as a wildcard character when searching for a value in Access?
answer
#
question
in the accompanying figure, arrow number 1 identifies the button which indicates the form is displayed in _ view
answer
form
question
data in a form may only be modified in _ view
answer
form
question
a _ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern
answer
wildcard character
question
in the accompanying figure, editing mode is indicated by which numbered arrow?
answer
1
question
in the accompanying figure, which record number is the current record?
answer
33
question
one _ available for specifying conditional formatting in a report is "check values in the current record or use an expression:
answer
rule type
question
which of the following methods should be used in report layout view to edit a field caption object that is not fully displayed?
answer
resize the object
question
which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order
answer
-
question
a wildcard character used as the first and/or the last character in a character string to match any number of characters is the _ charater
answer
*
question
A predefined style that you can apply to a form or report.
answer
auto format