Learn how to create multi-table queries using both the Query Wizard and Query Design View. Author Jen McBee will show you how to add criteria to your queries to filter the data, a challenge you may encounter on the Access 2010 MOS Exam.
- [Instructor] There will be times when a query…that's based on one table,…while it gives you good information,…doesn't give you all the information that you'd like to see.…That's when you're going to want to use…a multi-table query.…On the Access 2010 MOS exam you may be asked…to create an advanced query,…that means creating a multi-table query,…and you may be asked to add a filter to the criteria row…in your query.…In this video, we'll explore creating multi-table queries…using two methods.…
First we'll use the query wizard, then we'll create…a second query in design view.…We'll also filter our information before we run the query.…I have the 0502 exercise file open, so let's get started.…First let's create a query using our customers table…and our orders table.…Let's go ahead and open up each of the tables.…In our customers table we have customer ID,…company name, and all the contact information.…
In the orders table, we have a customer ID…which means we'll be able to create a relationship…between these two tables so that we can run the query,…
- 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.