|
Programming
in VBA |
an eWord company |
|
This course is conducted using MS Office 2007, however is also suitable for Office 2003 and 2010 users. |
|
General Course Information This 3 day program aims to increase your productivity by providing the skills and knowledge to program VBA in Access effectively.
You will learn to Ø Understand some of the aspects of developing applications in Access Ø 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
What skills you need Participants need to be proficient users of Microsoft Access and should have extensive experience in formatting, reports, queries and relational databases.
Electus training Electus is a South Australian company with 20 years of experience in training. Trainers and facilitators at Electus are chosen for their expertise, practical and broad experience in their field and a relaxed and friendly manner.
Training includes Each participant receives a training reference manual/workbook and supplementary training materials. Refreshments and lunch are provided. |
|
Duration 3 days 9:00am-4:15pm
Who needs to come This course is designed for proficient Access users who wish to learn how to develop programs in VBA.
Nationally Recognised Qualification You can choose to have this course assessed towards a unit of competency for a nationally recognised qualification.
Regular venue 37 Angas Street Adelaide SA (near Victoria Square)
How to book Contact
Electus by
Course dates Visit www.electus.com.au for the latest course schedule or ring us on (08) 8221 5517.
|
Course Content
|
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 Macros And VBA · Creating Macros · Assigning Macros · Creating More Complex Macros · Converting Macros to VBA Code · Why you shouldn't use Macros VBA Essentials · Creating a Startup Form · Understanding Modules · Code Behind Forms · Standard Code Modules · Standard Vs Class Modules · Naming Conventions VBA Subroutines · Understanding Modules · The Anatomy of a Module · Creating a Subroutine · Creating a Function · Calling Procedures · Passing Parameters · Returning Values · Scoping Procedures Variable VBA · 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 |
Interactive VBA · The Act o 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 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 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 The DoCmd Object · 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
|
ActiveX Data Objects - Tables · Setting References using VBA · Creating a Table with ADO · Removing a Table using ADO · Populating a Form using ADO · Dealing with an Empty Table ADO Forms & Recordsets · Navigating Records in a Form · Finding a Record · Updating a Record · Deleting a Record · Adding a New Record Debugging VBA · 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 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
|