Access 2003 Programming Weekend Crash Course

Acknowledgments.

FRIDAY.

Part I—Friday Evening.

Session 1–Introduction to Microsoft Access and Programming.

Session 2–From Macros to Modules.

Session 3–System and Process Design, Testing, and Debugging.

Session 4–Events—A Place to Run Your Code.

SATURDAY.

Part II—Saturday Morning.

Session 5–Declaring and Understanding Variables and Using Naming Conventions.

Session 6–Logical Constructs—Loops, Decisions, Choices, and Quick Exits.

Session 7–Procedures, Modules, and Class Modules.

Session 8–Access Architecture.

Session 9–Working with Data Programmatically.

Session 10–Adding, Updating, and Deleting Records Using ADO.

Part III—Saturday Afternoon.

Session 11–Navigating an Application Using Switchboards, Custom Menus, and Keyboard Events.

Session 12–Using Unbound Forms.

Session 13–Programming Check Box, Option Group, Combo, and List Box Controls.

Session 14–Programming Subforms and Continuous Forms.

Session 15–Programming Tabbed Controls.

Session 16–Message Boxes and Error-Handling Programs and Techniques.

Part IV—Saturday Evening.

Session 17–Importing and Exporting Data.

Session 18–Techniques to Improve the Speed of an Application.

Session 19–Creating Animated Splash Screens, About Boxes, and Startup Screens.

Session 20–Creating Help Systems.

SUNDAY.

Part V—Sunday Morning.

Session 21–Creating Search Dialog Box Forms.

Session 22–Programming Dialog Boxes and Reports and Working with ActiveX Controls.

Session 23–Application Architecture.

Session 24–Packaging Your Application.

Session 25–Programming Wizard-Type Forms for Easier Processing.

Session 26–Using Add-Ins with Your Application.

Part VI—Sunday Afternoon.

Session 27–Programming and Using File Attachments.

Session 28–Securing Access Databases.

Session 29–Access and Client Server Data.

Session 30–Creating SQL Server Queries.

Appendix–Answers to Part Reviews.

Index.