There are three action queries in Access that make managing tables easier. In this video, learn how to create a make table query, append query, and an update 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 want to rearrange them I can do so …
- Modifying the database structure
- Managing table relationships and keys
- Exporting data
- Managing records and fields
- Creating and running queries
- Configuring form controls
- Modifying form positioning
- Grouping report fields
- Formatting reports
- Taking the practice exam
Skill Level Intermediate
1. Microsoft Office Specialist (MOS) Exam Overview
2. Managing Databases
3. Create and Modify Tables
4. Create and Modify Queries
5. Modify Forms in Layout View
6. Modify Reports in Layout View
7. Final Practice Exam
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.