Step by step
Download
1 / 6

Step By Step - PowerPoint PPT Presentation


  • 119 Views
  • Uploaded on

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.

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

PowerPoint Slideshow about 'Step By Step' - azia


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