Results 1 to 5 of 5
  1. #1
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,613
    Thanks
    3
    Thanked 58 Times in 58 Posts

    Book recommendation for Queries (2000 and up)

    One of our clients has a person who acts as their support person, and has some training and experience with Access. She would like to get more in-depth information on queries so she can construct things such as mailing lists and simple summary reports. She asked if I could recommend an intermediate level book on the subject, and the best I could come up with from our personal library was Chapters 4 and 11 in Alison Balter's 2002 Desktop Development. I'm looking for additional suggestions along the same line - advanced stuff such as the Access Developer's Handbook are too much for her at the moment. Thanks in advance.
    Wendell

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

    Re: Book recommendation for Queries (2000 and up)

    So is she looking for a book on SQL or for a book on building queries in Access? Joe Celko has some basic books on SQL that I've always found very useful.
    Charlotte

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

    Re: Book recommendation for Queries (2000 and up)

    I think at this stage it's more about building more complex queries than it is about SQL. She isn't a programmer per se, though she does do web pages using Front Page and has some familarity with HTML. And she's working only with attached tables in the Access environment, though the back-end is SQL Server.
    Wendell

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

    Re: Book recommendation for Queries (2000 and up)

    I've never seen anything really useful on using the query grid to build complex queries. The SQL books might be her best best. Once you understand the SQL basics, the query grid is an easy way to create the actual statements.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    London, Gtr London, United Kingdom
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book recommendation for Queries (2000 and up)

    I am absolutely useless with queries but I do find the tips useful and easy to follow here

    http://[www.fontstuff.com/access/acctut17.htm]

    Maybe this will help

    Stephen

Posting Permissions

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