I have a DB (Access 2003) which contains two tables each table is linked two
a seperate SharePoint site.

My objective is to keep the Table 2 columns updated by pulling data from
Table 1. Subsequently, I want perform this action without overwriting data in
Table 1, since Table 1 will always remain current.

Bottom line, I would like to be able to pull data from select columns from
Table 1 and write to specific columns in Table 2.

What is the best way to approach this design? I am certain Macros and/or
queries will apply here. I am just not sure exactly where to start.

I am very new to Access and any help would be much appreciated! Thanks.