Overview
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
Synopsis
Prague, a database author and lecturer, leads readers through a 15- hour tutorial that teaches beginners and experienced information system professionals how to program in Microsoft Access and VBA and how to create sophisticated, data-driven solutions with Access 2003. Each day of the "weekend" (which begins Friday evening) is divided into four to six sessions that can be completed in about half an hour. At the end of each session are review questions, which are answered in an appendix. Margin icons highlight key facts, tricks, cautions, and cross references. Annotation ©2004 Book News, Inc., Portland, OR