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, Parameter, and Crosstab 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: Comfortable navigating in Windows environment, windows file management skills. Prior database knowledge helpful but not required.