I am trying to create a database to track product defects and yeilds. It
seems to be more time consuming than it should. I cannot find a template
anywhere. Can someone please point me in the right direction?

On Tue, 17 Jul 2007 06:00:00 -0700, QualityPaints
<(E-Mail Removed)> wrote:

>I am trying to create a database to track product defects and yeilds. It
>seems to be more time consuming than it should. I cannot find a template
>anywhere. Can someone please point me in the right direction?

Most Access databases *don't* start from templates. There are templates
around, but they're either very general (inventory databases say) or very
specific (Music Collections say). You almost surely won't find one designed
for the specific task of product defects and yields; for one thing, the design
of such a database would be quite different if the product is organic garden
produce than if the product is Air Force fighter jets!

The right direction would be to either learn about database normalization and
database design (see below), and go through the design steps: one possible
route would be

- Identify the purpose of the database
- Identify all the relevant Entities (real-life things, persons, or events)
needed in the application
- Determine how the entities are related
- Identify all of the relevant Attributes (distinct, atomic chunks of
information) for each type of entity
- Construct Tables - a table for each type of entity, a field for each
attribute
- Make sure there are no repeating groups of fields or other violations of
normal design (see the Database Design 101 link in Jeff's website below)
- Create the tables
- Create Forms to enter data into the tables
- Create Queries to assemble the data into useful collections
- Create Reports to print the data from the queries

A second route would be to hire someone with database design skills and
experience to do it for you. If you do, expect to work with them closely,
participating in the design - if they won't do that, watch out!

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

John W. Vinson [MVP]