Step By Step

Lei YangComputer Science Department

Create A Table-1Create a table named EmployeeAttribute Set

◦ID: Auto Number(primary key)◦Name: Text◦Gender: Text(Lookup Wizard)◦Salary: Money◦DptName: Text

Populate Data-21 Simple Method2 Using Forms3 Import Data From File

Query-3Q1

◦Find all information of female employees

Q2◦Find all information of employees

whose salaries are greater than 5000Q3

◦Find the names of male employees from HR department

Q4◦Find the names starting with “J”

Query-4Q4

◦Compute the average salary of the company

Q5◦Compute the number of female

employeesQ6

◦Compute the average salary of male and female employees

Report-51 Basic Report2 Chart Report