VBA ACCESS 2003

New Horizons Learning Centres of Australia
Brisbane, Melbourne, Newcastle, Perth, Sydney, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course aims to increase your productivity by providing the skills and knowledge to program using VBA in Access 2003 effectively.

Learning Outcomes:
At the completion of this courseware participants will be able to:

Understand some of the aspects of developing applications in Access 2003
Create and assign macros and understand the advantages and disadvantages of using macros
Understand the programming environment and how forms and modules are used in it
Create and work with subroutines and function procedures
Create and work with variables
Communicate with the user through input boxes and message boxes
Program decision structures using IF and CASE statements
Develop a variety of programming loops for repeating operations
Use the DoCmd object to perform most of the operations associated with a database
Use DAO to handle working with data in your programs
Use the debugging features of VBA to locate and identify errors
Develop safeguards in your program and prevent unforeseen errors.

Target Audience:
This course is intended for people who wish to improve their knowledge and skills in the use of the Access 2003 VBA.

Pre-requisites:

This course is designed for participants with a sound knowledge of the Access 2003.
Outline:

Development Basics
- The Access Development Environment
- The Importance Of Splitting Databases
- Maintaining Links
- Using The Database Splitter
- Using Queries For Reports And Forms
- Access Run-Time
- Understanding Client/Server
- Quick Reference

Macros And VBA
- Macro Overview
- Creating Macros
- Assigning Macros
- Creating More Complex Macros
- Converting Macros To VBA Code
- Why You Shouldn’t Use Macros
- Quick Reference

VBA Essentials
- Programming Environment Overview
- The Role Of Forms
- Creating A Startup Form
- Understanding Modules
- Code Behind Forms
- Standard Code Modules
- Standard Vs Class Modules
- Naming Conventions
- Quick Reference

VBA Subroutines
- Understanding Modules In Access
- The Anatomy Of A Module
- Creating A Subroutine
- Creating A Function
- Calling Procedures
- Passing Parameters
- Returning Values
- Scoping Procedures
- Quick Reference

Variable VBA
- Overview Of Variables
- Creating String Variables
- Option Explicit
- Working With Numbers
- Dealing With Overflows
- Working With Decimals
- Working With Dates
- Default Values
- Scoping Variables
- Local Variables
- Module-Wide Variables
- Passing Parameters
- Passing Parameters By Value
- Quick Reference

Interactive VBA
- The Act Of Communicating
- Creating A Simple Input Box
- Creating More Elaborate Input Boxes
- Global Positioning
- Simple Message Boxes
- Creating Larger Messages
- Breaking A Message Line
- Customising Icons And Buttons
- Message Box Functions
- Responding To Different Buttons
- Quick Reference

Decisive VBA
- Decisions Overview
- Creating An In-Line If
- Creating A Block If
- Multiple If
- Multiple If Using Text
- Using Case Statements
- Value Ranges In Case Statements
- Case Statements With OR
- Asking Yes/No Questions
- Quick Reference

Looping VBA
- Program Loops
- Creating A While Loop
- Taking Care Of Counters
- Creating An Until Loop
- For Each Loops
- Exiting From Loops
- For Next Loops
- Quick Reference

The DoCmd Object
- Overview Of DoCmd
- Navigating With DoCmd
- Moving Through Records
- Filtering Records With DoCmd
- Opening A Form With DoCmd
- Opening A Report With DoCmd
- Closing A Form
- Creating Variable Reports
- Quick Reference

ActiveX Data Objects -
- Tables

- Overview Of ADO
- Setting References Using VBA
- Creating A Table With ADO
- Removing A Table Using ADO
- Populating A Form Using ADO
- Dealing With An Empty Table
- Quick Reference

ADO Forms & Recordsets
- Overview of ADO Forms
- Navigating Records In A Form
- Finding A Record
- Updating A Record
- Deleting A Record
- Adding A New Record
- Quick Reference

Debugging VBA
- Overview Of Debugging
- Setting A BreakPoint
- Setting Additional Breakpoints
- Stepping Through A Procedure
- Viewing The Call Stack
- Using The Locals And Immediate Windows
- Adding A Watch
- Deleting A Watch
- Quick Reference

Handling Errors In VBA
- Error Handling Overview
- Understanding Common Errors
- Creating A Simple Error Handler
- Understanding The Error Object Model
- More Elegant Error Handling
- Resuming From Errors
- Forcing An Error
- Creating Custom Errors
- Quick Reference.
...''

Phone:1300 794 006

School Address:

Level 6, St. Martins Tower
31 Market Street
Sydney NSW 2000 Australia

Level 4, 200 Creek Street,
Brisbane, QLD 4000

Level 2, 31 Queen Street,
Melbourne, VIC 3000

9 Denison Street,
Newcastle West NSW 2302


Jobs & Resumes: Brisbane, Melbourne, Newcastle, Perth, Sydney
Houses & Roommates: Brisbane, Melbourne, Newcastle, Perth, Sydney
Travel Agencies: Brisbane, Melbourne, Perth, Sydney

Search other schools for VBA ACCESS 2003 training resources.

QuarkXPress 6.0
Microsoft Office 2007
MS Word 2007
Windows Vista
Microsoft Expression Web 2007
Team Collaboration Using Microsoft Windows SharePoint Services
Forecasting and Trend Analysis using Microsoft Office Excel 2003
Access 2007
Lotus Notes 7
Managing Critical Business Information Using Microsoft Office Access 2003
Managing Financial Information Using Microsoft Office Access 2003
Web Design with XHTML, HTML, and CSS
Time and Task Management Using Microsoft Office Outlook 2003
XML
FileMaker Pro 7.0
Presentations Using Microsoft Office PowerPoint 2003
Online Merchandising Using Microsoft Office FrontPage 2003
Adobe Photoshop CS3
CorelDRAW 12

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.