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)

Booking normally opens 30 days before the course begins.
Commences Dates Time Sessions Cost Location Status
10th week Wednesday 29 June 09:15-12:15 1 9.00 IT Services, 13 Banbury Road places available Add to basket

Can't make any of these dates? Express an interest in future dates for this course.

Frequency: Every term.