|
ms802-ver10.2-sg
Programming in VBA Using Access 2002 (2 day)
Description
This course aims to increase your productivity by providing the skills and knowledge to program VBA in Access 2002 effectively.
Audience
This course is designed for proficient Access users who wish to learn how to develop programs in VBA.
Suggested PrerequisitesThis course is designed for participants who are proficient users of Access 2002. Participants should have extensive experience in formatting, reports, queries and relational databases.
MethodologyA hands-on approach is taken during this course. The exercises are designed to impart relevant skills and knowledge by having participants work through real-life examples and scenarios.
ObjectivesAt the completion of this courseware participants will be able to:
• understand some of the aspects of developing applications in Access 2000
• 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 ADO 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.
Course OutlineDevelopment 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 • Development Basics Quick Reference • On Your Own
Macros And VBA • Macro Overview • Creating Macros • Assigning Macros • Creating More Complex Macros • Converting Macros To VBA Code • Why You Shouldn't Use Macros • Macros and VBA Quick Reference • On Your Own
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 • VBA Essentials 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 • VBA Subroutines 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 • Variable VBA 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 • Interactive VBA 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 • Decisive VBA 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 • Looping VBA 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 • The DoCMD Object 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 • ActiveX Data Objects Quick Reference
ADO Forms & Recordsets • Overview Of ADO With Forms & Recordsets • Navigating Records In A Form • Finding A Record • Updating A Record • Deleting A Record • Adding A New Record • ADO Forms & Recordsets 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 • Debugging VBA 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 • Handling Errors Quick Reference.
|
|
|
|
