PPM database sample

K

Kyle

I am looking for a sample MS Access database to keep track of manufactured
product that allows me to calculate the Parts Per Million (PPM) after a
period of collecting data.

Thanks
 
J

John W. Vinson

I am looking for a sample MS Access database to keep track of manufactured
product that allows me to calculate the Parts Per Million (PPM) after a
period of collecting data.

Thanks

Ummmm....

You're not going to find a premade database designed to fit your very specific
requirements. It should be pretty easy to build one from scratch though, if
you can identify the "Entities" (real-life people, things, or events) of
importance, and for each kind of Entity identify its relevant "Attributes"
(discrete chunks of information about that entity); each kind of Entity will
get a table, and each Attribute will be a field. See the references at:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials



You don't say what kind of product, or PPM of what, or what data you're
collecting, or I might have some table design suggestions.
 
S

Steve

If you don't have the time to "bone up" on Access to be able to create your
own database, I can create a "starter" database for you to the completion
degree you want that will meet your requirements. I provide help with Access
applications for a modest fee. If interested, email me at (e-mail address removed).

Steve
 
J

John... Visio MVP

Steve said:
If you don't have the time to "bone up" on Access to be able to create
your own database, I can create a "starter" database for you to the
completion degree you want that will meet your requirements. I provide
help with Access applications for a modest fee. If interested, email me at
(e-mail address removed).

Steve


Time to say good bye stevie....

These newsgroups are provided by Microsoft for FREE peer to peer support.
Stevie is a known troll who harrasses posters with offers of help at
reasonable/modest fee. There is nothing reasonable or modest about stevie's
fees and his help is overpriced even when it is free.

John... Visio MVP
 
K

Kyle

This project I am thinking to setup which it is caught me stuck. I need to
track number of board technician tested today, number of boards passed and
number of boards scrapped after final testing. These products I am referring
to are either electronics board or mechanical components.

After data collect, I need to run a daily report of how many individual type
of board or mechanical components fail or pass. It could be in batch of same
components. I also need to calculate PPM of the products after shipped and
return for service due to defective. This database will also handle the
product (board or mechanical) repaired and returned for service.

In order for me to collect the data, I need some way to track individual
piece of product (board or mechanical components). Some components have
serial number (SN) for tracking and some do not have SN. Some have both SN
and description; some with description but no SN. For instance, I need to
track a single piece of “A†or batch of five “Aâ€s shipped to customer when
one of the five return to service. The primary key of the product is they
all have name or description. But not all have its own ID (such as SN) to
identify the individual pieces that is why I am not sure how to track so that
the PPM report would not calculate the same piece of “A†twice.

I hope you could follow my initial explanation above for this project. Your
suggestion is appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top