Novice
Windows Vista 
Access 2010 64bit
I am new to this and would like to have someones opinion on how many and what tables I should create for the spreadsheet that I am attaching. I want to start off on the right foot.
The Accounts (loweast, lowcentral, lowwest, etc.........) refer to states. So I assume that I need a table labeled accounts for which I can put in the states....I just don't know what fields I should combine into one table.
Last edited by sgilleland; 05-31-2011 at 07:50 AM. Reason: Add Attachment
VIP
Windows XP Access 2010 32bit
Your spreadsheet is not attached.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows Vista Access 2010 64bit
File is now attached to original post....thanks
VIP
Windows XP Access 2010 32bit
That PDF doesn't help me understand your data. What is nature/purpose of the data? What information do you want to keep track of? In designing a db, need to determine the entities - customers, products, orders, vendors, employees, etc. - of your data. Determine relationships and design tables to suit.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote