In this movie, Adam demonstrates his solution to the first challenge. The finished query uses criteria to find the ten full-time employees with a job rating of four or five, that have the highest salaries. The final query includes the employee names, when they started work for H+ Sport, and their department.
- [Voiceover] In the first challenge for this course,…I asked you to find some information…about the employees at H+ Sport.…Here's how I'd go about finding out that answer.…First, I come up here to the Create tab…and we'll start a new query I've designed you…and use the Employees table as our Source,…and we should add in a few fields here,…I want to know what Department they're in,…I want to see if they are full-time,…so I'll need that Status.…Their Hire Date, don't need anything about…their Benefits, but I do want to see the information…about their Salary and the Job Rating.…So these are the fields I'm going to pull from.…
Now the Status is, I only want the Full-Time employees…so I'll go ahead and type in Full Time here.…I only wanted to see the Job Ratings that were above four,…or either a four or a five.…I think you could say four or five like this,…or I could just say greater than or equal to four.…I can obviously go ahead and do it that way.…Let's go ahead and say Run, see where we're at right now.…So I'm seeing just the full-time employees, I've got their…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- 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.