Access 2003 All-in-One Desk Reference For Dummies

Collectif Wiley

810 pages, parution le 16/10/2003

Ajouter à une liste

Indisponible

Résumé

Provides new and experienced Access users and beginning programmers with nine task-oriented minibooks covering all aspects of Access
Part of Microsoft Office, Access is the most widely used database in the world and, along with the rest of the Office suite, will undergo a major revision in version 2003
Covers beginning- to advanced-level material in an easy-to-use format, with minibooks on Access and database design, tables, queries, forms, reports, macros, database administration, programming with Visual Basic for Applications (VBA), and using Access with the Web
Shows the reader how to store, organize, view, analyze, and share data, as well as how to build powerful, custom database solutions that integrate with the Web and enterprise data sources

Introduction
Book I: Essential Concepts
- Chapter 1: Introducing Access 2003
- Chapter 2: Getting Started, Getting Around
- Chapter 3: Designing Your Database the Relational Way
Book II: Tables
- Chapter 1: Creating and Modifying Tables
- Chapter 2: Entering and Editing Data in Datasheets
- Chapter 3: Sorting, Finding, and Filtering Data
- Chapter 4: Importing and Exporting Data
- Chapter 5: Avoiding “Garbage In, Garbage Out”
- Chapter 6: Protecting Your Data with Referential Integrity
Book III: Queries
- Chapter 1: Creating Select Queries
- Chapter 2: Letting Queries Do the Math
- Chapter 3: Doing Neat Things with Action Queries and Query Wizards
- Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables
Book IV: Forms
- Chapter 1: Designing and Using Forms (And Reports)
- Chapter 2: Jazzing Up Your Forms (And Reports)
- Chapter 3: Creating Smarter Forms
- Chapter 4: Doing Calculations in Forms (And Reports)
Book V: Reports
- Chapter 1: Creating and Spiffing Up Reports
- Chapter 2: Printing Beautiful Reports
- Chapter 3: Creating Charts and Graphs from Your Data
Book VI: Macros: Automating Stuff in Access
- Chapter 1: Making Macros Do the Work
- Chapter 2: Making Macros Smarter
Book VII: Database Administration
- Chapter 1: Database Housekeeping
- Chapter 2: Sharing the Fun — and the Database: Managing Multi-User Access
- Chapter 3: Securing Your Access Database
Book VIII: Programming in VBA
- Chapter 1: What the Heck Is VBA?
- Chapter 2: Writing Code
- Chapter 3: Writing Smarter Code
- Chapter 4: Controlling Forms with VBA
- Chapter 5: Using SQL and Recordsets
- Chapter 6: Debugging Your Code
- Chapter 7: Integrating Office Applications
Book IX: Access on the Web
- Chapter 1: Creating Data Access Pages
- Chapter 2: Creating Access Projects
- Chapter 3: Introducing XML
- Appendix: Installing Microsoft Access
- Index

L'auteur - Collectif Wiley

Collectif Wiley

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Collectif Wiley
Parution	16/10/2003
Nb. de pages	810
Format	18,5 x 23,5
Couverture	Broché
Poids	1223g
Intérieur	Noir et Blanc
EAN13	9780764539886
ISBN13	978-0-764-53988-6