GOPAS is a provider of highly interactive self-study courses for Office Computer Skills training. Courses on Microsoft Office, ECDL and Windows are available in English, Arabic, French, German, Czech and Slovak localisations. Read more...


MS Access 2010: Advanced

MS Access 2010: Advanced
(0)
£15.00 per seat

Buy Now

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