Page 61 - Computer Class 08
P. 61

Queries

             You use queries to view, change and analyse data in different ways. You can also use them
             as a source of records for forms and reports.

               Let’s  Learn...
               Let’s
                      Learn...
             To create a query.

             1.   Click on the Create    tab.
             2.   Click on Query Design      in the Queries   group.

             3.   Select the table that you would like to base your query on.
             4.   Click Add  .

             5.   Repeat steps 3 and 4 until all tables are added.
             6.   Close   the Show Table   window.

                       1
                                      2




































                                                                                                        4     6






             The table(s) will now be displayed in the upper part of the Query Design Screen                by boxes
             containing the tables’ fields.





                                                                                    Computer-8              61
   56   57   58   59   60   61   62   63   64   65   66