Access 97 developer's handbook

목차 (Table of Contents)

• CONTENTS
• Foreword = xxiii
• Introduction = xxvii
• PART Ⅰ Overview of Access = 3
• Chapter 1 : What's New in Access 97 = 5
• A Brief Access History = 6
• Access 97 - the Best Access Ever = 8
• Summary = 12
• Chapter 2 : The Access Event Model = 15
• So Many Eveents, So Little Time = 16
• Hooking In = 17
• Form Events = 20
• The Sequence of Events = 26
• Summary = 41
• Chapter 3 : Using VBA Class Modules = 43
• Why Use Clas Modules? = 44
• How Class Modules Work = 48
• A Simple Example : A Text File Class = 49
• Using Property Statements = 58
• A Simple Database Example = 63
• Advanced Class Module Techniques = 67
• Summary = 82
• PART Ⅱ Manipulating Data = 85
• Chapter 4 : Database Design = 87
• The Relational Model = 88
• Relational Database Design = 89
• Normalizing a Set of Tables = 96
• Integrity Rules = 105
• A Practical Approach to Database Design = 109
• Normalizing a Database with Existing Data = 111
• Breaking the Rules : When to Denormalize = 115
• Summary = 117
• Chapter 5 : Access SQL = 119
• Where Can You Use Access SQL? = 121
• Learning Access SQL = 123
• The SELECT Statement = 124
• Aggregating Data = 142
• Union Queries = 156
• Subqueries = 159
• Parameterized SQL = 167
• Using External Data Sources = 168
• Updating Data with SQK = 173
• Data Definition withh SQL = 178
• Creating SQl Pass-Through Quries = 186
• Differences between Access SQL and SQL-92 = 189
• Summary = 192
• Chapter 6 : Using Data Access Objects = 195
• Dueling Object Hierarchies = 196
• Nuts and Bolts : Syntax Explained = 198
• Using Default Collections = 207
• Enumerating Objects in Collections = 208
• Working with Properties = 209
• Data Definition Using DAO = 213
• Connecting and Reconnecting Attached Tables = 228
• Working with Recordsets = 235
• Meet the Recordsets = 235
• Creating a Recordset = 236
• Creating Recordset Objects = 239
• Moving through a Recordset = 240
• Sorting Recordsets = 262
• Filtering Non-Table Recordsets = 266
• Editing Data in a Recordset Object = 268
• Using Containers to Handle Saved Documents = 271
• Designing frmDBC = 277
• Choosing an Object Type and an Action = 278
• Displaying the Object List = 278
• Filling the Object List = 279
• Summary = 290
• PART Ⅲ Presenting Data = 293
• Chapter 7 : Controlling Controls = 295
• Controls and Theif Uses = 296
• Code-Behind-Forms and Class Modules = 297
• Some Standard Control Properties = 298
• Using the Tag Property to Create Your Own Properties = 299
• The ControlType Property = 302
• The ControlTipText and ShortCutMenuBar Properties = 303
• Using the TabStop and TabIndex Properties = 306
• Using the displayWhen Property = 308
• Using Labels = 308
• Using Text Boxes = 310
• Using Two-State Controls (the Yes/No Crowd) = 317
• Using Option Groups - Controls inside Controls = 319
• Using Controls's Controls Collection = 326
• Using List and Combo Boxes = 328
• How and When to Use Subforms = 370
• Using Command Buttons = 374
• The Tab Control = 381
• Using the Tab Control as a Container = 392
• Using Default Control Properties to Your Advantage = 393
• Creating Controls Programmatically = 395
• What Are These Controls, Anyway? = 401
• Summary = 405
• Chapter 8 ; Topics in Form Design and Usage = 407
• Introduction to Class Modules = 408
• Windows Handles, Classes, Access Forms, and MDI = 410
• Controlled Closing = 412
• Removing a Foam's Caption Bar = 414
• Retrieving and Saving Information about Forms = 418
• Using Forms as Toolboxes = 441
• Creating Self-Disabling Navigation Buttons = 452
• Screen Resolution and Distributing Forms = 465
• Filtering Data = 476
• The Filter Property = 476
• The Filter On Property = 480
• The Filter Event = 481
• The Apply Filter Event = 482
• Fine-Tuning Filter by Form = 483
• Ordering Your Rows = 484
• Creating Popup Forms = 485
• Using Popup Tools = 488
• Creating User-Defined Properties = 492
• Using Form procedures as Methods = 494
• Form-Level Error Handling = 496
• Using Sybforms in Your Applications = 499
• Controlling the Pesky Users = 504
• Displaying Multiple Instances of Forms = 508
• What Happens When You Create a New Instance? = 509
• How Do You Create a New Instance? = 510
• A Better Solution = 511
• Closing a Form Instance = 513
• Closing All the Instances = 513
• Summary = 515
• Chapter 9 : Topics in Report Design = 519
• Report Properties New Since Access 2 = 520
• Controlling Sorting and Grouping = 523
• Events of Reports and Their Sections = 538
• Report Events = 538
• Section Design-Time Properties = 546
• Section Rum-Time Properties = 550
• Examples Using Report and Section Events and Properties = 555
• Printing Multiple Labels = 555
• Printing Mailing Labels Starting at a Specific Location = 557
• Handling Odd and Even Pages = 560
• Controlling the Starting Page Number = 562
• Numbering Items of a Report = 563
• Inserting Blank Lines = 564
• Some Simple Sample Reports = 566
• The Sales Report = 566
• The Phone Book = 571
• Companies, Contacts, and Hardware = 579
• Altering Your Report's Layout Programmatically = 585
• Summary = 588
• Chapter 10 : Controlling Your Printer = 591
• Controlling Print Setup Information = 592
• Controlling Print Layout Information = 607
• Introducing the prtDevNames Property = 611
• Controlling Your Destination = 616
• Providing a List of Output Devices = 617
• Retrieving Printer Capabilities = 628
• The Printer Driver's DeviceCapabilities Function = 633
• Summary = 639
• Chapter 11 : Shared Office Programmability = 641
• References Are Everything = 642
• The FileSearch Object Model = 643
• The CommandBar Object Model = 655
• The Office Assistant = 693
• Is There More? = 716
• Summary = 717
• PART Ⅳ Multiuser Issues = 719
• Chapter 12 : Developing Multiuser Applications = 721
• Setup on a Network = 722
• Multiuser Settings = 723
• Choosing a Locking Strategy = 728
• Recordset Error Hadnling = 745
• Transaction Processig = 745
• Multiuser Action Queries = 749
• Splitting Action Queries = 752
• Using a Custom AutoNumber Routine = 757
• Security = 762
• Determining Which Users Have a Database Open = 763
• The Wire = 764
• Test, Test, Test! = 766
• Summary = 767
• Chapter 13 : Mastering Replication = 769
• Replication : What Is It and How Does It Work? = 770
• The Many Faces of Replication = 772
• When to Use Replication = 779
• Replication Topologies = 783
• Change Made to a Database When It Is Replicated = 786
• Replicating a Database = 792
• Synchonizing Replicas = 806
• Managing Conflict and Errors = 827
• Other Issues to Consider = 842
• Summary = 847
• Chapter 14 : Securing Your Application = 849
• Security Basics = 850
• Jet Workgroup-Based Security = 852
• Workgroups = 854
• User and Group Accounts = 856
• Assihning Permissions = 861
• Ownership = 866
• Encryption = 868
• Programming Security Using Data Access Object = 869
• Properly Securing a Database with the Access Security Wizard = 906
• Unsecuring a Secured Database = 910
• Migrating Secured Database to Access 97 = 911
• Security and Linked Tables = 912
• Summary = 912
• Chapter 15 : Developing Client-Server Applications = 915
• The Difference between file-Server and Client-Server = 916
• Using Client-Server versus File-Server = 918
• The Role of Access in Distrigbuted Applications = 923
• Understanding ODBC = 925
• Configuring ODBC = 930
• Using the Sample Datagase = 933
• Using the Three Methods of Getting Data = 934
• Evaluating Query Alternatives = 942
• Configuring ODBC for Your System = 943
• Configuring Your Server for Access = 945
• Editing ODBC Data = 946
• Understanding Your Server = 948
• Designing an Efficient Client/Server Application = 949
• Building Your Forms = 955
• Building Reports = 957
• Common Client-Server Migration Problems = 958
• Looking In on Jet and ODBC = 960
• The Upsizing Wizard = 963
• Summary = 965
• PART Ⅴ Building Applications = 967
• Chapter 16 : Error Handling and Debugging = 969
• Dealing with Syntax Errors = 970
• Dealing with Run-time Errors = 971
• Dealing with Logic Errors, AKA Bugs! = 1000
• Techiques and Strategies for Debugging = 1023
• Summary = 1029
• Chapter 17 : Application Optimization = 1031
• Tuning Your Application's Performance = 1032
• Hardware and Windows Issues = 1033
• Understanding How the Jet Query Engine Works = 1034
• Configuring the Jet Engine = 1040
• Microsoft's Unsupported Jet Optimization Tools = 1044
• Speeding Up Queries and Recordsets = 1049
• Speeding Up Forms = 1051
• Speeding Up Reports = 1053
• Optimizing VBA's Use of Modules and Compilation = 1053
• Speeding Up VBA : Testing Hypotheses = 1061
• Summary = 1079
• PART Ⅵ Interoperability = 1081
• Chapter 18 : Accessing DLLs and the Windows API = 1083
• Introducing Dynamic Link Libraries = 1084
• Calling DLL Procedures from VBZ = 1086
• Examples Using the Windows API = 1096
• How to Construct a Declare Statement = 1105
• More Advanced Details of Calling DLLs = 1114
• Converting Windows API Calls from Access 2.0 = 1125
• Summary = 1130
• Chapter 19 : Harnessing Wizard Magic = 1133
• Using the Exported Procedures = 1135
• File-Handling Functions = 1136
• Using the Windows Common Dialogs = 1140
• Reading and Writing Registry Values = 1146
• Font-Handling Functions = 1160
• Object-Handling Functions = 1168
• Miscellaneous Functions = 1178
• Summary = 1186
• Chapter 20 : Using Access as an Automation Client = 1189
• Automation Basics = 1190
• Creating Objects = 1197
• Controlling Other Applications = 1205
• Creating Automation Solutions with Microsoft Office 97 = 1208
• Example : Smart Mail Merge to Word = 1214
• Example : Outlook Time Reporting = 1220
• Example : Creating a PowerPoint Presentation = 1226
• Example : Populating an Excel Worksheet = 1234
• Using ActiveX Controls = 1240
• Tapping into Events Using WithEvents = 1250
• Summary = 1254
• Chapter 21 : Controlling Access as an Automation Sever = 1257
• Looking at Access as an Automation Server = 1258
• Running Access Reports Using Automation = 1262
• The Five-Part Process for Printing Reports Using Automation = 1265
• Calling User-Defined Functions from an Automation Client = 1275
• Writing Automation-Friendly Applications = 1280
• Summary = 1294
• PART Ⅶ Finishing Touches = 1297
• Chapter 22 : Building Add-Ins = 1299
• Libraries and Wizards and Builders, Oh My! = 1300
• Creating Library Databases = 1303
• Building Your Own Builders = 1313
• Developing Custom Wizards = 1325
• Control Wizards : A Hybrid = 1353
• Distributing and Installing Add-Ins = 1357
• Advanced Add-in Topics = 1361
• Summary = 1370
• Chapter 23 : Web-Enabling Your Applications = 1373
• What Are Hyperlinks? = 1375
• Where to Find the Links = 1377
• Using Hyperlinks for Intra-Database Navigation = 1386
• Controlling Hyperlinks with VBA = 1387
• Using the Microsoft Web Browser Control = 1394
• An HTML Primer = 1400
• The Publish to the Web Wizard = 1405
• Publishing Static HTML = 1406
• Publishing Internet Database Connector Pages = 1408
• Publishing Active Pages = 1421
• Wizard Templates = 1432
• Using and Manipulating Profiles = 1435
• The Web Publishing Wizard = 1437
• Publishing without the Wizard = 1438
• Getting Additional Information on Web Publishing = 1441
• Recognizing Access' Limits as an Internet Data Server = 1442
• Back to the Stone Age? = 1442
• Summary = 1443
• Chapter 24 : Using Source Code Control = 1445
• What Is Source Code Control? = 1446
• Support for Source Code Control in Access 97 = 1448
• Using Microsoft Visual SourceSafe = 1456
• Working with VSS from Access 97 = 1462
• Controlling SourceSafe with VBA = 1475
• Summary = 1485
• APPENDIXES On the CD
• Appendix A : The Reddick VBA Naming Conventions, Version 4.0 CD
• Appendix B : Startup and Global Options CD
• Index = 1486