Access 2003 Bible - Cary N. Prague , Michael R. Irwin - Librairie Eyrolles
Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
Access 2003 Bible
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

Access 2003 Bible

Access 2003 Bible

Cary N. Prague, Michael R. Irwin

1402 pages, parution le 29/10/2003

Résumé

If Access 2003 can do it, you can do it too...

Databases can be complex. That's why you need the expert guidance in this comprehensive reference manual to help you harness their power with a solid understanding of database purpose, construction, and application. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology. If you're familiar with earlier versions, you can jump right into Access 2003 enhancements like wider use of XML and Web services.

Inside, you'll find complete coverage of Access 2003

  • Create tables, manipulate datasheets, and work with multiple tables
  • Understand the seven database objects and design systems objects
  • Apply the seven-step design method to build databases tailored to your needs
  • Build forms with wizards, create bound and unbound forms, and add data validation
  • Learn how to use Visual Basic® and the VBA Editor to automate Access applications
  • Use XML to create basic and advanced Data Access Pages
  • Automate query parameters, create functions and subroutines, and add programmed error routines
  • Exchange data with Word, Excel, PowerPoint®, and other Office applications

Bonus CD-ROM and companion Web site!

  • All source code from the book as well as a complete working example
  • Exclusive Office 2003 Super Bible eBook, with more than 500 pages of information about how Microsoft Office components work together
  • Bonus shareware, freeware, trial, demo, and evaluation programs that work with or enhance Microsoft Office
  • Searchable eBook version of Access 2003 Bible
  • An easy-to-use interface that allows you to browse and install everything on the CD

Contents

  • Part I: Creating Desktop Applications
    • Section I: Working with Data Tables and Queries
    • Chapter 1: Understanding Data
    • Chapter 2: Creating and Building Tables
    • Chapter 3: Entering Data into Tables and Forms
    • Chapter 4: Creating and Understanding Relationships
    • Chapter 5: Displaying Selected Data with Queries
    • Chapter 6: Using Operators and Expressions in Multi-table Select Queries
    • Chapter 7: Working with External Data
    • Section II: Building Forms and Reports
    • Chapter 8: Understanding the Many Uses of Forms and Controls
    • Chapter 9: Building and Manipulating Forms and Controls
    • Chapter 10: Creating Bound Forms and Placing Controls
    • Chapter 11: Adding Data-Validation Features to Forms
    • Chapter 12: Creating Professional-Looking Forms and Reports
    • Chapter 13: Understanding and Creating Reports
    • Chapter 14: Working with Subforms
    • Chapter 15: Creating Calculations and Summaries in Reports
    • Chapter 16: Presenting Data with Special Report Types
    • Chapter 17: Using OLE Objects, Graphs, Pivot Tables/Charts, and ActiveX Controls
    • Section III: Automating Your Applications
    • Chapter 18: Understanding Visual Basic and the VBA Editor
    • Chapter 19: Introduction to Programming and Events
    • Chapter 20: Working with Expressions and Functions
    • Chapter 21: Working with SQL, Recordsets, and ADO
    • Chapter 22: Automating, Searches, Filters, and Query Parameters
    • Chapter 23: Calling Subprocedures and Functions
    • Chapter 24: Effective Debugging and Error Handling in VBA
    • Chapter 25: Creating Switchboards, Command Bars, Menus, Toolbars, and Dialog Boxes
    • Chapter 26: Programming Continuous Forms, Tab Dialogs, and Command Buttons
  • Part II: Creating Enterprise Applications
    • Section IV: Upsizing to SQL Server and MSDE 2000
    • Chapter 27: Upsizing Data to a SQL Server Database
    • Chapter 28: Working with Access Projects
    • Chapter 29: Working with Access Projects and SQL Server Tables and Queries
  • Part III: Creating Web Applications
    • Section V: Creating Data Access Pages and Using XML and InfoPath
    • Chapter 30: Using and Creating Access Objects for Intranets and the Internet
    • Chapter 31: Building and Working with Data Access Pages
    • Chapter 32: XML, Access, and InfoPath
  • Part IV: Advanced Access Database Topics
    • Chapter 33: Exchanging Data with Office Applications
    • Chapter 34: Adding Security to Applications
    • Chapter 35: Creating Help Systems
    • Chapter 36: Working with Advanced Select Queries and Other Query Topics
    • Chapter 37: Working with Action and SQL Queries
    • Chapter 38: Increasing the Speed of an Application
    • Chapter 39: Preparing Your Application for Distribution
  • Part V: Appendixes and Reference Material
    • Appendix A: Access 2003 Specifications
    • Appendix B: Access Auto Auction Tables
    • Appendix C: Using the CD-ROM Included with the Book
    • Appendix D: Using Standard Naming Conventions
    • Index

L'auteur - Cary N. Prague

Cary N. Prague is a winner of the Computer Press Association's Book of the Year Award. He has written 35 books on databases and developed the award-winning Check Writer program. He is founder of the world's largest Access add-on company, Software International. He is also the co-author of IDG Books Worldwide's Access SECRETS?.

L'auteur - Michael R. Irwin

is considered one of the leading authorities on automated database and Internet management systems today. He is a noted worldwide lecturer, a winner of national and international awards, best-selling author, and developer of client/server, Internet, Intranet, and PC-based database management systems.
Michael has extensive database knowledge, gained by working with the Metropolitan Police Department in Washington, D.C. as a developer and analyst for the Information Systems Division for over 20 years and assorted Federal Agencies of the United States Government. Since retiring in June 1992, he runs his own consulting firm, named The Irwin Group, and is principal partner in the company - IT in Asia, LLC, specializing in Internet database integration and emphasizing Client/Server and net solutions. With consulting offices in Cincinnati, Ohio, Bangkok, Thailand, and Manila, Philippines, his companies offer training and development of Internet and database applications. His company has the distinction of being one of the first Microsoft Solution's Providers (in 1992). His local, national, and international clients include many software companies, manufacturers, government agencies, and international companies.

Caractéristiques techniques

  PAPIER
Éditeur(s) Wiley
Auteur(s) Cary N. Prague, Michael R. Irwin
Parution 29/10/2003
Nb. de pages 1402
Format 18,5 x 23,5
Couverture Broché
Poids 1925g
Intérieur Noir et Blanc
EAN13 9780764539862
ISBN13 978-0-7645-3986-2

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