I have watched the video on creating a vehicle maintenance database and have created one from the video.. I have a few questions.

Firstly, what is the best way to determine the number of vehicles each mechanic has serviced each month and for the entire year?

Secondly, I have put a combo box in the from with the mechanics' names, is there a way to have the vehicle data automatically populate when a mechanic is selected from the drop-down menu, instead of manually navigating through each entry?

Thirdly, how can I set up a query to identify when a vehicle is due for maintenance based on mileage or due date, whichever comes first?

Lastly, how difficult is it to set up a pop-up reminder for vehicles that are due for maintenance within the next 30 days or is past due?

Thanks