| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| Programming Microsoft Access 2002 (MOC2657) |
| Course Number: MOC2657 |
| Category: Database & Collaboration Tools |
| Duration: 3.00 days |
Description
This course teaches programming concepts and how to add simple functionality to a Microsoft Access 2002 database using Microsoft Visual Basic for Applications.
Outline
- Module 1: Introduction to Programming
- Using Visual Basic Help
- Writing Procedures
- Working with Variables
- Controlling Program Flow
- Calling Procedures
- Module 2: Responding to User Actions
- Overview of the class application
- Adding event procedures
- Working with events
- Using objects, properties, and methods
- Using the DoCmd object
- Module 3: Validating Data
- Overview of data validation
- Validating data without using code
- Validating data by using code
- Module 4: Using Functions and Understanding Scope
- Understanding functions
- Understanding scope
- Module 5: Using Debugging Tools
- Set breakpoints to stop program execution
- Run selected portions of code
- Test data and procedures in the Immediate window
- Monitor variable values in the Locals window
- Add and edit watch expressions
- Module 6: Handling Run-Time Errors
- Types of errors
- Adding Error Handlers
- Module 7: Looping Through Code
- Overview of looping structures
- For loops
- Do loops
- Module 8: Working with Records
- Overview of recordsets
- Retrieving data
- Structured query language (SQL)
- Manipulating data
- Module 9: Working with XML
- About XML
- Importing XML
- Exporting XML
- Transforming XML
- Modifying XML
- Module 10: Finalizing Your Application
- Reviewing your application
- Enhancing the user interface
- Packaging for delivery