Learn how to create a simple select query, run the query, and save the results. Author Jen McBee walks you through the steps of creating a query using two methods: the Query Wizard, and query Design View. Creating simple select queries is a skill that you
- [Teacher] A database can have thousands…of records in the table, and a select query…helps you get just the data you need and…presents the data in a DataSheet View.…On the Access 2010 MOS exam,…you'll be asked to create queries.…We're going to start with a simple query, yes that's…the one that you'll focus most on during the exam.…We're going to look at two ways to create a simple query:…using the Query Wizard, and using Design View.…
I'll then show you how to run your queries.…And lastly, we will learn how to…sort the information in our queries.…I have the 0501 exercise file open, so let's get started.…Now the main reason for using a query is it makes it easier…to view, add, delete, or change the data in your tables.…Also, queries are used to quickly find specific…records by filtering on specific criteria.…You also can run calculations and…summarize data using your queries.…
But as I said, we're going to start with a simple…select query and work our way through the…different query types in the following videos.…
- 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.