Microsoft Access
dhurba9212
Access_Chapter_6_-_Lab_Test_A_-_HaveMore_Electronics.accdb| 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#));
