car fleet planner

[romelsms1]

Dear all,



I join to your group in order to learn more about ms access (I am a beginner in this field) since excel is limited regarding “data bases”
What I’m trying to do is a data base to keep track of a cars fleet with a planner/planning. In detail I want to have a database with the fleet (with all the information) another with drivers and in the end a planning for all cars bay days

I found on the internet a Gantt example but I don’t understand how it’s made


thank you in advance for your help!

[ranman256]

i cant download the attacment, but make a schema....

tCustomer table
-----
CustID
firstN
lastN
etc



tVehicle table
-----
VIN
make
model
descr
RentID (this would indicate the car is rented)
etc...


tService table
------------
VIN
SvcDate
Problem
FixedDate
etc...



tRental table (similar to an order)
------
RentID
CustID
AmtDue
RentDate
etc...


tRentalDetail table (order detail)
----------
RentDtlID
RentID
VIN
StartDate
ReturnDate
etc...

[orange]

You may get some ideas, definitions and models from Database Answers fleet management

[HiTechCoach]

Note: This has been cross posted to other forums

A message to forum cross posters