Employee

Name

Sex

Computer Expertise

Years of College

Years Worked for Company

Willing to Relocate Yes/ No

Work Region

Area

Strawberry Shortcake

Female

Microsoft Excel

1

15

Yes

N

Barney Dino

Male

Microsoft Word

2

5

No

E

Candy Dandy

Female

Macromedia Dreamweaver

3

10

Yes

S

Bob Builder

Male

Adobe Photoshop Elements

4

3

Yes

N

Blue Bird

Male

Macromedia Fireworks

3

7

No

NE

Spongebob Squarepants

Male

 

Adobe Presenter

2

20

Yes

W

Cinderella

Yeller

Female

 

Microsoft Access

1

3

No

NE

Mars Bars

Male

Microsoft Outlook

2

5

No

N

Handy Dandy

Male

Macromedia Flash

4

12

Yes

SE

Lean Cuisine

Female

Microsoft PowerPoint

1

3

No

N

Chips Ahoy

Male

Microsoft Word

3

6

No

W

Ipod Nick

Male

Macromedia Fireworks

2

3

No

S

Dolly Cat

Female

Camtasia Studio

1

9

No

SW

Oprah Stedman

Female

Microsoft PowerPoint

4

4

Yes

N

Brady Bunch

Male

Microsoft Publisher

3

8

Yes

NE

Rice Crispy

Female

Microsoft Excel

2

2

Yes

S

Cream Cake

Female

Macromedia Dreamweaver

4

6

No

NW

Alice Wonderland

Female

Windows Movie Maker

0

1

No

NE

Glow Shimmer

Female

 

Microsoft Word

1

5

No

N

Soda Pop

Male

Microsoft Excel

4

10

Yes

SW

Santa Clause

Male

Microsoft Publisher

2

3

Yes

N

Desk Top

Male

Microsoft Access

0

9

Yes

W

Gwen Hollywood

Female

Microsoft PowerPoint

3

12

No

N

Barbie Doll

Female

Macromedia Fireworks

2

8

Yes

S

Salad Dish

Male

Camtasia Studio

4

7

No

SW

Sand Man

Male

Windows Movie Maker

1

9

Yes

N

Thumb Drive

Male

Photo Story 3

0

3

Yes

NE

Mary Kate

Female

Macromedia Flash

1

18

Yes

SE

Mickey Mouse

Male

Microsoft PowerPoint

2

15

Yes

NE

Chuck Berry

Male

Microsoft Word

3

25

No

N

Lisa Simpson

Female

Adobe Photo Elements

4

5

No

W

ScoobyDoo

Male

Photo Story 3

0

2

No

N

Donald Duck

Male

Macromedia Dreamweaver

0

7

Yes

N

Lisa Frank

Female

Macromedia Fireworks

0

3

No

NE

Homer Simpson

Male

Microsoft Access

1

8

No

SE

Stewart Little

Male

Microsoft Publisher

2

4

Yes

N

Snicker Bars

Female

Microsoft Outlook

4

5

Yes

S

Ally Gator

Female

Microsoft Excel

3

3

No

SE

Slim Jim

Male

Macromedia Flash

1

5

Yes

N

Bart Simpson

Male

Microsoft PowerPoint

0

12

No

NE

Nosy Rosy

Female

Macromedia Fireworks

1

7

No

N

Blues Clues

Male

Microsoft Word

4

9

Yes

S

Peter Pan

Male

Photo Story 3

2

3

Yes

NE

Harry Potter

Male

Microsoft Access

3

20

Yes

N

Charlie Brown

Male

Macromedia Fireworks

4

6

No

NW

Penny Proud

Female

Microsoft Outlook

2

11

Yes

W

Pooh Bear

Male

Microsoft Word

3

15

Yes

E

Honey Bunny

Female

Photo Story 3

1

19

No

NW

Spider Man

Male

Microsoft Outlook

0

5

Yes

S

Super Man

Male

Microsoft Access

1

1

Yes

N

Billy Ray

Male

Macromedia Fireworks

4

2

No

S

Hannah Montana

Female

Microsoft Word

2

10

Yes

NE

Raven Symone

Female

Microsoft Publisher

3

12

Yes

S

Lizzie McGuire

Female

Microsoft Access

3

21

No

W

Dora Explorer

Female

Photo Story 3

0

15

No

E

Jenny Proud

Female

Microsoft Word

1

12

No

S

Big Bird

Male

Macromedia Flash

4

16

No

E

Betty Boop

Female

Microsoft Access

0

17

Yes

E

Tinker Bell

Female

Microsoft Publisher

4

21

Yes

W

Care Bear

Male

Microsoft Excel

4

4

Yes

N

Disney Channel

Male

Adobe Presenter

4

8

Yes

NW

Martha Stewart

Female

Microsoft Excel

3

4

No

NE

Will Smith

Male

Microsoft Publisher

3

5

No

W

Willy Wonka

Male

Microsoft Word

2

7

No

NW

Lemony Snickett

Male

Macromedia Flash

0

13

Yes

W

Leap Frog

Male

Microsoft Access

4

15

Yes

NE

Fisher Price

Male

Microsoft Excel

4

7

No

S

Bugs Bunny

Male

Microsoft Word

2

4

No

NE

Lola Bunny

Female

Macromedia Flash

0

6

Yes

N

Tweety Bird

Female

Microsoft Word

4

2

Yes

S

 

Query Wildcards and Expression Operators

Wildcard / Operator

Explanation

? Street

The question mark is a wildcard that takes the place of a single letter.

43th *

The asterisk is the wildcard that represents a number of characters.

<100

Value less than 100

>=1

Value greater than or equal to 1

<>"FL"

Not equal to (all states besides Florida)

Between 1 and 10

Numbers between 1 and 10

Is Null
Is Not Null

Finds records with no value
or all records that have a value

Like "a*"

All words beginning with "a"

>0 And <=10

All numbers greater than 0 and less than 10

"Bob" Or "Jane"

Values are Bob or Jane

 

Queries:

 

  1. How many female employees listed their expertise as Microsoft Word? Name them.
  2. How many employees live in the North (N) region that is willing to relocate? Name them.
  3. How many employees have worked for the company for 20 or more years? Name them.
  4. How many employees are male and listed their expertise as Macromedia Flash? Name them.
  5. Name the employees that have worked for the company five or less years.
  6. Name the employees who listed Macromedia Flash and who are willing to locate.
  7. Name the female employees that work in the North East (NE) region.
  8. Name the employees that have the last name Simpson.
  9. Name the employees with the last name Bars.
  10. Name all the employees thatís expertise is in some type of Microsoft program.
  11. Name all the employees that had move than 2 years of college and have worked for the company more than 20 years.
  12. Name the employees that listed Camtasia Studio as the expertise.
  13. Name all the male employees that have no college experience.
  14. List all the female employees thatís first name begins with the letter M. Name them.
  15. Name the employee thatís last name is Cuisine.
  16. Name all the male employees whose first name begins with the letter B.
  17. Name all the employees with the last name Dandy.
  18. Name all the male employees that work in the West (W) region.
  19. Name all employees that are an expert in any Adobe software program.
  20. Name all the employees that are an expert in some Microsoft program and is willing to relocate.