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
From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Create and run a query6m 9s
-
(Locked)
Create a crosstab query3m 37s
-
(Locked)
Create an action query3m 6s
-
(Locked)
Create a parameter query4m 1s
-
(Locked)
Modify a query4m 43s
-
(Locked)
Create calculated fields and grouping within queries4m 39s
-
(Locked)
✓ Challenge: Create queries23s
-
(Locked)
✓ Solution: Create queries8m 47s
-
(Locked)
-
-
-
-