Scribd Logo
Upload

Welcome to Scribd!

  • 50 views

    CCP305

    Uploaded by

    api-3849444
    This document discusses filters in Microsoft Access. It begins by defining a filter as a way to extract selected data from a large dataset based on specific criteria. It then describes two main types of filters: filter by selection, which displays records that satisfy the given conditions, and filter excluding selection, which displays records that do not satisfy the conditions. Steps for creating each type of filter are provided. The document concludes by recapping filters and their uses.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd

    CCP305

    Uploaded by

    api-3849444
    50 views20 pages
    This document discusses filters in Microsoft Access. It begins by defining a filter as a way to extract selected data from a large dataset based on specific criteria. It then describes two main types of filters: filter by selection, which displays records that satisfy the given conditions, and filter excluding selection, which displays records that do not satisfy the conditions. Steps for creating each type of filter are provided. The document concludes by recapping filters and their uses.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses filters in Microsoft Access. It begins by defining a filter as a way to extract selected data from a large dataset based on specific criteria. It then describes two main types of filters: filter by selection, which displays records that satisfy the given conditions, and filter excluding selection, which displays records that do not satisfy the conditions. Steps for creating each type of filter are provided. The document concludes by recapping filters and their uses.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    50 views20 pages

    CCP305

    Uploaded by

    api-3849444
    This document discusses filters in Microsoft Access. It begins by defining a filter as a way to extract selected data from a large dataset based on specific criteria. It then describes two main types of filters: filter by selection, which displays records that satisfy the given conditions, and filter excluding selection, which displays records that do not satisfy the conditions. Steps for creating each type of filter are provided. The document concludes by recapping filters and their uses.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    of 20

    DEPARTMENT OF TECHNICAL EDUCATION

    GOVERNMENT OF ANDHRA PRADESH

    Name of the Faculty : USHA RANI JASTY


    DESIGNATION : Sr. Lecturer in CCP
    Branch : D.C.C.P.
    Institute : Government Polytechnic for Women,
    : Kakinada, E.G. District.
    Semester : 3rd Semester
    SUBJECT : Computer Packages
    Subject Code : CCP – 305
    Major Topic : Ms Access
    Duration : 50 minutes
    Sub Topic : Filter
    Teaching Aids : PPT and visuals

    CCP305.34 1
    OBJECTIVE

    On completion of this period, you would be


    able to:
     Define a Filter

     Know types of Filters


     Use Filter by Selection
     Use of Filter Excluding Selection
    CCP305.34 2
    Structure
     Filter – Definition
     Types of filters
     Filter by selection
     Filter excluding section

    CCP305.34 3
    Recap
    In the last period, you learned
     Creation of Make-Table Query
     Which is useful for creating a new
    table with the result of Query
     Creation of Delete Query
     Which is useful to delete records of the
    table
     Creation of Queries on Multiple Tables
     Queries can be created on Multiple
    Tables simply by adding Multiple
    Tables from SHOW TABLE

    CCP305.34 4
    Filter
     Definition

     To extract the selected data from a voluminous


    data
     To select the data on the basis of specific
    condition or criteria

    CCP305.34 5
    Types of Filters
     Various ways of using the Filters

     Filter by Selection
     Filter Excluding Selection
     Filter by Form
     Advance Filter/Sort
     Filter for Input

    CCP305.34 6
    Filter by Selection

    It displays the records which satisfies


    the condition

    CCP305.34 7
    Step 1 Open the database

    Fig-1 showing open database


    windaow
    CCP305.34 8
    Step 2
    Open a Table

    Fig-2 showing selecting a table


    CCP305.34 9
    Step 3
    Click on a Field on which you want Filter

    Fig-3 showing selecting a field for filter


    CCP305.34 10
    Step 4
    Select “Filter” Option from “Records” Menu and
    Select “Filter By Selection” Option

    Fif-4 showing selection of filter by selection option


    CCP305.34 11
    Step 5
    It displays the records which satisfies the condition

    Fig- 5 showing filter output

    CCP305.34 12
    Filter Excluding Selection

    It displays the records which do not satisfies


    the condition or criteria

    CCP305.34 13
    Filter Excluding Selection
     Step 1 - Open the database
     Step 2 - Open the table
     Step 3 - Click on a Field on which you
    want filter
     Step 4 - Select the “Filter” option from
    “Record” Menu

    CCP305.34 14
    Step 5
    Select “Filter Excluding Selection” Option

    Fig-5 showing selecting filter excluding selection option


    CCP305.34 15
    Step 6
    The records which does not satisfies the condition will
    be displayed

    Fig-6 showing Filter Excluding Selection out put


    CCP305.34 16
    Summary
     Filters
     To extract a part of data

     To select the required data basing on criteria


    or condition
     Filter by Selection
     It shows the records which satisfies the
    condition
     Filter Excluding Selection
     It shows the records which does not satisfied
    the condition

    CCP305.34 17
    QUIZ
    1.What is the use of filter?
    ANS : To select the required data for a given
    condition

    CCP305.34 18
    Frequently asked Questions
     What is a Filter?
     List the various types of Filters
     What is a Filter by Selection and how it will be
    useful?
     What is a Filter Excluding Selection and how it
    will be useful?

    CCP305.34 19
    THANK YOU

    CCP305.34 20

    You might also like