Apply Filter Macro Action

The Filter tool appears in the Sort and Filter.

Filter

Selection

Advanced Filter by Form

Advanced Filter/Sort

Toggle Filter

Each type of filter performs the same basic function, but in a slightly different way. Advanced Filter/Sort option, found by clicking the advanced button, opens a window that actually has you building a query — selecting tables and fields to filter, setting up criteria for the filter to use while it is finding specific records, that sort of thing.

Filters work in tables, forms, and queries. Although you can apply a filter to a report, filtering reports can be a daunting task. Of course, what you read here can be applied to that process, should you want to try it on your own. In addition, what you learn to apply to a table can be applied when you are working with queries and forms.

In this chapter, we will cover the basics of Macros in Access. A Macro is a tool that allows you to automate tasks and add functionality to your forms, reports, and controls.

    Macros in Access work a bit different from Macros in Word or Excel, where you essentially record a series of keystrokes and play them back later

    Access Macros are built from a set of predefined actions, allowing you to automate common tasks, and add functionality to controls or objects

    Macros can be standalone objects viewable from the Navigation pane, or embedded directly into a Form or Report. Once you have created database objects like tables, forms and reports, Macros can provide a quick and easy way to tie all those objects together to create a simple database application that anyone can use or even modify, with relatively little training.

    Macros provide a way to run commands without the need to write or even know VBA code, and there is a lot that you could achieve just with Macros

Action	Description
Filter Name	The name of a filter or query that restricts or sorts the records of the table, form, or report. You can enter the name of either an existing query or a filter that has been saved as a query in the Filter Name box in the Action Arguments section of the Macro Builder pane.
Where Condition	A valid SQL WHERE clause (without the word WHERE) or an expression that restricts the records of the table, form, or report.

Condition	Action	Arguments	Comment
[CompanyNameFilters]=1	ApplyFilter	Where Condition: [Name] Like "A*"	Filter for names that start with A
[CompanyNameFilters]=2	ApplyFilter	Where Condition: [Name] Like "B*"	Filter for names that start with B
[CompanyNameFilters]=3	ApplyFilter	Where Condition: [Name] Like "C*"	Filter for names that start with C

Please Watching My Video is Below

Design by Vannak Vannaro