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.
Modify a query
From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Modify a query
- [Instructor] It seems we are constantly updating and changing information in our databases and we may also want to update our queries to meet our current needs. After watching this video you'll know how to rename a query, how to add, hide, and remove fields, how to sort data within queries, and how to filter the data within queries using comparison operators, such as greater than, less than, and equal to. Let's jump right into our modify queries database. We do have a single query in this database. Let's go ahead and run the query and I can do that quickly just by double-clicking on the name in the navigation pane. This query has all the information on our employees, the building they work in, the department they're in, their ID number, et cetera. Let's Close the query and we'll go ahead and name this query by right-clicking and going to Rename. This is Employee Information. Be sure when you name your queries that you…
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.