Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
SQL: Access to SQL Server
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

SQL: Access to SQL Server

SQL: Access to SQL Server

Desktop Edition and Beyond

Susan Sales Harkins, Martin W.P. Reid

694 pages, parution le 05/02/2002

Résumé

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.
-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
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

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

Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription