Question Help

[AndyPandy]

Hi Need help with the following. I need this spreadsheet turning into a database as I believe access with give me what I need .

It needs to be tabbed like a website I.e. eng search View checklist, amend delete, add

How it is to work.

I enter the engineer number it them show me if that engineer is off and which engineer is covering, also as covering engineers can cover more than one area I will need it to show me if it finds duplicates of the same covering eng if they are covering more than one area and which area

i.e.

Enter Engineer Number – Shows engineer branch region, comments, covering eng telephone number, if covering eng covers more than one area area eng weather data is there or not I want it to display,

Covering eng also covers
Eng Branch, region comments and telephone number.

So when I do a search it will show me who is covering if the covering engineer is covering more than one area.

thanks

 

[plog]

That's a good overview of the specific project, now what can we specifically help you with?

Since you didn't ask anything specific, I'll give you general advice.

1. The first step is to set up your tables correctly. Don't worry about forms or reports. Read up on "database normalization" (google that). Make sure that is correct.

2. Create the reports you need. This is a two part, iterative process that starts with building a query to provide you with the data you need. Once that query is built, set up the report, format it, place all the data elements on it that you want. If you don't have the data elements you want, or think of new ones, head back to the query and add them. Wash, rinse and repeat until the report is correctly set up. Do this for every report you need.

3. Now you get to build forms. A good rule of thumb is that each table that can be modified should have its own form. Sometimes this involves sub-forms when one to many and many to many relationships exists between your tables.

If you have specific issues, feel free to post back here with what you are trying, any error messages you are receiving and the results you expect to receive.

Good luck.

 

[AndyPandy]

Thanks for that

I just need help with the table design and the query design in order to get what i want from it could you start me off please.

 

[plog]

I can point you in the right direction:

http://en.wikipedia.org/wiki/Database_normalization

And I can help you with specific questions once you've taken a stab at it.

 

[AndyPandy]

Ok this is what i think is correct 1st

Table Eng

Engineer ID
Engineer Num
Eng Commens
BranchID

Table Branch
BranchID
Branch Name
Region

CovEng table

Cov EngID
Cov Eng Num
Comments
Telephone Number
Branch ID

 

[plog]

In english, what's the difference between the Table Eng and CovEng table? Why is this data seperate?