Microsoft Access Project

You will use database software to design a database for managing inventory for a small business. Sylvester's Bike Shop, located in San Francisco, California, sells road, mountain, hybrid, leisure, and children's bicycles. Currently, Sylvester's purchases bikes from five suppliers but plans to add new suppliers in the near future. Use the [login to view URL] file (attached) to perform the following activities. Create a query that identifies the five most expensive bicycles. The query should list the bicycles in descending order from most expensive to least expensive, the quantity on hand for each, and the markup percentage for each. Create a query that lists each supplier, its products, the quantities on hand, and associated reorder levels. The query should be sorted alphabetically by supplier. Within each supplier category, the products should be sorted alphabetically. Create a query that lists only the bicycles that are low in stock and need to be reordered. Using the query, produce a report that provides supplier information about the identified items. Write a description of how the database could be enhanced to improve the management of the business. What tables or fields should be added? What additional reports would be useful? Resource available to get you started: Review Access 2013 topics to become familiar with Microsoft Access 2013. Review Creating Calculated Fields and Total Rows to learn how to calculate the markup percentage on bicycles in Microsoft Access 2013. Review Designing a Multi-Table Query  and More Query Design Options to learn how to build Microsoft Access 2013 queries. Review Creating Reports to learn how to build Microsoft Access 2013 reports. Download the [login to view URL] file to get started. If you use an Apple computer, you will need to use OpenOffice. (See the attached file for information on OpenOffice) Deliverables Enhance the database file to address the requirements listed above. Write the description of how the database could be enhanced to improve the management of the business in the Text Submission Field. Attach the enhanced database file. ( For OpenOffice users, please be sure and save the file as a Microsoft Access file type. ) Submit.