Answered step by step
Verified Expert Solution
Question
1 Approved Answer
for Q 3 - Bicycles Low in Stock a Query object named as Bicycles Low in Stock in which contains 8 fields ( Product Name,
for QBicycles Low in Stock
a Query object named as Bicycles Low in Stock in which contains fields Product Name, Product Number, Supplier Number, Company Name, Street Address, City, State, and Zip Code and 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 QQ should be included in your Business Software Assignment ACCESS file. Your answer for Qhow database can be enhancedcan be posted on the Note of this Assignment in Moodle.
please explain in detail how to solve this. Include the formula needed to show the records of bicylces low in stock. Thank you!
for QFive Most Expensive Bicycles
a Query object named as Five Most Expensive Bicycles in which contains fields Product Number, Product Name, Selling Price, Quantity on Hand, and Profit Margin and records of most expensive bicycles.
a Report object named as Five Most Expensive Bicycles which is generated from the above query.
for Q Suppliers and Products
a Query object named as Suppliers and Products in which contains fields Company Name, Product Number, Product Name, Quantity on Hand, and Record Level and 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 QBicycles Low in Stock
a Query object named as Bicycles Low in Stock in which contains fields Product Name, Product Number, Supplier Number, Company Name, Street Address, City, State, and Zip Code and 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 QQ should be included in your Business Software Assignment ACCESS file. Your answer for Qhow database can be enhancedcan be posted on the Note of this Assignment in Moodle.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started