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.

Challenge: Gather employee emails based on department

Challenge: Gather employee emails based on department

From the course: Access 2016: Queries

Start my 1-month free trial

Challenge: Gather employee emails based on department

“

- [Voiceover] Obtaining query parameters from other objects within the database is an incredibly powerful technique, which is why I've made it the focus for our second challenge. I'd like you to build a query that outputs an email list for our employees. The user should be able to select which department they want from a list of valid choices, and then retrieve the email directory from the employees in the chosen department. This challenge requires you to build a query hooked to a combo box on a form, and you'll find a blank form in the H+ Sport Challenge 2 Start database. And that'll help get you going. Because there a couple of components needed, it'll probably take a little longer than the last challenge. Say, about 10 minutes. Good luck.

Contents