Results 1 to 11 of 11
  1. #1
    Join Date
    Aug 2008
    Posts
    78

    Unanswered: Book Reccomendations

    Besides google and that kind of research, what would be 3 good books to have for someone who is a past beginner in SQL but not advanced? Looking to expand my SQL knowledge as it relates to Access.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Book1 Access xxxx desktop Developers Handbook where xxxx is the access version (year), published by Sybex, autohers Litwin, Getz & Guberloy
    Book2 Access xxxx Enterprise Developers Handbook where xxxx is the access version (year), published by Sybex, autohers Litwin, Getz & Guberloy
    Book3 ... pick any one of the reaminder

    or
    book1 Access Developers Handbook (includes both the dektop and enterprise books
    Book2 & 3 ... pick any one of the remainder
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2008
    Posts
    78
    Thanks for the list. I did buy those about a month and a half ago when i was first starting out based on advice here. They're pretty helpful, esp the code lib on the cd.

    i was thinking more of a book that focuses on SQL. I know that access has some SQL specific syntax that can't be used in general SQL. Any books like that? Almost just pure SQL?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, i have a "pure SQL" book coming out in december, see my sig

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by PonPending
    I know that access has some SQL specific syntax that can't be used in general SQL.
    It is more difficult to name RDBMSs that do not include propriety SQL and stick to the standard than those that do. BTW - Access has a SQL Server combitibility option, which puts it closer to the ANSI 92 SQL standard.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by pootle flump
    It is more difficult to name RDBMSs that do not include propriety SQL and stick to the standard than those that do.
    mimer

    now it's not difficult at all

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Aug 2008
    Posts
    78
    I'd like to use create statements to create some sample datasets to run thru some examples I found. Sure would be nice to paste in:

    Code:
    CREATE TABLE EMPLOYEE_TBL
    (
    EMP_ID              VARCHAR2(9)       NOT NULL,
    LAST_NAME           VARCHAR2(15)      NOT NULL,
    FIRST_NAME          VARCHAR2(15)      NOT NULL,
    MIDDLE_NAME         VARCHAR2(15),
    ADDRESS             VARCHAR2(30)      NOT NULL,
    CITY                VARCHAR2(15)      NOT NULL,
    STATE               CHAR(2)           NOT NULL,
    ZIP                 NUMBER(5)         NOT NULL,
    PHONE               CHAR(10),
    PAGER               CHAR(10),
    CONSTRAINT EMP_PK PRIMARY KEY (EMP_ID)
    );

    I was able to get this far:

    Code:
    CREATE TABLE EMPLOYEE_TBL (
        EMP_ID Text(9), 
        LAST_NAME Text(15),
        MIDDLE_NAME TEXT(15),
        ADDRESS TEXT(30),
        STATE TEXT(2),
        PHONE TEXT(10),
        PAGER TEXT(10)   
    );
    But not sure of the syntax for defining a primary key using access. Would be great to right click on an existing table and have it export 'CREATE' DDL specific to access.

    Anyone know the proper syntax for Primary Key in a Create statement in access?

    I could type the data up in txt files or a spreadsheet and then link it.. but I want to build standalone tables using the CREATE statement. I guess it's these differences i'm looking for in a book or maybe I just deal w/it on a case by case basis..

    Also.. just some good SQL Books in general..

  8. #8
    Join Date
    Aug 2008
    Posts
    78
    NVRMD - I had a typo in my syntax.. that create statement works..

    Either that or i checked off the ANSI-92 compatibility (thx Pootle) and it's working now...


    So, any intermediate SQL Book reccomendations?

  9. #9
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I didn't post before as you asked re standard SQL, however these are excellent for JET SQL.
    http://msdn.microsoft.com/en-us/library/aa140011(office.10).aspx
    (check the margin for Intermediate and Advanced SQL articles).

    BTW - not many Access users use DDL - just FYI
    Testimonial:
    pootle flump
    ur codings are working excelent.

  10. #10
    Join Date
    Aug 2008
    Posts
    78
    meaty link! Went right to my bookmarks.. thanks for the launch point!

  11. #11
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Mine too. Thanks PF.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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