skip to navigation skip to content
- Select training provider - (University Information Services - Digital Literacy Skills)
Thu 23 Jun - Fri 24 Jun 2016
14:00 - 17:00

Venue: Phoenix Teaching Room 1, New Museums Site

Provided by: University Information Services - Digital Literacy Skills


Booking

Bookings cannot be made on this event (Event is completed).


Other dates:

No more events

[ Show past events ]



Register interest
Register your interest - if you would be interested in additional dates being scheduled.


Booking / availability

Access 2013: Further Use
Prerequisites

Thu 23 Jun - Fri 24 Jun 2016

Description

This course is intended for those already using Microsoft Access 2013 who wish to explore more advanced queries and forms. Those who have attended the Access 2013: 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
Prerequisites

Prior knowledge of Windows is assumed, and basic knowledge of Access tables, forms, reports and queries (as covered on the Introduction) is required.

Sessions

Number of sessions: 2

# Date Time Venue Trainer
1 Thu 23 Jun 2016   14:00 - 17:00 14:00 - 17:00 Phoenix Teaching Room 1, New Museums Site map Lynn Foot
2 Fri 24 Jun 2016   14:00 - 17:00 * 14:00 - 17:00 * Phoenix Teaching Room 1, New Museums Site map Lynn Foot
* Optional session.
Topics covered
  • Introduction to relational database design
  • Working with multiple tables
  • Queries (action, summary)
  • Forms (enhancing forms)
Format

Presentations, demonstrations and practicals.

Taught using

Access 2013 on MCS Windows

Notes
  • 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
Duration

Two half day sessions

Theme
Databases

Booking / availability