Video: How to Create a Query From a Filter in Microsoft Access

This Season: Tailgating; Tech Know; New Year, New You; Tax Time

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.

Comments

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 chipbrowne.com.

Follow eHow: Follow @eHow

How to Create a Query From a Filter in Microsoft Access

Comments

Related Ads

Related Articles & Videos