Access Three – Flashcards

The default query type for Access is the Crosstab query.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Which comparison operator matches a pattern that includes wildcards?

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

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?

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

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

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?

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?

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

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

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

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

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

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

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.

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

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

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

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

The default name for a new Access query is ____________________.

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

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

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