Access 2007 Question

[Fly Boy 5]

I'm trying to design a database to track build time for equipment and issues
by assembly. All equipment has a model, serial and job number to track them.
The 3 assemblies would be Fed-Sep, Filler and loader. Issues by date
incurred would be:
design, drawing, parts qty, wrong parts, bill of material, quality ect.

Please give me some ideas.

Thanks, Jim

 

[John W. Vinson]

I'm trying to design a database to track build time for equipment and issues
by assembly. All equipment has a model, serial and job number to track them.
The 3 assemblies would be Fed-Sep, Filler and loader. Issues by date
incurred would be:
design, drawing, parts qty, wrong parts, bill of material, quality ect.

Please give me some ideas.

Thanks, Jim

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

Identify the Entities (real-life things, people or events); each type of
Entity gets its own table. Each entity has Attributes - distinct, atomic,
non-repeating chunks of information you need to know about the entity; each
Attribute is a field. Identify the Relationships between the tables... and
you're on your way.

John W. Vinson [MVP]