Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: MS Access question

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Palo Alto, CA
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This is probably a dumb question, and yes I know this is an Excel forum, but why would someone need to learn to use MS Access if they were already proficient in Excel (besides the fact that Excel is limited to 64000 rows or something)? In other words, what can Access do (or do better) that Excel can't?

    And can anyone recommend a comprehensive intro book to Access? I've seen a few popular ones (Mastering Access, Using Access, and the Access Bible), but don't know which to get.

    Thanks

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Access is great for databases, and creating reports.

    Excel has the ability to be more proficient in calculations and formulas than what access is limited to.
    Colin

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you get into many records then Access is much faster at retrieving info. You can also use SQL with Access. With VB or VBA you can actually use SQL with Excel as well. I'm learning both. Excel seems to have some decent built in database workings...
    Use Access to store your data and Excel to play with it.
    Tom

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Palo Alto, CA
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sounds good. Thanks.

    Anyone got any book recommendations/preferences for Access?

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No. Not really any up to date recommendations.
    I'm using a book by Que publishing for Access 97. I don't have the book in fromt of me at the moment.
    It's been good enough for me so far.
    Tom

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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