In the previous lesson you completed the first step, creating a table. Now you will complete the second step, entering data into the table.
Our Store database will include the following data:
Trans | ItemNo | SDate | Descript | Dept | Qty | Price | Sale |
1 | 2344 | 10/27/97 | Hard Candy | Candy | 1 | $2.59 | Yes |
2 | 2345 | 11/01/98 | Candy Bar | Candy | 3 | $1.00 | No |
3 | 3321 | 12/14/98 | Soap | Grocery | 4 | $3.69 | No |
4 | 4215 | 12/11/98 | Pan | Kitchen | 6 | $9.99 | No |
5 | 5216 | 04/28/99 | Corn | Produce | 2 | $1.29 | No |
6 | 9874 | 05/03/99 | Apple | Produce | 3 | $1.59 | No |
7 | 7371 | 06/09/99 | Crackers | Grocery | 9 | $2.39 | Yes |
8 | 1921 | 07/04/99 | Beef | Meat | 2 | $5.49 | No |
9 | 9873 | 08/31/99 | Milk | Dairy | 7 | $2.69 | No |
10 | 2321 | 12/31/99 | Chocolate | Candy | 7 | $8.59 | Yes |
Now on to adding data to your table!