SQL: Access to SQL Server / Edition 1

SQL: Access to SQL Server / Edition 1

5.0 4
by Susan Sales Harkins, Martin Reid
     
 

ISBN-10: 1893115305

ISBN-13: 9781893115309

Pub. Date: 01/28/2002

Publisher: Apress

SQL: Access to SQL Server 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 using Access to developing with Access.

In addition

Overview

SQL: Access to SQL Server 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 using Access to developing with Access.

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.

Product Details

ISBN-13:
9781893115309
Publisher:
Apress
Publication date:
01/28/2002
Edition description:
2002
Pages:
698
Product dimensions:
7.52(w) x 9.25(h) x 0.36(d)

Related Subjects

Table of Contents

Part 1: SQL Fundamentals: 1. What is SQL and Where Did It Come From? 2. An Introduction to Using Jet SQL in Access. 3. An Introduction to Relational Database Theory. 4. SQL Grammar. 5. Retrieving Data. 6. Modifying Data. 7. Grouping and Summarizing Data. 8. Creating and Modifying Tables. 9. Creating Indexes and Relationships. 10. Advanced Manipulation Techniques. 11. When a Simple Query Isn't Enough.

Part 2: Working with MSDE 2000: 12. Introducing the MSDE Engine. 13. ADP - A Step Closer to SQL Server. 14. Organizing Data With Views. 15. Procedures - The SQL-Based Function. 16. Running the Upsizing Wizard. 17. Managing Security. 18. Preparing for SQL Server.

Part 3: The Transition to SQL Server: 19. Introduction to SQL Server. 20. SQL Server Structure. 21. Working with Stored Procedures. 22. Upsizing Directly from Access. 23. Security Issues. 24. SQL Server to the Web.

Appendix A: SQL Comparison Tables.

Appendix B: Ready to Run Solutions.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

SQL: Access to SQL Server 5 out of 5 based on 0 ratings. 4 reviews.
Anonymous More than 1 year ago
Guest More than 1 year ago
It's nice to find a book in which I found no typos (only column headings and data in table 6-3 confused), and the example code actually runs. The authors also used just enough step-by-step hand holding to keep the flow.
Guest More than 1 year ago
I agree with the previous reader. This book is the best!!! Very, very clear.
Guest More than 1 year ago
I have many books on Access and this is THE best. If you have to buy one book on SQL and Microsoft Access get this one.