Question

Write down the data type of the following attributes of an employee . Empno , empname , address , phoneno , designation , dateofjoining , salary and dept

Answer 1

EmpNo - AutoNumber or ShortText

EmpName - ShortText

Address - Short Text

PhoneNo- ShortText

Designation - Lookup & Relationship

Dateofjoining- Date & Time

Salary - Number

Dept - Lookup& Relationship