From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365

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 Expert - Microsoft Office Specialist for Office 2019 and Office 365

Start my 1-month free trial

Create and run a query

“

- [Instructor] Queries allow us to pull specific data from our tables and we can pull data from one table at a time when we do a simple query or we can use multiples tables and make a more complex query. Once we have our query results, we can then create forms and reports to display our information. Let's go ahead and jump into our Queries database and create some queries. I'm going to show you two ways to create a query. Under the Create tab, we'll use both the Query Wizard and the Query Design. We'll use the wizard first. First, I'll select my table Employee Data. Click on Query Wizard, Simple Query Wizard and in the first screen, this is where we select the table that we want to use in our query. Now, because I had already selected EE Data, that one popped right up for me. So from this table, we see the available fields on the left and as we select them, they will go into the Selected Fields window on…

Contents