Question

Create a data sheet in MS Access which includes Employee ID, Employee Name, Father Name, Gender (Male, Female), Age, Date of Joining (dd-mm-yyyy), Address, Cell number (0300-0000000) and City (Karachi, Islamabad, Lahore). 

Answer 1

1. Creating the table using the query

2. Adding new record after creating a new form

3. Updated employee table