Microsoft Access
dhurba9212
Access_Chapter_7_-_Lab_Test_A_-_HaveMore_Electronics.accdb| Item ID | Qty on Hand | Date Updated | Outlet ID |
|---|---|---|---|
| T1587 | 2 | 4/1/12 | HME 11 |
| L2458 | 5 | 3/12/12 | HME 15 |
| M9899 | 7 | 6/1/12 | HME 17 |
| P2933 | 8 | 1/29/12 | HME 26 |
| Y9390 | 13 | 7/8/12 | HME 11 |
| U9893 | 20 | 6/15/12 | HME 15 |
| H4541 | 10 | 2/25/12 | HME 17 |
| H2250 | 21 | 8/30/12 | HME 26 |
| T8345 | 7 | 10/1/12 | HME 11 |
| P4320 | 16 | 12/22/12 | HME 15 |
| U1165 | 24 | 1/4/12 | HME 17 |
| Y2899 | 14 | 6/12/12 | HME 26 |
| I9809 | 25 | 4/5/12 | HME 11 |
| N9300 | 17 | 5/5/12 | HME 17 |
| B9839 | 9 | 3/15/12 | HME 26 |
| Item Descr | Price | Item ID |
|---|---|---|
| BlueRay DVD | ¤ 269.00 | T1587 |
| DVD RW | ¤ 135.00 | L2458 |
| External Hard Drive | ¤ 179.00 | M9899 |
| HD Video | ¤ 248.00 | P2933 |
| LaserJet LJ9900 | ¤ 189.00 | Y9390 |
| Maximun CPU | ¤ 267.00 | U9893 |
| Palm Reader280 | ¤ 548.00 | H4541 |
| Ultimate Keyboard | ¤ 204.00 | H2250 |
| WiFi Router | ¤ 169.00 | T8345 |
| HD LCD | ¤ 147.00 | P4320 |
| Big Audio - Sound Kit | ¤ 325.00 | U1165 |
| LGM Pad | ¤ 699.00 | Y2899 |
| TKB Laptop | ¤ 875.00 | I9809 |
| LR Car Stereo | ¤ 451.00 | N9300 |
| OnCue TV | ¤ 689.00 | B9839 |
| Address | City | State | Zip | Outlet ID | Phone Orders | Online Orders | Updates |
|---|---|---|---|---|---|---|---|
| 1298 Western Court | Bedlam | CA | 34896 | HME 11 | true | false | |
| 25 Parkington Palace | Southtown | CA | 39746 | HME 15 | true | true | |
| 1212 Mocking Bird | Ambervson | CA | 38957 | HME 17 | false | false | |
| 774 Oakland | Parkville | CA | 38974 | HME 26 | false | true |
| Full Name | Gender | Age | Hire Date | Outlet ID | Quota | YTD Sales | Sales Rep ID | Job Type |
|---|---|---|---|---|---|---|---|---|
| Smith, Mike | M | 35 | 6/27/12 | HME 17 | ¤ 1,500,000.00 | ¤ 0.00 | 651 | PT |
| Moeller, Pierre | M | 24 | 3/12/01 | HME 11 | ¤ 3,656,640.00 | ¤ 3,336,300.00 | 321 | PT |
| Battistini, Jorge | M | 26 | 7/2/01 | HME 15 | ¤ 3,371,092.00 | ¤ 1,960,932.00 | 101 | ST |
| Lambert, Paul | M | 35 | 3/16/02 | HME 11 | ¤ 1,768,442.00 | ¤ 1,525,237.00 | 205 | PT |
| Brunell, Candace | F | 36 | 6/1/02 | HME 17 | ¤ 3,000,264.00 | ¤ 2,078,386.00 | 613 | PT |
| Leon, Tommy | M | 39 | 6/6/02 | HME 26 | ¤ 1,652,836.00 | ¤ 1,432,701.00 | 475 | PT |
| Lyon, Jody | F | 27 | 8/3/02 | HME 15 | ¤ 2,280,900.00 | ¤ 1,548,311.00 | 125 | FT |
| Lopez, Maria | F | 25 | 6/3/04 | HME 17 | ¤ 1,837,213.00 | ¤ 1,563,140.00 | 140 | PT |
| Dillig, Henry | M | 42 | 11/21/06 | HME 11 | ¤ 3,899,402.00 | ¤ 1,916,753.00 | 285 | PT |
| Kahn, Ramesh | M | 44 | 4/6/07 | HME 26 | ¤ 3,426,535.00 | ¤ 3,292,270.00 | 512 | FT |
| Chiu, Leslie | F | 36 | 7/15/07 | HME 26 | ¤ 3,218,514.00 | ¤ 2,514,181.00 | 678 | FT |
| Wochos, Lisa | F | 30 | 10/21/07 | HME 15 | ¤ 2,648,883.00 | ¤ 2,188,106.00 | 287 | ST |
| Cataldo, Lydia | F | 25 | 11/15/07 | HME 11 | ¤ 3,668,028.00 | ¤ 2,846,910.00 | 465 | FT |
SELECT [Sales Rep].[Sales Rep ID], [Sales Rep].[Name], [Sales Rep].[Outlet ID], [Sales Rep].[Quota], [Sales Rep].[YTD Sales]
FROM [Sales Rep];
SELECT [Sales Rep].[Sales Rep ID], [Sales Rep].[Full Name], [Sales Rep].[Outlet ID], [Sales Rep].Quota, [Sales Rep].[YTD Sales]
FROM [Sales Rep]
WHERE ((([Sales Rep].[Outlet ID])="HME 11"));
SELECT DISTINCTROW *
FROM [Sales Rep];
SELECT DISTINCTROW *
FROM [Sales Rep];
UPDATE [Sales Rep]
SET [Sales Rep].[Job Type] = "PT";
SELECT DISTINCTROW *
FROM [Sales Rep];
SELECT DISTINCTROW *
FROM [Sales Rep];
SELECT [Outlets].[Outlet ID], [Outlets].[Address], [Outlets].[City], [Outlets].[State], [Outlets].[Zip], [Sales Rep].[Sales Rep ID], [Sales Rep].[Full Name], [Sales Rep].[YTD Sales]
FROM Outlets INNER JOIN [Sales Rep] ON [Outlets].[Outlet ID] =[Sales Rep].[Outlet ID];
SELECT DISTINCTROW *
FROM [Sales Rep];
PARAMETERS __Outlet ID Value;
SELECT DISTINCTROW *
FROM [Sales Rep] AS [Outlets Form]
WHERE ([__Outlet ID] = [Outlet ID]);
SELECT DISTINCTROW *
FROM Outlets;
SELECT Outlets.[Outlet ID], Outlets.Address, Outlets.City, Outlets.State, Outlets.Zip, Outlets.[Phone Orders], Outlets.[Online Orders], Outlets.Updates, Outlets.Updates.FileData, [Updates].[FileFlags] AS Expr1, Outlets.Updates.FileName, [Updates].[FileTimeStamp] AS Expr2, Outlets.Updates.FileType, [Updates].[FileURL] AS Expr3
FROM Outlets
WHERE (((Outlets.[Online Orders])=Yes));
SELECT DISTINCTROW [Outlets].[Outlet ID], [Outlets].[Address], [Outlets].[City], [Outlets].[State], [Outlets].[Zip], [Outlets].[Phone Orders], [Outlets].[Online Orders], [Outlets].[Updates], [Updates_E33226FBD767455DAC3708C7ADE44AE2].[FileData], [Updates_E33226FBD767455DAC3708C7ADE44AE2].[FileFlags] AS Expr1, [Updates_E33226FBD767455DAC3708C7ADE44AE2].[FileName], [Updates_E33226FBD767455DAC3708C7ADE44AE2].[FileTimeStamp] AS Expr2, [Updates_E33226FBD767455DAC3708C7ADE44AE2].[FileType], [Updates_E33226FBD767455DAC3708C7ADE44AE2].[FileURL] AS Expr3, [Updates_E33226FBD767455DAC3708C7ADE44AE2].[_Updates]
FROM Outlets LEFT JOIN f_308340A1498A4184BCCD9901476044D0_Updates AS Updates_E33226FBD767455DAC3708C7ADE44AE2 ON [Outlets].[Updates]=[Updates_E33226FBD767455DAC3708C7ADE44AE2].[_Updates]
WHERE ((([Outlets].[Online Orders])=Yes));
SELECT Outlets.[Outlet ID], Outlets.[Address], Outlets.[City], Outlets.[State], Outlets.[Zip], Outlets.[Phone Orders], Outlets.[Online Orders], Outlets.[Updates], Outlets.[Updates].[FileData], [Updates].[FileFlags] AS Expr1, Outlets.[Updates].[FileName], [Updates].[FileTimeStamp] AS Expr2, Outlets.[Updates].[FileType], [Updates].[FileURL] AS Expr3
FROM Outlets
WHERE (((Outlets.[Phone Orders])=No));
SELECT DISTINCTROW [Outlets].[Outlet ID], [Outlets].[Address], [Outlets].[City], [Outlets].[State], [Outlets].[Zip], [Outlets].[Phone Orders], [Outlets].[Online Orders], [Outlets].[Updates], [Updates_582D248E45D04FD491093AF935794DA7].[FileData], [Updates_582D248E45D04FD491093AF935794DA7].[FileFlags] AS Expr1, [Updates_582D248E45D04FD491093AF935794DA7].[FileName], [Updates_582D248E45D04FD491093AF935794DA7].[FileTimeStamp] AS Expr2, [Updates_582D248E45D04FD491093AF935794DA7].[FileType], [Updates_582D248E45D04FD491093AF935794DA7].[FileURL] AS Expr3, [Updates_582D248E45D04FD491093AF935794DA7].[_Updates]
FROM Outlets LEFT JOIN f_308340A1498A4184BCCD9901476044D0_Updates AS Updates_582D248E45D04FD491093AF935794DA7 ON [Outlets].[Updates]=[Updates_582D248E45D04FD491093AF935794DA7].[_Updates]
WHERE ((([Outlets].[Phone Orders])=No));
SELECT [Sales Rep].[Sales Rep ID], [Sales Rep].[Job Type], [Sales Rep].[Full Name], [Sales Rep].[Gender], [Sales Rep].[Age], [Sales Rep].[Hire Date], [Sales Rep].[Outlet ID], [Sales Rep].[Quota], [Sales Rep].[YTD Sales]
FROM [Sales Rep]
WHERE ((([Sales Rep].[Hire Date])>#11/1/2006#));
SELECT Outlets.[Outlet ID], Outlets.Address, Outlets.City, Outlets.State, Outlets.Zip, Outlets.[Phone Orders], Outlets.[Online Orders], Outlets.Updates, [Sales Rep].[Job Type], [Sales Rep].[Full Name], [Sales Rep].Gender, [Sales Rep].Age, [Sales Rep].[Hire Date], [Sales Rep].Quota, [Sales Rep].[YTD Sales], [Sales Rep].[Sales Rep ID]
FROM Outlets INNER JOIN [Sales Rep] ON Outlets.[Outlet ID] = [Sales Rep].[Outlet ID];
SELECT Inventory.[Outlet ID], Inventory.[Item ID], Inventory.[Qty on Hand], Inventory.[Date Updated], Items.[Item Descr], Items.Price
FROM Items INNER JOIN Inventory ON Items.[Item ID] = Inventory.[Item ID];
PARAMETERS __Outlet ID Value;
SELECT DISTINCTROW *
FROM [SELECT [Inventory and Items].[Outlet ID], [Inventory and Items].[Item ID], [Inventory and Items].[Qty on Hand], [Inventory and Items].[Date Updated], [Inventory and Items].[Item Descr], [Inventory and Items].[Price] FROM [Inventory and Items]]. AS [Outlet Master Report]
WHERE ([__Outlet ID] = [Outlet ID]);
