Summary of DBD181[Active]

Open Window University for the Creative Arts, Ltd (companies registration no: 120190006214) is a Private Higher Education Institution registered as a UNIVERSITY with the Higher Education Authority in Zambia in accordance with the Higher Education Act No. 4 of 2013, holding Certificate Number: 2020/HEA082. Open Window University courses are accredited by the Higher Education Authority (HEA) and registered with the Zambia Qualifications Authority (ZAQA). The Institution has additionally been granted registration in line with the TEVET Act No. 13 of 1998 and TEVET Amendment Act No. 11 of 2005 to offer Level 4 Certificates, with TEVETA Registration Number TVA/ 1061. For more information, please contact Open Window University at info@owu.edu.zm © 2021 Open Window University. All rights reserved.

General

Announcements

Examination (November 2025)

Overview

Study Guide

McFadyen, R. (2016) Relational Databases and Microsoft Access. Ron McFadyen.

O'Reilly Books

Assignments and Project

Assignment 1

Assignment 2

Project

Class Tests

DBD 181 CT3

DBD 181 ST

Database Design

(Slides) Lecture 1 Database Design - Part 1

(Slides) Lecture 1 Database Design - Part 2

Exercise 1

Database Normalisation

(Slides) Lesson 02 Database Normalization Part 1

(Slides) Lesson 02 Database Normalization Part 2

Exercise 2

Designing Database Objects

(Slides) Lesson 03 Part 1 Designing the Database Objects

(Slides) Lesson 03 Part 2 Creating Databases and Tables

(Notes) 7-Step Design Process

Exercise 3.1

Exercise 3.2

Database Relationships

(Slides) Lesson 04 Creating Relationships and Entering data

Animal Hospital Database

Exercise 4

Queries

(Slides) Lesson 05 Queries - Part 1

(Slides) Lesson 05 Queries - Part 2

Exercise 5

SQL Introduction

(Slides) Lesson 06 SQL In Access - Part 1

(Slides) Lesson 06 SQL In Access - Part 2

(Slides) Lesson 06 SQL In Access - Part 3

Exercise 6

Exercise 6.1 SQL Queries 1

Exercise 6.2 SQL Queries 2

Forms

(Slides) Lesson 07 Creating Forms in Access Part 1

(Slides) Lesson 07 Creating Forms in Access Part 2

Exercise 7

Reports

(Slides) Lesson 08 Creating Reports in Access

Exercise 8

Basic Database Networking

(Slides) Lesson 09 Basic Database Networking

Exercises

Exercises

Solutions

Resources

Sample databases

DBD181[Active]

FIND OUT MORE ABOUT

OPEN WINDOW ZAMBIA