Queries allow you to pull specific data from your tables. In this video, learn how to create simple queries and multi-table queries.
- [Instructor] Queries allow us to pull specific data … from our tables … and we can pull data from one table at a time … when we do a simple query … or we can use multiples tables … and make a more complex query. … Once we have our query results, … we can then create forms and reports … to display our information. … Let's go ahead and jump into our Queries database … and create some queries. … I'm going to show you two ways to create a query. … Under the Create tab, … we'll use both the Query Wizard … and the Query Design. … We'll use the wizard first. … First, I'll select my table Employee Data. … Click on Query Wizard, … Simple Query Wizard … and in the first screen, … this is where we select the table … that we want to use in our query. … Now, because I had already selected EE Data, … that one popped right up for me. … So from this table, … we see the available fields on the left … and as we select them, they will go … into the Selected Fields window on the right. … Let's start with Employee Number, …
- 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.