Which Microsoft Access training course is right for you
This page gives a summary of our 3 main Access training courses. You can see more details about our Access training on our main MS Access page.
Access for Developers
This three-day course shows you how to build databases in Microsoft Access. The first part of the course shows you how to build databases, including creating relationships:
Learn how to build databases, set primary keys and create relationships.
The course then explains how to create queries and reports, and build forms:
Learn how to create forms like this one!
The course also shows how to create reports like this one:
A sample Access report.
Finally, the course includes enough VBA to learn how to link forms together.
Access Visual Basic for Macros (VBA)
Our two-day Access VBA course shows you how to write Visual Basic for Applications code in Access, so you'll learn how to make sense of code like this:
Private Sub Courseware0Id_AfterUpdate()
Me.Courseware1Id = Null
Me.Courseware2Id = Null
Me.Courseware2Id.Visible = False
'if nothing chosen, hide next level
If IsNull(Me.Courseware0Id) Then
Me.Courseware1Id.Visible = False
Exit Sub
End If
'otherwise, allow user to choose next level
Me.Courseware1Id.RowSource = s
Me.Courseware1Id.Visible = True
End Sub
We also run a two-day advanced VBA course, for experienced VBA programmers.
Access Querying
Finally, Wise Owl run a one-day Access querying course, for those who just need to get data out of their corporate database:
Learn how to write queries like this one, as well as understand how to create and use tables in Access.
This course is an alternative to the three-day developer course, not a prequel!