Made a valiant attempt and floundered at amending, to our business requirements, the ‘Vehicle maintenance’ template
Made the attached Tables to start at building from scratch.
The attached shows, I hope, the concept of the information required to store and query.
I would be grateful for the following:
Is the attached normalised properly, if not how should it be corrected? Are the relationships properly in place?
Or, once this attachment has been viewed would you recommend persevering with the template? Would that still be a simpler way forward?
The database is for use in a small(ish) business where there are two companies running cars and light commercials and ‘family’ owned cars.
(The thought also occurs at this time of posting fields would be needed to query when MOT and other commercial testing would be required so I will need to add these later)
Database (Access 2007_Vista) are new to me. I am starting with this project with a view to learning before starting on a more important project of a stock control database (with all its implications!)
Thank you for considering and hopefully your guidance.
Made the attached Tables to start at building from scratch.
The attached shows, I hope, the concept of the information required to store and query.
I would be grateful for the following:
Is the attached normalised properly, if not how should it be corrected? Are the relationships properly in place?
Or, once this attachment has been viewed would you recommend persevering with the template? Would that still be a simpler way forward?
The database is for use in a small(ish) business where there are two companies running cars and light commercials and ‘family’ owned cars.
(The thought also occurs at this time of posting fields would be needed to query when MOT and other commercial testing would be required so I will need to add these later)
Database (Access 2007_Vista) are new to me. I am starting with this project with a view to learning before starting on a more important project of a stock control database (with all its implications!)
Thank you for considering and hopefully your guidance.