Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a Query object named as Five Most Expensive Bicycles in which contains 5 fields (Product Number, Product Name, Selling Price, Quantity on Hand, and

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

1 13 82 10 39 24 roduct Table Product Numb - Product Categc. Product Narr. Purchase Co: Selling Pris . Supplier Numl. Qu

Supplier Table ID No Supplier Nui Company Name Street Address City Stat - ZIP Cod. Click to Add 11 Bicyclists Choice 1459 W 

 

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

Step by Step Solution

3.42 Rating (161 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Pathway To Introductory Statistics

Authors: Jay Lehmann

1st Edition

0134107179, 978-0134107172

More Books

Students also viewed these Organizational Behavior questions

Question

y = 5x Graph the equation by hand.

Answered: 1 week ago

Question

5/7 4/9 Perform the indicated operation by hand.

Answered: 1 week ago

Question

Give three explanations for the law of demand

Answered: 1 week ago