Exp19_Access_Ch10_Cap_Drivers

profilelacey.xyY
Blake_Exp19_Access_Ch10_Cap_Drivers.accdb
Home>Computer Science homework help>Exp19_Access_Ch10_Cap_Drivers
AgentID InsuranceCo InsAgentFirstName InsAgentLastName InsAddress InsCity InsState InsZIP InsPhone mSysRowId
AS2234 AS William Smith 7035556657 VQlbSrz6MW5LfTpiiswJYZPfdxtdwqV57v7Xa+ZZ9MU=-~7AN1Ci0K+aJCeh6XUbmEJg==
AS8842 AS Anna Taylor 7035559998 VQlbSrz6MW5LfTpiiswJYZPfdxtdwqV57v7Xa+ZZ9MU=-~7AN1Ci0K+aJCeh6XUbmEJg==
SF4485 SF Terri Jones 7035558876 VQlbSrz6MW5LfTpiiswJYZPfdxtdwqV57v7Xa+ZZ9MU=-~7AN1Ci0K+aJCeh6XUbmEJg==
SF8567 SF James Johnson 7035551243 VQlbSrz6MW5LfTpiiswJYZPfdxtdwqV57v7Xa+ZZ9MU=-~7AN1Ci0K+aJCeh6XUbmEJg==
SF8870 SF Darin Miller 7035550987 VQlbSrz6MW5LfTpiiswJYZPfdxtdwqV57v7Xa+ZZ9MU=-~7AN1Ci0K+aJCeh6XUbmEJg==
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
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
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
341123456 LA Minor James Hallard Barnes 8 Shane Drive Baton Rouge LA 70810 2255556712 M 6' 1" 205.00 Blonde Brown false 2 2016-01-04 1999-01-04
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
341678901 LA Adult Kirk Richard Abelson 226 Valley Street Baton Rouge LA 70810 2255552234 M 5' 10" 170.00 Black Brown true 5 2015-05-31 1995-05-30
341789012 LA Adult Eric Thomas Abelson 226 Valley Street Baton Rouge LA 70810 2255555542 M 6' 2" 225.00 Blonde Blue true 2 1990-06-20 1970-06-27
341876543 LA Minor Bruce David Callander 2 Kron Lane Baton Rouge LA 70810 2255557875 M 6' 1" 195.00 Black Blue false 2 2016-08-07 1999-08-07
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
341901234 LA Special 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
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 1935-08-13
342012345 LA Minor Andrew Edward JAMES 243 Oak Baton Rouge LA 70817 2255555833 M 5' 10" 180 Brown Brown true 2016-06-30 1999-05-30
342098765 LA Minor Andrea Marie LARRABEE 823 Shyrock Drive #1540 Baton Rouge LA 70817 2255556789 F 5' 6" 150.00 Brown Hazel false 2016-06-02 1999-04-01
342123456 LA Minor Harold B STAUSS One Front Royal Baton Rouge LA 70817 2255552176 M 6' 1" 185 Blonde Brown false 2 2016-08-15 1999-03-15
342234567 LA Minor David N ANDERSON 805 North Allen Baton Rouge LA 70817 2255555589 M 6' 4" 305 Brown Brown true 2016-06-04 1999-01-20
342678901 LA Minor Kerry Eldon MITCHELL 622 Valley View Baton Rouge LA 70817 2255554322 M 5' 10" 170.00 Black Brown true 2016-06-01 1999-05-03
342789012 LA Minor John Eric LANDERS 1032 North Jackson #301 Baton Rouge LA 70817 2255552455 M 6' 2" 225.00 Blonde Blue true 2016-06-02 2000-04-18
InsuranceID DriverID InsuranceAgentID AutoType AutoYear TagID TagExpiration
10001 341012345 SF4485 Buick 2009 4321R 2021-08-01
10002 341234567 AS8842 Nissan 2006 4457D 2021-02-01
10003 341789012 SF8567 Dodge 2003 54687 2021-07-01
10004 341123456 AS8842 Volvo 2010 B3847 2021-02-01
10005 341876543 SF8870 Cadillac 2006 CADME 2021-08-16
10006 342234567 AS2234 Mercedes 2007 MYCAR 2021-06-30
10007 341098765 SF8567 GMC 2008 TR876 2021-10-01
10008 341789012 SF8567 Chrysler 2005 TR887
10009 123456789 AS2234 Toyota 2004 X1234
ID mSysRowId
1 e7RvnlrKG3x9C+iCf9s+JaAqUMU7F2ITlKVjvd3fe0E=-~Bk/ZGzEfI8dYStrKnQvIzQ==
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;