Page 42 - TP_Prime_V2.2_Class8
P. 42

Design View

                  The  Table  Design  View  allows  users  to  define  and  modify  the  structure  of  a  table,
                  including field types, properties, etc. The Design view window is divided into two parts:

                  • Field Grid Pane: It is used to define the field names and their data types.

                  • Field Properties Pane:  It  is  used  to  set  the  properties  for  the  fields  defined  in  the
           Prime (Ver. 2.2)-VIII  table.                                                 Field Properties pane




                                                                                            Field grid pane










          40

                                                        Design View


                   Naming Conventions for Writing a Field Name in Access

                  Following naming conventions you should remember while writing field names:

                  •  Field name can be up to 64 characters long.

                  •  Field name can include any combination of letters, numbers, spaces, and special characters
                    except a period (.), an exclamation mark (!), an accent grave (') and brackets ([ ]).

                  •  Field name cannot begin with the leading spaces.

                  •  Field name cannot include a double quotation mark (").


                   Creating a Table


                  Table can be created in three ways:

                  •  Creating tables using Design View

                  •  Creating tables using Datasheet View

                  •  Creating tables using Templates

                  Let us create a table using Design view.

                   Creating a Table Using Design View

                  In this view, you can define fields which are to be included in the table. You can simultaneously

                  define properties of these fields.
   37   38   39   40   41   42   43   44   45   46   47