SQL: Access to SQL Server [Paperback]

Susan Sales Harkins (Author), Martin W.P. Reid (Author)

Book Description

ISBN-10: 1893115305 | ISBN-13: 978-1893115309 | Publication Date: January 15, 2002 | Edition: 1

This is the first book of its kind! Microsoft Access uses a specific dialect of SQL known as Jet SQL to communicate with the Jet Engine. This book shows you how to talk directly to the Jet, bypassing the query design window. Why would you want to? You can't really take advantage of all the Jet has to offer until you can speak its language. The first part teaches you the rules and syntax you'll need to master to talk Jet SQL. The second and third sections show you how to upside an Access database to an Access Project and discusses some of the changes the Access Developer will face when working with SQL Server, including Stored Procedures, Functions, and Views. These sections are full of helpful hints and warnings. "Access SQL to SQL Server Desktop Edition and Beyond" is more than just a comprehensive reference tool for Jet SQL. You'll also find efficient SQL solutions for common Access problems and tasks, in addition to helpful hints and warnings about what to avoid. Learning Jet SQL is an important step from using Access to developing with Access. Understanding Jet SQL opens new possibilities to more efficient solutions that are easier to build than convention methods - once you know the language.

Editorial Reviews

About the Author

Susan Sales Harkins is an independent consultant specializing in Microsoft Access, Office, and Visual Basic for Applications. 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: Using Microsoft Access 97 and Using Microsoft Access 2000. 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, U.K., 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 (4 customer reviews)
• Amazon Best Sellers Rank: #364,472 in Books (See Top 100 in Books)
  • #63 in Books > Computers & Technology > Databases > Relational Databases

Customer Reviews

Most Helpful Customer Reviews

17 of 17 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

This review is from: SQL: Access to SQL Server (Paperback)

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.

13 of 14 people found the following review helpful:

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

By 

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

This review is from: SQL: Access to SQL Server (Paperback)

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

11 of 12 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 review is from: SQL: Access to SQL Server (Paperback)

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.