Page 91 - iPrime_V2.2_class7
P. 91

NAMING  CONVENTIONS  FOR  WRITING  A FIELD  NAME  IN

                     ACCESS
                 You should remember the following naming conventions 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 grave accent (') and brackets ([ ]).
                    Field name cannot begin with the leading spaces.
                    Field name cannot include a double quotation mark (").

                     CREATING A TABLE

                 Tables 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 that are to be included in the table. You can simultaneously
                 define the properties of these fields.
                 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 Save As
                                                        dialog box.



                 Selecting Design View

                 Step 4  Enter a name for your table in the Table Name text
                         box.
                 Step 5  Click on the OK button.                                             Save As dialog box

                 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.


                                                                           Database and DBMS—An Introduction       89
   86   87   88   89   90   91   92   93   94   95   96