Access Introduction

This workshop is designed to introduce you to key elements of Access databases. 

It will allow you to become familiar with the concepts required to design an initial database to collect and record data, query your information and produce a simple report.

Key content

  • Database concepts and design principles
  • Creating a database
  • Creating a table, setting field properties and primary keys
  • Entering and editing data within the table
  • Creating a form for data entry
  • Modifying the design of a form, and entering data using a form
  • Searching for records using filters - by selection, advanced filters
  • Creating select queries using set criteria
  • Creating simple reports that sort and group data using the Report Wizard
  • Simple formatting of reports within design view

Objectives

  • Learn the skills required to design, setup and use your first database
  • Work from the initial brief and design stages, through to inputting and outputting your data

Suitable for

New and existing users

Notes

PC only. Access 2016 is used. Also suitable for 2013 users.

Cost

Free for University of Auckland and UniServices staff

Registration

If you are University of Auckland staff, please visit Career Tools to view workshop availability and register on a session.

All others, please see our Registration page for more information.

Dates, times and venues for scheduled workshops 2018

Tuesday 1 May 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Tuesday 31 July 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Wednesday 24 October 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland