+ Reply to Thread
Results 1 to 3 of 3

access or Excel

  1. #1
    Forum Contributor
    Join Date
    06-15-2007
    Location
    Scotland
    Posts
    142

    access or Excel

    Hello, I wonder if somebody could tell me the advantage of having a datamanagment aplication trhough excel or Access.
    The reason that I am asking is because I am really familair with excel but not with access, and in the past I made my excel sheet work fine with data except when amount of data is too large, at that point the routines get very slow going trhough the whole collection of data just to find it.

    Does any body has enoguh knowledge to tell me the main advantage to use access and also if will be easy to use vba?

    Also any idea if there is any forum similar to this but in access?

    best regards and many thanks to all the people that alwasy has help me.

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Access or Excel

    Here's a general comparison of Excel and Access:
    http://office.microsoft.com/en-us/he...429181033.aspx

    For on-line MS Access help....
    This site has some great talent:
    http://www.utteraccess.com/

    and this is the lead page for the Microsoft Newsgroups:
    http://www.microsoft.com/office/comm...tOverview.mspx

    Regarding VBA, MS Access has a different object model from Excel. If you are already comfortable with VBA, then the web resources above can help. The biggest obstacle will not be VBA, though. It will be training yourself to expoit Access' database functionality. Again, the above websites can help.

    I hope that helps.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Contributor
    Join Date
    06-15-2007
    Location
    Scotland
    Posts
    142
    Ron, Many thanks for the explanation I found the material very good.
    an yes I agree with you last statement
    cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1