Using an Append Query to Add Records to a Table

If you want to add a copy a bunch of records from one table to another, the best way to do it is with an Append Query. Whether you've just imported some new customer records, or a client gives you their product sheet in Excel, or anything along these lines, you can use an Append Query to get them into your existing Access tables. This video will show you how.

Pre-Requisite

• Import Data: https://599cd.com/Import

Recommended Courses

• Access Expert 14: https://599cd.com/ACX14
• Access Expert 22: https://599cd.com/ACX22

Links

• Query Criteria: https://599cd.com/Criteria
• Suppress Warnings: https://599cd.com/SuppressWarnings
• Indexing: https://599cd.com/Indexing
• AutoNumbers Are NOT For You: https://599cd.com/AANFY

Up Next...

• Append Mistake #1: https://599cd.com/AppendMistake1
• Append Mistake #2: https://599cd.com/AppendMistake2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, Append Queries, Append Query, Add records to a table by using an append query, What is an append query, Why would you use an append query, Creating an Append Query, How to Append Data, How To Make An Append Query