Question

a)    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).

b)    Also create its Form and add at least 2 record through the form and create the following queries:

·      List only those employees who belong to the city Karachi.

·      Show only the female employee in the employee table

There should be at least 12 to 15 record in the table.

Please reply as early as possible.

Answer 1

Create Table:

You can use design view or query to create table.

I showed you to create a table using query and then use design view to update constraint.

Go to Create -> Query design -> right click and select SQL View

Execute the following query to create the table

CREATE TABLE Employee(

             EmployeeID INT PRIMARY KEY

             , EmployeeName VARCHAR(100)

             , FatherName VARCHAR(100)

            , Gender VARCHAR(10)

              , Age INT

            , DateOfJoining DATE    

              , Address VARCHAR(100)

             , CellNumber VARCHAR(20)

             , City VARCHAR(100)

)