skip to navigation skip to content
Tue 23 Jun - Wed 24 Jun 2020
09:30 - 13:00


Provided by: University Information Services - Digital Literacy Skills


Bookings cannot be made on this event (Event is not taking bookings).

Other dates:

No more events

[ Show past events ]

Booking / availability

Access 2016: Further Use

Tue 23 Jun - Wed 24 Jun 2020


Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

This course is intended for those already using Microsoft Access 2016 who wish to explore more advanced queries and forms. Those who have attended the Access 2016: Creating a Simple Database course will find this follows on seamlessly from where that course left off - but be prepared for a harder challenge. Part of the course explores relational database design concepts for simple databases. The remainder focuses on more advanced queries and forms. The second session is optional for you to either work through and consolidate the course material, or to receive support on your own project.

Target audience
  • All current University members (departments and colleges)
  • Further details regarding eligibility criteria are available

Number of sessions: 2

# Date Time Venue Trainers
1 Tue 23 Jun 2020   09:30 - 13:00 09:30 - 13:00 University Information Services, Phoenix Teaching Room 1, New Museums Site map Simon Meaker
2 Wed 24 Jun 2020   09:30 - 13:00 * 09:30 - 13:00 * University Information Services, Phoenix Teaching Room 1, New Museums Site map Simon Meaker,  Lynn Foot
* Optional session.
Topics covered
  • Introduction to Relational Database Design
  • Creating Relationships
  • Importing and Exporting Records
  • Modifying Forms
    • Tabbed Forms
    • Simple Macros on Forms
    • Action buttons
  • Queries
    • Multi-table queries - understanding inner and outer joins
    • Parameter queries
    • Calcualtions in queries
    • Action queries

Presentations, demonstrations and practicals.

Taught using

Access 2016 on MCS Windows

  • Anyone wishing to copy the course exercise files should bring a USB memory stick or they can be downloaded
  • This course does not fully cover relational database design - there is a separate course on this topic RDB Design
  • Various self-taught modules on Access are also available

Two half day sessions

Related courses

Booking / availability