Access 2007: Further Use Prerequisites
Mon 29 Nov - Tue 30 Nov 2010
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 | Mon 29 Nov 2010 09:30 - 13:00 | 09:30 - 13:00 | Titan Teaching Room 2 | A.T. Judd, M. ten Wolde |
| 2 | Tue 30 Nov 2010 09:30 - 13:00 | 09:30 - 13:00 | Titan Teaching Room 2 | A.T. Judd, M. ten Wolde |
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/
- There are special Access courses for Departmental Support Staff: see http://www.admin.cam.ac.uk/offices/personnel/staffdev/list.shtml#it_skills_development or contact Staff Development for details. Self-taught courses are also available.
- 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