To Lecture Notes
ISP 121 -- Activity 8
Filtering and Sorting
Submit an MS-Word file containing your answers.
Make sure that each group member submits a copy of Word document.
Include each group member's name in the file name and at the top
of the document.
- Download the access file
flights.accdb to your hard drive.
- Open the Flights table in Flights.mdb and use advanced filtering and
sorting to answer the following questions. For each question,
(1) type the answer to the question in your MS-Word document,
(2) copy and paste part or all of the result table into your document and
(3) show the components of your filter as an MS-Word table.
- What is the most expensive flight available? (Sort flights by Price
in descending order.) Copy only the first five rows of the
result table for (2).
- What is the cheapest flight that originates in Chicago?
- How many flights originate in New York and terminate in Miami?
- What are the departure and arrival times of flights that
leave from Dallas and arrive in Chicago?
- Show the Flights table sorted by origin, destination and day of week.
Why is it not very useful to sort flights by day of week?
- Show all of the Tuesday flights that originate at
Dallas and terminate at Los Angeles, sorted by departure time;
show the components of the filter that you used for this question.