From the course: Building Solutions Using Excel and Access 2019 Together

Unlock the full course today

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

Create basic queries using tables

Create basic queries using tables

From the course: Building Solutions Using Excel and Access 2019 Together

Start my 1-month free trial

Create basic queries using tables

“

- [Instructor] When you work with databases, whether you created them for yourself or you inherited them, you'll likely need to know how to query information. Once all your tables are in place, it's easy to start writing basic queries. We're in our database. Let's go create a query. I'll choose create and we'll do a simple select query. I'll choose query design. I'll bring in my department list, my department list names, and then my zip codes. I'll go ahead and choose close on the show table. I want you to imagine that a lot of people are doing V look-ups repetitively to tie the department list to the list names to even the zip codes. We're going to use Access joins in our query to do that. If you haven't already had the Access Essentials course, I'd encourage you to take that class. Also check out Learning Data Analytics where there's an introductory discussion on joins and how they impact your data. All right, let's go ahead and join these. I'll join my department by dragging it to…

Contents