+612 9045 4394
SQL : Access to SQL Server - Susan Sales Harkins

Paperback Published: 29th January 2002
ISBN: 9781893115309
Number Of Pages: 800

Share This Book:


RRP $93.77
Ships in 7 to 10 business days

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.

Chapter 1: Structured Query Language

Chapter 2: An Introduction to Using Jet SQL in Access

Chapter 3: An Introduction to Relational Database Theory

Chapter 4: SQL Grammar

Chapter 5: Retrieving Data

Chapter 6: Modifying Data

Chapter 7: Grouping and Summarizing Data

Chapter 8: Creating and Modifying Tables

Chapter 9: Manipulating Relationships and Indexes

Chapter 10: Advanced Manipulation Techniques

Chapter 11: Queries: The Sequel

Chapter 12: An Introduction to the SQL Server 2000 Desktop Engine

Chapter 13: Introduction to SQL Server

Chapter 14: SQL Server Views

Chapter 15: SQL Server Structure

Chapter 16: Working with Stored Procedures

Chapter 17: Upsizing Directly from Access

Chapter 18: Security Issues

Chapter 19: SQL Server Meets the Web

Appendix A: More SQL Solutions to Common Problems

Appendix B: An Introduction to Using ADO and ADOX with SQL

ISBN: 9781893115309
ISBN-10: 1893115305
Audience: General
Format: Paperback
Language: English
Number Of Pages: 800
Published: 29th January 2002
Publisher: Apress
Country of Publication: US
Dimensions (cm): 23.55 x 18.87  x 3.94
Weight (kg): 1.18