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 attended 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:  trainer-led

This is a trainer-led course covered over two three-hour sessions on consecutive days.

To see when the next session of this course is running, please check our training calendars:

Resources: