Create the ANIMAL table
The procedure to create the ANIMAL table is demonstrated in this Video (wmv) (63.3MB; 4.12min).
Create the ANIMAL table with the following fields:
|Field Name||Data Type||Description|
|CowID||Autonumber||Cow ID unique for all records|
|CowNum||Number||Cow ID unique to a farm|
|FARMERID||Number||Farmer Identification code|
|DOB||Date/Time||Date of birth of the cow|
|MY||Number||Annual milk yield|
|Mastitis||Yes/No||Has the cow suffered from mastitis in the past 3 months?|
|Metritis||Yes/No||Has the cow ever had metritis?|
|ROP||Yes/No||Has the cow ever had retention of placenta?|
|Lameness||Yes/No||Was the cow lame at the time of survey?|
|Breed||Text||Breed of the cow|
- Apply an input mask to DOB (such as a short date)
- You could create a combo-box for the field Breed if you know beforehand the most common cow breeds.
- Note that the default field size for a Number data type is Long Integer which is okay if you don’t want to store fractions. Use Single or Double if you expect your data to have fractions. You can also use other field sizes such as Byte and Integer but it is usually safe to use Long Integer for numbers without fractions and Double for numbers with fractions. For further information about number field size, keep your cursor in the field size property and press F1.
- Another property in the General tab worth mentioning here is the Default Value. This is the value that is entered automatically in a field and is useful to reduce data entry time if you expect many observations to have the same value (for example, if most of the farmers are from NSW, then this could be specified in the default value property).
- For numbers, Access automatically assigns zero as the default value. I usually prefer to delete this, as zero is then assigned even for the missing values, if the data entry operator doesn’t delete it.
Go to >Create Relationships