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