Access 2013: Further Use Prerequisites
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.
- 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 | Tue 24 Nov 2015 14:00 - 17:00 | 14:00 - 17:00 | University Information Services, Roger Needham Building, Ely Training Room 2 | map | Lynn Foot, Somsri Parker |
2 | Wed 25 Nov 2015 14:00 - 17:00 * | 14:00 - 17:00 * | University Information Services, Roger Needham Building, Ely Training Room 2 | map | Lynn Foot, Somsri Parker |
- 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.
Access 2013 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