If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
PPM database sample
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 |
#2
|
|||
|
|||
PPM database sample
Kyle
Have you tried searching on-line with your favorite search engine? -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ "Kyle" wrote in message ... 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 |
#3
|
|||
|
|||
PPM database sample
On Thu, 4 Dec 2008 23:25:01 -0800, Kyle
wrote: 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/acc...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 W. Vinson [MVP] |
#4
|
|||
|
|||
PPM database sample
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 . Steve "Kyle" wrote in message ... 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 |
#5
|
|||
|
|||
Stevie the troll is at it again --- at a modest price.
"Steve" wrote in message
... 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 . 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 |
#6
|
|||
|
|||
PPM database sample
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. "John W. Vinson" wrote: On Thu, 4 Dec 2008 23:25:01 -0800, Kyle wrote: 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/acc...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 W. Vinson [MVP] |
#7
|
|||
|
|||
PPM database sample
"Steve" wrote in message
... "bone up" santus snipped drivel http://home.tiscali.nl/arracom/whoissteve.html |
Thread Tools | |
Display Modes | |
|
|