20 Points. Due May 10. Late deadline May 17.
In this assignment, you will create queries for a database. If you do not have the Access program, you should use the campus computer labs to complete the assignment.
Querying the Second Hand Goods Database
Do Cases and Places 1: Querying the Second Hand Goods Database.
Open the HW9 database you created in the last assignment. If your assignment had big errors in it, you may need to make corrections before you can complete this assignment. Read my grading comments before starting..
Create each query "a" through "e". Save each Query with an identifying name such as Querya, Queryb, etc. Your database file should contain 5 saved queries. Each query is worth 4 points.
The assignment instructions are reproduced below:
a. Find the number and description of all items that contain the word "Table."
b. Find the item number, description, and condition of the item that has the earliest posting date.
c. Find the total price of each item available for sale. Show the item description and total price.
d. Find the seller of each item. Show the seller's first name and last name as well as the item description, price, quantity, and date posted. Sort the results by item description within seller last name.
e. Create a parameter query that will allow the user to enter an item description when the query is run. The user should see all fields in the query result.
Email the database file with the saved queries to me as HW10.