From the Ground up

[Logandouglasbr]

Hey all, I'm brand new here because I inherited my companies "database" and I need to restore some semblance of order but I've never used Access.

What I have is a number of excel spread sheets establishing a hierarchy of data and I would like to create a real database so we can stop the redundancy. In my spreadsheets I have;

Multiple Companies, each company has several foremen, each foreman has several routes, each route has several pad, each has several well, then for each well there are results for every month of testing and multiple tests. Is there a way to make a cohesive database of this?

I'm sorry if I sound completely out of my mind, it's all a little overwhelming for me having never used the program. If you can give me any help or direction I would greatly appreciate it.



I am using Access 2007

[orange]

Do you have any experience with Data Base?
Do you have any experience with Systems Development or Standards?
Do you have any documentation about your Business and the major Business Processes?

Knowing Excel may be a hindrance because you have to unlearn one object model and activities and learn another.

Does you company have a planning area for any aspect of the business -- new markets, building relocation.. anything?
How successful is it?

You can certainly read tutorials and do practice exercises but that can be a slow and tedious approach.

Is your company big enough to bring in a designer, or send you off on some training? If you go through some of June7's posts on the forum, you will see her company brought someone in to do some development and to mentor her.

Good luck with whatever you decide. But I have to emphasize that data base and spreadsheet are very different.