project -Database in Access

profileAlbt20
part2.accdb
Home>Computer Science homework help>project -Database in Access
CarID TagNumber Make Model CarYear CategoryID Picture Condition Available
1 4 BMW 2008 BMW 7 Series 2008 Good true
2 5 Honda 2013 Honda Civic Si 2013 Good true
3 16 Lexus 2015 Lexus IS 250 AWD 2015 Good true
4 47 Subaru 2013 Subaru Legacy 2.5i Premium 2013 Good true
5 87 Mitsubish 2014 Mitsubishi Lancer ES 2014 Good true
CategoryID Category Daily Weekly Monthly
CustomerID DrvLicNumber FullName Address City State ZIPCode Occupation Note
1 E8574 jane [email protected] tori toronto 2536-412 Self-employed on progress
2 R5841 Michel [email protected] cran Hurugay 456-225 Students on progress
3 Y5485 Edward [email protected] hamna crane 4721-635 Employed on prograss
4 S7542 Ford [email protected] Nairobi Kenya 5285-6352 Companies Given
5 A8574 Carol [email protected] Texass Texaas 5414-6374 Self-employed Given
6 Q8502 William [email protected] Califonia Califonia 8596-6307 Students On progress
7 D5874 Marian [email protected] Tomaco Tomaco 5241-2002 Employed Given
8 T8714 Moses [email protected] Washington Washington 7458-9658 Employed On progress
9 U8595 Ronny [email protected] Dinia wenii 5241-9685 Students On progress
10 L4114 Ann [email protected] Nigeria Nigeria 4752-7895 Self-employed Given
EmployeeID EmployeeNumber FirstName LastName Title Notes
ID AllFK
RentalOderID EmployeeID CustomerID CarID CarCondition StartDate EndDate TotalDays AmountPaid OrderStatus Notes
1 Well returned