SQL: Access to SQL Server (Paperback)

by Susan Sales Harkins (Author), Martin W.P. Reid (Author)
Key Phrases: stored procedure

Editorial Reviews

Product Description
<p> <i>SQL: Access to SQL Server</i> is more than just a comprehensive reference tool for Access developers. You'll also find efficient SQL solutions for common Access problems and tasks, as well as helpful hints and warnings about what to avoid. Learning Jet SQL is an important step from just <i>using</i> Access to <i>developing</i> with Access. </p> <p> In addition to learning Jet SQL, readers will embark on a journey into the world of SQL Server 2000. The journey starts when you learn how to install SQL Server and ends with an introduction to XML and ASP. Along the way, using Access Data Projects, you'll see features new to SQL Server 2000, including functions that return tables, instead of triggers and gotchas with upsizing. The authors highlight not only the enormous opportunities awaiting you as an Access developer, but also the potential challenges and pitfalls you may face as you move from Access to SQL Server 2000. </p>

About the Author
Susan Sales Harkins is an independent consultant specializing in MS Access, MS Office, and VBA. For several years, Susan was editor-in-chief at The Cobb Group, publishing several computer-based monthly journals. She’s the author of two books on Access: <i>Using Microsoft Access 97</i> and <i>Using Microsoft Access 2000</i>. Currently, Susan writes for a number of publishers, including Element K Journals, PC Magazine, ZDNet, CNet, and TechRepublic.

Martin Reid is an analyst with The Queen’s University of Belfast and has been working with relational databases including Oracle, SQL Server, Access, and MySQL for over 15 years. Martin currently works with several organizations in Northern Ireland, providing database solutions to common business problems. Martin is also a contributor to CNET Comparison/Competition.

Product Details

• Paperback: 800 pages
• Publisher: Apress; 1 edition (January 15, 2002)
• Language: English
• ISBN-10: 1893115305
• ISBN-13: 978-1893115309
• Product Dimensions: 9.3 x 7.4 x 1.6 inches
• Shipping Weight: 2.6 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars See all reviews (3 customer reviews)
• Amazon.com Sales Rank: #559,798 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

16 of 16 people found the following review helpful:

5.0 out of 5 stars Simply the best - is #1 in my top 3 books to "use"., February 11, 2002

By A Customer

I read a lot of books covering topics from Access, SQL Server, to VBA. This book covers all of the "required" Access topics. It covers them better than any other book I have ever seen. It then goes on to cover topics I have not seen in other books or classes. While reading the book you will catch yourself saying why have I never seen this before, or hey I can use this! It uses Jet, Transact & VBA. Do you want to build better applications, do you want to know more than the competition, do you want to be a better developer? If so, this book is a definite purchase.

This book is already my favorite book of all time, replacing "The Guru's Guide to Transact-SQL
by Kenneth W. Henderson, Ken Henderson". (You should get that book as well). I also just purchased "Microsoft Access Version 2002 Inside Out (With CD-ROM) by Helen Feddema" and I think that book will also be in my "top three" books to reference/read.

If you are serious about being a top developer, get this book.

12 of 13 people found the following review helpful:

5.0 out of 5 stars Excellent, Excellent book, September 21, 2002

By	Shabab Sadeghi-ray "only good books" - See all my reviews (REAL NAME)

I own about 30 books about Access (all versions). This book tops all of them. If you are using Access 2000 or 2002(XP) and you like to know about SQL Server (2000), trust me this is it. Try to read it from begining to the end. It's written in english language (not technical slang) and it shows you some cool tricks even for those Access 97 users. Hope to see more books from these guys. Thanks

10 of 11 people found the following review helpful:

5.0 out of 5 stars Exellent Resource for SQL Server and Access, February 14, 2002

By A Customer

This book is well written and easy to follow. The explanations are written in clear language and instructions are written out step by step. The book is well organized which means it's easy to use it more as a reference book. But, it is such a pleasure to read, you want want to skip a single page. This book covers both very elemental aspects of SQL, but also has much to offer the more experienced user.