I have an idea but I have no idea where to start

[isapple]

Good afternoon.

I am an intern at a manufacturing company.
They asked me to migrate all of their excel spreadsheets onto MS Access.
I pretty much drew out the ERD and created tables, but I had some cool ideas on how to track things, but I have no idea how to start.

First of all, I was trained in MS Access 2010, but the software version that the company has is MS Access 2007 (no navigation form )

Its not that different, but the macro builder is significantly harder to use in my opinion.

I just wanted to ask a question.

In my form, I have a field which displays "units produced" this indicates total units produced for that specific lot.
In the same form, I have a textbox that allows the user to input how many units they produced that way, and a button that adds the units produced and the total units produced for the lot.

So since it is a manufacturing company, I thought it would be good to track daily output of our product, so how can I also create a new record on a separate table indicating how many units they produced for a certain day? We could use this for efficiency tests and performance reviews, as we can see the output of every single business day.

so basically, if total units produced was 1000 on june 23
and then on june 24 I produce 320
on the original production table, it would state: June 24 and then 1320
and on the other table, it would state: June 24 and then 320

thank you!

 

[Uncle Gizmo]

I don't understand why you want two tables, just sum the quantities in one table...

 

[isapple]

I want to keep track of how many are produced daily... so at the end of the month we get a daily avg which will be useful later when doimg analysis

 

[Uncle Gizmo]

Sorry... still not getting it, but it is late, might have a look tomorrow...

 

[plog]

so basically, if total units produced was 1000 on june 23
and then on june 24 I produce 320
on the original production table, it would state: June 24 and then 1320
and on the other table, it would state: June 24 and then 320

That's not how databases are to work. You don't store redundant data, so you wouldn't store a running total, you would calculate it when you need it.

I suggest you post your relationships table so we can help you make sure you have the correct structure. My guess is you just need to search this forum for 'running total query'.

 

[isapple]

That's not how databases are to work. You don't store redundant data, so you wouldn't store a running total, you would calculate it when you need it.

Ohhh.. I see.
That actually makes more sense.
Thank you!

 

[gemma-the-husky]

seriously, this depends how experienced you are in access, and it sounds like not ever so.

changing excel to access can be a major project. Without being patronising, the fact that you think you need a separate table to store easily calculated data indicates you may not find this project so easy.

If your firm has a budget for this, I would get some professional help in to help you. I think this will be a much more productive way of proceeding.

Personally, I do not like using any version of access after A2003, but pretty well everything in A2010 is in A2007. Just press F11

 

[isapple]

I'll give it the rest of the week, and then if I'm really stuck I'll talk to my manager about the status