Results 1 to 2 of 2
  1. #1
    oo0tommyk0oo is offline Novice
    Windows XP Access 2002
    Join Date
    Jul 2011
    Posts
    10

    Question Acces or excel, for handleing my data?

    Hi all, I am just after a bit of advice from Access users here.

    I have to keep track of a list of seat numbers (2000+), each seat number has a heap of data that goes with it.
    -floor
    -tower


    -Employee
    -Employee Manager (3 levels, other levels are worked out from manager)
    -Status (occupied, vacant)
    -work style
    -and a few others

    Seat numbers, floor & tower never change, but employee and others do. I need to keep track of these changes but only as far back as the last change, so who sat there before and how long ago was the change.

    I am currently using excel to do this. It does the basic job well, but in order to get it to record history and such i am going to have to start running some VBA. My question is, would you advise to switch to access? Could access handle this better or will there be little difference, not worth the extra build time?

    One issue is my excel level is intermediate/advanced, where as my access level is basic/intermediate...

    Thank you for any advice

    Tommy

  2. #2
    oo0tommyk0oo is offline Novice
    Windows XP Access 2002
    Join Date
    Jul 2011
    Posts
    10
    I should mention i will not be the only person entering data into the table. Other staff have much lower IT skills. This is one of the reasons i was looking at access, forms are so easy to create compared to excel.

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

Similar Threads

  1. Acces 2003: Import Form
    By compooper in forum Import/Export Data
    Replies: 4
    Last Post: 06-22-2011, 02:51 PM
  2. Visual Basic / Acces Form differences
    By MWMike in forum Forms
    Replies: 3
    Last Post: 10-06-2010, 09:06 PM
  3. Acces 2003 MUI error
    By coudu in forum Access
    Replies: 0
    Last Post: 03-15-2010, 04:53 AM
  4. Replies: 1
    Last Post: 03-10-2010, 04:53 AM
  5. acces listbox hatası(acces debug)
    By carso in forum Access
    Replies: 1
    Last Post: 09-22-2009, 04: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