This is from an early version of a Microsoft Access Application I created recently for one of my clients. They needed help with managing data related to their Staff Members. This is used internally by a department at a university.
1) Employee - analogous to "Staff Member"
2) Training - analogous to "Training Compliance"
Value added entities:
1) Category - used to create parent list grouping (example = "Allergen")
2) Item - used to create child members of a Category (example = "Cat Hair")
- These entities allow the user to associate two entities together in a relationship
1) Employee Allergen
2) Employee File
3) Employee Note
4) Employee Shirt
5) Employee Training
This is the Entity Relationship Diagram...
Below is a brief overview of each form I created for this application
- "Main Menu" appears when the application is opened
- Used for navigation
- Open Forms, Queries, and Reports form here
- "Employee Editor"
- Create, read, update, delete (CRUD) operations for Employee records
- Contains a Tab Control for relationship generation
- "Training Editor"
- Create, read, update, delete (CRUD) operations for Training records
- Contains a subform from which Employee relationships can also be generated
- "Category Editor"
- CRUD operations for Categories and Items in a Category
- Flexible and rapid generation of 1:N relationships
Here is a simple Query example...
Here is the same Query data but now as a Report...
This is the VBA Module from the Category Editor...