Our database will include data on internships in academic department. The first table keeps data on students participated in intern program. Type SSN in the first row s Field Name text box, and press Enter to advance to the Data Type text box. In Data Type text box keep Text data type. Now click on SSN field to make it active, and then click on Primary key icon to make this field a primary key for the table.
Primary key is used to identify each record in the table.
Now save the table and name it Student. In the second row of Field Name type First Name, use Text Data Type once again, and change Field Size to 16. Repeat this step for Last Name field. Next Field is BirthDate. For simplicity, we ll create only State field for student s address.