Results 1 to 3 of 3
  1. #1
    rjbeck52 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    1

    Access for tracking statistics

    Brand new to Access. I am trying to find a system to track multiple monthly statistics for approximately 100 individuals. There are about 20 categories and I would like to track both individual stats and group stats for each category. Ideally the individuals would be able to submit there information on-line. Is this possible and/or reasonable utilizing access?

    Bob

  2. #2
    RedWolf3x is offline Advanced Beginner
    Windows 7 32bit Access 2003
    Join Date
    Jul 2011
    Posts
    31
    This is something that can be worked out with some time in access. I recommend using an external datasource for the tables. Generally speaking Access is a single user database and if you want you update from multiple people you will want to use the external tables.

  3. #3
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Quote Originally Posted by RedWolf3x View Post
    Generally speaking Access is a single user database and if you want you update from multiple people you will want to use the external tables.
    Say WHAT? What are you talking about? Access is not a single user database and it works fine with multiple users and using INTERNAL tables as well. I am not sure where you came up with that but it is very, very incorrect. If it is set up properly, you can have quite a few users using it.
    I've had well over a hundred users using the same database. You need to split the database to a backend (tables only) and a frontend which gets copied to every user's machine. And with that set up you can have many users inputting or updating data at the same time.

    So for rjbeck52, I would like to know what kind of statistics? Where do they come from? What exactly is it that you are wanting to track?

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

Similar Threads

  1. Replies: 1
    Last Post: 06-06-2011, 06:50 PM
  2. Employee Tracking
    By nycon in forum Access
    Replies: 6
    Last Post: 10-27-2010, 05:42 PM
  3. library statistics
    By sonia in forum Access
    Replies: 1
    Last Post: 04-11-2010, 12:22 PM
  4. tracking
    By mugziegumz in forum Access
    Replies: 0
    Last Post: 11-20-2008, 10:11 AM

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