Microsoft Access Training

Our Microsoft Access Training Courses are designed to help users go from a database novice to expert in no time. All of our courses can be delivered as live, instructor-led online or in-person onsite classes. Our two-day Introduction course teaches students the basics of creating a database in Microsoft Access including how to create and use tables, forms, reports and queries. Our one-day Microsoft Access Advanced course builds on those skills to help students create more advanced reports and queries, including action queries to update, append and delete data. And, finally, our Microsoft Access VBA Training course teaches students how to use Macros and Visual Basic for Applications (VBA) Programming language to automate a database and create a full-blown application using Access.

Available Courses

  • Live, Instructor-Led Online Course for Individuals
  • Private Group Onsite or Live Online Course For Teams
  • Self-paced eLearning Course for Individuals

In this Microsoft Access Introduction Training course, students will learn how to use Access to create databases to store and manage data. Students will see how to create tables, design forms for data input and create reports to summarize data. Students will also learn how to create queries to join, filter, and sort data. Finally, students will see how to share data across other applications, including Excel.

In this Microsoft Access Advanced Training Course, students will learn advanced Microsoft Access skills such as how to secure and manage a database, how to design advanced forms and how to split an Access database for a multi-user environment, utilizing a front-end and back-end database. Students will also see how to use Macros in Microsoft Access to automate common tasks and will get an introduction to using VBA (Visual Basic for Applications) to take their…

In this Microsoft Access VBA Training course, students will learn how to use the VBA (Visual Basic for Applications) programming language to automate their database applications. They will learn about creating Sub Procedures and Functions and see how to call these blocks of code from an event occurring in Microsoft Access, such as a button being clicked or a user saving a record. Students will be introduced to the Microsoft Access Object Model, which will…