12.  Database Projects

Creating the Structure of the Database:

In order to create a structure for a table by name employee, select ‘properties’ in the database window and right-click it.   Select the New Table Option.   The Table Structure Window appears on the screen as shown in the figure 3.

Enter the table name as ‘employee’.    Now click ‘Add Field’ item.   You will get the field entry dialog window as shown in the figure 4.

                               Figure 3

                                   Figure 4

Enter the first field name as ‘empno’.   Select the Type as Text and size as 10.   Then click OK. You will get back to the Table Structure window.   Repeat the process of adding field for three more items, namely empname, dept and salary.   For salary enter the data type as Currency.  The final table structure window with four fields will appear as shown in the figure 5.

To finish the table creation, click ‘Build the Table Button’.  Now the Table structure creation is over.   Next we can optionally add indexes to the fields.

Figure 5