Designing and developing databases in Access 2010
Note that database design is a specialist area that takes a long time to master and this course can only introduce you to the basic principles of database design. It is aimed at people who need to design their own relational databases from scratch and will cover the practical aspects of creating tables and relationships as well as introducing participants to the principles of database design and giving participants an opportunity to experiment with designing their own databases.
This course is suitable for those who are using existing databases and just need to understand the way relational databases are structured and to be able to create tables and relationships.
Note that this course can be completed by people using Access 2007. There are some differences between the two versions but most features are the same.
Pre-requisites (staff training course):
It is strongly recommended that participants are confident in using an existing database, particularly navigation, opening and closing objects and viewing and entering data in tables. Users who need to develop these skills should complete the Using databases in Access course before embarking on this one. Participants may also find it helpful to watch this 10-minute video tutorial to begin to understand the terminology and concepts of relational database design.
Trainer led sessions are no longer available for Access 2010, see Access 2013.
The resources listed below can be used for self-paced learning.
- Manual (Word doc)
- Tasks (Word doc)
- Task Files (zip file)
- Presentation slides (doc file)
- Answer to exercise 13 (doc file)