Results 1 to 3 of 3
  1. #1
    bmantz65 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Mar 2013
    Posts
    1

    Access 2003: New table design help

    I maintain an Access Database for my team at work. My team is supplying the table data in a new format that I am supposed to upload into the database. I have attached an Excel file to give you an example. The new format is on the first sheet entitled "New Data Format". The old data format they supplied me and what I uploaded directly into the database is on the "Old Data Format" sheet.



    How would I go about incorporating the new data format into the table design? Note: This is a blank table with no existing data in it, so I can modify the design.

    I do queries off this data. For example, a report that shows which people are assigned "Role 2" or which courses are people taking who have "Role 3" (A separate table maps the roles to courses).

    Thank you
    Attached Files Attached Files

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    http://databases.about.com/od/tutori...xcelsample.htm

    This is an example that should help. Good luck with your project.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Your Old structure is actually more normalized.

    The New structure is basically a CROSSTAB of the Old.

    The queries you want to do will be easier on the Old structure.
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2003 Table Linking Issue.
    By Tripurari in forum Access
    Replies: 4
    Last Post: 01-29-2013, 06:37 AM
  2. Replies: 31
    Last Post: 07-31-2012, 05:28 PM
  3. Missing Records in a Table (Access 2003)
    By Shayne in forum Access
    Replies: 7
    Last Post: 10-13-2011, 07:13 AM
  4. Update table MS Access 2003
    By riagil in forum Queries
    Replies: 2
    Last Post: 08-31-2010, 12:12 AM
  5. Access 2003 - Creating Buttons from a Table
    By Speedy in forum Programming
    Replies: 2
    Last Post: 02-28-2009, 05:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums