Exp19_Access_AppCapstone_Comp – Drivers 1.0

profilethomast2093
Exp19_Access_AppCapstone_Comp_Drivers.accdb
Home>Computer Science homework help>Exp19_Access_AppCapstone_Comp – Drivers 1.0
AgentID InsuranceCo InsAgentFirstName InsAgentLastName InsAddress InsCity InsState InsZIP InsPhone mSysRowId
AS2234 AS William Smith 7035556657
AS8842 AS Anna Taylor 7035559998
SF4485 SF Terri Jones 7035558876
SF8567 SF James Johnson 7035551243
SF8870 SF Darin Miller 7035550987
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 7/5/08 11/22/85
341012345 LA Adult Brian Andrew Andrews 132 Blue Street Baton Rouge LA 70810 2255553385 M 5' 10" 200.00 Brown Brown true 4 5/5/95 5/15/75
341098765 LA Adult Victoria May Bowman 20 Spruce Avenue Baton Rouge LA 70810 2255559876 F 5' 5" 130.00 Red Hazel false 3 6/10/99 6/20/69
341123456 LA Minor James Hallard Barnes 8 Shane Drive Baton Rouge LA 70810 2255556712 M 6' 1" 205.00 Blonde Brown false 2 1/4/21 1/4/05
341234567 LA Adult Richard Alvin Bingham 90 Highland Place Baton Rouge LA 70810 2255559855 M 6' 2" 250.00 Brown Brown true 1/10/94 1/19/54
341678901 LA Adult Kirk Richard Abelson 226 Valley Street Baton Rouge LA 70810 2255552234 M 5' 10" 170.00 Black Brown true 5 5/13/95 5/30/45
341789012 LA Adult Eric Thomas Abrahamson 130 Flay Street #301 Baton Rouge LA 70810 2255555542 M 6' 2" 225.00 Blonde Blue true 2 6/20/00 6/27/80
341876543 LA Minor Bruce David Callander 2 Kron Lane Baton Rouge LA 70810 2255557875 M 6' 1" 195.00 Black Blue false 2 8/7/21 8/7/05
341890123 LA Adult Lawrence Allen Alexander 198 Broad Street #1001 Baton Rouge LA 70810 2255552530 M 6' 1" 270.00 Gray Blue true 2/1/02 2/1/52
341901234 LA Adult Mark Wayne Anderson 1459 River Drive Baton Rouge LA 70810 2255553964 M 5' 8" 160.00 Brown Brown false 1 12/2/98 12/22/48
341987654 LA Special Ibrahim Isaac Brown 177 Forest Avenue Baton Rouge LA 70810 2255551232 M 5' 10" 200.00 Gray Brown true 2 8/10/95 8/13/75
342012345 LA Minor Andrew Edward JAMES 243 Oak Baton Rouge LA 70817 2255555833 M 5' 10" 180 Brown Brown true 6/30/21 5/30/05
342098765 LA Minor Andrea Marie LARRABEE 823 Shyrock Drive #1540 Baton Rouge LA 70817 2255556789 F 5' 6" 150.00 Brown Hazel false 6/2/22 4/1/06
342123456 LA Minor Harold B STAUSS One Front Royal Baton Rouge LA 70817 2255552176 M 6' 1" 185 Blonde Brown false 2 8/15/22 3/15/06
342234567 LA Minor David N ANDERSON 805 North Allen Baton Rouge LA 70817 2255555589 M 6' 4" 305 Brown Brown true 6/4/21 1/20/05
342678901 LA Minor Kerry Eldon MITCHELL 622 Valley View Baton Rouge LA 70817 2255554322 M 5' 10" 170.00 Black Brown true 6/1/22 5/3/05
342789012 LA Minor John Eric LANDERS 1032 North Jackson #301 Baton Rouge LA 70817 2255552455 M 6' 2" 225.00 Blonde Blue true 6/2/21 4/18/05
InsuranceID DriverID InsuranceAgentID AutoType AutoYear TagID TagExpiration mSysRowId
10009 123456789 AS2234 Toyota 2009 X1234
10001 341012345 SF4485 Buick 2011 4321R 8/1/22
10007 341098765 SF8567 GMC 2010 TR876 10/1/22
10004 341123456 AS8842 Volvo 2012 B3847 2/1/22
10002 341234567 AS8842 Nissan 2008 4457D 2/1/22
10008 341789012 SF8567 Chrysler 2010 TR887
10005 341876543 SF8870 Cadillac 2011 CADME 8/16/22
10003 341789012 SF8567 Dodge 2008 54687 7/1/22
10006 342234567 AS2234 Mercedes 2012 MYCAR 3/1/22
ID mSysRowId
1
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:]));