Add the following fields to the table, with the appropriate data types: LName (for last name),
TelNum (for telephone number), DOB (for date of birth), DateJoined, Salary, Address, City,
PostalCode, OnLeave and Gender. Note that some fields may have more than one correct data
The primary key is used because
field value needs to be unique for each employee.
Modify the field properties so that the SIN, FName, and LName are required fields.
and LName should not allow zero length entries. Set the default value for City to “Calgary”.
Set the default value for DateJoined to today’s date (enter Date()). As the caption of DOB,
type in BirthDate.
We used the Validation rules stop users from entering incorrect data into your tables one validation rule
can make sure that the DOB is earlier than today’s date. Another one can be used to ensure that the
salary is not zero or it is not a negative number.When a user enters data that is incorrect (according to