Microsoft Office Tutorials and References
In Depth Information
Cases and Places continued
•• 4: Designing Queries to Help in Your Job Search
Make It Personal
Use the contacts database you created in Cases and Places 4 in Chapter 1 on page AC 71 for this
assignment, or see your instructor for information on accessing the ﬁ les required for this topic.
Consider your own personal job situation. What questions would you want to ask this database? Using
a word processing program, such as Microsoft Word, write the questions in your own words. Can
your database answer the questions that you listed? If it can, design the queries for Access. Run and
save each query. In your Word document, identify which questions were posed to Access and which
questions could not be answered. For questions that could not be answered, explain why your database
cannot answer the question. Submit the Word document and the revised database in the format
speciﬁ ed by your instructor.
•• 5: Creating Queries to Analyze Data
Obtain a copy of the weather page of your local newspaper. As a team, choose 30 cities of interest.
Create a database that contains one table and has ﬁ ve ﬁ elds (City, State or Province, High Temp, Low
Temp, Sky). Use the newspaper’s abbreviations for Sky; for example, c for cloudy, r for rain and so on.
Create queries that do the following:
a. Display the ﬁ ve cities with the highest high temperatures.
b. Calculate the difference between the high and low temperatures for each city.
c. Display the average high and low temperature for all cities.
d. List the states or provinces in your table. Each state or province should appear only once.
Write a one-page paper that explains what the team learned from querying the database and any
conclusions you can draw about the data — for example, describe the Sky conditions for the cities with
the least difference in high and low temperature. Submit the assignment in the format speciﬁ ed by