3. Data dictionary - an example
There are a number of reasons why a database is the most suitable application for storing information.
Field Name |
Data Type |
Other information |
CustomerID |
Autonumber |
Primary key field |
Title |
Text |
Lookup: Mr, Mrs, Miss, Ms Field size 4 |
Surname |
Text |
Field size 15 Indexed |
FirstName |
Text |
Field size 15 |
DateOfBirth |
Date/Time |
Format: Medium Date Range check: >=01/01/1930 |
HomeTelephone |
Text |
Field size: 12 Presence check |
challenge see if you can find out one extra fact on this topic that we haven't already told you
Click on this link: Data Dictionary