# Step By Step - PowerPoint PPT Presentation

1 / 6

Step By Step. Lei Yang Computer Science Department. Create A Table-1. Create a table named Employee Attribute Set ID: Auto Number(primary key) Name: Text Gender: Text(Lookup Wizard) Salary: Money DptName: Text. Populate Data-2. 1 Simple Method 2 Using Forms 3 Import Data From File.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

### Download Presentation

Step By Step

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

## Step By Step

Lei Yang

Computer Science Department

### Create A Table-1

• Create a table named Employee

• Attribute Set

• ID: Auto Number(primary key)

• Name: Text

• Gender: Text(Lookup Wizard)

• Salary: Money

• DptName: Text

### Populate Data-2

• 1 Simple Method

• 2 Using Forms

• 3 Import Data From File

### Query-3

• Q1

• Find all information of female employees

• Q2

• Find all information of employees whose salaries are greater than 5000

• Q3

• Find the names of male employees from HR department

• Q4

• Find the names starting with “J”

### Query-4

• Q4

• Compute the average salary of the company

• Q5

• Compute the number of female employees

• Q6

• Compute the average salary of male and female employees

### Report-5

• 1 Basic Report

• 2 Chart Report