Page 285 - Trackpad 402_Class-X_Final
P. 285

Filtering can be defined as the process of using a query to filter the records based on the criteria so that only the
            records matching the criteria will be available to the user thus hiding the data which is not needed.

            DBMS allows the user to create queries using Structure Query Language (SQL). It interacts with users to help them
            access data from the database.




                    STEPS FOR CREATING QUERIES
            To create a query, select the Query object in the Database list.  The three different methods used to create a query in
            the OpenOffice Base. These are:
            •  Create Query in Design View…     •  Use Wizard to Create Query…      •  Create Query in SQL View…

            Creating a Query in the Design View

            A design view helps you design a query by specifying the tables and the criteria.  Let us design a query to display the
            list of students with their marks. The query will have -Admno, Name from STUDENT table and Weekly test1, Term 1
            and Term 2 from MARKS tables.

            The steps to design a query using a Design view are as follows:
            Step 1:   Select database object Queries and click on Create Query in Design View option under the Tasks pane. The
                    Query Design window opens.






















































                                                                                   Database  Management System  285
   280   281   282   283   284   285   286   287   288   289   290