MS Access 2010: Advanced

Introduction

This course focuses on the creation of reports, data access pages and macros. It will also familiarize you with the options for database management, data import and export, as well as with the SQL language.

Lessons

  • Report creation
  • Reports with calculations
  • Graphical editing of Reports
  • Additional report options
  • Pivot table and chart
  • Object dependencies and properties inheritance
  • Macro basics
  • Assigning a macro to a button
  • Data validation using macros
  • Data evaluation via macros
  • Database print and documentation
  • Importing Access Objects and splitting a database
  • Data exporting
  • Program import and export
  • XML format
  • Navigation in a database
  • Security and privacy in databases
  • SQL language