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
From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Create and run a query6m 9s
-
(Locked)
Create a crosstab query3m 37s
-
(Locked)
Create an action query3m 6s
-
(Locked)
Create a parameter query4m 1s
-
(Locked)
Modify a query4m 43s
-
(Locked)
Create calculated fields and grouping within queries4m 39s
-
(Locked)
✓ Challenge: Create queries23s
-
(Locked)
✓ Solution: Create queries8m 47s
-
(Locked)
-
-
-
-