Navigate to the "Queries" section of your Access file in the navigation pane, which is commonly located in the left-hand panel of the program. If you can't see the section by default, click the "All Access Objects" tab at the top of the navigation pane and select "Queries." Double-click the name of the query table to open the information on your screen.
Highlight information that you wish to insert into the Access query table and press "CTRL" + "C" to copy the information to your clipboard. For example, you can copy information from a separate text file, Excel file or another Access data table in this manner.
Select the box next to the very last row in the query to select the entire row. The very last box of the table remains empty at all times to allow you to insert new records.
Click "Paste" on the Access main menu and select "Paste Append" from the drop-down menu. This inserts the copied information to your query table. You can then use the "Sort & Filter" option on the Access toolbar to sort the information in alphabetical or numerical order if you wish.