Help with d/b table setup

[leftpeg]

Hi,

I have posted several questions regarding how to set up my database recently and i am now a little bit confused. I would appreciate anyones help on how many tables to use, relationships etc.

To briefly explain, my company has been awarded a contract to carry out safety checks on 6,000 main incoming meters for the UKs largest utilities provider.

My database needs to store the following info:

House No
Road
Town
Postcode
Date job completed
Completed by (engineer name)

Engineer First Name
Engineer Last Name

Then there are about 10x fields for Y/N answers to job specific questions
Job aborted
Reasons for jobs aborted

I know how to create queries and would be pretty confident with that. The queries will be:

jobs oustanding
jobs completed
jobs completed by particular enigneer in a particular week
jobs aborted - reasons (text field)

I just need help with the tables and relationships so they all link in together. I want to get the d/b set up the best way i can from the start.

One other thing i would like to do is allocate jobs on the job table to certain employees, would i do that using a new filed on the job table and then a combo box?

apologies for all the questions at once. any help will be greatly appreciated.

thanks

 

[georgedwilkinson]

How long will this database be used? Is it a one time deal?

My experience with utilities tell me that they already store MOST of the data you mention...why not just use that and add the little bit that you don't have?