Step by step
This presentation is the property of its rightful owner.
Sponsored Links
1 / 6

Step By Step PowerPoint PPT Presentation


  • 85 Views
  • Uploaded on
  • Presentation posted in: General

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.

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 - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Step by step

Step By Step

Lei Yang

Computer Science Department


Create a table 1

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

Populate Data-2

  • 1 Simple Method

  • 2 Using Forms

  • 3 Import Data From File


Query 3

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

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

Report-5

  • 1 Basic Report

  • 2 Chart Report


  • Login