From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Unlock the full course today

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

Create and run a query

Create and run a query

From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Start my 1-month free trial

Create and run a query

“

- [Instructor] Once your tables have been created, formatted and data has been entered, it's time to begin analyzing the data with Queries. In this video I'll show you how to create a Simple Query in Query Design view. I'll also show you how to create a Multitable Query using the Query Wizard. Let's go ahead and take a look at our O four O one create queries database. Let's focus first on the employee information table. I'll open it up so we can take a look at our fields. What I'd like to do is create a simple query that pulls the Department, First Name, Last Name and Employee Number. I'm going to go ahead and close the table. Go to my create tab, and in my queries group, click on Query Design. This launches my Show Table window, and I can select the employee information table by double-clicking on it, and then go ahead and close that show table window. You can resize the list of fields so that you can see all the fields included in that table. Now I'm going to show you three…

Contents