| 10. An index allows Microsoft Access to work faster when
finding and sorting records. They work in a similar way to the way you would use an index in the back of a traditional book, i.e. Access uses the index to find the location of the required data. Set the 'Costume ID' field to be indexed. Choose ' Yes(No Duplicates)'. This means that it will index this field but will not allow two records to have the same value, meaning that the costume ID will be unique to each costume. |
 |
| 11. Sometimes it is very important that you do not forget to enter
data into a field – it might be a problem if you want to sell a
costume but don’t know how much it should be sold for.
Make 'selling cost' a required field, meaning that a price must be entered for each costume and it cannot be left blank. |
|
| 12. Now save the table, by clicking on the save icon in the toolbar. Call the table ‘Costumes’ when prompted. |
|
 |
|
Next Page |
Try these
great search terms!
ECDL
ICDL
Database
Office software
