catraining

 

Microsoft Partner
Microsoft Access VBA Introduction

Audience: This course is designed for existing Access users who want to use VBA to automate database tasks or simplify complex database sequences.

Course Duration: 2 days(2)

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Access VBA Introduction training course is delivered at our training centre in London situated close to Liverpool Street station, training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

 

 

After completing this course, students will be able to:
  • Use the VBA code editorreaining course
  • Create message boxes and variables
  • Create function procedures
  • Understand Visual Basic concepts
  • Trigger code in various ways
  • Create loops
  • Manipulate Recordsets
  • Debug procedures and handle errors
  • Automate Forms
  • Link to Excel and Word
  • Modify queries

  • Course Content

    print this page
  • Module 1: The VBA code editor
    • Two ways to create modules
    • Using Project Explorer
    • Basic subroutines and comments
    Module 2: Messages and variables
    • The all-powerful DoCmd object
    • Displaying messages
    • Getting input from users
    • Using variables
    Module 3: Creating functions
    • Passing arguments
    • Returning values
    Module 4: Visual Basic explained
    • Objects and collections
    • Methods and properties
    • The Access object model
    • Getting help in VBA
    Module 5: Triggering code
    • Attaching code to forms
    • Attaching code to buttons
    • Attaching code to events
    • Manipulating form/control properties
    • Making code not form-specific
    Module 6: Looping
    • The four types of loop
    • Looping over all open forms
    • Looping over controls
    • Looping over Access Objects

     

    Module 7: Recordsets
    • Choosing ADO or DAO
    • Adding data
    • Editing data
    • Deleting data
    Module 8: Debugging and error handling
    • Stepping through macros
    • Setting breakpoints
    • Trapping for errors
    • Case studies
    Module 9: Automating Forms
    • Navigation buttons
    • Creating a simple menu
    • Validating forms
    • Criteria forms
    Module 10: Linking to Excel and Word
    • Referencing other applications
    • Manipulating Excel from Access
    Module 11: Modifying queries
    • Basic SQL statements
    • Amending queries' SQLMicrosoft

     


Call us now for further information Tel:08001601666