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.

Modify a query

Modify a query

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

Start my 1-month free trial

Modify a query

“

- [Instructor] Modifying access queries so that you can change the query result is relatively easy. In this video, I'll show you how to rename a query. I'll show you how to filter and sort the data within a query, and I'll also show you how to format the fields right within the query. Let's go ahead and take a look at our 04_05 Modify_Queries database, and we'll start with the employee department and name query that has already been created. I'll double click to open it, so we can see that currently department, last name, and first name are the fields that are being displayed. I'd like to go ahead and add a couple more fields to this query. Let's go into design view, and from the field list up above, we'll add employee number and date of hire. I'll simply click on employee number, and remember you can click and drag and drop these fields anywhere you want to. So I'll put the date of hire field right in front of the last name field. Now, let's go ahead and run this query. Now we can…

Contents