SQL: Access to SQL Server
Desktop Edition and Beyond
Susan Sales Harkins, Martin W.P. Reid
Résumé
-Susan Sales Harkins has been writing about Access since 1992, and has written two books about Access
-Includes a handy appendix with a table comparing Jet SQL, Access SQL, and SQL Server's T-SQL; another appendix contains problem-solving solutions.
-Features time-saving information on upsizing from Access to SQL Server.
-Shows how to leverage new features in Access 2002 when working with SQL Server.
-Peppered with advice and tips from industry pundits who were invited by the authors.
"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.
The book covers a lot of ground taking the reader from basic SQL right up to an introduction on executing Stored Procedures via the Web. The authors see SQL - as it's used in Access , MSDE, and SQL Server - as being the common thread.
Susan Sales Harkins is an independent consultant specializing in MS Access, MS Office, and VBA. For several years, Susan was an Editor-in-Chief at The Cobb Group, publishing several computer-based monthly journals. She's also the author of two QUE 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 and has been working with relational databases including Oracle, SQL Server, Access, and MySQL for over 15 years. Martin also currently works with several organizations in Northern Ireland providing database solutions to common business problems. Martin is also a contributor to CNet Comparison/Competition.
Contents
Part 1: SQL Fundamental
- 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
- 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
- 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
L'auteur - Susan Sales Harkins
Susan Sales Harkins has been the Editor-in-Chiefof
Microsoft Access, The Cobb Group's tips and techniques
monthly journal on MS Access since 1994. Ken Hansen is a
principal in HSC Consulting, Inc. and has over 20 years
experience in the Information Systems area. He currently
specializes in developing business solutions with Access,
Visual Basic, Microsoft Office and SQL Server. Before
becoming a consultant, Ken held various management
positions, including that of Information Systems Director
for a Fortune 500, worldwide holding company. Ken is a
Microsoft Certified Solutions Developer. Tom Gerhart has
been an independent consultant since 1993 when he retired
from IBM. His current area of specialty is to design and
develop business solutions based on Microsoft Office with a
primary emphasis on the use of Microsoft Access and
Microsoft SQL Server. He has worked with all releases of
Access, with a number of projects involving backend
databases (including Oracle and Microsoft SQL). He has also
worked with Visual Basic, including the development of
ActiveX components. Tom does some training in addition to
his consulting.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Apress |
Auteur(s) | Susan Sales Harkins, Martin W.P. Reid |
Parution | 05/02/2002 |
Nb. de pages | 694 |
Format | 18,5 x 23,5 |
Couverture | Broché |
Poids | 1186g |
Intérieur | Noir et Blanc |
EAN13 | 9781893115309 |
ISBN13 | 978-1-893115-30-9 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse