Access 2016

Access 2016
(Access 2013, Access 2010, and earlier versions also available.)

Access 1 - introductory activities

  • using an Access database
  • navigating and searching in tables
  • datasheet and form views
  • Access terminology; including tables, records, fields and keys
  • design and layout views
  • improving the appearance of forms
  • inserting, deleting, and updating data
  • sorting data into order
  • applying filters
  • simple queries using the QBE grid
  • creating a database and tables from scratch.

Access 2 - intermediate activities

  • developing a form in design view
  • importing data into tables
  • criteria searching
  • using calculations and functions in queries
  • developing output reports, including summary information
  • developing a multi-table database
  • inserting sub-forms into a main form
  • setting up a navigation pane as a user-friendly interface.

Annual licence fee $2.50 per user (Access 1 and 2) - a minimum order of 10 licences applies.
Single user licence: Perpetual licence $7.50 (Access 1 and 2).

Download sample Access activity (484 kB)