How to Create a Microsoft Access Form or Report From Filtered Records

Video Transcript

"Hello my name is Chip Browne. I teach computer programming and Microsoft applications classes at a local business college at Stevens Henagar College here in Utah. I also create practice tests for Microsoft Office application specialist's program. Today we are going to learn how to create a form or a report based upon filtered records. Microsoft Access is a registered trademark of Microsoft Corporation. I am not affiliated with Microsoft Corporation. To create a form or a report which is based upon filtered records it is important to understand that the table that you create the form or report on can be filtered very easily using the objects in Microsoft Access. Here let's begin with the Northwind Trader's database. We'll choose the object customers. Here is a query of the customer's table that shows all records without any filter added. Now let's add the filter. The filter can be added by clicking on the column that you want to filter and select the value or values that you would like to display. I have selected purchasing manager as the job title and in doing that it filters out all other values. This is the filtered query. It has not yet been saved but it will be saved while we create the report that is based upon it. Now let's create the report. On the create tab in reports group, click report. Here is the prompt that says that the table that I was working with, the filtered query has not yet been saved as a new object. I'll click yes. That new object was saved and this is the report which has the filtered records of that new object. It too is an object. You can see that only purchasing managers are showing up on this report. This is how you create a report from filtered data records. For more information visit me, Chip Browne, at chipbrowne.com."