TASK.docx - TASK#1 Add the following fields to the table...

This preview shows page 1 - 2 out of 7 pages.

TASK#1 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 type. The primary key is used because field value needs to be unique for each employee. Task#2 Modify the field properties so that the SIN, FName, and LName are required fields. FName 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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture