Results 1 to 2 of 2
  1. #1
    zachlunch is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    7

    Question Move big tadabase to desktop student template database access 2010

    I need to move an existing database of one big table of 500 records. The student database has multiple tables that seem to sync up, like students and guardians. I want to have those connection.

    Right now records of students and parents are all in one with a ton of fields. fields like last name, parent name, student name, etc. I want to split this up between all the nice neat tables in the desktop student database, but when I go to say students and guardians table, they should be synced to one record, although they are originally in their respective student/guardian tables.

    The only way I have gotten close to getting this the correct setup is when I use forms to slowly enter information one record at a time, which I want to avoid, obviously.



    Any help would be appreciated, and I'll work with any assistance I can get. Thank you for reading my post.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,528
    Access has a wizard to help normalize a flat file. This appears to be a good tutorial http://symplebyte.com/microsoft_offi...ta_access.html

    However, getting the data into already created tables could be a lot trickier, especially if the tables use autonumber fields for primary/foreign key links.
    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. Replies: 4
    Last Post: 08-21-2013, 07:08 AM
  2. Replies: 5
    Last Post: 01-01-2013, 09:15 AM
  3. access student database template
    By austinpeay1999 in forum Access
    Replies: 6
    Last Post: 06-19-2012, 03:43 PM
  4. Replies: 2
    Last Post: 06-12-2012, 03:48 PM
  5. Move all access 2003 data to sharepoint 2010
    By accesstosharepoint in forum SharePoint
    Replies: 0
    Last Post: 10-22-2011, 08:32 AM

Tags for this Thread

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 - Senior Forums