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: Intermediate

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

Buy Now

Introduction

In this course, you will learn advanced techniques of designing tables and queries. You will acquaint yourself in depth with the creation and use of forms.

Lessons

  • Field indexing and data validation
  • Totals
  • Aggregate functions
  • Crosstab query
  • Action queries
  • Data normalization
  • Make-Table query
  • Form creation using wizard
  • Working with form
  • Creating forms in design view
  • Working with form controls
  • Calculated form fields
  • Combo Box in forms
  • Option buttons in forms
  • Organising Form fields
  • Creating a Form with a subform
  • Subform insertion in design view
  • Form as a user interface