5. Data dictionary example

The table below is an example of a typical data dictionary entry. The IT staff uses this to develop and maintain the database.

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