FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Maintaining and Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

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

A) quotes
B) parenthesis
C) brackets
D) number signs

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

-The ___________________ command allows hidden fields to be redisplayed.

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

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

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

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

The default group in the Navigation Pane is ____.

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

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?

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?

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?

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

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

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

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

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

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

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

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

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