Curriculum Design and Instruction To Teach
Microsoft Office Access 2007: Programming in
Visual Basic for Applications (VBA): Volume 8:
Author: Charles Hayes:
Microsoft Office Access, previously
known as Microsoft Access, is a
relational database management
system from Microsoft which combines
the relational Microsoft Jet Database
Engine with a graphical user interface.
It is a member of the 2007 Microsoft
Office system. Access can use data stored
in Access/Jet, Microsoft SQL Server, Oracle,
or any ODBC-compliant data container.
Skilled software developers and data
architects use it to develop application
software. Relatively unskilled programmers
and non-programmer "power users" can use it
to build simple applications. It supports
some object-oriented techniques but falls
short of being a fully object-oriented
development tool.
Special Features Include:
* Phases For Conducting A Needs Assessment:
* Curriculum Design Supplement:
* Curriculum Design Plan:
* Lesson Plans:
* Instructional Goals:
* Instructional Objectives:
* Instructional Activities:
* Instructional Evaluation Techniques:
* Standard Vocabulary:
* A Limited Glimpse:
Topics Include:
@ Programming In Visual Basic for
Applications (VBA):
* Introduction:
I. What is VBA:
A. Finding VBA Code:
1. Opening a class module:
2. Creating or opening a standard module:
B. Enabling VBA Code:
1. How code is organized:
C. Using the Visual Basic Editor:
1. Using the Code window:
2. Using the Immediate window:
3. Using the Object Browser:
4. Searching the Object Library:
5. Referring to objects and collections:
6. Choosing object libraries:
7. Closing the Visual Basic Editor:
D. Discovering Code as You Go:
1. Converting macros to VBA code:
2. Cutting and pasting code:
II. Writing Code:
A. How VBA Works:
B. VBA Syntax:
1. Arguing with VBA:
2. Module level versus procedure
level:
C. Declaring Module Options:
D. Writing Your Own VBA Procedures:
1. Creating a new standard procedure:
2. Creating a new event procedure:
3. Passing arguments to procedures:
4. Returning a value from a function:
E. Typing and Editing in the Code Window:
1. Shortcut keys used in the Code window:
2. Typing comments:
3. Breaking lines of code:
4. Dealing with compile errors:
F. Testing and Running Your Code:
1. Testing sub procedures:
2. Running sub procedures from Access:
3. Testing function procedures:
4. Using function procedures in Access:
III. Writing Smarter Code:
A. Creating Variables and Constants:
1. Make me a variable:
2. Scope and Lifetime of variables:
3. Defining constants:
4. Organizaing variables into arrays:
5. Multidimensional arrays:
6. Naming conventions for variables:
B. Making Decisions in VBA Code:
1. Using If...End If staements:
2. Nesting If...End If Statements:
3. Using a Select Case block:
C. Executing the Same Code Repeatedly:
1. Using Do...Loop to create a loop:
2. Using While...Wend to create a loop:
3. Using For...Next to create a loop:
4. Looping through an array:
5. Analyzing each character in a string:
D. Using Custom Functions:
IV. Controlling Forms with VBA:
A. Displaying Custom Messages:
1. Displaying a message box:
2. Responding to what the user clicks:
B. Opening Forms with DoCmd:
1. Umpteen ways to open a form:
C. Changing Form Controls with VBA:
1. Some Cool Control properties:
2. Controlling Properties example:
D. Understanding Objects and Collections:
1. Properties, Methods, and events:
2. Referring to objects and collections:
3. An example: Seeing whether a form is open:
4. Looping through collections:
5. Using With...End With:
V. Using SQL and Recordsets:
A. Recordsets and Object Models:
1. Quick and easy recordsets:
2. ADO recordset properties and methods:
3. Looping through a recordset:
4. Defining a recordset's cursor type:
5. Field names in recordsets:
B. SQL and Recordsets:
1. Breaking up long SQL statements:
C. Running Action Queries from VBA:
1. Cleaning up connections:
VI. Debugging Your Code:
A. Considering Types of Program Errors:
B. Fixing Compiler Errors:
C. Trapping Runtime Errors:
1. Fixing the runtime error:
2. Eliminating the Runtime error:
D. Dealing with Logical Errors:
1. Watching things happen:
2. Slowing down procedures:
3. Cleaning up:
* STATE OF THE ART CURRICULUM DESIGN:
* NEW:
* REFERENCES:
* ILLUSTRATIONS:
* B & W - COLOR PRINT:
* 8 TO 10 INCH FONTS:
* PHOTOS:
* PAPERBACK:
* TRANSPARENT FRONT PAGE:
* TITLE PAGE:
* BLACK OR WHITE BACK PAGE COVER:
* BINDED: BLACK OR WHITE COIL:
* 100 WHITE PAGES: 8x11 INCHES:
* ALLOW 10 TO 14 DAYS TO RECEIVE ITEM:
* ORDER EARLY WHILE SUPPLIES LAST:
