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

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