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.

Challenge: Create a select query

Challenge: Create a select query

From the course: Access 2019: Queries

Start my 1-month free trial

Challenge: Create a select query

“

- [Instructor] Now that we've begun to explore the role of the select query in Access Database, it's time to put some of that knowledge to the test in our first challenge. In this challenge, I'd like you to find the top 10 full-time employees with a job rating of four or five that have the highest salaries. I'd like to know their names, when they started working for the company, and their department. Make sure to provide clear, English readable column headers by modifying the column aliases. This challenge should take you no more than about five minutes. Good luck.

Contents