PERHAPS A GIFT VOUCHER FOR MUM?: MOTHER'S DAY

Close Notification

Your cart does not contain any items

SQL

Access to SQL Server

Susan Sales Harkins Martin Reid

$130.95   $105.07

Paperback

Not in-store but you can order this
How long will it take?

QTY:

English
APress
29 January 2002
SQL: Access to SQL Server is more than just a comprehensive reference tool for Access developers. Youll 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.

By:   ,
Imprint:   APress
Country of Publication:   United States
Edition:   Softcover reprint of the original 1st ed.
Dimensions:   Height: 235mm,  Width: 191mm,  Spine: 36mm
Weight:   1.345kg
ISBN:   9781893115309
ISBN 10:   1893115305
Pages:   698
Publication Date:  
Audience:   General/trade ,  ELT Advanced
Format:   Paperback
Publisher's Status:   Active
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

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.

See Also