Access with excel.

[Aris]

Default Simple question...
I have a workbook I made that the other PM's in my office use as well. It has several worksheets and I want to add
to it so our jobs have everything in it's own workbook and not need different workbooks.

Here is what I want to do and I was wondering if Access can help me achieve this.
When we do change orders, we have a different excel sheet for that. On average, we can have around
30 change orders per job. Each change order workbook has 4 work sheets. Instead of having 30 different files,
I want to have it so when we make a change order, it saves the entered info into the job "database", and when needed, can be pulled back up again. This way, we have one workbook, and I can have a menu that you pull down, select the change order number, and it fills in from the database.
I assume this would keep the workbooks down and size as well. Is this how access works? I can totally re do my entire workbook I created to make it more streamline!


Cross post:
http://www.mrexcel.com/forum/microso...-question.html

[alansidman]

Here is a short read on the fundamentals of db design. I think that after you read this you will have a better understanding of RDBMS. I think if you are willing to jump into Access you will find it can do what you are looking for. Not a simple task and access has a steep learning curve. The end product will make it worth while.

http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf