Access X Programming Weekend Crash Course
Published on 10. October 2003
Book
Paperback/Softback
504 pages
978-0-7645-3975-6 (ISBN)
Description
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, continued - 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; and, Creating SQL Server Queries.
Saturday, continued - 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; and, Creating SQL Server Queries.
More details
Series
Language
English
Place of publication
Foster City
United States
Publishing group
John Wiley & Sons Inc
Target group
Professional and scholarly
College/higher education
Illustrations
Illustrations
Dimensions
Height: 233 mm
Width: 187 mm
Thickness: 25 mm
Weight
699 gr
ISBN-13
978-0-7645-3975-6 (9780764539756)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Content
Preface.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.