Page 37 - ModularV1.1 _c8_flipbook
P. 37

3.  Freezing means to make one or more columns to be visible all times.             ............................

                    4.  We can move a column from one place to another in the table.                    ............................

                    5.  We cannot delete a column from a table.                                         ............................
                 C.  Fill in the blanks using the words given below.


                                              navigation, blue-colour, field properties, hide fields


                    1.  The ............................ option is used to hide a column.

                    2.  ............................ buttons are used to navigate through the records.

                    3.  The ............................ pane is used to set column properties.

                    4.  When you drag a column, a ............................ bar will appear to show the position of the column.
                 D.  Short answer type questions.
                    1.  What do you mean by freezing a column?

                      ..............................................................................................................................................................................
                    2.  How many rows can we add in a table?

                      ..............................................................................................................................................................................
                    3.  Which command is used to delete the records from a table?
                      ..............................................................................................................................................................................

                 E.  Long answer type questions.
                    1.  Write the steps to freeze a column in a table.
                    2.  Write the steps to add a new column in a table.
                                                   In the lab                                         Subject Enrichment



                       Create the following table in MS Access:
                                       Field Name                                      Type
                       ID (Primary Key)                             Text
                       Name                                         Text
                       Address                                      Text
                       Email                                        Text
                       Occupation                                   Text
                       Age                                          Number

                       After creating the preceding table, perform the following operations:
                      •  Add a new column with the name ‘School Name’.
                      •  Add 5 records in the table.






                 Do a walk-through of all the topics covered in this chapter.


                                                                                 Working with Tables in MS Access  35
   32   33   34   35   36   37   38   39   40   41   42