Skip to site navigation

Designing and developing databases in Access 2010

Description:

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.

Outline:

  • overview of database design
  • introduction to table design
  • creating a table
  • fields and data types
  • primary keys
  • field and table properties
  • lookup fields
  • principles of good database design
  • types of relationships
  • linking tables (creating relationships)
  • designing a database based on a scenari

Delivery:  Self-paced

Trainer led sessions are no longer available for Access 2010, see Access 2013.
The resources listed below can be used for self-paced learning.

Resources: