|
Introduction
|
- Definition of Query
- Uses
- Limitations
- Challenges
- Introduction to Database Structure
|
|
Review of Basic Elements of Query
|
- Tables and Fields
- Criteria
- Operators
- Conjunctions
- Parentheses
- Nulls (empty fields)
- Sort
|
|
Complex Queries
|
- Multiple criteria with parentheses
- The less common tables
- Audit Trail
- How to break down complex queries
|
|
Advanced Query Techniques
|
- Query Parameters
- Stored Criteria
- Advanced Joins
- Eliminate Duplicate Names in queries
- Multiple Not Equals or Not Likes
- Use cumulative fields
- Store queries externally
|
|
Uses for Queries
|
- Change Data Globally (Assign Data)
- Delete Folders to Clean Out the Database
- Create and Modify Groups of Folders
- Purge Pledges, Mailings, Contacts, Memberships
- Update Giving Levels
- Export Data
- Quick Reports
|
|
Trouble Shooting Tips
|
- Syntax Errors
- Optimize Performance
|
