From the course: Access 2019: 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 2019: Queries

Start my 1-month free trial

Solution: Create a select query

“

- [Instructor] In the first challenge for this course, I asked you to find some information about the employees at H+ Sport. Here's how I go about finding the answer. Let's start with the create tab and we'll create a new query in design view. Now I'm only interested in information from the employees table, so go and add that one in, and close the show table window. I do want to add the first name and last name columns. I don't need to email address, but I do need department, status, hire date, I don't need their benefit information, but I do need salary as well as the job rating. If I go ahead and run this query right now, I'm seeing all the employees in the entire company, total of 740 records. So now we can go ahead and turn our attention to start filtering these down. I'm only interested in the employees of the status of full time, so come down here to the criteria and type in full time. And actually it looks like when I type in time, Access thinks that I'm typing the function…

Contents