Page 60 - ModularV1.1 _c8_flipbook
P. 60

3.  You can set multiple queries in a form.                                           ........................

                     4.  Modal Dialog form is useful in creating navigational menu systems.                ........................

                     5.  MS Access does not allow you to design a form manually.                           ........................

                  C.  Fill in the blanks using the words given below.


                                                          form, split, logo, title, create


                     1.   ........................ and ........................ are the commands present in the Header/Footer group on the
                        Design tab.
                     2.  ........................ View is used to enter, edit and view data.

                     3.  ........................ form shows two parts.
                     4.  Form Design command is present in the Forms group of the ........................ tab.

                  D.  Short answer type questions.
                     1.  What is a form in MS Access?

                        ......................................................................................................................................................................................

                     2.  Write the names of the three main views in which a form can be displayed.
                        ......................................................................................................................................................................................

                     3.  Which form view gives a detailed view of the structure of the form?
                        ......................................................................................................................................................................................

                  E.  Long answer type questions.
                     1.  Define any two views of a form.
                     2.  Explain any three types of forms.

                                                    In the lab                                         Subject Enrichment



                     Create the following table in MS Access.
                         Customer Name        Address     Item ID     Item Name       Quantity         Price

                         Neeraj Sharma          Delhi     120220        Soft Toy          10           500
                         Nikhil Kumar         Mumbai      334678        Football          20           1000

                         Divya Sharma          Meerut     212232          Ball           100           100
                        Create a form using the above table.







                  1.   Tell the students how forms are important in MS Access.
                  2.   Do a walk-through of all the topics covered in this chapter.




                  58      Modular (Ver. 1.1)-VIII
   55   56   57   58   59   60   61   62   63   64   65