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
Resources A course book must be purchased when you attend the course (included in the Cost below)
Software Microsoft Access 2010
Format Presentation with practical exercises
Further information Note: This course replaces Access: Database structure.
Where next? Databases: Creating a user interface using Access
Taught using:
Windows 7

Course provider: IT Learning Programme

Schedule
Booking normally opens 30 days before the course begins.
Commences Dates Time Sessions Cost Location Status
1st week Thursday 16 October 09:15-12:15 1 9.00 IT Services, 13 Banbury Road places available Add to basket
2nd week Tuesday 21 October 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.