Relational Database at Sylvester's Bike Shop
HI, THE PAPER HAS BEEN REVISED. PLEASE SEE EMAIL FOR DETAILS.
HI EVERYONE, the client asked to prepare his order in MS Access, but NOT MS Word. That’s why I can’t upload the paper via BMN system. I will send this doc via email shortly.
Use the following tables answer the following: Be Careful tables are different from previous assignment.
The chart must be used with ACESS.
• Prepare a report that identifies the five most expensive bicycles (Selling Cost). The report should list the bicycles in descending order from most expensive to least expensive (Selling Cost).
What is the quantity on hand for each? What is the profit margin for each? ( 30 Points )
• Prepare a report that lists each supplier, its products, quantity on hand, and associated reorder levels. The report should be sorted alphabetically by supplier.
Within each supplier category, the products should be sorted alphabetically. ( 20 Points )
• Prepare a report listing only the bicycles that are low in stock showing Product Name, Product Category, Company Name, Purchase Cost and Quantity on Hand and Reorder level.
Sorted by Purchase Cost ( 30 Points )
• Prepare a report showing the cheapest bike bought from each supplier, listing Company Name, Product Category, Product Name, Purchase Cost, and Selling Cost. Sorted by Company Name ( 20 Points )
will include a sample chart if needed.