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
|
|||
|
|||
Access 2007 Question
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 |
#2
|
|||
|
|||
Access 2007 Question
On Sat, 22 Dec 2007 05:51:00 -0800, Fly Boy 5
wrote: 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/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 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] |
Thread Tools | |
Display Modes | |
|
|