This course introduces fundamental relational database management system (RDBMS) concepts
and data normalization principles, providing a foundation for creating simple tables, queries, forms and reports.
On successful completion you will be able to apply these new skills:
- Design basic databases using data normalization rules.
- Create tables and setting properties and constraints.
- Create table relationships (One-to-One, One-to-Many, Man-to-Many).
- Design and create queries for viewing, sorting, filtering and analyzing data (Select, Total, and Parameter queries).
- Design and create simple forms for data input.
- Design and create simple reports for data output.
- Using basic database functions in queries (IIf, Left, Right, InStr, Mid).
- Create charts in forms and reports.
Prerequisites: You should be comfortable navigating in a Windows environment including file management
tasks such as copying, moving, and renaming files. No database experience is necessary.
Class Syllabus
In-class Practice Problems
Homework Assignments
Database Solution Files