Exam 3: Access Module Maintaining and Querying a Database

Queries based on more than one table, must have a ____ field.

A calculated field created in a query generates results when ____.

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

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

Expression Builder is found in the Query Setup group on the DESIGN tab.

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

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

The default name for a new Access query is ____________________.

The default group in the Navigation Pane is ____.

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

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

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

The ___________________ command allows hidden fields to be redisplayed.

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

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

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

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

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

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 ?

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