Exam 3: Maintaining and Querying a Database

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

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

Identify the letter of the choice that best matches the phrase or definition. -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.

Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name,When to Plant,Amount of Sun,Annual,and Perennial.  He needs to answer the following questions using his database. Which plants need full sun? Which plants are Perennials? -When creating a query to determine which plants need full sun,which fields must be included in the query?

The first field specified in the sorting process is called the ____________________ field.

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

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

Identify the letter of the choice that best matches the phrase or definition. -The field used to determine the order of records in a datasheet.

Identify the letter of the choice that best matches the phrase or definition. -A type of query in which you specify the fields and records you want Access to select.

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

Identify the letter of the choice that best matches the phrase or definition. -A dialog box used to enter text,expressions,or other values.

Which aggregate function would be used to calculate the lowest field value for the selected records?

The ascending sort order for the Date/Time data type sorts dates from ____________________.

Jorge has created a database for the herb garden he is planting this spring.  Fields in the database include: Plant Name,When to Plant,Amount of Sun,Annual,and Perennial.  He needs to answer the following questions using his database. Which plants need full sun? Which plants are Perennials? -After creating the query,Jorge must set criteria to have the query return only those plants that need full sun.Entries for the Amount of Sun field include: partial sun,little sun,and full sun.How should Jorge enter the criteria for the exact match of full sun?

Date criteria are automatically enclosed in ____ when entered in a query design.

A set of restrictions placed on records in an open datasheet or form that temporarily isolates a subset of the records is called a ____________________.

A criterion,or rule,that determines which records are selected when a query is run is called a(n)____.

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

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

Which comparison operator matches a pattern that includes wildcards?