Access Intermediate

This course looks at the design of relational databases and the use of the related data in queries and reports together with more advanced form creation and ways to make your database more user friendly.

Key content

  • Database concepts and design principles
  • Create and utilise relationships between tables
  • Export record sets in Excel or text format
  • Collect data using email
  • Advanced queries - calculations in queries, asking for input for queries, creating a cross-tab query, other action-taking queries
  • Advanced form design - using the toolbox, bound and unbound controls, setting properties of controls, adding other controls to forms including combo boxes and command buttons
  • Make databases easier for others to use - switchboards and custom navigation panes

Objectives

  • Learn the key concepts of relational databases
  • Gain more advanced skills with queries, form design and reports

Prerequisite

Access Introduction

Suitable for

This is an advanced level workshop which is suitable for those who have completed the prerequisite or who are competent with the topics covered in that workshop. Before registering for this workshop, it is your responsibility to ensure that you are competent with the topics covered in the prerequisite workshop.

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 29 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

Registration is now open for all University of Auckland and UniServices staff.

Registration for all others opens in early June 2017. Please contact us from this date to request registration. Please note registrations will be processed on a first come first served basis.

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