Results 1 to 3 of 3
  1. #1
    dpick is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    2

    Best Practice Guidance

    Need advice:


    Background:
    I’m designing a new Access 2013 database. I receive a Spreadsheet report quarterly which I will import into Access. When I receive the second quarters Spreadsheet I want to see what changed from the previous quarter and do some simple addition. In addition, I will need to keep all four quarters for end of year reports.
    Problem: I’m perplexed on how to handle the import of each subsequent report. Do I create a new table each quarter? Or do I append to the original? I want to create a form which will contain buttons to run queries. Such as, if field “A “is blank first quarter and again in the second quarter display “ID”.
    If I create a new table each time, how can I relate the Form buttons with the newly created table without having to recreate the queries behind the buttons each quarter?
    On the other hand, if I have one continues table the field “Computer Name” would be listed up to four times (one for each quarter) with a different ID number. How would I link them back together to validate the differences?
    Display Name Publisher Version Install Date Computer Name User Name
    Adobe Acrobat X Pro Adobe Systems 10.1.16 20151105 APGRNBC3G2J06 Michael.J.Murphy

    Thank you for your time.
    Dpick

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,426
    Do I create a new table each quarter? Or do I append to the original?
    append append append

  3. #3
    dpick is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    2
    Okay thank you.

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

Similar Threads

  1. Best practice for deploying Database
    By saudkazia in forum Access
    Replies: 4
    Last Post: 10-08-2015, 10:46 AM
  2. Need a bit of guidance
    By pipermac in forum Access
    Replies: 3
    Last Post: 10-14-2014, 08:18 AM
  3. Access sharing best practice?
    By DB88 in forum Access
    Replies: 2
    Last Post: 05-06-2014, 12:49 PM
  4. Best Practice for Access, Macro, SQL
    By seageath in forum Database Design
    Replies: 0
    Last Post: 02-27-2012, 09:34 PM
  5. Best practice?
    By thekruser in forum Queries
    Replies: 2
    Last Post: 09-20-2010, 09:41 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