Steps to Create the New Database :
- Click on Start Button
- Then click on Run
- Type “Msaccess” and press Enter Key
- Choose the Blank Database option
- Click on Create button
- Then choose the “Navigation Pane”
- Select the Table Required Table and right click on the table
- Choose and click the Design View
- Type the Table Name “EMP” click on ok Button
- Type the Required field name and choose data types
Example Table :
| Field Name | Data Type |
|---|---|
| EmployeelD | Number |
| FirstName | Text |
| LastName | Text |
| Address1 | Text |
| Address2 | Text |
| City | Text |
| State | Text |
| Zipcode | Text |
| Phone | Text |
Note : Employee Id add the Primary Key.
Follow @Sarvavasi.com