Page 41 - ModularV1.1 _c8_flipbook
P. 41
Tech
Funda
You can also remove the filter by clicking on the Filter icon from the Sort &
Filter group of the Home tab.
Using Custom Filter
Custom filter allows you to filter data according to particular criterion. MS Access provides
different criteria from which you can choose according to your requirement. Follow these steps
to use custom filter:
Step 1 Click on the column header on which you
want to apply custom filter.
Step 2 Click on the down-arrow next to the
column name. A drop-down list appears.
Step 3 Hover the mouse on the Text Filter
option. A list of criteria appears.
Step 4 Select the desired criteria. In this case, we Using custom filter
have selected Begins With criteria. The Custom Filter dialog box appears.
Step 5 Type the desired value in the textbox. In this case, we have typed M.
Step 6 Click on the OK button. The filtered data appears.
Custom Filter dialog box Filtered data
IMPORTING DATA FROM OTHER APPLICATIONS
Importing data means to access the data from other applications to MS Access. MS Access allows
to import data from different types of files like text file, MS Excel file, HTML file and another
database. Perform the following steps to import data from a MS Excel file:
Step 1 Open a database in MS Access and click on the Excel command under the Import &
Link group of the External Data tab. The Get External Data - Excel Spreadsheet dialog
box appears.
Step 2 Click on the Browse button. The File Open dialog
box appears.
Step 3 Select the MS Excel file from which you want to
import the data. In this case, we have selected the
Student Record file. Importing data
Advanced Features of MS Access 39

