This course discusses the principles of good design for a database - choosing suitable fields and tables and setting up relationships between them, using Access. We teach using Access 2010, but the course will also be suitable for users of other versions.
Key topics
- Planning a database with a single table
- 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
- Setting up relationships between tables
- Working on related data using a form
Course information
| Intended audience | Those who need to design and build a new database from scratch, or to revise an existing database |
| Prior knowledge | Knowledge of using an Access database to edit and add data is assumed (as covered in Access: Fundamentals) |
| Resources | A course book must be purchased when you attend the course (see the Cost below) |
| Software | Microsoft Access 2010 |
| Format | Presentation with practical exercises |
| Further information | Using Access 2003 or 2007? See our Microsoft Office page |
| Where next? | Access: Creating queries forms and reports |
Course provider: IT Learning Programme
Frequency: Every term. Express an interest in future dates for this course.