MS Access 2010: Intermediate

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