| Ray Merry |
| 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 | |