Course Details and Schedule

If you need to build, plan or revise a database, this is the course. Starting with a design from the course Databases: Concepts of database design, you will use Access to create tables with fields and a range of useful properties, learn about relationships between tables, create and manage them.

See below for course schedule

Key topics
  • Building a single-table database in Access
  • Choosing fields with appropriate data types
  • Setting properties to help accurate data input
  • Flat-file vs. multiple-table design
  • Building a database with multiple tables
  • Primary key fields
  • Setting up relationships between tables
Course information
Intended audience Those who need to design and build a new database from scratch, or to revise an existing database
Prior knowledge This course assumes you have already planned the design of your database, as shown in Databases: Concepts of database design. Watch these videos to prepare for this course (requires an Oxford University account with
Resources A course book must be purchased when you attend the course (included in the Cost below)
Software Microsoft Access 2013
Format Presentation with practical exercises
Further information Note: This course replaces Access: Database structure
Where next? Databases: User-friendly databases using Access
Taught using:
Windows 7

Course provider: IT Learning Programme

What you will need:

BYOD friendly. A computer and software are provided, however you can bring your own with the correct software installed (read our guidance first)


Frequency: Every term. Express an interest in future dates for this course.