PPM database sample

[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

 

[Jeff Boyce]

Kyle

Have you tried searching on-line with your favorite search engine?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[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.

 

[John... Visio MVP]

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

 

[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.

 

[Keith Wilby]

"bone up" santus

<snipped drivel>

http://home.tiscali.nl/arracom/whoissteve.html