MGMT4205 Ashford University Access Management & Information Systems Project This is an ACCESS assignment Achieving Operational Excellence: Building A relat

MGMT4205 Ashford University Access Management & Information Systems Project This is an ACCESS assignment Achieving Operational Excellence: Building A relational Datatabase for Inventory Management.1. Download the data file here. (See the attachment in .accdb format)2. Read and follow the instructions to complete this assignment. (See the attachment here in .pdf format)3. Turn in your completed assignment (ensue that it is in .accdb format) to this drop box in a timely manner. Expectation on your MGMT4205-Assignment #2 (ACCESS)
Dear students,
My expectation on your Business Software Assignment#2 are listed below:
for Q1-Five Most Expensive Bicycles
?
?
a Query object named as Five Most Expensive Bicycles in which contains 5 fields
(Product Number, Product Name, Selling Price, Quantity on Hand, and Profit Margin)
and 5 records of most expensive bicycles.
a Report object named as Five Most Expensive Bicycles which is generated from the
above query.
for Q2- Suppliers and Products
?
?
a Query object named as Suppliers and Products in which contains 5 fields (Company
Name, Product Number, Product Name, Quantity on Hand, and Record Level) and 24
records sorted alphabetically by Supplier name.
a Report object named as Suppliers and Products which is generated from the above
query and has to be sorted alphabetically by suppliers and within each supplier category,
the products should be sorted alphabetically.
for Q3-Bicycles Low in Stock
?
?
a Query object named as Bicycles Low in Stock in which contains 8 fields (Product Name,
Product Number, Supplier Number, Company Name, Street Address, City, State, and Zip
Code) and 7 records of bicycles low in stock.
a Report object named as Bicycles Low in Stock which is generated from the above query.
The above Objects of your answers for Q1-Q3 should be included in your Business Software
Assignment 2 ACCESS file. Your answer for Q4–how database can be enhanced–can be posted
on the Note of this Assignment in Moodle.

Purchase answer to see full
attachment