Access Three

Which of the following criteria will show Ja'nice all orders placed on or after July 1, 2015?

>=#7/1/2015#

The criteria entered in the figure above are an example of which logical operator?

And

In the accompanying figure, which field is the primary sort field?

City

Which aggregate function supports the Yes/No field data type?

Count

The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

Ctrl + End

After choosing the two tables for the new query, Ja'nice must relate the two tables using a common field. What is the common field between the two tables?

Customer ID

Ja'nice would also like to create a query that shows her specific products (by Product ID) that were purchased by individual customers. To do this, she must use at last two tables to create the query. Which two tables would be best to use for this query?

Customer Info and Order Info

Now that Ja'nice has chosen the table to use for the query, for which field will she create criteria?

Date

Hiding a field in Datasheet view removes the field from the current table.

False

It is more efficient to use the Query Wizard for common, informational queries than to design your own query.

False

It is not possible to create a query from more than one table.

False

Results of a query are narrowed by using the Or logical operator.

False

The default query type for Access is the Crosstab query.

False

The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

Home

In the accompanying figure, which field represents a calculated field?

Late Fee

Which comparison operator matches a pattern that includes wildcards?

Like

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value. `

Navigation

Ja'nice wants to create a query that will show her all orders placed on or after July 1, 2015. Which table does Ja'nice need to use for this query?

Order Info

A calculated field is formatted using the ____ for the field.

Property Sheet

The default name for a new Access query is ____________________.

Query1

To locate a specific field value or part of a field value, a user may search a table datasheet, a query datasheet, or a form using the ____________________.

Sign Command

In the accompanying figure, the brackets indicate that a related record exists in a ____________________.

Subdatesheet

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

Temporary

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.

True

Fields included in a query may be modified after the query is saved.

True

Logical operators must be used in order to combine two or more conditions in a query.

True

To toggle between navigation mode and editing mode press the F2 keyboard shortcut.

True

When a question is asked of a database using a select query, the answer is returned as a datasheet.

True

A dialog box used to enter text, expressions, or other values.

Zoom box

This type of datasheet displays temporary contents based on the criteria established in the design grid.

query

Functions that perform arithmetic operations on selected records in a database.

aggregate functions

Statistical information such as totals and averages is calculated using ____.

aggregate functions

The + symbol is an example of a(n) ____ operator.

arithmetic

The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

comparison operator

A criterion or rule that determines which records are selected when a query is run.

condition

In the accompanying figure, the plus sign beside the record indicated by arrow number 2 indicates that this record ____.

does have a related record in another table

In the accompanying figure, how is the Match type specified to find the characters "1638"?

entire field value

A combination of database fields, constants, and operators that are used to perform a calculation is called a(n) ____.

expression

In the criterion, <=250, the operator will return values for the specified field that are ____.

less than or equal to 250

Operators that allow two or more conditions to be combined such as And.

logical operators

A query based on more than one table is a(n) ____query.

multitable

The comparison operator, < >, is used to insert a condition that means ____.

not equal to

The field used to determine the order of records in a datasheet.

sort field

The condition "Seattle" for the field City in a student database is an example of what type of value?

text value

A predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.

theme