Where do I find an access template to track product defects and y.

G

Guest

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?
 
J

John W. Vinson

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/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

John W. Vinson [MVP]
 

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