a Query object named as Five Most Expensive Bicycles in which contains 5 fields (Product Number,...

  

 

 

Transcribed Image Text:

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. or 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. "roduct Table Product Numb Product Categc Product Nam 1 Road Classic 109 2 Road 3 Road 4 Mtn. 5 Mtn. 6 Mtn. 7 Hybrid 8 Hybrid 9 Hybrid 10 Leisure 11 Leisure 12 Leisure 13 Leisure 14 Children 15 Children 16 Children 17 Children 18 Road 19 Road 20 Road 21 Leisure 22 Leisure 23 Mtn. ▾ Elegant 210 Runroad 1000 Eagle 3 Eagle 2 Eagle 1 Runblend 2000 Eagle 7 Tea for Two Runcool 3000 Starlight Supreme 350 Blue Moon Runkidder 100 Red Rider Coolest 100 Green Rider Runroad 4000 Runroad 5000 Twist & Shout Breeze Breeze LE Bluff Breaker Purchase Co: $207.49 $281.52 $250.95 $150.89 $429.02 $85.95 $100.47 $50.00 $350.52 $401.11 $561.54 $410.01 $574.01 $180.95 $255.99 $211.46 $609.00 $75.29 $50.95 $15.00 $69.99 $95.47 $390.95 $450.95 $490.50 $89.95 Selling Prix Supplier Numl Quantity on Ha Reorder L $290.49 $109.95 $375.00 ▾ $394.13 $350.99 $490.73 $135.99 $140.66 $70.00 $105.41 $75.99 $25.50 $97.98 $133.66 $495.99 $599.99 $635.70 $130.95 $149.95 $495.00 1 1 3 2 2 2 3 2 4 3 4 1 4 3 4 1 4 3 3 4 5 5 7 7 8 5 2 1 0 9 3 5 1 3 4 10 8 6 4 5 5 0 4 5 3 Supplier Table ID No 3 4 5 (New) Supplier Nui Company Name 1 Bicyclist's Choice 2 Bike-One 3 Run-Up Bikes 4 Simpson's Bike Supply 107 Piedmont 5 The Bike Path 0 City - Stat. ZIP Coc Click to Add 57106 92110 07521 74114 11937 Street Address 1459 Washington Avenue Sioux Falls SD 2000 Oceanside Lane 1155 Fifth Avenue San Diego CA Long Branch NJ Tulsa OK 1999 Stephen Hands Path East Hamptor NY 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. or 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. "roduct Table Product Numb Product Categc Product Nam 1 Road Classic 109 2 Road 3 Road 4 Mtn. 5 Mtn. 6 Mtn. 7 Hybrid 8 Hybrid 9 Hybrid 10 Leisure 11 Leisure 12 Leisure 13 Leisure 14 Children 15 Children 16 Children 17 Children 18 Road 19 Road 20 Road 21 Leisure 22 Leisure 23 Mtn. ▾ Elegant 210 Runroad 1000 Eagle 3 Eagle 2 Eagle 1 Runblend 2000 Eagle 7 Tea for Two Runcool 3000 Starlight Supreme 350 Blue Moon Runkidder 100 Red Rider Coolest 100 Green Rider Runroad 4000 Runroad 5000 Twist & Shout Breeze Breeze LE Bluff Breaker Purchase Co: $207.49 $281.52 $250.95 $150.89 $429.02 $85.95 $100.47 $50.00 $350.52 $401.11 $561.54 $410.01 $574.01 $180.95 $255.99 $211.46 $609.00 $75.29 $50.95 $15.00 $69.99 $95.47 $390.95 $450.95 $490.50 $89.95 Selling Prix Supplier Numl Quantity on Ha Reorder L $290.49 $109.95 $375.00 ▾ $394.13 $350.99 $490.73 $135.99 $140.66 $70.00 $105.41 $75.99 $25.50 $97.98 $133.66 $495.99 $599.99 $635.70 $130.95 $149.95 $495.00 1 1 3 2 2 2 3 2 4 3 4 1 4 3 4 1 4 3 3 4 5 5 7 7 8 5 2 1 0 9 3 5 1 3 4 10 8 6 4 5 5 0 4 5 3 Supplier Table ID No 3 4 5 (New) Supplier Nui Company Name 1 Bicyclist's Choice 2 Bike-One 3 Run-Up Bikes 4 Simpson's Bike Supply 107 Piedmont 5 The Bike Path 0 City - Stat. ZIP Coc Click to Add 57106 92110 07521 74114 11937 Street Address 1459 Washington Avenue Sioux Falls SD 2000 Oceanside Lane 1155 Fifth Avenue San Diego CA Long Branch NJ Tulsa OK 1999 Stephen Hands Path East Hamptor NY