PowerPoint 2K/ Integrated Projects 1A
andychen5029
i01a_store_locations.accdb| Manager ID | Firstname | Lastname |
|---|---|---|
| CO-100 | Margaret | Voboril |
| NM-100 | Jim | Wolfgang |
| OR-100 | Vicki | Plasek |
| WA-100 | Firstname | Lastname |
| Manager ID | Address | Monthly Rent | City |
|---|---|---|---|
| CO-100 | 403 Starlight Blvd | ¤ 5,000.00 | Denver |
| OR-100 | 10 East Blvd | ¤ 5,000.00 | Portland |
| OR-100 | 403 State Blvd | ¤ 6,000.00 | Salem |
| WA-100 | 2445 Cove St | ¤ 4,500.00 | Spokane |
| NM-100 | 403 Central Blvd | ¤ 5,500.00 | Albuquerque |
| CO-100 | 208 E Central Ave | ¤ 6,000.00 | Golden |
| CO-100 | 98045 North Ave | ¤ 4,500.00 | Aurora |
| NM-100 | 7303 Spring Blvd | ¤ 6,000.00 | Santa Fe |
| NM-100 | 8692 Garden Blvd | ¤ 6,000.00 | Gallup |
| CO-100 | 197 Tower Rd | ¤ 4,500.00 | Denver |
| NM-100 | 8851 Skyline Blvd | ¤ 4,500.00 | Albuquerque |
| WA-100 | 7108 Main St | ¤ 5,500.00 | Bellingham |
| WA-100 | 51977 Winding Way | ¤ 5,500.00 | Seattle |
| OR-100 | 8692 Technology Blvd | ¤ 5,500.00 | Eugene |
| NM-100 | 52792 Greenfield | ¤ 6,000.00 | Taos |
| OR-100 | 7825 Blue St | ¤ 5,000.00 | Portland |
| OR-100 | 692 Lilly Blvd | ¤ 5,500.00 | Springfield |
| WA-100 | 35725 Water Street | ¤ 6,000.00 | Tacoma |
| CO-100 | 7925 S Forrest Rd | ¤ 5,500.00 | Boulder |
| CO-100 | 782 Mill Rd SW | ¤ 6,000.00 | Colorado Springs |
PARAMETERS __Manager ID Value;
SELECT DISTINCTROW *
FROM [Store Locations] AS [Managers Form]
WHERE ([__Manager ID] = [Manager ID]);
SELECT DISTINCTROW *
FROM Managers;
SELECT DISTINCTROW *
FROM [Store Locations];
SELECT [Store Locations].[Address], [Store Locations].[City], [Managers].[Firstname], [Managers].[Lastname], Managers.[Manager ID]
FROM Managers INNER JOIN [Store Locations] ON Managers.[Manager ID]=[Store Locations].[Manager ID];
SELECT Managers.Firstname, Managers.Lastname, [Store Locations].[Monthly Rent], [Store Locations].Address, [Store Locations].City
FROM Managers INNER JOIN [Store Locations] ON Managers.[Manager ID] = [Store Locations].[Manager ID];
