• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/150

Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

150 Cards in this Set

  • Front
  • Back
The ____ prefix tag in the All Access Objects pane identifies each table in the database.
a. tab c. tbl
b. table d. tbe
c. tbl
< and >= are examples of ____ operators.
a. logical c. match
b. comparison d. pattern
b. comparison
he ____ comparison operator selects records by matching field values to a specific pattern that includes one or
more of these wildcard characters: #, *, and ?.
a. And c. Or
b. As d. Like
d. Like
The ____ represents any string of characters.
a. & c. *
b. @ d. ?
c. *
The ____ represents any single character.
a. * c. #
b. ? d. @
b. ?
The ____ represents any single digit.
a. # c. @
b. * d. ?
a. #
Using a pattern match is similar to using an exact match, except that a pattern match includes ____ characters.
a. random c. absolute
b. literal d. wildcard
d. wildcard
In a list-of-values match, you use ____ to separate the values.
a. periods c. quotation marks
b. commas d. ampersands
b. commas
With a text list-of-values match, you enclose each value in ____.
a. brackets c. braces
b. quotation marks d. parentheses
b. quotation marks
The ____ comparison operator lets you define a condition with two or more values.
a. Like c. As
b. In d. Or
b. In
When you use the ____ comparison operator, if a record’s field value matches one value from the list of defined
values, then Access selects and includes that record in the query results.
a. As c. In
b. Like d. Or
c. In
A(n) ____ query performs aggregate function calculations on the values of one database field and displays the
results in a spreadsheet format.
a. aggregate c. crosstab
b. function d. both A and B
c. crosstab
Aggregate functions like those shown in the accompanying figure perform ____ operations on selected records
in a database.
a. composite c. join
b. comparative d. arithmetic
d. arithmetic
The aggregate function ____ returns the total of the field values in a selection of records.
a. Sum c. Total
b. Tot d. Aggr
a. Sum
You need to perform an aggregate function in a crosstab query. Your function needs to calculate the number of
the nonnull field values in your spreadsheet. You will use the ____ aggregate function?
a. Count c. Var
b. StDev d. Avg
a. Count
You can change a select query to a crosstab query in Design view using the Crosstab button in the Query Type
group on the ____ tab.
a. Crosstab c. Selection
b. Design d. Wizard
b. Design
If you convert an Access database to SQL-Server, your ____ queries will not work.
a. append c. crosstab
b. update d. select
c. crosstab
The ____ property for a query lets you limit the number of records in the query results.
a. Limit c. Top Values
b. Show Records d. Restrict
c. Top Values
As the last step in creating a Top Values query, you ____ the query.
a. evaluate c. automate
b. retask d. run
d. run
A ____ field lets the user select a value from a list of possible values.
a. roster c. lookup
b. datasheet d. manager
c. lookup
The ____ Mask Wizard is an Access tool that guides you in creating a predefined format for a field.
a. Format c. Input
b. Field d. Display
c. Input
To include literal display characters, you need to create a(n) ____ mask.
a. display c. viewing
b. field d. input
d. input
A(n) ____ mask is a predefined format used to enter and display data in a field.
a. entry c. input
b. display d. field
c. input
When you click the Input Mask box in the Field Properties pane, a ____ button appears to the right of the Input
Mask box.
a. Display c. Build
b. Create d. Show
c. Build
The input mask character ____ indicates that a digit or space can be entered.
a. ! c. 0
b. @ d. 9
d. 9
The input mask character ____ indicates that only a digit can be entered.
a. 0 c. !
b. 9 d. #
a. 0
The input mask character ____ determines whether to store in the database the literal display characters such as
the hyphen and parentheses.
a. -- c. ::
b. ++ d. ;;
d. ;;
If the value of ____ displays between the input mask characters ;; this indicates that literal display characters
should not be stored in the database.
a. 0 c. 2
b. 1 d. 5
b. 1
Which of the following input mask characters represents a digit or space that can be entered; however, entry is
not required?
a. 0 c. !
b. ;; d. 9
d. 9
____ between Access objects can occur in various ways.
a. Formats c. Masks
b. Alignments d. Dependencies
d. Dependencies
The Object Dependencies ____ displays a collapsible list of the dependencies among the objects in an Access
database.
a. window c. manager
b. pane d. explorer
b. pane
A(n) ____ exists between two objects when a change to the ____ of data in one object affects the ____ of data in
the other object.
a. object dependency, properties c. query dependency, description
b. object independency, properties d. query independency, description
a. object dependency, properties
In the Object Dependencies pane, the ____ option button allows you to view the objects that affect the selected
table.
a. Objects that I depend on c. Affected objects
b. Objects that depend on me d. Things that cause dependencies
a. Objects that I depend on
The ____ property value will be displayed in a dialog box if the user enters an invalid value.
a. Data-Entry c. Validation Rule
b. Validation Text d. Datasheet
b. Validation Text
Access detects ____ validation rule violations immediately after you finish your field entry and advance to
another field.
a. table c. field
b. record d. row
c. field
The Freeze Fields command is available in the ____ group on the Home tab, under the More button.
a. File c. Records
b. View d. Table
c. Records
Which of the following commands is used to keep selected columns visible no matter where you scroll in the
datasheet?
a. Keep Visible c. Display Columns
b. No Scroll d. Freeze Fields
d. Freeze Fields
The best way to view the contents of Memo fields that contain a large number of characters is to use the ____
dialog box in a datasheet.
a. Insert c. View
b. Zoom d. Column Width
b. Zoom
A ____ folder is a folder on a drive or network where you place databases you know are safe.
a. safe c. trusted
b. secure d. valued
c. trusted
Jane wants to use literal display characters to ensure hyphens appear in the phone numbers she enters into her
database. What’s the best way to go about doing this?
a. Jane can use the Literal Display Wizard.
b. Jane should create an input mask.
c. Jane can enter the literal display characters herself.
d. Jane cannot use literal display characters in a personal database.
b. Jane should create an input mask.
What input mask would Jane use if she wanted the phone numbers to display with the following criteria:
Area code not required in the phone number but, if entered, displayed in parentheses. The phone number digits
will display with a hyphen after the first three digits. Characters, when typed in, will fill in from left to right.
a. ![000] 999-9999::_ c. [000] 999-9999;;_
b. (999) 000-0000;;_ d. !(999) 000-0000;;_
d. !(999) 000-0000;;_
When looking for particular inventory in the database, Matt sometimes needs to create a query that allows him
to select records whose values for the designated field match one of two or more simple condition values.
Which comparison operator would serve him in this instance?
a. Not c. In
b. This d. Find
c. In
Matt’s computer is displaying a dialog box that prompts him to enter one or more criteria values when he runs
his query. He enters the prompts in the Criteria text box for zip code. What is he doing?
a. creating a parameter query c. running a modified design query
b. creating a criteria-strict query d. none of the above
a. creating a parameter query
Put the following steps for creating a parameter query in the correct order for Matt:
1. Decide which fields will use prompts when the query runs. In the Criteria box for each of these fields, type the
prompt you want to appear in a message box when you run the query.
2. Enclose the prompt in brackets.
3. Create a select query that includes all fields to appear in the query results.
4. Choose the sort fields and set the criteria that do not change when you run the query.
a. 4, 3, 2, 1 c. 1, 4, 3, 2
b. 3, 4, 1, 2 d. 1, 3, 2, 4
b. 3, 4, 1, 2
Which query is capable of performing aggregate function calculations on the value of a database field and then
displaying the results in a spreadsheet format?
a. crosstab c. parameter
b. find unmatched d. top values
a. crosstab
You explain to your friend that she can change the value of a field to a ____, which lets the user select from a list
of choices rather than having to remember the correct one.
a. different field name c. foreign field
b. lookup field d. primary key
b. lookup field
You explain to your friend that in Design view, she can scroll down to a given field, click the right side of the
____, and then click Lookup Wizard to begin to create a lookup field.
a. Data Type text box c. primary key field
b. memo box d. text area
a. Data Type text box
One guideline for working with forms is to design a form to match a ____ document closely if users will refer to
one while working with the form.
a. main c. source
b. control d. destination
c. source
One guideline for working with forms is to display ____ fields in a distinctive way, and prevent users from
changing and updating them.
a. bound c. calculated
b. unbound d. both a and b
c. calculated
One guideline for working with forms is to align field values with ____ for readability.
a. labels c. tabs
b. records d. all of the above
a. labels
Each object you place in a form is called a(n) ____.
a. index c. label
b. icon d. control
d. control
One guideline for working with forms is to use ____ values whenever possible to reduce user errors.
a. base c. consistent
b. default d. color-coded
b. default
A form ____ provides the same functionality as a lookup field in a clearer, more flexible way.
a. control box c. value box
b. combo box d. entry box
b. combo box
You can press the ____ key to open or close the Navigation Pane.
a. F3 c. F11
b. F4 d. F12
c. F11
The ____ Control property specifies the default control used to display a field.
a. Display c. Dynamic
b. Default d. Standard
a. Display
The Documenter is available in the Analyze group on the ____ tab.
a. Format c. File
b. Database Tools d. Window
b. Database Tools
“Names, Fields, and Properties” and “Names and Fields” are examples of ____ documentation options.
a. field c. index
b. table d. record
c. index
“Properties,” “Relationships,” and “Permissions by User and Group” are all examples of ____ documentation
options.
a. field c. index
b. table d. record
b. table
The item marked 2 in the accompanying figure includes the ____ documentation.
a. table c. field
b. relationship d. record
c. field
The item marked 3 in the accompanying figure includes the ____ documentation.
a. relationship c. table
b. field d. record
c. table
All of the following are included on the report in the accompanying figure EXCEPT ____ documentation.
a. table c. record
b. field d. relationship
d. relationship
When you use the ____ tool, the record source for the form must either be open or selected in the Navigation
Pane.
a. Layout c. Datasheet
b. Form d. Design
c. Datasheet
When working with forms, you view and update data in ____ view.
a. Datasheet c. Form
b. Layout d. Design
c. Form
A Multiple Items form cannot be displayed in ____ view.
a. Design c. Form
b. Datasheet d. Layout
b. Datasheet
When you use the Split Form tool, the ____ views are synchronized with each other at all times.
a. Form and Layout c. Form and Datasheet
b. Layout and Design d. Design and Datasheet
c. Form and Datasheet
To select several controls in a form, press and hold down the ____ key while clicking each control.
a. Esc c. Shift
b. Alt d. Ctrl
c. Shift
The ____ layout for a form arranges text box controls vertically with a label to the left of each control.
a. tabular c. stacked
b. datasheet d. lateral
c. stacked
If the Field List pane in the accompanying figure displays the “No fields available to be added to the current
view” message, click the ____ link to display the tables in the database.
a. Add fields c. Show all tables
b. Fields to be added to the view d. Show all database objects
c. Show all tables
The item marked 1 in the accompanying figure is the ____ bar.
a. section c. grid
b. ruler d. detail
a. section
The items marked 2 in the accompanying figure are the ____.
a. grid markers c. rulers
b. detail bars d. control bars
c. rulers
The item marked 6 in the accompanying figure is the ____.
a. roster c. grid
b. index d. layout
c. grid
A(n) ____ control is not linked to a field in the underlying table or query.
a. unbound c. freeform
b. bound d. object
a. unbound
You use a(n) ____ control to display text.
a. bound c. graphical
b. unbound d. freeform
b. unbound
An unbound control that displays text is called a(n) ____.
a. index c. roster
b. label d. listing
b. label
Which of the following is an unbound control?
a. label c. check box
b. toggle button d. all of the above
a. label
Design view for a form contains a ____ section, which is a rectangular area consisting of a grid with a section
bar above the grid.
a. Record c. Contents
b. Field d. Detail
d. Detail
____ are available for each control in the Controls group.
a. Design hints c. ScreenTips
b. Help labels d. Support tables
c. ScreenTips
Which of the following serve as guides for positioning controls in a form?
a. Rulers c. Control Wizards
b. Detail sections d. Object frames
a. Rulers
___ at the top and left edge of the Detail section define the horizontal and vertical dimensions of the form.
a. Bars c. Menus
b. Toolbars d. Rulers
d. Rulers
When you add a bound control to a form, Access adds a text box and, to its left, a(n) ____.
a. label c. key
b. icon d. grid
a. label
Sizing ____ let you resize a control.
a. handles c. controls
b. managers d. objects
a. handles
A selected control displays ____ sizing handles.
a. three c. seven
b. six d. eight
c. seven
For which of the following is a Control Wizard not available?
a. Combo Box c. List Box
b. Design Box d. Command Button
b. Design Box
After selecting a control, you can press the ____ key to open and close the property sheet for the control.
a. F1 c. F4
b. F2 d. Esc
c. F4
The ____ function determines the number of occurrences of an expression.
a. Number c. Sum
b. Count d. Occur
b. Count
You precede expressions with a(n) ____ to distinguish them from field names.
a. equal sign c. pound sign
b. ampersand d. caret
a. equal sign
If you need to set a property by typing a long text entry, you can open the ____ dialog box and type the entry in
the dialog box.
a. Text Entry c. Set Property
b. Data d. Zoom
d. Zoom
If the Tab Stop property for a text box is set to ____, users cannot tab to the control.
a. Bypass c. False
b. No d. Blank
b. No
The ____ property specifies the text that appears in a ScreenTip when users hold the mouse pointer over a
control on a form.
a. Alternative c. ControlTip Text
b. DisplayText d. Special Effect
c. ControlTip Text
____ refers to the control that is currently active and awaiting user action.
a. Resolution c. Display
b. Focus d. Currency
b. Focus
One example of ____ order in a form is top-bottom, left-right.
a. tab c. change
b. focus d. alter
a. tab
The order in which you change the focus in a form is called the ____ order.
a. focus c. alter
b. change d. tab
d. tab
To make small adjustments to the length of a line, select the line, hold down the ____ key, and then press an
arrow key.
a. Esc c. Shift
b. Alt d. Ctrl
c. Shift
When users mouse over a specific control on the August Inventory table form, you want a ScreenTip to appear.
What property should you choose to accomplish this?
a. ControlTip Text c. ScreenTip Text
b. Label d. Text
a. ControlTip Text
You want to change the order in which users move from control to control as they press the Tab key, which is
currently from left to right, to top to bottom. To do this, you will change the ____.
a. build event order c. tab order
b. focus order d. toggle order
c. tab order
Which of the following is NOT a guideline Catherine would follow in her work?
a. Provide users with a visual clue as to the length of text box values.
b. Use colors, fonts, and graphics readily to keep users visually stimulated.
c. Use a consistent style for all forms in a database.
d. Identify each field value with a label that names the field.
b. Use colors, fonts, and graphics readily to keep users visually stimulated.
Catherine’s first task is to modify the custom form for entering the Employee information. She wishes to add a
control that will allow the user to exit the form and return to the database to choose from different tables, forms,
queries, reports, or data access pages. On which section of the Employee form should the Exit button be placed?
a. Detail c. Form Header
b. Form Footer d. all of the above; it does not matter where
a. Detail
One of your students, Miguel, is looking to display a table field value on his new form. Which of the following
types of controls will you instruct him to use?
a. bound c. unbound
b. calculated d. section
a. bound
Your students want to know which type of control is added by moving the fields in the Field List pane to the
Form window. What do you tell them?
a. unbound controls c. calculated controls
b. bound controls d. section controls
b. bound controls
The ____ Header section appears once at the beginning of a report.
a. Report c. Page
b. Group d. Detail
a. Report
The ____ Header section is used for report titles, company logos, report introductions, and cover pages.
a. Page c. Report
b. Access d. Group
c. Report
If your report has a(n) ____ Header section, it precedes the first Page Header section.
a. Group c. Detail
b. Report d. Access
b. Report
The ____ Header section is used for column headings, page numbers, and report dates.
a. Page c. Report
b. Column d. Group
a. Page
Use the ____ section of a report to print calculated values.
a. Detail c. Group Footer
b. Report Footer d. Report Header
a. Detail
The ____ section is usually used to print totals for the group.
a. Group Header c. Page Footer
b. Group Footer d. Detail
b. Group Footer
If your report has a(n) ____ Footer section, it precedes the Page Footer section on the last page of the report.
a. Access c. Report
b. Group d. Detail
c. Report
A ____ is the formatted printout (or screen display) of the contents of one or more tables from a database.
a. datasheet c. query
b. report d. section
b. report
Which of the following offers you more flexibility in formatting and printing data with a professional, readable
appearance?
a. datasheets c. forms
b. queries d. reports
d. reports
You can view reports on screen in all of the following EXCEPT ____.
a. Design view c. Report view
b. Print Preview d. Datasheet view
d. Datasheet view
You can use Report view to apply a(n) ____ to the data in a report.
a. key c. filter
b. index d. gauge
c. filter
Use ____ when you want to filter report data before printing a report.
a. Report view c. Layout view
b. Print Preview d. Design view
a. Report view
Use ____ when you want to copy a selected portion of a report.
a. Report view c. Layout view
b. Print Preview d. Design view
a. Report view
Use ____ when you want to modify a report while seeing actual report data.
a. Report view c. Layout view
b. Print Preview d. Design view
c. Layout view
Use ____ when you want to add lines to a report.
a. Report view c. Layout view
b. Print Preview d. Design view
d. Design view
In ____, you can view the live version of a report prior to printing it and apply filters to it.
a. Design view c. Print Preview
b. Layout view d. Report view
d. Report view
A(n) ____ field is a report sort field that includes a Group Header section before a group of records that has the
same sort field value and that includes a Group Footer section after the group of records.
a. section c. grouping
b. aggregate d. consolidated
c. grouping
When you use an aggregate function in ____, Access adds the results of the function to the end of the report and
adds subtotals for each grouping field.
a. Report view c. Layout view
b. Design view d. Print Preview
c. Layout view
The view shown in the accompanying figure is ____.
a. Report view c. Design view
b. Layout view d. Print Preview
d. Print Preview
The accompanying figure shows the ____ Footer section with zero height.
a. Group c. Page
b. Report d. Detail
a. Group
Design view for forms and reports includes horizontal and vertical rulers, grids in each section, and similar
buttons in groups on the ____ tab.
a. Layout c. Format
b. Design d. Options
b. Design
A(n) ____ control displays field values for each record in the record source.
a. unbound c. object
b. bound d. master
b. bound
The item marked 1 in the accompanying figure is the ____ section.
a. Page Header c. Detail
b. Report Header d. Group Header
b. Report Header
The item marked 3 in the accompanying figure is the ____ section.
a. Detail c. Page Footer
b. Group Header d. Report Footer
b. Group Header
The item marked 4 in the accompanying figure is the ____ section.
a. Report Header c. Detail
b. Group Header d. Page Header
c. Detail
The item marked 6 in the accompanying figure is the ____ section.
a. Page Footer c. Report Footer
b. Group Footer d. Detail
a. Page Footer
The item marked 7 in the accompanying figure is the ____ section.
a. Report Footer c. Group Footer
b. Report Header d. Page Footer
a. Report Footer
To draw or extend a straight line, press the ____ key before dragging the line and release it after releasing the
mouse button.
a. Ctrl c. Shift
b. Alt d. Esc
c. Shift
A listing of total contracts by city would be an example of a ____ report.
a. summary c. grouping
b. detail d. chart
a. summary
Which of the following is a possible source of data for a report?
a. a single table c. multiple tables
b. a query based on one or more tables d. any of the above
d. any of the above
In the Reports group on the ____ tab, click the Blank Report button to open a blank report in Layout view.
a. New c. Create
b. Blank d. Open
c. Create
If you specify a sort field as a ____ field, you can include a Group Header section and a Group Footer section
for the group.
a. sorting c. grouping
b. clustering d. blank
c. grouping
Access lets you organize records in a report by sorting them using one or more ____ fields.
a. index c. ranking
b. sort d. order
b. sort
Each sort field can be designated as a ____ field.
a. ranking c. cluster
b. blank d. grouping
d. grouping
A(n) ____ header section appears by itself at the bottom of a page.
a. extra c. abandoned
b. neglected d. orphaned
d. orphaned
To prevent orphaned sections, you set the ____ property to keep the whole group together on one page.
a. If Room c. Print First
b. Keep Together d. Print Detail Record
b. Keep Together
You cannot use the To Fit command on the Size menu to resize ____.
a. labels added with the Label tool c. text boxes
b. controls added with the Label tool d. any of the above
c. text boxes
When set to Yes, the ____ property expands a text box vertically to fit the field value when the report is printed.
a. Expands c. Can Grow
b. Vertical Expansion d. Expand on Printing
c. Can Grow
You use the ____ property to hide a control on a report when the control’s value is the same as that of the
preceding record.
a. No Dupes c. Repeating
b. No Repeating d. Hide Duplicates
d. Hide Duplicates
For properties in the property sheet that offer a list of choices, you can ____ the property name to cycle through
the options in the list.
a. click c. hover over
b. right-click d. double-click
d. double-click
In a function, the ____ symbol/sign indicates that what follows it is an expression.
a. + c. -b. = d. *
b. =
In which of the following cases does the Date function display (instead of the actual current date)?
a. when you print the report c. when you view the report in Layout view
b. when you preview the report d. none of the above
d. none of the above
You can display page numbers in a report by including a(n) ____ in the Page Header or Page Footer section.
a. expression c. index
b. rule d. condition
a. expression
As you select fields from the Available fields list box or type text for a label, the ____ label box shows the
format for the label.
a. Demo c. Prototype
b. Advance d. Preview
c. Prototype
In the ____ section of the Page Setup dialog box, you specify the number of column sets and the row and
column spacing between the column sets.
a. Grid Settings c. Column Layout
b. Column Size d. Set Number
a. Grid Settings
First, you want to sort (but not group) your products by manufacturer name. Your task is to put in the correct
order the following steps for selecting a sort field that is not a grouping field in a report.
1. Click the Add a sort button in the Group, Sort, and Total pane.
2. Click the sort field in the list.
3. Click the More button on the sort field band to set additional properties for the sort field.
4. Display the report in Design or Layout view.
5. If necessary, click the Group & Sort button in the Grouping & Totals group on the Format tab in Layout view
or the Design tab in Design view.
a. 3, 2, 1, 4, 5 c. 2, 4, 1, 3, 5
b. 1, 2, 4, 5, 3 d. 4, 5, 1, 2, 3
d. 4, 5, 1, 2, 3
You have been sorting by product type. Now you would like to sort in ascending order by the date when the
product arrived in your inventory, so you know what merchandise has been around the longest. What button do
you click in the Group, Sort, and Total pane?
a. Sort by c. Add a sort
b. New sort d. New sort value
c. Add a sort
Where would be the best place(s) for Walter to put a control for the Date on his Recent Issues report?
a. Detail section c. Page Header section
b. Page Footer section d. both b and c
d. both b and c
The IssueCode field contains abbreviations that Walter needs to include in his report, and these abbreviations
need some brief explanations. Where would be the best place for Walter to put these explanations?
a. Detail section c. Page Footer section
b. Report Footer section d. Group Footer section
c. Page Footer section
What property should Craig click to make sure that the text box for the sum total of the accounts can be
expanded if the account total is larger than average?
a. Align c. Can Shrink
b. Can Grow d. Expand
b. Can Grow
If Craig wants to use the Line tool to add a double line above the account total, where would he find this tool?
a. in the Tools group on the Design tab c. in the Drawing group on the Tools tab
b. in the Controls group on the Design tab d. in the Design group on the Tools tab
b. in the Controls group on the Design tab