How do I use code in delphi 7 to copy row from access table to another table

I have created two access tables using Adoquery and Datasource to show data on two separate dBgrids. Tables have similar columns and fields. Field names include item name, stock in and stock out. I would like to know the code needed to locate item names from one dbgrid and copies the item name to replace the similar item names on the other dbgrid using code in Delphi 7. What I merely mean is that I would quickly do this using access database since it will just involve copying an item name row from one table then replacing the same item name in the other table by pasting data there. However is this possible to achieve using code for the dbgrids?