From the course: Access 2019: Building Dashboards for Excel

Unlock the full course today

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

Create queries

Create queries

From the course: Access 2019: Building Dashboards for Excel

Start my 1-month free trial

Create queries

“

- [Instructor] There are multiple ways to create and build queries, so let's get started building with the Query Wizard. Okay, let's go to the Create tab. Let choose Query Wizard, we're going to do a Simple Query Wizard. Go ahead and click OK. Now I can pull from tables or queries. I'm going to go ahead and use my table users. Scroll up there to grab that. I want to bring in the UserID, the user first name and last name, scroll on down. I also want to pull that user's ManagerID, and if the user is actually a manager, so I'll double click that. All right, I'll go ahead and choose Next. It's asking me do I want to see a summary or the detail? I want to see every record, so I'll leave it at detail. I'll choose Next. And then I want to call this Users and then I'll choose Finish and then it shows me the data results, my 702 users. Let's go take a look at the Design view. I'll right click and go to Design View.…

Contents