Microsoft Access
dhurba9212
Access_Chapter_5_-_Lab_Test_A_-_HaveMore_Electronics.accdb| Address | City | State | Zip | Outlet ID |
|---|---|---|---|---|
| 1298 Western Court | Bedlam | CA | 34896 | HME 11 |
| 25 Parkington Palace | Southtown | CA | 39746 | HME 15 |
| 1212 Mocking Bird | Ambervson | CA | 38957 | HME 17 |
| 774 Oakland | Parkville | CA | 38974 | HME 26 |
| 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];
