How to Create Database for tracking KM Per Liter

[Narinderpal]

hi,


Good Day
I'm new to database... i want to create a database in access as per below
Information which shows user details, Vehicle information etc.... & table which contains columns like.... Fuel Card No., Date Fuel Filled, Liters filled, Cost, Odometer Start, Odometer End, Distance (KM), KM/Liter

A look of the same table i have pasted herewith

Employee Name
Employee Badge No.				Rate Per Litre
Vehicle Number				For Period	From 00/Jan/00 TO 00/Jan/00
Vehicle Description				Average KM / Litre
Project
Card No.	Date Filled Fuel	Litres	Cost	Odometer Start	Odometer End	Distance (KM)	KM / Liter
		0.000	0.000			0	0.000

[Dal Jeanis]

Head over to Roger's access library at http://rogersaccesslibrary.com and review his easy tutorials about how to design a database and how to design an application.

You have at least three entity tables there, one to represent your employees, one your vehicles, and one your fill-up events. At a guess, you may need a table for projects as well, and if the same vehicle can be used on multiple projects, then there may be some other design issues to think about.

This stuff isn't difficult, but your database will stay easiest to code and maintain if you start off understanding the right way to think about your own information. That's why I'm sending you to Roger Carlson's tutorials first, because he has examples of different simple databases and how to work out the "entities' that are in them.

For instance, does the fuel card stay with a single vehicle, or is it carried by a single employee, or does it move around from vehicle to vehicle or person to person? If it moves around, then it's an entity of itself and needs its own table. If it stays with a person or a vehicle, then it might properly be an "attribute" of the person or the vehicle, or it might need its own table, depending on usage.

Anyway, do a quick review of Roger's samples, and then come back here and ask more questions.