Microsoft Access VBA Introduction Training Course

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

Course Duration: 2 days

We are happy to arrange for a trainer to contact you to help tailor you course.

Course Availability: Monday – Saturday

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

Course Location: This Access VBA introduction training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

  • Use the VBA code editor
  • 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 Outline

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’ SQL
, Microsoft Access VBA Introduction Training
, Microsoft Access VBA Introduction Training

Microsoft Office Access 2016 (also known as Microsoft Access, or simply Access) is a database application. In this context, data refers to information that is usually in the form of text or numbers, and this information is stored in a table. Information in one table may relate to information in zero, one, or many other tables. One or more tables of information, when grouped together in a logical way, are collectively referred to as a database.

Access is designed to enter, edit, and analyze the data in a database. Queries are used to extract information from the tables based on search criteria. You can use a form as a user-friendly method of viewing, entering, or modifying data. Access can also generate reports (such as quarterly sales by each employee) based on the data in the database.

 

Microsoft Access is the Microsoft Office relational database product. It is only available on the PC platform and is not available for Mac OSX Microsoft Access is used for efficient data management and storage. It is primarily used to track and manage very large quantities of data: like customer’s contact details, order numbers etc.

 

Mouses Microsoft training courses take you on a journey from being a complete beginner through to an advanced user who will then be able to make full use of the application’s capabilities and beyond.

 

Taught by highly efficient, expert MCT trainers with many years of experience our hands-on courses mean that you will gain practical experience as well as useful tips and tricks. Full access to our extensive library of software help guides is included in the price.

 

  • Microsoft Access Training courses London