PCWorkshops

Java and Data-related training courses to companies of all sizes

MS Access Advanced Course

Course Aims

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced tools and concepts in Access  in order to increase their knowledge and productivity.

Who Should Attend

Users with a good understanding of Microsoft Office Access   who want to expand on their capabilities in a short space of time. TSome of the lessons are quite technical and delegates must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Course Outline

Advanced Data Management

  • Referential Integrity
  • Table Relationships
  • An Introduction to SQL
  • Modal Dialog Boxes

Advanced Form Tasks

  • Using Subforms
  • Creating a Navigation Form
  • Advanced Form Controls
  • Exporting a Form
  • Other Form Tasks

Pivoting Data

  • Creating a PivotTable
  • Using PivotTables
  • Advanced PivotTable Tasks
  • Creating a PivotChart
  • More on PivotCharts

SQL and Microsoft Access

  • Understanding SQL
  • Using the SELECT Statement
  • Using Subqueries
  • Using SQL Joins
Training Location

The Royal Commonwealth Club, 25 Northumberland Avenue, Embankment, London WC2N 5AP

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s