Learn how to quickly create a new table based on the results of a query. Author Jen McBee will demonstrate how to use an existing query or a new query to create a table and how to apply criteria to the query to filter the data.
- View Offline
- Exercise Files
- [Narrator] After you've created your query…and viewed your results you might decide…that you want to make a brand new table based…on the results of your query.…On the Access 2010 mos exam, you may be asked to…use the make-table query to create a brand new table.…Once you have created your new query,…you'll run the query and then you'll be able to view…your new table, is this sound interesting?…Well, I thought you might think so.…I had the 0505 exercise file open,…so let's go ahead and get started.…
We're going to work with our customer's query,…let's go ahead and open it up and take a look at it.…It has great information in here,…the order ID and the customer ID,…company name and then a contact information…and it also has information on the order date…and the ship date.…Let's go into design view,…we can see that we have two tables…that we are accessing information from for this query.…To make a table from these results,…these are the steps you're going to take.…
We'll go into design view and right now…it's just a simple select query, we're going to click on,…
- 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.