Our Store database will include the following data:
Field Name | Field Type | Field Descrpt | Field Width |
Trans | Counter | Transaction Number | Predefined |
ItemNo | Text | Item Number | 4 |
SDate | Date/Time | Date Of Purchase | Predefined |
Descript | Text | Item Description | 25 |
Dept | Text | Department Making Sale | 8 |
Qnty | Number | Quantity | Predefined |
Price | Currency | Item Price | Predefined |
Sale | Yes/No | Is Item On Sale? | Predefined |
Now on to creating the table!
Click
![]() |
Click Design View
Click
![]() |
Now you try it!