Today's TechHelp tutorial from Access Learning Zone focuses on tracking employee training and certifications using Microsoft Access. I'm your instructor, Richard Rost, and in response to frequent questions about this topic, I've decided to guide you through creating a comprehensive database system from scratch. This will allow you to effectively monitor which courses employees should take, those they have completed and when, as well as manage the renewal of certifications.
We'll start by designing the necessary tables and then proceed with building the database step by step. This series is at the developer level and will include some VBA programming, although I'll initially focus on constructing the database without it. Forms and tables will be laid out first, and any VBA aspects will be introduced later in the series. For those unfamiliar with VBA, I recommend watching my introductory video, which provides a foundational understanding in about 20 minutes.
Unlike previous tutorials, I'm building this database in real-time alongside you. I have prepared a basic table layout, but we'll be exploring and constructing the database together, learning from any necessary adjustments that arise during development. This hands-on approach mirrors real-world scenarios where feedback and revisions are common.
This comprehensive tutorial series will likely span several parts. As always, I begin my process by outlining the tables and fields required. This is crucial, especially for intricate databases. We'll first look at the department table, necessary for tracking which departments employees and courses belong to. Each department could have multiple roles, leading to a one-to-many relationship.
Our next focus is the course table, which I'll refer to as courseD. This tracks both training courses and certifications, potentially including academic requirements. Categories of courses reflect different departments, such as HR and IT, and may consist of specifics like course codes, descriptions, and resource URLs for further information. The table also logs expiration intervals, important for certification renewals, and whether a course is currently active.
A junction table will link roles to courses, specifying what each position requires. This determines the necessary training for various roles. Additionally, we'll consider course prerequisites where necessary, creating a many-to-many relationship to reflect real-world requirements.
The employee table will connect with other components. Key fields include employee ID, supervisor ID, personal information, and employment dates. A junction table will relate employees to roles, allowing for multiple roles per employee if needed. Details like start and end dates for roles, qualification dates, and whether it's a primary role are tracked here.
Finally, we'll use a junction table to document courses taken by each employee. This will include enrollment dates, deadlines, completion dates, expiration dates, and their status, useful for generating progress reports.
This tutorial covers the initial schema of our database, which we'll refine as needed. Establishing a solid starting framework is crucial, and we'll continue constructing our database in the next session.
For an in-depth tutorial and step-by-step instructions on everything discussed, visit my website. Live long and prosper, my friends.
For more info please visit:
No comments:
Post a Comment