Back to Home

What is Access?

Microsoft Access is a giant organiser that can be used for handling lists of data (databases). Access is a Relational Database, which means that it can hold a lot more related data in a more meaningful way than Excel.

Databases are no help if you can’t extract the data later, so Access is also a powerful reporting tool which can create charts without having to export the data to Excel, and create Forms without having to export to a Word Mail Merge - although Access is easily capable of performing these tasks if you need it to

Manuals are available in 2007, 2010, 2013 and 2016 versions.

 

 

 

 

What is in the course?

Did you want Access VBA? Follow this link to the VBA page.

Access Level 1

Access Level 2

Access Level 3

Access Level 4

Exercise File Downloads

My Access 2013 Database doesn't do PivotTables?!

No, sorry. Access 2013 does not support PivotTables or PivotCharts like the 2007 and 2010 versions. There has been some heated discussion on the web, but Microsoft has dropped them from Access 2013.