Access Introduction

Designed to introduce the user to key elements of Access databases.

Become familiar with the concepts required, design an initial database to collect and record data, query your information and easily output some simple reports.

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, set up 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 2013 is used. Also suitable for 2010 users.

Cost

Free for University of Auckland and UniServices staff
Free for University of Auckland postgraduate students
$125+GST for others

Dates, times and venues for 2017

January - March 2017

Wednesday 8 March 2017, 1-4pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

April - June 2017

There are currently no scheduled sessions for this period.

July - September 2017

Thursday 7 September 2017, 9am-12pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus