Access 2003 Programming Weekend Crash Course

by Prague, Cary N.; Reardon, Jennifer; Kasevich, Lawrence S.; Reid, Diana; Phan, Phuc V.

• ISBN13: 9780764539756
• ISBN10: 0764539752
• Format: Paperback
• Copyright: 2003-10-10
• Publisher: WILEY

Summary

Get up to speed on Access 2003 programming - in a weekend! The big day is Monday. The day you get to show off what you know about Access 2003 programming. The problem is, you're not really up to speed. Maybe it's been a while since you've done Access programming. Perhaps you're not acquainted with all the new tools that Access 2003 provides. Or maybe you just like a challenge. In any event, we've got a solution for you - Access 2003 Programming Weekend Crash Course. Open the book Friday evening, and on Sunday afternoon - after completing 30 fast, focused sessions - you'll be able to dive right in and start creating sophisticated, data-driven solutions with Access 2003. It's as simple as that. The Curriculum Friday Evening: 4 Sessions, 2 Hours * Introduction to Access and Programming * From Macros to Modules * Design, Testing, and Debugging * Events - A Place to Run Your Code Saturday Morning: 6 Sessions, 3 Hours * Variables and Naming Conventions * Loops, Decisions, and Quick Exits * Procedures, Modules, and Class Modules * Access Architecture Working with Data Programmatically * Adding, Updating, and Deleting Records Using ADO Afternoon: 6 Sessions, 3 Hours * Switchboards, Custom Menus, and Keyboard Events * Using Unbound Forms * Programming Check Box, Option Group, Combo, and List Box Controls * Subforms and Continuous Forms * Programming Tabbed Controls * Message Boxes and Error Handling Saturday, cont. Evening: 4 Sessions, 2 Hours * Importing and Exporting Data * Improving the Speed of an Application * Creating Animated Splash Screens, About Boxes, and Startup Screens * Creating Help Systems Sunday Morning: 6 Sessions, 3 Hours * Creating Search Dialog Box Forms * Dialog Boxes, Reports, and ActiveX Controls * Application Architecture * Packaging Your Application * Programming Wizard-Type Forms * Using Add-Ins Afternoon: 4 Sessions, 2 Hours * Programming File Attachments * Securing Access Databases * Access and Client Server Data * Creating SQL Server Queries

Table of Contents

Preface

Acknowledgments

Friday

Friday Evening

Introduction to Microsoft Access and Programming

From Macros to Modules

System and Process Design, Testing, and Debugging

Events-A Place to Run Your Code

Saturday

Saturday Morning

Declaring and Understanding Variables and Using Naming Conventions

Logical Constructs-Loops, Decisions, Choices, and Quick Exits

Procedures, Modules, and Class Modules

Access Architecture

Working with Data Programmatically

Adding, Updating, and Deleting Records Using ADO

Saturday Afternoon

Navigating an Application Using Switchboards, Custom Menus, and Keyboard Events

Using Unbound Forms

Programming Check Box, Option Group, Combo, and List Box Controls

Programming Subforms and Continuous Forms

Programming Tabbed Controls

Message Boxes and Error-Handling Programs and Techniques

Saturday Evening

Importing and Exporting Data

Techniques to Improve the Speed of an Application

Creating Animated Splash Screens, About Boxes, and Startup Screens

Creating Help Systems

Sunday

Sunday Morning

Creating Search Dialog Box Forms

Programming Dialog Boxes and Reports and Working with ActiveX Controls

Application Architecture

Packaging Your Application

Programming Wizard-Type Forms for Easier Processing

Using Add-Ins with Your Application

Sunday Afternoon

Programming and Using File Attachments

Securing Access Databases

Access and Client Server Data

Creating SQL Server Queries

Appendix-Answers to Part Reviews

Index

Table of Contents provided by Publisher. All Rights Reserved.