Access: Screen Play Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Create ->Table Design The Receipt Form Try it: Create a Receipt Table Go to Create -> Table Design Add the following fields and data types:   ReceiptID Autonumber CustomerID Number MovieID Number DateSale Date/Time   Make the ReceiptID the Primary Key. This means that the numbers will automatically increase incrementally and that the data will be indexed.     Each record in the Receipt table will be unique: no duplicates.   Save the table as tblReceipt.