Results 1 to 9 of 9
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I need to learn access, from scratch, zilch knowledge. I would appreciate some pointers to both online resources and books that will assist me in my quest.

    I have jest watched the first 3 you tube videos in the access 101 series and gave up BORED RIGID!! I need something a little less dull (Sorry Richard). Any suggestions?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    It might be worthwhile to check if there is an Access course you can follow close to where you live/work and in the near future.

    About books: see http://www.wopr.com/index.php?showtopic=345723. It's some years old so there will probably be new editions of the books mentioned there, but they should still be relevant.

    I have learned a lot from studying the sample databases provided by Microsoft. See Post 716059 for links.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Oh, and two very useful posts by SteveH:

    Tips'n'Tricks
    Normalization

  4. #4
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Great links! Thanks Hans.

    I think you may be right about a course, but I would prefer an online alternative that I can fit in as and when.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Have a look at this site, quite good tutorial and hraphics.

    http://www.bcschools.net/staff/AccessHelp.htm

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    [quote name='VegasNath' post='780141' date='16-Jun-2009 12:32']Great links! Thanks Hans.

    I think you may be right about a course, but I would prefer an online alternative that I can fit in as and when.[/quote]
    One issue before you start studying in detail is what version of Access you have. If you have 2000, 2002, or 2003 then there are any number of good books and training facilities online. But if you have 2007 then the User Interface has changed enough, and some functional "enhancements" have been added that make it better to work with books and training focused specifically on 2007.
    Wendell

  7. #7
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='780121' date='16-Jun-2009 18:12']Oh, and two very useful posts by SteveH:

    Tips'n'Tricks
    Normalization[/quote]

    Hans, I am honoured - thank you for the plug
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  8. #8
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Hong Kong
    Posts
    359
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='SteveH' post='780192' date='17-Jun-2009 07:58']Hans, I am honoured - thank you for the plug [/quote]
    Hi Steve,
    Thank you for sharing your valuable knowledge with us. Even though some (such as error trapping by macro) may no longer be applicable to 2007, it's still useful as a whole. I wish those popular books (Inside Out, Bible, Dummies, Missing Manual,...etc.) on Access would cover your time-saving golden rules.
    Thanks again. Have a nice day.
    Armstrong

  9. #9
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Hong Kong
    Posts
    359
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Vegas,
    [quote name='VegasNath' post='780117' date='17-Jun-2009 00:44']I need to learn access, from scratch, zilch knowledge. I would appreciate some pointers to both online resources and books that will assist me in my quest.

    I have jest watched the first 3 you tube videos in the access 101 series and gave up BORED RIGID!! I need something a little less dull (Sorry Richard). Any suggestions?[/quote]
    You and I are more or less on the same boat. After a month of intensive study, I suppose the basic working knowledge can be covered in 7 layers within 6 to 8 weeks, especially if you have some background on relational database.
    1. Tables
    2. Queries
    3. Forms
    4. Reports
    5. Macros
    6. VBA
    7. Advanced level

    I doubt the value of video watching. The key to succeed Access learning is to actually create a lot of tables, queries, forms, reports, macros, and VBA codes. Above all, raise a lot of questions here on this forum. You won't regret the efforts you invest in Access learning. BTW, consider using Access 2007, which is significantly better than 2003 in terms of functionalities and performance.
    Just my 2 cents.
    Armstrong

Posting Permissions

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