Skip to site navigation

Designing and developing databases in Access 2013

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 2010.  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 (this is available self-paced only) 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:

All ISD IT Training course materials are now available to download from the Moodle course: ISD IT Training

You will need to login to Moodle using your UCL user ID and password.

Materials are organised by application name e.g. SPSS or Excel 2013 then by course.

Whenever possible please ensure that you have downloaded the course materials prior to attending a booked course.