Page 30 - ModularV1.1 _c8_flipbook
P. 30

04                               WORKING WITH


                                                                       TABLES IN MS ACCESS














                           Your Aim

                           to learn about:

                              l  Creating a New Table                    l  Handling Columns in a Table
                               l  Handling Records in a Table


                  As you know, a table is used to store data in a database. It contains the data in the form of rows
                  and columns. MS Access 2010 allows us to add a maximum of 256 columns and unlimited rows
                  in a table. In the previous chapter, you have learnt about database and table. In this chapter, you

                  will learn how to perform different types of operations on a table. You will also learn how to work
                  with records.

                      CREATING A NEW TABLE

                  Table can be created in two ways:
                      Creating tables using Design View.                Creating tables using Datasheet View.
                  Let us create a table using Design view.

                  Creating a Table Using Design View

                  In this view, you can define fields that are to be included in the table. You can simultaneously
                  define properties of these fields also.

                  To create a table in Design view, follow these steps:
                  Step 1  Click on the Table command from the Tables group under
                          the Create tab. This will create a new table as Table1 in the
                          database.



                                                                                                 Creating a Table


                                        Step 2   Click on the  View command from the  Views group  under  the
                                                Home tab. A drop-down list opens.

                                        Step 3   Click on the Design View option. This will open the Save As dialog
                                                box.

                  Selecting Design View

                  28      Modular (Ver. 1.1)-VIII
   25   26   27   28   29   30   31   32   33   34   35