Learn how to create and run an Append query. Author Jen McBee demonstrates the process of creating and running a query that will append records to an existing table, and how to add criteria to the query to filter the data, all skills you may be asked to d
- [Instructor] There'll be times when…you want to append information…to an existing table, and this is the…perfect time for you to use an append query.…You use an append query when you need…to add new records to an existing table…by using data from other sources.…On the Access 2010 MOS exam you may…be asked to create an append query,…and this video will focus on the process…that you'll use during the exam.…I have the 05_04 exercise file open,…so let's get started.…
First, let's take a look at our Suppliers table.…Double-click on it to open it,…looks like we have 10 suppliers here.…Looks good, but…periodically we receive an update…from our IT department with all…of our new supplier information.…So we need to create a query that will…append all of our new suppliers…to our current Suppliers table.…Let's go ahead and close the table,…and let's create our query.…We'll go to Create, in the Query group,…we're going to do this in Query Design.…
The Append Query is, actually,…an option on the query ribbon,…so let's first go ahead and we'll add our table.…
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports
Skill Level Intermediate
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 18s
2. Managing the Access Environment
3. Building Tables
4. Create Forms
5. Create and Manage Queries
6. Create Reports
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.