From the course: Access 2016: Queries

Unlock the full course today

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

Solution: Create a select query

Solution: Create a select query

From the course: Access 2016: Queries

Start my 1-month free trial

Solution: Create a select query

“

- [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…

Contents