From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create an action query

Create an action query

From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Start my 1-month free trial

Create an action query

“

- [Narrator] Did you know you can use an action query to copy records from one or more data sources to an existing table? In this video I'll show you how easy it is to create an append query that you can use over and over again when you need to add records to an existing table. Let's go ahead and take a look at our 04_03 Action_Query database. And I first want to focus on the Employee Information table. Go ahead and open it up. And we can see that we have all this great information on our employees including their date of hire. We also have a table called New Employees which is where information on our new hires is loaded so that we can then append it to our Employee Information table. Let's go ahead and close both of these tables and we'll start creating our append query. I'll click on the Create tab and go over to our Queries group and we'll go ahead and go into Query Design. Using our Show Table window, I'll go ahead and double click on New Employees because this is the table that…

Contents