Results 1 to 5 of 5
  1. #1
    HAWKEYE is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Nov 2015
    Posts
    6

    Updating multiple tables at the same time

    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.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    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.

  3. #3
    HAWKEYE is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Nov 2015
    Posts
    6
    I will work on that, thanks for the information.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    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.

  5. #5
    HAWKEYE is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Nov 2015
    Posts
    6
    Thank you for the help will be looking this over.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 12-11-2013, 01:18 PM
  2. Replies: 2
    Last Post: 10-12-2013, 11:17 AM
  3. Updating Multiple Tables Via One Form
    By JoshuaRogers in forum Forms
    Replies: 2
    Last Post: 03-14-2012, 11:17 AM
  4. Replies: 2
    Last Post: 09-13-2011, 04:31 AM
  5. Updating Multiple Tables
    By gazzieh in forum Queries
    Replies: 0
    Last Post: 03-17-2010, 05:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums