Exam 4: Maintaining and Querying a Database

Case-Based Critical Thinking Questions Case 3-1 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?

Arithmetic operations are performed on selected records in a database using Statistical functions. ____________________

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

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

In the accompanying figure, a criterion is set for a field in the Visit table. ____________________

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

In the accompanying figure, the arrow outlined to the right of the field name "First Name"  gives the user access to the ____ feature when clicked.

Which method of adding all of the fields from a table to the design grid is best when record selection criteria will be used in the query?  How are the fields ordered in the design grid using this method?

Case-Based Critical Thinking Questions Case 3-2 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?

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

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

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

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

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

The query type that gives Access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

A sort field is unique if more than one record can have the same value for the sort field. __________________

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

Based on the criterion for the BirthDate field in the image above, the query will return all patients with a birth date ____.

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

The contents of query datasheet are permanent . ____________________