|
|
|
|
|
How Many Employess are making over $1000 a week
in our Company? |
|
How many of our customers buy more than 6 times
a year? |
|
What product in our Inventory made us the most
money last year? |
|
These and many other questions can be answered
by queries run on the Companies records. |
|
|
|
|
|
|
A Query organizes Data from a Database |
|
Simple Queries can be just parts of tables |
|
E.G. I have 20 fields but I only need 2 for the
accountants |
|
Queries can also be mathematical |
|
All salaries > 4.50 |
|
Sum all salaries |
|
The power of queries comes from the person who
sets them up! |
|
Example of CIA and Matching Travel with 2 people |
|
Matching Deposits with Meetings |
|
|
|
|
|
|
Glossary of terms |
|
Define the terms as used in this subject |
|
|
|
|
State what has been learned |
|
Define ways to apply training |
|
Request feedback of training session |
|
|
|
|
Chapter 9 |
|
Lab 4 and 12 |
|
List books, articles, electronic sources |
|
Consulting services, other sources |
|
|
|
|
|
|
|
|
|
Notes
