Primary Key It is very important that each costume in the database can be identified. This can be difficult if you have more than one of the same costume in stock with the same name and size. At school you there might be two students with the same name 'Laura Smith', so to identify which student's record belongs to which Laura smith, each student is given a 'student number' or 'office number'. This number uniquely identifies each student on the database. In your costumes table you have created a field called Costume ID. This will be different for every single costume in stock, even if they have the same name. It will help to uniquely identify each one. In databases this is referred to as the primary key. Every table in a database should have a primary key set up. |
|
9. You need to set your 'costume ID' as the primary key in your database table. |
 |
| Because you have set your 'costume ID' as an 'autonumber' data type, each time you enter a new record, it will automatically be assigned the next number. | |
 |
|
Next Page |
|
Try these
great search terms!
ECDL
ICDL
Database
Office software
