SQL

Access to SQL Server

Authors: Sales Harkins, Susan, Reid, Martin

Download source code

Buy this book

eBook $34.99
price for USA
  • ISBN 978-1-4302-1573-8
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $49.95
price for USA
  • ISBN 978-1-893115-30-9
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

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.

About the authors

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.

Table of contents (19 chapters)

  • Structured Query Language

    Harkins, Susan Sales (et al.)

    Pages 1-5

  • An Introduction to Using Jet SQL in Access

    Harkins, Susan Sales (et al.)

    Pages 7-34

  • An Introduction to Relational Database Theory

    Harkins, Susan Sales (et al.)

    Pages 35-68

  • SQL Grammar

    Harkins, Susan Sales (et al.)

    Pages 69-82

  • Retrieving Data

    Harkins, Susan Sales (et al.)

    Pages 83-132

Buy this book

eBook $34.99
price for USA
  • ISBN 978-1-4302-1573-8
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $49.95
price for USA
  • ISBN 978-1-893115-30-9
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
SQL
Book Subtitle
Access to SQL Server
Authors
Copyright
2002
Publisher
Apress
Copyright Holder
Susan Sales Harkins and Martin Reid
eBook ISBN
978-1-4302-1573-8
DOI
10.1007/978-1-4302-1573-8
Softcover ISBN
978-1-893115-30-9
Edition Number
1
Number of Pages
XIX, 698
Topics