Access 2010: Further Use Prerequisites
This course is intended for those already using Microsoft Access 2010 to store and retrieve data who wish to explore queries, forms and reporting. Those who have attended the Access 2010: Creating a Simple Database course will find this follows on seamlessly from where that course ended. Part of the course explores relational database design concepts for simple databases holding a few tables. The remainder focuses on more advanced queries. The second session is optional for you to work through the course material or receive support on your own project.
- All current University members (departments and colleges)
- Further details regarding eligibility criteria are available
Prior knowledge of Windows is assumed, and basic knowledge of Access tables, forms, reports and queries (as covered on the Introduction) is required.
Number of sessions: 2
| # | Date | Time | Venue | Trainers | |
|---|---|---|---|---|---|
| 1 | Thu 25 Jun 2015 09:30 - 13:00 | 09:30 - 13:00 | University Information Services, Roger Needham Building, Ely Training Room 2 | map | Lynn Foot, Lynda Stratford |
| 2 | Fri 26 Jun 2015 09:30 - 13:00 * | 09:30 - 13:00 * | University Information Services, Roger Needham Building, Ely Training Room 2 | map | Lynn Foot, Lynda Stratford |
- Introduction to relational database design
- Working with multiple tables
- Queries (action, summary)
- Forms (enhancing forms)
Presentations, demonstrations and practicals.
Access 2010 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
Booking / availability