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: