Course begins: 17 Jan 2022
The first session will be for course orientation and an Introduction to Teams and Canvas.
During the course we will develop one main relational database project, which will be a simple multi-table application based on a small retail business selling goods to customers. This course will start with an elementary introduction to relational database systems, starting with the concept of relationships - what they are and why they are needed. This will be followed by a general overview of table objects, table types, and the basic connections required in a relational system. Design rules will be introduced on a ‘common sense’ basis.
On a practical level the course will examine the underlying design techniques and methods by which the relational objects and their contents can be constructed and manipulated in Microsoft Access. This includes using VBA and SQL.
The following list gives some of the topics which this course aims to cover:
- The basic concepts of a relational database.
- Defining and designing table objects for a relational database system.
- Defining relationships - use of key fields.
- Different types of relationships - one to one; one to many.
- Design rules, data integrity and validation.
- Building a practical relational database system with Microsoft Access.
- The user interface: creating multi-table queries; forms for data input; and 'smart' forms and reports for data output.
- An introduction to VBA and SQL.