skip to navigation skip to content
Tue 11 Aug - Wed 12 Aug 2020
14:15 - 17:00
Venues:

Provided by: University Information Services


Booking

Bookings cannot be made on this event (Event is in the past).


Other dates:


2012


2013


2014


2015


2016


2017


2020



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


Booking / availability

Access 2007: Further Use
Prerequisites

Tue 11 Aug - Wed 12 Aug 2020

Description

This course is intended for those already using Microsoft Access 2007 to store and retrieve data who wish to explore queries, forms and reporting. Those who have attended the Access Intro course will find this follows on seamlessly from where that course ended.

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 Trainers
1 Tue 11 Aug 2020   14:15 - 17:00 14:15 - 17:00 Greenwich House: Training Room 1 A.T. Judd,  M. ten Wolde
2 Wed 12 Aug 2020   14:15 - 17:00 * 14:15 - 17:00 * Phoenix Teaching Room A.T. Judd,  M. ten Wolde
* Optional session.
Topics covered
  • Introduction to relational database design
  • Working with multiple tables
  • Advanced queries (action, summary, crosstab)
  • Advanced reports (master-detail reports, changing the design of reports)
  • Advanced forms (designing a custom form, chart forms, switchboard)
  • Transferrring data between access and other applications
Format

Presentations, demonstrations and practicals.

System requirements

Access 2007 on PWF Windows

Notes
  • Anyone wishing to copy the course exercise files should bring a USB memory stick or they can be downloaded from; http://www-tus.csx.cam.ac.uk/courses/files/
  • This course only covers the use of Access and does not cover relational database design - there is a separate course on this topic.
  • Various self-taught modules on Access are also available.
Duration

Two half day sessions

Themes

Booking / availability

Override user: