step by step
Download
Skip this Video
Download Presentation
Step By Step

Loading in 2 Seconds...

play fullscreen
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
ad