Slide 1Create A Table-1Populate Data-2Query-3Query-4Report-5Step By StepLei YangComputer Science DepartmentCreate A Table-1Create a table named EmployeeAttribute Set◦ID: Auto Number(primary key)◦Name: Text◦Gender: Text(Lookup Wizard)◦Salary: Money◦DptName: TextPopulate Data-21 Simple Method2 Using Forms3 Import Data From FileQuery-3Q1◦Find all information of female employeesQ2◦Find all information of employees whose salaries are greater than 5000Q3◦Find the names of male employees from HR departmentQ4◦Find the names starting with “J”Query-4Q4◦Compute the average salary of the companyQ5◦Compute the number of female employeesQ6◦Compute the average salary of male and female employeesReport-51 Basic Report2 Chart
View Full Document