Alison Balters Mastering Access 2002 Desktop Development

Alison Balter

1348 pages, parution le 01/10/2001

Ajouter à une liste

Indisponible

Résumé

Readers of Alison Balter's Mastering Microsoft Access 2002 Desktop Development will learn
A thorough knowledge of Access application development.
Real-world solutions to specific development and programming problems.
Professional programming techniques backed by concise, no-nonsense explanations of the underlying theories.
Debugging and troubleshooting methods to solve problems quickly and get stalled development projects back on track.

Contents

Introduction 1
Part I The Basics Of Access Development
1 Access as a Development Tool 7
What Types of Applications Can You Develop in Access? 8
Access as a Scalable Product 13
What Exactly Is a Database? 13
Getting to Know the Database Objects 14
Object Naming Conventions 25
Hardware Requirements 26
How Do I Get Started Developing an Access Application? 27
What's New in Access 2002 32
Summary 38
2 What Every Developer Needs to Know About Tables 39
Building a New Table 40
Selecting the Appropriate Field Type for Your Data 44
Working with Field Properties 50
The All-Important Primary Key 62
Working with the Lookup Feature 63
Working with Table Properties 65
Using Indexes to Improve Performance 67
Access Tables and the Internet 67
Working with PivotTable and PivotChart Views 72
Summary 77
3 Relationships: Your Key to Data Integrity 79
Introduction to Relational Database Design 80
Establishing Relationships in Access 89
Establishing Referential Integrity 92
Looking at the Benefits of Relationships 98
Examining Indexes and Relationships 99
Summary 102
4 What Every Developer Needs to Know About Query Basics 103
What Is a Query, and When Should You Use One? 104
Everything You Need to Know About Query Basics 104
Ordering Your Query Result 111
Refining Your Query with Criteria 112
Working with Dates in Criteria 115
Understanding How Query Results Can Be Updated 116
Building Queries Based on Multiple Tables 117
Creating Calculated Fields 123
Getting Help from the Expression Builder 125
Summarizing Data with Totals Queries 127
Excluding Fields from the Output 131
Nulls and Query Results 132
Refining Your Queries with Field, Field List, and Query Properties 134
Building Parameter Queries When You Don't Know the Criteria at Design Time 137
Summary 141
5 What Every Developer Needs to Know About Forms 143
Uses of Forms 144
Anatomy of a Form 146
Creating a New Form 147
Working with the Form Design Window 150
Selecting the Correct Control for the Job 159
Control Morphing 167
Conditional Formatting 169
What Form Properties Are Available, and Why Should You Use Them? 169
What Control Properties Are Available, and Why Use Them? 176
Bound, Unbound, and Calculated Controls 183
Using Expressions to Enhance Your Forms 183
The Command Button Wizards: Programming Without Typing 184
Building Forms Based on More Than One Table 187
Basing Forms on Queries: The Why and How 191
Access Forms and the Internet 192
Summary 201
6 What Every Developer Needs to Know About Reports 203
Types of Reports Available 204
Anatomy of a Report 208
Creating a New Report 209
Working with the Report Design Window 213
Selecting the Correct Control for the Job 216
What Report Properties Are Available and Why Use Them 220
What Control Properties Are Available and Why Use Them 225
Inserting Page Breaks 228
Unbound, Bound, and Calculated Controls 228
Using Expressions to Enhance Your Reports 229
Building Reports Based on More Than One Table 229
Working with Sorting and Grouping 235
Improving Performance and Reusability by Basing Reports on Stored Queries or Embedded SQL
Statements 239
Access Reports and the Internet 240
Summary 247
7 VBA: An Introduction 249
VBA Explained 250
What Are Access Class Modules, Standard Modules, Form Modules, and Report Modules? 252
Working with Variables 263
Adding Comments to Your Code 268
Using the Line Continuation Character 269
Using the VBA Control Structures 269
Passing Parameters and Returning Values 278
Executing Procedures from the Module Window 279
The DoCmd Object: Performing Macro Actions 280
Working with Built-In Functions 281
Working with Constants 286
Tools for Working in the Visual Basic Editor 289
Customizing the VBE 300
Summary 306
8 Objects, Properties, Methods, and Events Explained 307
Understanding Objects, Properties, Events, and Methods 308
Using the Object Browser to Learn About Access' Objects 313
Referring to Objects 315
Properties and Methods Made Easy 316
Declaring and Assigning Object Variables 319
Understanding the Differences Between Objects and Collections 320
Passing Objects to Subroutines and Functions 322
Determining the Type of a Control 323
Special Properties That Refer to Objects 324
Understanding Access's Object Model 325
New Access 2002 Properties 334
Summary 339
9 Advanced Form Techniques 341
What Are the Form Events, and When Do You Use Them? 342
What Are the Section and Control Events, and When Do You Use Them? 354
Referring to Me 361
What Types of Forms Can I Create, and When Are They Appropriate? 362
Using Built-In Dialog Boxes 370
Adding Custom Menus, Toolbars, and Shortcut Menus to Your Forms 374
Taking Advantage of Built-In, Form-Filtering Features 379
Including Objects from Other Applications: Linking Versus Embedding 381
OpenArgs 382
Switching a Form's RecordSource 383
Power Combo Box and List Box Techniques 386
Power Subform Techniques 394
Synchronizing a Form with Its Underlying Recordset 395
Creating Custom Properties and Methods 396
Summary 403
10 Advanced Report Techniques 405
Events Available for Reports, and When to Use Them 406
Order of Events for Reports 410
Events Available for Report Sections, and When to Use Them 410
Programmatically Manipulating Report Sections 415
Special Report Properties 416
Controlling the Printer 418
Practical Applications of Report Events and Properties 420
Summary 447
11 Advanced Query Techniques 449
Action Queries 450
Special Query Properties 460
Optimizing Queries 463
Crosstab Queries 467
Outer Joins 474
Self Joins 476
Understanding SQL 477
Union Queries 487
Pass-Through Queries 489
The Propagation of Nulls and Query Results 490
Subqueries 491
Using SQL to Update Data 492
Using SQL for Data Definition 494
Using the Result of a Function as the Criteria for a Query 496
Passing Parameter Query Values from a Form 497
Jet 4.0 ANSI-92 Extensions 499
Summary 508
12 Advanced VBA Techniques 509
What Are User-Defined Types, and Why Would You Use Them? 510
Working with Constants 512
Working with Arrays 515
Advanced Function Techniques 521
Working with Empty and Null 529
Creating and Working with Custom Collections 535
Low-Level File Handling 539
Understanding and Effectively Using Compilation Options 539
Importing and Exporting Code Modules 540
Working with Project Properties 541
Summary 545
13 Exploiting the Power of Class Modules 547
Exploring the Benefits of Class Modules 548
Object Orientation--An Introduction 548
Creating and Using a Class Module 549
Creating Multiple Class Instances 553
The Initialize and Terminate Events 554
Working with Enumerated Types 555
Building Hierarchies of Classes 556
Adding a Parent Property to Classes 557
The Implements Keyword 558
Working with Custom Collections 559
Adding Your Own Events 562
Summary 580
14 What Are ActiveX Data Objects and Data Access Objects, and Why Are They Important? 581
Using ActiveX Data Objects Versus Data Access Objects 582
Examining the ActiveX Data Object Model 583
Understanding ADO Recordest Types 590
Working with ADO Recordset Properties and Methods 600
Modifying Table Data Using ADO Code 617
Creating and Modifying Database Objects Using ADO Code 624
Examining the Data Access Object Model 628
Getting to Know DBEngine 638
Using CurrentDB() 639
Understanding DAO Recordset Types 640
Selecting Among the Types of DAO Recordset Objects Available 641
Working with DAO Recordset Properties and Methods 641
Modifying Table Data Using DAO Code 657
Creating and Modifying Database Objects Using DAO Code 662
Using the DAO Containers Collection 666
Summary 672
Part II What To Do When Things Don't Go As Planned
15 Debugging: Your Key to Successful Development 675
Avoiding Bugs 676
Harnessing the Power of the Immediate Window 677
Invoking the Debugger 683
Using Breakpoints to Troubleshoot 684
Stepping Through Code 686
Setting the Next Statement to Execute 691
Using the Calls Window 691
Working with the Locals Window 693
Working with Watch Expressions 693
Continuing Execution After a Runtime Error 698
Looking At Gotchas with the Immediate Window 700
Using Assertions 700
Debugging Tips 701
Summary 702
16 Error Handling: Preparing for the Inevitable 703
Implementing Error Handling 704
Using On Error Statements 706
Using Resume Statements 709
Clearing an Error 713
Examining the Cascading Error Effect 713
Using the Err Object 715
Raising an Error 716
Using the Errors Collection 718
Creating a Generic Error Handler 719
Preventing Your Own Error Handling from Being Invoked 733
Creating a Call Stack 733
Building a Custom Error Handler Class 737
Working with Error Events 743
Creating a List of Error Codes and Descriptions 744
Summary 747
17 Optimizing Your Application 749
Introducing Optimization 750
Modifying Hardware and Software Configurations 750
What Jet 3.5 Did to Improve Performance 755
Understanding What Jet 4.0 Does to Improve Performance 755
Letting the Performance Analyzer Determine Problem Areas 756
Designing Tables to Optimize Performance 757
Designing Queries to Optimize Performance 759
Making Coding Changes to Improve Performance 760
Designing Forms and Reports to Improve Performance 780
Summary 783
Part III Developing Multiuser and Enterprise Applications
18 A Strategy to Developing Access Applications 787
Splitting Databases into Tables and Other Objects 788
Basing Forms and Reports on Queries or Embedded SQL Statements 790
Understanding the Access Runtime Engine 791
Using an EXE Versus Access Database: What It Means to You 796
Understanding the Importance of Securing Your Database 797
Using Access as a Front End 798
Summary 801
19 Using External Data 803
Importing, Linking, and Opening Files: When and Why 804
Importing External Data 807
Creating a Link to External Data 811
Opening an External Table 820
Understanding Windows Registry Settings 822
Using the Jet OLEDB: Link Provider String 823
Refreshing and Removing Links 825
Looking at Special Considerations 828
Troubleshooting 829
Looking at Performance Consi

Caractéristiques techniques

	PAPIER
Éditeur(s)	Sams
Auteur(s)	Alison Balter
Parution	01/10/2001
Nb. de pages	1348
Format	18,5 x 23,2
Couverture	Broché
Poids	2227g
Intérieur	Noir et Blanc
EAN13	9780672321016

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

Alison Balters Mastering Access 2002 Desktop Development

Résumé

Caractéristiques techniques

Consultez aussi