Atabase (Microsoft Access needed) Making Queries/Forms

Using Microsoft Access, create queries for the Fleet Truck Maintenance database. (the file is attached)
(2 is fine // Dont go to overboard)


Using Microsoft Access, create three reports for the Fleet Truck Maintenance database. Possible reports might include:

Inventory Tracking Report listing of vehicle ID number, VIN, and vehicle description

DOT Inspection Report listing of last inspection and reminders of upcoming inspections

Lube/Service Intervals Report service intervals by miles, days, or hours

Fuel Log Report mileage, costs per mile

Common Failure Analysis breakdown of like repairs by type of repair or repair costs

Operating Trend Analysis breakdown of maintenance operations over time