From the course: Access 2013: Queries

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Solution: Find the top ten employees

Solution: Find the top ten employees - Microsoft Access Tutorial

From the course: Access 2013: Queries

Start my 1-month free trial

Solution: Find the top ten employees

In the first challenge for this course, I asked to find some of the information about the employees at KinetEco. Here's how I went about finding the answer. First, we'll start a new query in design view. I go to Create Tab and Query Design. Here, we're only interested in information about the employees. So, I'll select that table and say Add and then Close. Let's open this up again so I can see it. Now I'm going to add in a few fields from the Employees table. We wanted to know the first and last name for our employees, what their full-time status was, so I'll choose the Status column. When they were hired, so I'll choose the HireDate column, and what department they're from. Let's go ahead and scroll down and find Department. I also wanted some information about their salary, so I'll choose Salary, and I also wanted to filter this by criteria base off their job rating. So, I'll add the JobRating here. Now, lets go at through and see if you need updates any of these aliases. The first…

Contents