PLEASE ZOOM IN IF YOU CANNOT SEE. ANSWER THIS FAST PLEASE AND I WILL UPVOTE.
EL Product Table - Product Numt - Product Categc. Product Nam: Purchase Cop-Selling Pr Supplier Nume Quantity on Ha Reorder le Click to Add 1 Road Classic 109 $207,49 $290.49 2 Road Elegant 210 $281.52 $394.13 2 3 3 Road Runroad 1000 $250.95 $350.99 3 8 5 A 4 Min. Eagle 3 Sas0.52 $490.73 2 5 Z 5 Min. Eagle 2 $401.11 $561.54 2 2 2 6 GMtn. Eagle 1 $110.01 $574,01 2 1 2 7 7 Hybrid Runblend 2000 $180.95 $255.99 3 5 8 * Hybrid Eagle 2 $150.89 $211.16 2 2 9 9 Hybrid Tea for TWO $429,02 $609.00 3 2 10 10 Leisure Runcool 1000 $35.95 $135.99 5 5 11 11 Leisure Starlight $100.47 $140.66 4 1 2 12 12 Leisure Supreme 50 $50.00 570.00 5 13 13 Leisure Blue Moon $75.29 SIOS. 41 4 2 14 14 Children Runkidder 100 $50,95 575.99 10 5 15 15 Children Red Rider $15.00 $25.50 5 10 10. Children Coolest 100 560.99 $97.90 17 17 Children Green Rider $55.47 5133.66 5 18 18 Road Kunroad 9000 $19.95 $495.99 5 19 19 Road Runroad 5000 $450,95 $599.99 20 20 Road Twist & Shout $490 50 S615.70 21 21 Leisure Breeze $89.95 $11.95 Sanih - Product Table 1 Product Nurt Product Catege - Product Norr. Purchase Co. Selling Prk. Supplier Numi. Quantity on Reorderle Click to Add- 6 2 $410.01 6 Min. 1 $574.01 Eagle 1 0 7 7 Hybrid Funblend 2000 $180.95 $255.99 2 B Fagle 7 8 Hybrid 2 $150.89 $211.46 4 3 9 9 Hybrid $609.00 Tea for Two S429.02 3 3 Runcool 3000 10 5 $85.95 10 Leisure $135.99 2 11 1 11 Leisure $100.47 Starlight 4 $140.66 12 5 1 3 $50.00 $20.00 12 Leisure Supreme 350 13 2 4 $75.29 Blue Moon 13 Leisure $105.41 10 5 3 14 $50.95 $75.99 Runkidder 100 14 Children 4 15 Children 15 $15.00 Red Rider 525.50 3 16 16 Children Coolest 100 $69.99 $97. 17 1 17 Children $95.47 Green Rider $133.110 10 1 Road $19.95 Rubroad 4000 $495.99 19 19 Road Runroad 5000 $450.95 $999.99 20 Road $490.50 Twist & Shout 20 50350 21 21 Leisure Breeze S89.95 S130.50 22 Leisure 22 Breeze S109.95 $149.95 23 Mt. $375,00 Bluff Breaker 20 $495.00 24 24 Min SASS 5619.99 $0.00 50.00 Jetty Breaker Supplier Table ID No - Supplier Nu. Company Name Street Address City Stal - ZIP COC - Click to Add 1 Bicyclist's Choice 1459 Washington Avenue Sioux Falls SD 52106 2 Bike One 2000 Oceanside Lane San Diego CA 92110 3 3 Run-Up Bikes 1155 Fifth Avenue Long Branch NJ 07521 4 4 Simpson's Bike Supply 107 Piedmont Tulsa OK 74114 5 5 The Bike Path 1999 Stephen Hands Path East Hamptor NY 11937 (New) 0 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. EL Product Table - Product Numt - Product Categc. Product Nam: Purchase Cop-Selling Pr Supplier Nume Quantity on Ha Reorder le Click to Add 1 Road Classic 109 $207,49 $290.49 2 Road Elegant 210 $281.52 $394.13 2 3 3 Road Runroad 1000 $250.95 $350.99 3 8 5 A 4 Min. Eagle 3 Sas0.52 $490.73 2 5 Z 5 Min. Eagle 2 $401.11 $561.54 2 2 2 6 GMtn. Eagle 1 $110.01 $574,01 2 1 2 7 7 Hybrid Runblend 2000 $180.95 $255.99 3 5 8 * Hybrid Eagle 2 $150.89 $211.16 2 2 9 9 Hybrid Tea for TWO $429,02 $609.00 3 2 10 10 Leisure Runcool 1000 $35.95 $135.99 5 5 11 11 Leisure Starlight $100.47 $140.66 4 1 2 12 12 Leisure Supreme 50 $50.00 570.00 5 13 13 Leisure Blue Moon $75.29 SIOS. 41 4 2 14 14 Children Runkidder 100 $50,95 575.99 10 5 15 15 Children Red Rider $15.00 $25.50 5 10 10. Children Coolest 100 560.99 $97.90 17 17 Children Green Rider $55.47 5133.66 5 18 18 Road Kunroad 9000 $19.95 $495.99 5 19 19 Road Runroad 5000 $450,95 $599.99 20 20 Road Twist & Shout $490 50 S615.70 21 21 Leisure Breeze $89.95 $11.95 Sanih - Product Table 1 Product Nurt Product Catege - Product Norr. Purchase Co. Selling Prk. Supplier Numi. Quantity on Reorderle Click to Add- 6 2 $410.01 6 Min. 1 $574.01 Eagle 1 0 7 7 Hybrid Funblend 2000 $180.95 $255.99 2 B Fagle 7 8 Hybrid 2 $150.89 $211.46 4 3 9 9 Hybrid $609.00 Tea for Two S429.02 3 3 Runcool 3000 10 5 $85.95 10 Leisure $135.99 2 11 1 11 Leisure $100.47 Starlight 4 $140.66 12 5 1 3 $50.00 $20.00 12 Leisure Supreme 350 13 2 4 $75.29 Blue Moon 13 Leisure $105.41 10 5 3 14 $50.95 $75.99 Runkidder 100 14 Children 4 15 Children 15 $15.00 Red Rider 525.50 3 16 16 Children Coolest 100 $69.99 $97. 17 1 17 Children $95.47 Green Rider $133.110 10 1 Road $19.95 Rubroad 4000 $495.99 19 19 Road Runroad 5000 $450.95 $999.99 20 Road $490.50 Twist & Shout 20 50350 21 21 Leisure Breeze S89.95 S130.50 22 Leisure 22 Breeze S109.95 $149.95 23 Mt. $375,00 Bluff Breaker 20 $495.00 24 24 Min SASS 5619.99 $0.00 50.00 Jetty Breaker Supplier Table ID No - Supplier Nu. Company Name Street Address City Stal - ZIP COC - Click to Add 1 Bicyclist's Choice 1459 Washington Avenue Sioux Falls SD 52106 2 Bike One 2000 Oceanside Lane San Diego CA 92110 3 3 Run-Up Bikes 1155 Fifth Avenue Long Branch NJ 07521 4 4 Simpson's Bike Supply 107 Piedmont Tulsa OK 74114 5 5 The Bike Path 1999 Stephen Hands Path East Hamptor NY 11937 (New) 0 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
