How to Query & Append Microsoft Access

Access queries manipulate your database tables and pull information based on criteria that is set in the query design. This information is either presented in a spreadsheet table or altered using an action query. An append query takes information from one table and attaches it to a separate table. This table can exist within the same database or you can import this data into a separate database. This is a quick way to add records to a table without duplicate data entry.

• 1

  Open your Microsoft Access database. Click the table that has the information you want to append. Click "Create" on the top menu and choose "Query Wizard." Select "Simple Query Wizard." Click "OK."

• 2

  Add the fields you want to add to the other table. Move a field by pressing the ">" button. Press the ">>" button to move all the fields at once. Click "Next."

• 3

  Name the query. Click the radio button next to "Modify the query design." Click "Finish."

• 4

  Click the "Design" tab. Press the "Append" button in the "Query Type" group.

• 5

  Click the "Append to" drop-down box and select a table in the same database. Add to another database by clicking the second radio button and selecting the file from your computer. Click "OK."

• 6

  Click the field in the "Append To" row. For each field, choose a field from the "Append To" row that matches the corresponding table. This is the field that your data will be placed in.

• 7

  Click "Run" on the top ribbon. A warning box appears telling you that you are going to append. Click "Yes."