Page 87 - iPro_trackGPT_V5_Class7
P. 87

This will open a blank table in the Design view. The table is divided into three columns:

                    Field Name: It is used  to enter the name of the field to be displayed as a column heading
                    in the table.
                    Data Type: It is used  to define the type of data that can be entered in that field. The commonly
                    used data types in Access are Text, Number, Date/Time, Currency, AutoNumber, Yes/No, etc.

                    Description: It is used to give additional comments or information to the user while entering
                    data. The entry in this field is optional.

                 To move between columns and insert new fields at the end, press the Tab key.
                 The detailed properties of each field can be defined in the Field Properties pane according to
                 the naming conventions for writing a field name discussed earlier.


                 Setting Field Properties

                 The detailed properties of each field can be defined in the Field Properties pane according to
                 the rules for writing a field name discussed earlier.
                 To set field properties, follow the given steps:


                                                                                           2  Set the properties.

                       1  Click on the
                       field name in which
                       you want to set the
                       properties.




                 Saving a Table

                 To save a table, perform the following steps:


                         1  Select on the Save command from the Quick Access
                        Toolbar or press Ctrl + S to save your changes to the
                        table design. The Save As dialog box appears.










                                      2  Type the name of the
                                      table in the Table Name
                                      text box.




                                                                      3  Click on the OK button to save the table.

                 The table will be saved with the specified name.




                                                                          Database and DBMS—An  Introduction     85
   82   83   84   85   86   87   88   89   90   91   92