|
|
|
Module 1: Introduction to Programming
- Using Visual Basic Help
- Writing Procedures
- Working with Variables
- Controlling Program Flow
- Calling Procedures
- Lab:
- Introduction to Programming
Skills
- Use Visual Basic Help.
- Use the Visual Basic Editor to add code to applications.
- Declare and use variables.
- Use built-in functions to obtain values from users.
- Create and call Sub procedures.
- Use conditional statements to control the flow of programs.
Top |
|
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
- Lab:
- Responding to User Actions
Skills
- Create an event procedure.
- Add an event procedure to a form.
- Respond to user actions programmatically.
- Perform specific tasks by using the DoCmd object.
Top |
|
|
Module 3: Validating Data
- Overview of Data Validation
- Validating Data Without Using Code
- Validating Data by Using Code
- Lab:
- Validating Data
Skills
- Differentiate between data validation at the table level, form level, and code level
- Use the built-in validation tools in Microsoft Access.
Top |
|
Module 4: Using Functions and Understanding Scope
- Using functions
- Understanding scope
- Lab:
- Using Functions and Understanding Scope
Skills
- Describe the appropriate use of functions.
- Call built-in and custom functions in an application.
- Create a custom function.
- Describe the different levels of scope available to variables and procedures.
- Define variables at the appropriate level of scope.
- Define procedures at the appropriate level of scope.
Top |
|
|
Module 5: Using Debugging Tools
- Stepping Through Code
- Viewing Variables
- Lab:
- Using Debugging Tools
Skills
- 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.
Top |
|
Module 6: Handling Run-Time Errors
- Types of Errors
- Adding Error Handlers
- Lab:
- Handling Run-Time Errors
Skills
- Trap run-time errors.
- Create error handlers.
- Use the Err object.
Top |
|
|
Module 7: Looping Through Code
- Overview of Looping Structures
- For Loops
- Do Loops
Skills
- List the different looping structures available in Visual Basic for Applications.
- Write a For...Next loop to perform execution of code statements a fixed number of times.
- Write a Do...While and a Do...Until loop to perform execution of code statements a variable number of times.
- Describe the difference between beginning-of-loop and end-of-loop evaluation methods, and write code statements to accomplish each type of evaluation.
Top |
|
Module 8: Working with Records
- Overview of Recordsets
- Retrieving Data
- Structured Query Language (SQL)
- Manipulating Data
- Lab:
- Working with Records
Skills
- Define recordsets.
- Access data in tables by using ADO recordsets.
- Retrieve data by using SQL and ADO recordsets.
- Manipulate data by using SQL and ADO recordsets
Top |
|
|
Module 9: Working with XML
- About XML
- Importing XML
- Exporting XML
- Transforming XML
- Modifying XML using the DOM
Skills
- Describe XML and related technologies.
- Import XML into Access.
- Export XML from Access.
- Transform XML by using the Extensible Stylesheet Language for Transformations (XSLT).
- Modify XML by using the DOM.
Top |
|
Module 10: Finalizing Your Application
- Reviewing Your Application
- Enhancing the User Interface
- Packaging for Delivery
- Lab:
- Finalizing Your Application
Skills
- List four good coding practices and describe why you should use them.
- Describe the testing criteria for an application.
- Customize a switchboard.
- Hide code by creating an MDE file.
- Describe how to use the Compact and Repair utility to maintain your database application.
- Describe why and how to use the Database Splitter utility.
- Describe when and how to use the Packaging Wizard to prepare an application for distribution.
Top |
|
|
|
Exams:
-
There are no exams directly associated with this course
|
|
Price Options ex VAT:
Classroom Training
? |
Distance Learning
? |
eLearning Options
? |
Book Learning
? |
£
1185
(€1683)
|
£
674.00
(€957)
|
- |
No Books Supported for Course at present
|
|
|
Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008
|
|
