Intro to DB Access - Test 2

Created by ybriscoe77 

Upgrade to
remove ads

The ____ prefix tag in the All Access Objects pane identifies each table in the database.

tbl

< and >= are examples of ____ operators.

comparison

The ____ comparison operator selects records by matching field values to a specific pattern that includes one or more of these wildcard characters: #, *, and ?.

Like

The ____ represents any string of characters.

*

The ____ represents any single character.

?

The ____ represents any single digit.

#

Using a pattern match is similar to using an exact match, except that a pattern match includes ____ characters.

wildcard

In a list-of-values match, you use ____ to separate the values.

commas

With a text list-of-values match, you enclose each value in ____.

quotation marks

The ____ comparison operator lets you define a condition with two or more values.

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.

In

A(n) ____ query performs aggregate function calculations on the values of one database field and displays the results in a spreadsheet format.

crosstab

Aggregate functions like those shown in the accompanying figure perform ____ operations on selected records in a database.

arithmetic

The aggregate function ____ returns the total of the field values in a selection of records.

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?

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.

Design

If you convert an Access database to SQL-Server, your ____ queries will not work.

crosstab

The ____ property for a query lets you limit the number of records in the query results.

Top Values

As the last step in creating a Top Values query, you ____ the query.

run

A ____ field lets the user select a value from a list of possible values.

lookup

The ____ Mask Wizard is an Access tool that guides you in creating a predefined format for a field.

Input

To include literal display characters, you need to create a(n) ____ mask.

input

A(n) ____ mask is a predefined format used to enter and display data in a field.

input

When you click the Input Mask box in the Field Properties pane, a ____ button appears to the right of the Input Mask box.

build

The input mask character ____ indicates that a digit or space can be entered.

9

The input mask character ____ indicates that only a digit can be entered.

0

The input mask character ____ determines whether to store in the database the literal display characters such as the hyphen and parentheses.

;;

If the value of ____ displays between the input mask characters ;; this indicates that literal display characters should not be stored in the database.

1

Which of the following input mask characters represents a digit or space that can be entered; however, entry is not required?

9

____ between Access objects can occur in various ways.

Dependencies

The Object Dependencies ____ displays a collapsible list of the dependencies among the objects in an Access database.

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.

object dependency, properties

In the Object Dependencies pane, the ____ option button allows you to view the objects that affect the selected table.

Objects that I depend on

The ____ property value will be displayed in a dialog box if the user enters an invalid value

Validation Text

Access detects ____ validation rule violations immediately after you finish your field entry and advance to another field.

field

The Freeze Fields command is available in the ____ group on the Home tab, under the More button.

Records

Which of the following commands is used to keep selected columns visible no matter where you scroll in the datasheet?

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.

Zoom

A ____ folder is a folder on a drive or network where you place databases you know are safe.

trusted

Between work and personal contacts, June is finding her old, written address book is not big enough, and too difficult to maintain. She decides to create a database of her contacts as an electronic alternative to the pen and paper address book.

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?

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.

!(999) 000-0000;;_

In working with the Hardware Store chain's database, Matt is finding that only stores in particular zip codes have certain inventory. To sift through the large volumes of information in this database of many records, he simply wants to ask which store by zip code, and other specific criteria, has the item.

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?

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?

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.

3, 4, 1, 2

It is getting close to the end of the fiscal quarter for the Clothes Rack clothing store chain. Joanna is adding up the inventory of the four clothing stores of which she is the Regional Manager. She needs to see the summarized totals in the Outerwear category.

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?

crosstab

A friend is creating a database and wants to make extensive use of lists so that anyone who uses the database will have choices when entering data values, in order to minimize errors and to facilitate the entry of data. She suspects that you, as you are very familiar with Access, will know how to make this happen for her.

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.

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.

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.

source

One guideline for working with forms is to display ____ fields in a distinctive way, and prevent users from changing and updating them.

calculated

One guideline for working with forms is to align field values with ____ for readability.

labels

Each object you place in a form is called a(n) ____.

control

One guideline for working with forms is to use ____ values whenever possible to reduce user errors.

default

A form ____ provides the same functionality as a lookup field in a clearer, more flexible way.

combo box

You can press the ____ key to open or close the Navigation Pane.

F11

The ____ Control property specifies the default control used to display a field.

Display

The Documenter is available in the Analyze group on the ____ tab.

Database Tools

"Names, Fields, and Properties" and "Names and Fields" are examples of ____ documentation options.

index

"Properties," "Relationships," and "Permissions by User and Group" are all examples of ____ documentation options.

table

The item marked 2 in the accompanying figure includes the ____ documentation.

field

The item marked 3 in the accompanying figure includes the ____ documentation.

table

All of the following are included on the report in the accompanying figure EXCEPT ____ documentation.

relationship

When you use the ____ tool, the record source for the form must either be open or selected in the Navigation Pane.

Datasheet

When working with forms, you view and update data in ____ view.

Form

A Multiple Items form cannot be displayed in ____ view.

Datasheet

When you use the Split Form tool, the ____ views are synchronized with each other at all times.

Form and Datasheet

To select several controls in a form, press and hold down the ____ key while clicking each control.

Shift

The ____ layout for a form arranges text box controls vertically with a label to the left of each control.

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.

Show all tables

The item marked 1 in the accompanying figure is the ____ bar.

section

The items marked 2 in the accompanying figure are the ____.

rulers

The item marked 6 in the accompanying figure is the ____.

grid

A(n) ____ control is not linked to a field in the underlying table or query.

unbound

You use a(n) ____ control to display text.

unbound

An unbound control that displays text is called a(n) ____.

label

Which of the following is an unbound control?

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.

Detail

____ are available for each control in the Controls group.

ScreenTips

Which of the following serve as guides for positioning controls in a form?

Rulers

____ at the top and left edge of the Detail section define the horizontal and vertical dimensions of the form.

Rulers

When you add a bound control to a form, Access adds a text box and, to its left, a(n) ____.

label

Sizing ____ let you resize a control.

handles

A selected control displays ____ sizing handles.

seven

For which of the following is a Control Wizard not available?

Design Box

After selecting a control, you can press the ____ key to open and close the property sheet for the control.

F4

The ____ function determines the number of occurrences of an expression.

Count

You precede expressions with a(n) ____ to distinguish them from field names.

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.

Zoom

If the Tab Stop property for a text box is set to ____, users cannot tab to the control.

No

The ____ property specifies the text that appears in a ScreenTip when users hold the mouse pointer over a control on a form.

ControlTip Text

____ refers to the control that is currently active and awaiting user action.

Focus

One example of ____ order in a form is top-bottom, left-right.

tab

The order in which you change the focus in a form is called the ____ order.

tab

To make small adjustments to the length of a line, select the line, hold down the ____ key, and then press an arrow key.

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?

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

tab order

Which of the following is NOT a guideline Catherine would follow in her work?

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?

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?

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?

bound controls

The ____ Header section appears once at the beginning of a report.

Report

The ____ Header section is used for report titles, company logos, report introductions, and cover pages.

Report

If your report has a(n) ____ Header section, it precedes the first Page Header section.

Report

The ____ Header section is used for column headings, page numbers, and report dates.

Page

Use the ____ section of a report to print calculated values.

Detail

The ____ section is usually used to print totals for the group.

Group Footer

If your report has a(n) ____ Footer section, it precedes the Page Footer section on the last page of the report.

Report

A ____ is the formatted printout (or screen display) of the contents of one or more tables from a database.

report

Which of the following offers you more flexibility in formatting and printing data with a professional, readable appearance?

reports

You can view reports on screen in all of the following EXCEPT ____.

Datasheet view

You can use Report view to apply a(n) ____ to the data in a report.

filter

Use ____ when you want to filter report data before printing a report.

Report view

Use ____ when you want to copy a selected portion of a report.

Report view

Use ____ when you want to modify a report while seeing actual report data.

Layout view

Use ____ when you want to add lines to a report.

Design view

In ____, you can view the live version of a report prior to printing it and apply filters to it.

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.

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.

Layout view

The view shown in the accompanying figure is ____.

Print Preview

The accompanying figure shows the ____ Footer section with zero height.

Group

Design view for forms and reports includes horizontal and vertical rulers, grids in each section, and similar buttons in groups on the ____ tab.

Design

A(n) ____ control displays field values for each record in the record source.

bound

The item marked 1 in the accompanying figure is the ____ section.

Report Header

The item marked 3 in the accompanying figure is the ____ section.

Group Header

The item marked 4 in the accompanying figure is the ____ section.

Detail

The item marked 6 in the accompanying figure is the ____ section.

Page Footer

The item marked 7 in the accompanying figure is the ____ section.

Report Footer

To draw or extend a straight line, press the ____ key before dragging the line and release it after releasing the mouse button.

Shift

A listing of total contracts by city would be an example of a ____ report.

summary

Which of the following is a possible source of data for a report?

any of the above
a. a single table
c. multiple tables
b. a query based on one or more tables

In the Reports group on the ____ tab, click the Blank Report button to open a blank report in Layout view.

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

grouping

Access lets you organize records in a report by sorting them using one or more ____ fields.

sort

Each sort field can be designated as a ____ field.

grouping

A(n) ____ header section appears by itself at the bottom of a page.

orphaned

To prevent orphaned sections, you set the ____ property to keep the whole group together on one page.

Keep Together

You cannot use the To Fit command on the Size menu to resize ____.

text boxes

When set to Yes, the ____ property expands a text box vertically to fit the field value when the report is printed.

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.

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.

double-click

In a function, the ____ symbol/sign indicates that what follows it is an expression.

=

In which of the following cases does the Date function display (instead of the actual current date)?

none of the above
a. when you print the report
c. when you view the report in Layout view
b. when you preview the report

You can display page numbers in a report by including a(n) ____ in the Page Header or Page Footer section.

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.

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.

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.

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?

Add a sort

Walter works for a periodical publisher and needs to create a report on recent issues. The Recent Issues report needs to include IssueName, IssueMonth, IssueCode, IssueYear, and CoverImage. He feels the best way to do this is to design a custom report.

Where would be the best place(s) for Walter to put a control for the Date on his Recent Issues report?

both b and c
c. Page Header section
b. Page Footer section

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?

Page Footer section

Craig has been working all day to get his report for the Accounts database exactly the way he wants it. He has just finished positioning the control for the Date and Time in the Page Header 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?

Can Grow

See More

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set