Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-22-2017, 01:29 PM   #1
2015imsjfw
Newly Registered User
 
Join Date: Oct 2017
Location: Tucson, AZ, USA
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
2015imsjfw is on a distinguished road
New DB suggestions

I'm new to Access and have some questions.
Goal: Create a Scheduling DB for my Machine Shop
Tasks: Enter Router Data into tables - Job#s 1150-10450 (and counting)

I need some advice on how much of the Router Data to put in 1 table. Each Router has standard info such as job#,dates, part#, part revision, part description, quality info, engineer info, qty, PO #, Contract#,...

The second part of each Router has info for each Operation used to manufacture the part. OP 010, OP 020, OP 030... sometimes up to 30 ops per part.

Should I make a table with just the standard info then a separate table for the ops or each op?

2015imsjfw is offline   Reply With Quote
Old 10-22-2017, 03:38 PM   #2
plog
Banishment Pending
 
Join Date: May 2011
Posts: 9,489
Thanks: 12
Thanked 2,303 Times in 2,254 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: New DB suggestions

The process of setting up database tables is called normalization (https://en.wikipedia.org/wiki/Database_normalization). Read up on it, work through a few examples and then apply the principles to your data.

In general, tTables should be set up to accomodate data vertically (with more rows) and not horizontaly (with more columns). That is, you wouldn't have an [OP010] field, an [OP020] field, etc. Instead you would store the 020 information within a generic field ([OPNumber]). That way instead of 30 fields to accomodate your OP data, you would have 30 records to accomodate the data.
plog is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need suggestions seth.murphine Forms 2 04-15-2011 06:46 AM
Need help and suggestions markquan Queries 2 03-24-2009 07:39 AM
Need suggestions please Glytch Forms 7 11-07-2007 11:19 PM
Any Suggestions? ACE General 5 10-07-2003 12:03 PM




All times are GMT -8. The time now is 06:14 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World