SQL for Microsoft Access, Second Edition (Wordware Applications Library) [Paperback]

Cecelia L. Allison (Author)

Book Description

ISBN-10: 1598220608 | ISBN-13: 978-1598220605 | Publication Date: June 20, 2008 | Edition: 2

SQL for Microsoft Access, Second Edition provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language. Step-by-step examples demonstrate how to use SQL script to create tables, add records to tables, and retrieve and manage records. Readers will also learn about calculated fields, Access projects, and the integration of SQL script in VBA and ASP code.

Editorial Reviews

About the Author

Cecelia Allison is an experienced software tester and technical support specialist with extensive hands-on experience using and teaching SQL. She wrote and facilitates an on-line course titled Introduction to SQL that is offered through hundreds of accredited colleges, universities, and other educational facilities around the world. She also facilitates on-line technical courses for ITT Technical Institute and Park University. She holds a bachelor’s degree in finance and a master’s degree in computer information systems.

Neal Berkowitz is a computer consultant, author, web designer, system analyst, and computer builder with 25 years of experience. An acknowledged Access expert in the Dallas area, he has co-authored four books for Wordware and written a number of articles. --This text refers to an alternate Paperback edition.

Product Details

• Paperback: 360 pages
• Publisher: Jones & Bartlett Publishers; 2 edition (June 20, 2008)
• Language: English
• ISBN-10: 1598220608
• ISBN-13: 978-1598220605
• Product Dimensions: 9 x 6 x 0.8 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.3 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #178,175 in Books (See Top 100 in Books)
  • #81 in Books > Computers & Technology > Databases > Database Management Systems
  • #89 in Books > Computers & Technology > Databases > SQL

More About the Author

Cecelia L. Allison is a published author, technical writer, and an online professor. She writes and facilitates on-line SQL courses (Intro. & Intermed. SQL) that are offered on-line through hundreds of accredited colleges, universities, and other accredited educational facilities world wide.

She wrote SQL Simplified: Learn to Read and Write Structured Query Language and SQL for Microsoft Access 1st and 2nd edition. She also facilitates on-line technical courses for several colleges on-line.

Cecelia has been using SQL for over 15 years. Through her past and present employment as a technical specialist and software tester she has gained extensive experience in writing and implementing SQL. She holds a Bachelor of Science in Finance and a Master of Science in Computer Information Systems

My SQL Courses and Resources:

www.filedby.com/author/cecelia_allison/2495711/

www.ed2go.com

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

3.0 out of 5 stars Excellent Access Primer, September 23, 2007

By 

E. F. Bryan (North Palm Beach Florida) - See all my reviews
(REAL NAME)   

This review is from: SQL for Microsoft Access (Wordware Applications Library) (Paperback)

This book is an excellent primer for the SQL novice. It is well organized and offers an excellent exposition of Microsoft's version of the SQL language. There is just on big problem; it is just about impossible to download the book's companion file offered on the Wordware site. This problem is a serious flaw in an otherwise outstanding book.

4 of 4 people found the following review helpful:

5.0 out of 5 stars Excellent fundamentals explanation, February 3, 2009

By 

Jeffrey B. Stanley "j-stanley" (Elkhart, IN USA) - See all my reviews
(REAL NAME)   

This review is from: SQL for Microsoft Access, Second Edition (Wordware Applications Library) (Paperback)

As somebody new to both Access and SQL, I found this to be my best reference for getting started. It covers the basics and does a great job. You cannot perform advanced objectives without a solid understanding of the fundamentals.
Each chapter has a series of self-test questions to make sure you have mastered the necessary concepts for that chapter. (and the answers are in the back)
There's also quite a bit of good quick reference material in the back for frequently used SQL keywords (for Access) and general database terminology.
I've found it to be a great book and I highly recommend it.

3 of 3 people found the following review helpful:

2.0 out of 5 stars Lots of mistakes, June 9, 2010

By 

Fred King (Portland, Oregon) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: SQL for Microsoft Access, Second Edition (Wordware Applications Library) (Paperback)

This book is loaded with problems. I started using the book three days ago, trying to work my way through the examples. I have only reached page 73 and here are the problems I've run into so far:

On page 48 there is Example 6 that demonstrates how to insert five records into a table. However, the author doesn't mention that you cannot use the example as it is written in the book, and that you have to run the five statement separately. Frustrating!

On page 57 you are instructed to update a Sales table that you have not created (I know, it's in the "Companion Resources". I'll get to that.)

On page 71 you get instructions to order another non-existent table (another companion resource).

On page 73, Example 7 shows you how to order a table by selecting rows. However, the output shown on the page is wrong. It is supposed to put the last names in alphabetical order, but there is no discernible order to the table shown.

Now, about the Companion Resource files. I tried to download them but I got an email saying that they are available only to "qualified instructors"- not just us schleps who shelled out $36 for the book!

Maybe have someone test this book before the next edition!