|
|
| |
| |
| Steps to create a table from scratch |
| |
| 1) Start Access from the Start menu or from a shortcut. |
| |
| 2) The Getting Started screen will appear. |
| |
| 3) Create a database TutorialDB as showed in below image. |
| |
|
| Illustration 1: Office Create blank database named TutorialDB. Click here to view larger image. |
| |
| 4) Select the Create tab from the upper tab strip. |
| |
|
| Illustration 2: Click on the Create tab. |
| |
| 5) Select the Table Design icon. |
| |
| This option will display the following work area: |
| |
|
| Illustration 3: Working area for defining tables. Click here to view larger image. |
| |
| . At the right panel, all existing tables will appears. |
| |
| . At the left panel, the table field's datasheet appears, with the pointer positioned at the first row, ready to create a new field. |
| |
| . At bottom panel, Fields Properties panel allows the field's properties set up. |
| |
| 6) Fill all required field name´s for the new table, as follows. |
| |
|
| Illustration 4: Create a field. Click here to view larger image. |
| |
| 7) Select the Data Type list and select the right data type for the field. |
| |
|
| Illustration 5: Select the data type. Click here to view larger image. |
| |
|
