Fuel Inventory db

[amincomputer]

Halo Guyz,

My name is Amin. I am eager to develop a db for our charity organization based in Kenya to track its 10 vehicle's fuel consumption with mileage. The follwoing are features of the db.

I have table of 15 drivers and I have atable of 15 car plates

I need to design an Access database that track fuel mileage consuption.

I think i must have aform that have the follwing field.

1. FuelID(autonumber)
2. Drivers_Name ...........(Add addition Buttion for a new driver )
3. Vehicle_Plate_Number...........(Add addition Buttion for a new Car Plate )
4. Vehicle_Type......(Must update tself from Vehilce plate number. I.e when a KX 10 is entered, the vehilce type must automatically display ''Nissan Hard Boby in the vehicle type field.its not data entry field.
5. Volume of fuel loaded on each vehicle
6. Volume of fuel Reserves...( The reserve is 20,000 lts)
7. Volume of fuel balance(reserve)
8. Car starting mileage...( each vehicle with its own starting mileage)
9. Current mileage..( data entry field. must return the previous mileage number to current for each vehilce)
10. Fuel consumed.........(subtract start milage -current milage divide by fuel loaded)
11. Date fueled..(pulled from system date)
12. Display who loggged on and computer acount name for accountability

 

[amincomputer]

Any one with similar database? or can HELP?

 

[naveeddil]

Any update on this Post ?

 

[Mihail]

We can start. But I need "live" information (when I need).

 

[naveeddil]

What sort of information ?

 

[Pat Hartman]

You need to break the data into several tables. This should get you started.
tblDrivers:
DriverID (autonumber primary key)
FirstName
LastName
...
tblVehicles:
VehicleID (autonumber primary key)
VehiclePlateNumber
VehicleTypeID (long integer, foreign key to tblVehicleType)
FuelCapacity
...
tblFuelingLog:
FuelingLogID (autonumber primary key)
VehicleID (foreign key to tblVehicles)
DriverID (foreign key to tblDrivers)
FuelingDT
Liters
CostPerLiter
Mileage
...

 

[Mihail]

Example:

Volume of fuel Reserves...( The reserve is 20,000 lts)

What is this ? The fuel volume (in litters) that is stored in a big tank from where each vehicle will be fueled ?

 

[Mihail]

This sketch can be a start