One method of inserting a new record is using the INSERT INTO with SQL:
INSERT INTO tblCustomer (FirstName, LastName, Age)
VALUES ("Joe", "Smith", "31")
Or you can do this:
INSERT INTO tblCustomer SELECT FirstName, LastName, Age
FROM tblCustomer2
insert records access sql database