Updating multiple tables at the same time

[HAWKEYE]

New to MS ACCESS, I’m currently have multiple tables

1. Employtable Is for employees with only their employee number and start date.

2. Training table for the Sales Dept.
3. Training table for the Research Dept.
4. Training Table for the HR Dept.


Is there a way that when you enter a new employee row in the Employtable to have the tables for (SALES, RESEARCH and HR) update at the same time, these are only just a few of the tables that need to be updated.

[ItsMe]

Have you tried building an Action query? Maybe an UPDATE query would be beneficial. You can start by creating a basic SELECT query using the Query Designer. Within the Ribbon and under the Design tab, there is an option for Update.

[HAWKEYE]

I will work on that, thanks for the information.

[orange]

Hawkeye,

I think your structure is incorrect. You do not need a separate table for each department.

Keep things in their own table.

Employees
Departments
Training

You can learn a lot about tables and relationships by working through this tutorial from RogersAccessLibrary.
What you learn can be applied to any database.
Normalization.


Good luck.

[HAWKEYE]

Thank you for the help will be looking this over.