Excel, Tables and Access

profilemenoname
BTECApparelDatabase1orAssign2IntrotoAccessDatabase.accdb
Home>Business & Finance homework help>Operations Management homework help>Excel, Tables and Access
Item Number Description Item Type On Hand Cost Selling Price Supplier Code
3673 Wrap-Around Ear Warmers Cap 30 ¤ 7.49 ¤ 10.99 LM
4543 Crew Sweatshirt Clothing 20 ¤ 18.29 ¤ 23.99 PC
5923 Drink Holder Novelty 25 ¤ 1.10 ¤ 1.99 SD
6185 Fleece Vest Clothing 45 ¤ 28.80 ¤ 34.50 PC
6234 Fleece Hat with Visor Cap 12 ¤ 24.25 ¤ 26.50 LM
6345 Wool Socks Clothing 10 ¤ 10.06 ¤ 12.35 PC
6523 Electric Thumb Warmer Novelty 10 ¤ 19.59 ¤ 23.99 SD
7123 Hand Warmers Novelty 50 ¤ 17.50 ¤ 19.99 SD
7363 Baseball Cap Cap 50 ¤ 6.15 ¤ 9.99 LM
7934 Tote Bag (Extra Large) Novelty 34 ¤ 11.26 ¤ 14.99 SD
8136 Travel Mug Novelty 20 ¤ 2.47 ¤ 3.50 SD
8206 Turtleneck Clothing 15 ¤ 13.29 ¤ 14.79 PC
8344 V-Neck Pullover Clothing 26 ¤ 13.60 ¤ 15.75 LM
8590 V-Neck Vest Clothing 15 ¤ 20.85 ¤ 25.02 LM
9458 Windbreaker Clothing 28 ¤ 15.17 ¤ 18.20 PC
9583 Fleece Hoodie Clothing 8 ¤ 32.81 ¤ 34.50 PC
Item Number Date Ordered Number Ordered
6185 2014-11-16 15
8136 2014-11-16 20
8136 2104-11-19 25
8206 2014-11-16 5
8344 2014-11-22 10
8590 2014-11-08 5
8590 2014-11-16 20
8590 2014-11-17 10
9458 2014-11-08 16
9583 2014-11-09 20
Supplier Code Supplier Name Telephone Number Returns Online Ordering
LM LaResort Merchants 803-555-7641 true false
PC Parpres Clothing 517-555-3853 false true
SD Scrypt Distributors 610-555-8741 true true
SELECT [Supplier].[Supplier Code], [Supplier].[Supplier Name] FROM Supplier ORDER BY [Supplier Code];
SELECT Item.[Item Number], Item.Description FROM Item ORDER BY Item.Description;
PARAMETERS __Supplier Code Value; SELECT DISTINCTROW * FROM Item AS [Supplier Master Form] WHERE ([__Supplier Code] = [Supplier Code]);
PARAMETERS __Supplier Code Value; SELECT DISTINCTROW * FROM Item AS [Supplier Orders Data] WHERE ([__Supplier Code] = [Supplier Code]);
PARAMETERS __Supplier Code Value; SELECT DISTINCTROW * FROM [SELECT [Suppliers and Orders].[Supplier Code], [Suppliers and Orders].[Item Number], [Suppliers and Orders].[Description], [Suppliers and Orders].[Date Ordered], [Suppliers and Orders].[Number Ordered] FROM [Suppliers and Orders]]. AS [Supplier Orders Data] WHERE ([__Supplier Code] = [Supplier Code]);
PARAMETERS __Item Number Text; SELECT DISTINCTROW * FROM [SELECT [Reorder].[Item Number], [Reorder].[Date Ordered], [Reorder].[Number Ordered] FROM Reorder]. AS [Supplier Master List] WHERE ([__Item Number] = [Item Number]);
SELECT DISTINCTROW * FROM Item;
SELECT DISTINCTROW * FROM Item;
SELECT DISTINCTROW * FROM Item;
SELECT DISTINCTROW * FROM Item;
SELECT [Suppliers and Orders].[Supplier Code], [Suppliers and Orders].[Item Number], [Suppliers and Orders].[Description], [Suppliers and Orders].[Date Ordered], [Suppliers and Orders].[Number Ordered] FROM [Suppliers and Orders];
SELECT DISTINCTROW * FROM Supplier;
SELECT DISTINCTROW * FROM Supplier;
SELECT DISTINCTROW * FROM Item;
SELECT [Supplier].[Supplier Name], [Item].[Item Number], [Item].[Description], Item.[Cost], [Supplier].[Supplier Code] FROM Supplier INNER JOIN Item ON [Supplier].[Supplier Code] =[Item].[Supplier Code];
SELECT [Reorder].[Item Number], [Reorder].[Date Ordered], [Reorder].[Number Ordered] FROM Reorder;
SELECT Supplier.[Supplier Code], Supplier.[Supplier Name], Item.[Item Number], Item.Description, Item.[Item Type], Item.[On Hand], Item.Cost, Item.[Selling Price] FROM Supplier INNER JOIN Item ON Supplier.[Supplier Code] = Item.[Supplier Code];
SELECT Supplier.[Supplier Code], Item.[Item Number], Item.Description, Reorder.[Date Ordered], Reorder.[Number Ordered] FROM (Supplier INNER JOIN Item ON Supplier.[Supplier Code] = Item.[Supplier Code]) INNER JOIN Reorder ON Item.[Item Number] = Reorder.[Item Number] ORDER BY Supplier.[Supplier Code], Item.[Item Number], Reorder.[Date Ordered];