New to Access, need direction and help. Access 2002

[Guest]

Filter Data Base, explanation of what I am trying to build in Access 2002

What I have written in regards to tables I have completed, where do I go
next? I would like suggestions if what I have looks reasonable. I now would
like to build a form I guess that would allow me (Many) to enter data. I
would also like to lock this form so data can be entered but no one could
mess with the setup.

Tables & Fields, All dates to open on current date but, start Sept 2005. I
have info I would like to update once this is built. A 24 hour day is
midnight to midnight.
I would like when the data entry form is opened up that the date is always
current.

The table name in on the left and what is in the table is tabbed over.

Filters added to LDY (Lay down yard)
Date, Filters added
Filters added to LDY, This will add to Filters in LDY (6 numbers)
50 to 100,000

Filters at LDY
Filters in LDY (6 numbers) When the form is opened you could se the
current total
Removed LDY to Sea Can, This will add to Filters in Sea Can (4
numbers). A Sea Can is a big steel big as you would see on a ship.

NOTE: At this time I am not sure once we receive a new load of filters we
will be only using the lay down yard and do away with the Sea Can.

Filters in Sea Can
Filters in Sea Can (4 numbers) No more than 5,000
Date, current
Removed Sea Can (3 numbers) Usually 800, This will be the running
total filters removed to the field updated from below (Add to A-8, A-10 etc)

Sea Can to Field (3 numbers)
Add to A-8, a number here would give a date and number to “Removed
Sea Can†and update “Filters in Sea Canâ€. It would also show up at Table A-8
“Filters Addedâ€
Add to A-10, Same as A-8 (3 numbers)
Add to A-12, Same as A-8 (3 numbers)
Add to A-17, Same as A-8 (3 numbers)
Add to B-6, Same as A-8 (3 numbers)

A-8, Filters at Site
Date filters added to field
Filters Added, This will update “Filters at siteâ€
Filters at site (3 numbers)

A-8, Filter Skid Change; I have a lot here but I am breaking it up.
Date / Time filters were changed
113, Number of filters needed to change a set of used filters (A-12
filter change is 66)
Skid 1 ON, When skid 1 is ON then Skid 2 is OFF.
Start 1, Injection well totalizer start number (7), used to determine
barrels injected while skid was on line and how long filters are lasting.

Skid 1 OFF, Clicking this would allow,
Manual entry of “Finish 1†and once the ENTER key is
HIT, transfer it to “Start 2â€, Turn Skid 1 OFF & Turn Skid 2 ON.

NOTE: After the first “Start†entry it shouldn’t be needed to be entered
again as it will come from the “Finish†entry. It may be needed to be
adjusted in case of meters problems.
Subtract (113) from “Filters at site†and update “Filters at siteâ€.

NOTE: All totals to reset to zero @ Day end, Week end, Month end & Year end.
I will have to figure out a way to save this information year to year.
All totalizer figures to 7 numbers.
Update “Filters Used (D)†Day, on a bad filter day, filter skids could go
back and forth several times.

Update “Filters Used (W)†Week at well site
Update “Filters Used (M)†Month at well site
Update “Filters Used (Y)†Year at well site

Give “Total Barrels 1†Total barrels injected while Skid 1 was on line.

Update “Total Barrels (D)†Day at well site
Update “Total Barrels (W)†Week at well site
Update “Total Barrels (M)†Month at well site
Update “Total Barrels (Y)†Year at well site

Skid 2 ON, When skid 2 is ON then Skid 1 is OFF.
Start 2, Injection well totalizer start number, used to determine
barrels injected while skid was on line.
Skid 2 OFF, Clicking this would allow, Entry of “Finish 2†and once
the ENTER key is HIT, transfer it to “Start 1â€, Turn Skid 2 OFF & Turn Skid 1
ON.
Up-date rest same as Skid 1.

NOTE: I will build below after A-8 is working. How do I build something that
would allow me to simply add a new site as below? All sites are the same
except A-17.
A-10, same as A-8.
A-12, same as A-8.
A-17, the only difference with A-17 is it has 3 skids of which 2
could be on line at once.
B-6, same as A-8.


Disposal Totals, Day_Month_Year. Information from each disposal well would
update here.
Update “Filters Used (TD)†Day from all disposal wells
Update “Filters Used (TW)†Week from all disposal wells
Update “Filters Used (TM)†Month from all disposal wells
Update “Filters Used (TY)†Year from all disposal wells
Update “Total Barrels (TD)†Day from all disposal wells
Update “Total Barrels (TW)†Week from all disposal wells
Update “Total Barrels (TM)†Month from all disposal wells
Update “Total Barrels (TY)†Year from all disposal wells

Later in a “Reports†I would like to Graph in MS Excel the (D), (W), (M) &
(Y) of each well and the (TD), (TW), (TM) & (TY) of all disposal wells.

Add in comments box for;
Pigging program (when the pigs are sent). pipeline cleaners
Corrosion & Chemical dosing rate..

NOTE: I know the above seems like a lot but it will be very useful in
diagnosing problems in the process.

 

[Rob Oldfield]

Sorry to be a little sarcastic on a Christmas day, but you might want to
think about posting your questions using the English language. You, I hope,
understand what you're after, but I think you'll be the only one.

 

[Guest]

No problem, I will re-think my question.


Regards,
Drew

 

[Guest]

I would like to build a data base in Access. At my work we go thru a pile of
cotton filters. We order 50 to 100,000 at a time. We store the major part in
a lay down yard. We move 5,000 lots to a smaller storage area.

From there we move them usually 800 to 1000 at a time to 5 different sites
for use. I would like to track the filter usage at each site and the thru put
of each filter skid.

I would also like to track the filter / thru put usage at each site on a
daily, weekly, monthly and yearly basis.

What would be a good way to set this up?

Hopefully this will be easier to understand.

 

[tina]

based on your first post, and this last clarification post, i'd say your
table design is not normalized. i can't over-emphasize the importance of
good table design as the most important, and first, step in developing a
database - forms should not be considered until you have a solid foundation
to build them on. recommend you *stop* and learn the basic principles of
relational design before you go a step further - as it is, you're going to
have to undo much of what you've done, so there's little point in continuing
until you've built a solid tables/relationships foundation. see
http://home.att.net/~california.db/tips.html#aTip1 for more information on
relational design, or data modeling.

hth

 

[Guest]

Hi Tina,

Thank you for the direction.

Regards,
Drew

 

[tina]

you're welcome

Hi Tina,

Thank you for the direction.

Regards,
Drew