How to Create a Query From a Filter in Microsoft Access

Next Video:
How to Create an SQL Query in Microsoft Access....5

In Microsoft Access, the creation of query from a filter involves bringing up a table, applying a filter to a field and saving the query as an object query. View the results of creating a query from a filter with help from a computer programming teacher in this free video on Microsoft Access.

Part of the Video Series: Microsoft Access Tutorial
Promoted By Zergnet


Video Transcript

Hi my name is Chip Browne. I teach computer programming and Microsoft Office application classes at a local business college, Stevens Henagar here in Utah. I also create practice tests for Microsoft Office applications specialist certifications. Today we are going to learn in Microsoft Office Access 2007 how to create a query from a filter in Microsoft Access. Microsoft Access is a registered trademark of Microsoft Corporation. I'm not affiliated with Microsoft Corporation. To create a query from a filter we begin by bringing up a table. Next apply a filter to a field. Next save this query as an object query. Now let's look at query. Here are the results of the query as you can see because of the filter, we only received supplier F. That is how you create a query from a filter. For more information and videos visit me, Chip Browne at


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!