How do you make a query on Microsoft access?

Open a new query. Bring in the table you want to append records from and add in the fields you want to use. Click on the Query menu and pick Append Query. Choose the table that you want to append to from the drop down list. In the Append To line of the query design grid you can choose the corresponding fields you want to append to. When you have them chosen and applied any criteria, then you can run the query.

Before changing to an Append query it is often best to first set it up as a Select query so that you can see what records and fields will be appended when it is run. You can be more certain then that the correct records will be added.