From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
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 Expert - Microsoft Office Specialist for Office 2019 and Office 365
Create an action query
- [Instructor] In Access, there are several action queries that we can use to make our managing of our tables much easier. After watching this video, you'll know how to run a query that makes a new table. How to create a query that will append information to another table. And how to update information in a table using an action query. Let's jump right in to our action queries database and get started. First, let me show how you can make a new table based on query results. Let's go to create and we'll go right into query design. This show table window shows us all of our tables and queries that are currently in our database. We'll use the employee data table. I'll double-click on it to add it and click close. I'd like to make a new table that just shows department, employee number, benefit and benefit cost. Department, employee number, benefits and benefits cost. Now after I have these fields in the query grid, if I…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.