Microsoft Access 2007 Advanced

Topics: 3

Length: 9 hours

Access 2007 offers a vast array of functionality that beginners only briefly touch upon. This set of tutorials explores some of the more powerful abilities, including charts and pivot tables, forms, graphs, multitable and crosstab queries, security, macros, and more.

Topic 1: Expressions and Queries

This course deals with the use of Visual Basic for Applications functions when creating queries, with examples of queries that use the four basic types of joins in Microsoft Access 2007.

Topic 2: PivotTables, PivotCharts, and Graphs

Following this tutorial you will have a good understanding of Pivot Tables including exporting and optimising Pivot Tables, Charts and Graphs.

Topic 3: Macros and Data Imports/Exports

This topic deals with the use of macros and events, and your ability to import and export data between Microsoft Access 2007 and other programs.