Page 29 - ModularV1.1 _c8_flipbook
P. 29

3.  The maximum size of the Number data type is 32 bytes.                           ............................

                    4.  Field name can begin with underscore ( _ ).                                     ............................

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

                                                 datasheet, field grid, primary key, navigation


                    1.  ............................ buttons help in navigating through the records.
                    2.  The ............................ view is the default view of the table in MS Access.

                    3.  The ............................ pane is used to define the field names and their data types.
                    4.  A ............................ is a field in a table that uniquely identifies each record in the table.

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

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

                    2.  Explain any three features of MS Access.
                      ...........................................................................................................................................................................

                    3.  Write the names of any three data types of MS Access.

                      ...........................................................................................................................................................................
                    4.  What is primary key?

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

                 E.  Long answer type questions.
                    1.  What is the difference between Text and Memo data types?

                    2.  Explain the types of views in a database.
                    3.  What are the rules for writing a field name in a database?

                                                   In the lab                                         Subject Enrichment


                    Create a table using the ‘Design View’.
                         Roll No.           Name          Date of Birth      Phone No.            Place
                          A001        Manan Gupta          12/09/1987        2354667667           Delhi
                          A002        Ryansh Sharma        09/05/1986        3435555555        Chhattisgarh
                          A003        Rahul John           02/05/1990        656554432           Mumbai

                    •  Set Roll No as the primary key.
                    •  Delete the record no. A002.
                    •  Add another record.






                 1.  Explain the concept of different types of keys such as composite keys and foreign keys.
                 2.  Discuss the procedure to apply a primary key on a field. .

                                                                                   Introduction to MS Access 2010  27
   24   25   26   27   28   29   30   31   32   33   34