Results 1 to 12 of 12
  1. #1
    Lounger
    Join Date
    Jan 2005
    Location
    Colorado Springs, Colorado, USA
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Best Instruction (2000)

    Hi All

    What are some suggestions for the best books out there for learning Access 2000?

    Thom

  2. #2
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Instruction (2000)

    There are lots of good books, but I have found a great deal of good information including tutorials at this web site.
    http://functionx.com/access/
    Carla

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Best Instruction (2000)

    What part of Access are you trying to learn? If you want to learn how to use it, one of the Microsoft Press Step-by-Step books would be helpful. If you want to learn how to program it, one of the best books to start with is Beginning Access 2000 VBA.
    Charlotte

  4. #4
    Lounger
    Join Date
    Jan 2005
    Location
    Colorado Springs, Colorado, USA
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Instruction (2000)

    Thanks...But as you can see I am just a young pup. :-)

    I have done quite a bit on the computer in my past life, so I believe I can learn just about anything given the right instructions. It's just I have been away from programming for awhile.

    Thom

  5. #5
    5 Star Lounger st3333ve's Avatar
    Join Date
    May 2003
    Location
    Los Angeles, California, USA
    Posts
    705
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Best Instruction (2000)

    I've long been a fan of the Developer's Handbook, which is very highly regarded. (I own the 2.0, 97 and 2002 versions. The authors for the 2002 version are Litwin, Getz & Gunderloy.)

    Starting with the 2002 version (I think), they split the tome into 2 volumes, with Vol. 1 being the "desktop" volume and Vol. 2 (the "Enterprise" volume) getting into multi-user & client/server applications and etc. I just have Vol. 1.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Best Instruction (2000)

    The Access Developers Handbook is a wonderful reference, but not a good way to learn programming Access. It is generally pretty advanced and is more comprehensible when you have the basics of Access VBA under your belt. BTW, the 2000 version was also in two volumes.
    Charlotte

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Best Instruction (2000)

    Depending on the language and environment in which you programmed, Access VBA might be more or less familiar to you. Access 2000 and later are based on VB6, and it is designed to work with either the DAO or ADO object models. DAO is rather convoluted but is optimized for the Jet engine and may be less confusing to start with than ADO. ADO, on the other hand is extremely powerful and the only choice for some operations. If you aren't current in VBA6 or you're unfamiliar with Access, I still suggest the ]Beginning Access 2000 VBA book, which will take you over some of the preliminary humps.
    Charlotte

  8. #8
    5 Star Lounger st3333ve's Avatar
    Join Date
    May 2003
    Location
    Los Angeles, California, USA
    Posts
    705
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Best Instruction (2000)

    Back when I was an Access newbie, the Access 2 Developer's Handbook and Using Access 2 were the books I had. Using Access was definitely more intro-oriented, but I learned a lot more from the Developer's Handbook.

    I'm not familiar with Beginning Access 2000 VBA, though.

  9. #9
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,613
    Thanks
    3
    Thanked 58 Times in 58 Posts

    Re: Best Instruction (2000)

    Another book I like is Alison Balter's Mastering Access Development. For 2000 it was a single volume, but in 2002 it was split into a Desktop and Enterprise volumes. The 2002 set in particular is at a beginning to intermediate level, but also provides a good deal of pragmatic advise regarding pitfalls and traps you can fall into.
    Wendell

  10. #10
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Best Instruction (2000)

    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> The ADH was among the few really good references on Access 2. I had it as well, but Access Basic was its own language, written in Assembler, and was fast but extremely Access-specific. As VBA became the scripting language for Access, things became more complicated. People coming from Word and Excel see a familiar syntax but a totally unfamiliar object model. A book on beginning VBA for Access helps clear the confusion. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  11. #11
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,613
    Thanks
    3
    Thanked 58 Times in 58 Posts

    Re: Best Instruction (2000)

    I strongly agree - the other books mentioned talk briefly about VBA, DAO and ADO, but don't really give it the detailed coverage it needs if you are going to make Access really stand up and do it's thing.
    Wendell

  12. #12
    Lounger
    Join Date
    Jan 2005
    Location
    Colorado Springs, Colorado, USA
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Instruction (2000)

    (wagging my tail)

Posting Permissions

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