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
Scooby Doo	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.