Exam 3: Maintaining and Querying a Database

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

-The accompanying figure illustrates the use of the ____________________ logical operator to define query criteria.

-The ___________________ command allows hidden fields to be redisplayed.

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

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

-When the sort field data for each record in a database is different, the sort field is ____.

The default group in the Navigation Pane is ____.

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

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

-The AutoFilter sort method works on a(n)____ field(s).

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

Mrs. Godwin's high school Environmental Science class has collected historical weather data for the months of January, February, and March for three cities. The data has been entered into a database. Mrs. Godwin has asked the students to answer the following questions using the Access database. What was the highest recorded wind speed? Which city had the highest temperature and what was the highest temperature? Figure Case 3-1-1 Figure Case 3-1-2 -To save the HighestTemp query, Mrs. Godwin's students had to perform which of the following tasks?

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

-The primary key of a table must be unique for each record; however, the ____ sort field does not have to be unique.

Mrs. Godwin's high school Environmental Science class has collected historical weather data for the months of January, February, and March for three cities. The data has been entered into a database. Mrs. Godwin has asked the students to answer the following questions using the Access database. What was the highest recorded wind speed? Which city had the highest temperature and what was the highest temperature? Figure Case 3-1-1 Figure Case 3-1-2 -Using the datasheet in Figure 3-1-1, which is the quickest method to help students determine the highest wind speed from the recorded data?

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

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

Access may base queries on one or more tables or queries. ____________________

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

Ja'nice launched an online jewelry business several months ago to sell her handmade jewelry. As her business expanded, Ja'nice developed product codes for her jewelry and a database to track orders, track supply orders, and maintain customer information. The tables and fields in her database are illustrated in the figure below. -Which of the following criteria will show Ja'nice all orders placed on or after July 1, 2015?