Results 1 to 3 of 3
  1. #1
    V455764 is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2015
    Posts
    1

    Where do I start to build a database?

    Hello

    I am a complete newcomer to access and databases.

    I have 2 folders on my desktop that have about 2900 (It grows every day) .csv files that I would like to get into a database.

    I have an idea how I want the finished article to look/work and very basic understanding of how access and excel work. I mention excel here as a lot of fields I need are calculated from the data I have (lots of counts, percentages and ranking info) that will need to be analysed.



    I can provide a copy of one of the files if this helps.

    Thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I would start by Googling for MS Access Templates. You will probably find one that will work for you and save a *bunch* of time.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Save raw data, do calcs in queries and reports.

    Review http://www.rogersaccesslibrary.com/
    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. Build a database
    By chaddresnick in forum Access
    Replies: 2
    Last Post: 03-17-2015, 01:31 PM
  2. Using VBA or macros to build a database
    By Access_Novice in forum Access
    Replies: 11
    Last Post: 01-07-2015, 11:43 AM
  3. Replies: 2
    Last Post: 08-22-2014, 11:04 PM
  4. Build Database for Business
    By aggiemarine07 in forum Access
    Replies: 3
    Last Post: 11-07-2012, 03:50 PM
  5. Seeking someone to help me build my own database
    By Meat4grinder in forum Access
    Replies: 7
    Last Post: 08-11-2012, 10:04 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