Exp19_Access_AppCapstone_Comp_Drivers

lacey.xyY
Blake_Exp19_Access_AppCapstone_Comp_Drivers.accdb
Home>Computer Science homework help>Exp19_Access_AppCapstone_Comp_Drivers
AgentID InsuranceCo InsAgentFirstName InsAgentLastName InsAddress InsCity InsState InsZIP InsPhone mSysRowId
AS2234 AS William Smith 7035556657 ZpYrmr7iB4sAfX2TMA5uNVgcp3RlVwfCZfzXsGEp3as=-~tyO6cNko2nUQUwYg4I48KA==
AS8842 AS Anna Taylor 7035559998 ZpYrmr7iB4sAfX2TMA5uNVgcp3RlVwfCZfzXsGEp3as=-~tyO6cNko2nUQUwYg4I48KA==
SF4485 SF Terri Jones 7035558876 ZpYrmr7iB4sAfX2TMA5uNVgcp3RlVwfCZfzXsGEp3as=-~tyO6cNko2nUQUwYg4I48KA==
SF8567 SF James Johnson 7035551243 ZpYrmr7iB4sAfX2TMA5uNVgcp3RlVwfCZfzXsGEp3as=-~tyO6cNko2nUQUwYg4I48KA==
SF8870 SF Darin Miller 7035550987 ZpYrmr7iB4sAfX2TMA5uNVgcp3RlVwfCZfzXsGEp3as=-~tyO6cNko2nUQUwYg4I48KA==
DriverID StateIssued Photo Class FirstName MiddleName LastName Street Apartment City State ZIP HomePhone Gender Height Weight HairColor EyeColor OrganDonor Restrictions IssueDate ExpirationDate DateOfBirth mSysRowId
123456789 LA Adult Pamela R Toliver 7015 Westchester Drive Baton Rouge LA 70810 2255552752 F 5' 7" 135 Blonde Brown true 2 2008-07-05 1985-11-22 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
341012345 LA Adult Brian Andrew Andrews 132 Blue Street Baton Rouge LA 70810 2255553385 M 5' 10" 200.00 Brown Brown true 4 1995-05-05 1975-05-15 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
341098765 LA Adult Victoria May Bowman 20 Spruce Avenue Baton Rouge LA 70810 2255559876 F 5' 5" 130.00 Red Hazel false 3 1999-06-10 1969-06-20 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
341123456 LA Minor James Hallard Barnes 8 Shane Drive Baton Rouge LA 70810 2255556712 M 6' 1" 205.00 Blonde Brown false 2 2021-01-04 2005-01-04 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
341234567 LA Adult Richard Alvin Bingham 90 Highland Place Baton Rouge LA 70810 2255559855 M 6' 2" 250.00 Brown Brown true 1994-01-10 1954-01-19 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
341678901 LA Adult Kirk Richard Abelson 226 Valley Street Baton Rouge LA 70810 2255552234 M 5' 10" 170.00 Black Brown true 5 1995-05-13 1945-05-30 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
341789012 LA Adult Eric Thomas Abrahamson 130 Flay Street #301 Baton Rouge LA 70810 2255555542 M 6' 2" 225.00 Blonde Blue true 2 2000-06-20 1980-06-27 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
341876543 LA Minor Bruce David Callander 2 Kron Lane Baton Rouge LA 70810 2255557875 M 6' 1" 195.00 Black Blue false 2 2021-08-07 2005-08-07 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
341890123 LA Adult Lawrence Allen Alexander 198 Broad Street #1001 Baton Rouge LA 70810 2255552530 M 6' 1" 270.00 Gray Blue true 2002-02-01 1952-02-01 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
341901234 LA Adult Mark Wayne Anderson 1459 River Drive Baton Rouge LA 70810 2255553964 M 5' 8" 160.00 Brown Brown false 1 1998-12-02 1948-12-22 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
341987654 LA Special Ibrahim Isaac Brown 177 Forest Avenue Baton Rouge LA 70810 2255551232 M 5' 10" 200.00 Gray Brown true 2 1995-08-10 1975-08-13 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
342012345 LA Minor Andrew Edward JAMES 243 Oak Baton Rouge LA 70817 2255555833 M 5' 10" 180 Brown Brown true 2021-06-30 2005-05-30 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
342098765 LA Minor Andrea Marie LARRABEE 823 Shyrock Drive #1540 Baton Rouge LA 70817 2255556789 F 5' 6" 150.00 Brown Hazel false 2022-06-02 2006-04-01 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
342123456 LA Minor Harold B STAUSS One Front Royal Baton Rouge LA 70817 2255552176 M 6' 1" 185 Blonde Brown false 2 2022-08-15 2006-03-15 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
342234567 LA Minor David N ANDERSON 805 North Allen Baton Rouge LA 70817 2255555589 M 6' 4" 305 Brown Brown true 2021-06-04 2005-01-20 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
342678901 LA Minor Kerry Eldon MITCHELL 622 Valley View Baton Rouge LA 70817 2255554322 M 5' 10" 170.00 Black Brown true 2022-06-01 2005-05-03 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
342789012 LA Minor John Eric LANDERS 1032 North Jackson #301 Baton Rouge LA 70817 2255552455 M 6' 2" 225.00 Blonde Blue true 2021-06-02 2005-04-18 OxZ4TWmcF8AhmGSV2IdMwzA4Ba1UIfdU2AapHyv0f0c=-~osYZAzyR6fKS7nZgZNETFQ==
InsuranceID DriverID InsuranceAgentID AutoType AutoYear TagID TagExpiration mSysRowId
10009 123456789 AS2234 Toyota 2009 X1234
10001 341012345 SF4485 Buick 2011 4321R 2022-08-01
10007 341098765 SF8567 GMC 2010 TR876 2022-10-01
10004 341123456 AS8842 Volvo 2012 B3847 2022-02-01
10002 341234567 AS8842 Nissan 2008 4457D 2022-02-01
10008 341789012 SF8567 Chrysler 2010 TR887
10005 341876543 SF8870 Cadillac 2011 CADME 2022-08-16
10003 341789012 SF8567 Dodge 2008 54687 2022-07-01
10006 342234567 AS2234 Mercedes 2012 MYCAR 2022-03-01
ID mSysRowId
1 4A7VTah5hSV+ygb17/ZPlAwz4X3huxnQbGv2FY8/uZY=-~AxBSTHH9uVFk0NsZpWzjmQ==
SELECT [Test Drivers].* FROM [Test Drivers];
PARAMETERS __DriverID Value; SELECT DISTINCTROW * FROM Insurance AS Drivers WHERE ([__DriverID] = DriverID);
SELECT [Test Drivers].* FROM [Test Drivers];
SELECT [Test Drivers].* FROM [Test Drivers];
SELECT DISTINCTROW * FROM Drivers;
SELECT DISTINCTROW * FROM Insurance;
SELECT DISTINCTROW * FROM Drivers;
SELECT DISTINCTROW * FROM Insurance;
SELECT DISTINCTROW * FROM Insurance;
SELECT Insurance.DriverID, Insurance.AutoType, Insurance.AutoYear, Insurance.TagID FROM Insurance WHERE (((Insurance.AutoYear)=[Enter the auto year:]));