Hey all!

I'm trying to create my first database and would appreciate some help!! All my data currently resides in a now very bloated spreadsheet.

I’ve put a lot of thought into how the database should be arranged. I’ve attached a jpeg showing how I envisage the database working. I’ve used the car analogy as its simpler than using my industries jargon!

I’ve read quite a few tutorials so I’m starting to understand some basic concepts but I’m still at a loss on some elements. Here are my (initial!) questions…

• Does anyone know of any similar database structures that I could work from?
• How do I automatically fill out the first three fields for the monthly and yearly tables (based on the combination of fields table from the first three tables) so no data is missed?
• What’s the best way to deal with monthly/yearly data input?
• How should I deal with the primary key – I could use the car info unique field or should I use the access auto-assign one?


• Any advice on how the relationships between the tables should work? (not sure I fully understand this yet…)

I hope my post is relevant and clear and thanks in advance for any help!