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)