Three-Course Microsoft Access/Database Series

This hands-on foundational series in Relational Database Development takes a 3-tiered approach to help individuals gain relevant skills to manage and design effective database systems. Students seeking a portal into the complexities of database technologies will benefit from a holistic progression towards understanding relational database structure and development. Students seeking proficiency in Microsoft Access will gain practical skills to mine powerful, but lesser-known application features with confidence.

See what former students had to say about this course.

By using one development tool – Microsoft Access – and building one cohesive application from start to finish—students gain focused insight into the intricacies of the database world that can be readily applied to the real world.

This series evolves from Relational Database Management Systems (RDBMS) principles. The foundational course initiates students into design and manipulation of core database objects: tables, queries, forms and reports. Each object will be constructed from scratch so that students are guided on how to model an effective input/output schema.

As students develop skills to apply RDBMS concepts and data normalization rules, they learn intermediate level techniques to ensure data integrity and automate tasks. Various methods of data exchange between common programs are examined, as well as advanced table properties and constraints, complex queries and subqueries, functions and macro automation.

The final course explores the VBA programming layer. Students use VBA as a tool to understand primary concepts behind procedural programming languages. Theory will be organized into logical programming units that are enacted to enhance database usability and polish the finished design.

The culmination of this series will provide students with valuable skills and concepts necessary to navigate databases. Anyone who is new to database-speak or who is seeking a transition into the database technology field will benefit from this series.

Each course is designed to meet the differing needs and levels of experience of each learner. While you need not take the entire series, you should have the prerequisite experience to enter each course at the appropriate level.

Each course meets on 5 Saturdays (see Course Dates). Each Saturday class consists of one morning section (8:30am-11:30am) and one afternoon section (12:30pm - 3:30pm).

Each of these courses are offered for academic credit (2 semester units in EECS). There are 4 homework assignments (best 3 out of 4 are graded), 4 quizzes (best 3 out of 4 are graded), and one take-home final (usually project based).