question

A mathematical operator for division

answer

/

question

Either individual criterion must be true in order for the compound criterion to be true.

answer

OR criterion

question

Use to select values in a list

answer

IN

question

Represents any individual character.

answer

?

question

A comparison operator.

answer

NOT

question

Row that displays in the design grid when aggregate functions are used.

answer

Total

question

Use to select values in a given range.

answer

Between

question

Each individual criterion must be true in order for the compound criterion to be true.

answer

AND criterion

question

Represents any collection of characters

answer

*

question

An aggregate function

answer

VAR

question

In the accompanying figure, the Client table was added to the query by selecting the table and clicking the Add button in the ____ dialog box.

answer

Show Table

question

In the accompanying figure, the lower pane in the window where you enter criteria is called the _____.

answer

Design Grid

question

In the accompanying figure, you can delete the table by right-clicking the field list and clicking ____ on the shortcut menu.

answer

Remove Table

question

In the accompanying figure, you can enter BC76 in the ____ row of the Client Number field to find all clients whose client number is BC76

answer

Criteria

question

In the accompanying figure, you can remove a column by clicking just above the field name to select the column and then clicking the _____key(s).

answer

Delete

question

In the accompanying figure, the criterion from Current Due is 0. The query results for this query will display ____ in the Current Due field.

answer

$0.00

question

In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is $2,000.00, erase the 0 in the Current Due column and enter ___ in the Criteria row of the Amount Paid column.

answer

2000

question

In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is greater than $1,000.00, erase the 0 and enter ____ in the Criteria row of the Current Due column.

answer

>1000

question

In the accompanying figure, Amount Paid is the ____key.

answer

Secondary Sort Minor

question

In the accompanying figure, Business Analyst Number is the ____ key.

answer

Major Primary Sort

question

The special criteria that can be used in queries are ____.

answer

In Between And

question

A(n) ______ join is the default join in Access.

answer

inner

question

For group calculations, Microsoft Access supports ____ build-in statistics.

answer

MAX STDEV VAR

question

Less than (), and NOT (not equal to) are examples of _____.

answer

Comparison Operators.

question

The arithmetic symbols for use in query calculations are ____.

answer

Asterisk (*) Slash (/)

question

The ___ operator allows you to search for a range of values in one field.

answer

Between

question

To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

answer

Where

question

To change the caption for a field in a query, click the field in the design grid, click the ___ button on the Design tab, click the Caption box, and enter the new caption.

answer

Caption

question

To change the design of a query, right-click the query and then click ____ on the shortcut menu.

answer

Design View

question

To create a crosstab, click the ___button on the Create tab.

answer

Query Wizard

question

To create a new query in Design view, click create on the Ribbon to display the Create tab and then click the ____ button to create a new query.

answer

Query Design

question

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

answer

Square Brackets

question

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

answer

Zoom

question

To display the Join Properties dialog box, right-click the join line and click ____ on the shortcut menu.

answer

Join Prperties

question

To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the Ribbon, and then click the Excel button.

answer

External Data

question

To find all clients whose names begin with Gr, enter ____ in the Criteria row of the Client Name field

answer

Gr*

question

To find all individuals whose name is Francis or Frances, enter ____ in the Criteria row of the appropriate column.

answer

Franc?s

question

To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column

answer

MAX

question

To include calculated fields in queries, enter a name for the calculated field, a (n) ____, and then the expression in one of the columns in the Field row.

answer

Colon (:)

question

To include the Total row in the design grid, click the ___ button on the Design tab.

answer

Totals

question

To indicate grouping in Access, select ___ as the entry in the Total row for the field to be used for grouping.

answer

Group By

question

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

answer

Yes

question

Presents information about the database object, the progress of current tasks, and the statues of certain commands and keys.

answer

Status Bar

question

Field can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

answer

Memo

question

View that shows a report on the screen and does not allow changes to the report.

answer

Report view

question

Field can store a unique sequential number that Access assigns to the record

answer

AutoNumber

question

A commonly accepted shorthand representation for showing the structure of a relational database.

answer

DBDL

question

Can include such information as the file's author, title, or subject.

answer

Metadata

question

View that shows a report as it will appear when printed.

answer

Print Preview

question

Field can contain only monetary data.

answer

Currency

question

View that shows a report on the screen and allows changes to the report.

answer

Layout View

question

Field can contain any characters and the total numbers of characters cannot exceed 255.

answer

Text

question

In the accompanying figure, the Business Analyst Table displays in ____.

answer

Design View

question

In the accompanying figure, the key symbol that appears in the row selector for the Business Analyst Number field indicates that Business Analyst Number is the ____ for the table.

answer

Primary Key.

question

In the accompanying figure, the small box or bar to left of each field is called the.

answer

Row Selector

question

A field with a Yes/No data type can store only one of two values. The choices are ____.

answer

Yes/No True/False On/Off

question

File names cannot contain a(n) ______.

answer

Colon (:) Question Mark (?)

question

Table names cannot contain_____.

answer

Accent graves (') periods (.) square brackets []

question

The Access window consists of a variety of components. These include the ____.

answer

Quick Access Toolbar Ribbon Navigation Pane

question

You can create a table in ______.

answer

Design View Datasheet View

question

A field whose data type is ______ can contain any characters.

answer

Text

question

A field whose data type is ______ can store an OLE object, which is an object linked to or embedded in the table.

answer

OLE Object

question

A field with the _____data type can contain an attached file, such as an image, document, chart, or spreadsheet.

answer

Attachement

question

A field with the _____data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

answer

AutoNumber

question

A(n) ______ contains information about a given person, product, or event.

answer

Record

question

A(n) _____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

answer

Memo

Computer Quiz Number 4 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards