Access 2003 Programming Weekend Crash Course [Paperback]

Cary N. Prague (Author), Jennifer Reardon (Author), Lawrence S. Kasevich (Author), Diana Reid (Author), Phuc V. Phan (Author)

Book Description

ISBN-10: 0764539752 | ISBN-13: 978-0764539756 | Publication Date: October 10, 2003 | Edition: 1

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

Editorial Reviews

From the Back Cover

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

Product Details

• Paperback: 504 pages
• Publisher: Wiley; 1 edition (October 10, 2003)
• Language: English
• ISBN-10: 0764539752
• ISBN-13: 978-0764539756
• Product Dimensions: 9.3 x 7.4 x 1.1 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 3.8 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #1,311,935 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

17 of 17 people found the following review helpful:

4.0 out of 5 stars Take your time; as much as you need, October 3, 2004

By 

W Boudville (Terra, Sol 3) - See all my reviews
(VINE VOICE)    (TOP 1000 REVIEWER)    (HALL OF FAME REVIEWER)    (REAL NAME)   

This review is from: Access 2003 Programming Weekend Crash Course (Paperback)

The authors set themselves an ambitious remit. Can they actually teach you Access in 15 hours? They motivate this with a scenario of a weekend in which you have to learn, starting on Friday night, and going to Sunday afternoon. The time is divided into 6 parts, one on Friday, 3 on Saturday, 2 on Sunday. Each part has several sessions (=lessons) of half an hour each. A novel approach, at least to me. Somewhat of a role-playing setup.

Each session goes over some straightforward coding. There is a back and forth between the widget forms, which often show tabular data, and the procedures that make these forms, or analyse input from them.

The pace is rather hurried. And you don't really get into the SQL itself. But, by and large, you may be able to get a basic operational familiarity with Access if you stay the course. The problem is that some lessons may well take more than half an hour. If you find yourself doing this, don't worry. You're not a retard! Just take as much time as you need to understand the material. I think the authors are overly optimistic about the alloted time for some sessions. Yes, you can force yourself to commit only 30 minutes to each. But at what cost in comprehension? More to the point, you presumably want to build on what you learn here. A shaky foundation may not help. So take your time.

The book could be improved if the authors dispense with the artifice of the 15 hours total. Cute gimmick. But it wears thin, and can actually interfere with the book's efficacy.

17 of 19 people found the following review helpful:

5.0 out of 5 stars Awesome book to get up and running on Access 03 Programming, October 16, 2003

By 

Diane (Bloomington, IN) - See all my reviews

This review is from: Access 2003 Programming Weekend Crash Course (Paperback)

I bought this book to go along with Access 2003 Bible - also written by Cary Prague. I did some of the tutorials in this book and used the Bible to help expand my knowledge and found it very useful. This book gave me the first layer into Access Programming, but I needed it to get me going!

5.0 out of 5 stars excellent. makes you from beginner to expert. really, February 6, 2009

By 

YisMan - See all my reviews

Amazon Verified Purchase

This review is from: Access 2003 Programming Weekend Crash Course (Paperback)

short, easy to digest chapters.
very well explained.
i referred back to it many many times after i finished with it.
youve got theory, design, practice, quizes.
really well organized.
im sure very much work went into this book. and its obvious
RECOMMENDED for beginners/intermediates who want to go those few extra steps!