Steps to Building a Successful Query

1
Steps to Building a Successful Query
2
A clear spec beats a full house
?

• The start determines the end
• Get to know your data
• Link tables one at a time
• Filter after reliable retrieval
• Sort for maximum results
• Math functions for clarity
• Custom reports add pizzazz
• User forms for flexibility

3
Know thy enemy

• The start determines the end
• Get to know your data
• Link tables one at a time
• Filter after reliable retrieval
• Sort for maximum results
• Math functions for clarity
• Custom reports add pizzazz
• User forms for flexibility

?
4
Walk before you run

• The start determines the end
• Get to know your data
• Link tables one at a time
• Filter after reliable retrieval
• Sort for maximum results
• Math functions for clarity
• Custom reports add pizzazz
• User forms for flexibility

5
Do you know whats in that column?

• The start determines the end
• Get to know your data
• Link tables one at a time
• Filter after reliable retrieval
• Sort for maximum results
• Math functions for clarity
• Custom reports add pizzazz
• User forms for flexibility

6
Can I take your order sir?

• The start determines the end
• Get to know your data
• Link tables one at a time
• Filter after reliable retrieval
• Sort for maximum results
• Math functions for clarity
• Custom reports add pizzazz
• User forms for flexibility

7
Adding aggregates

• The start determines the end
• Get to know your data
• Link tables one at a time
• Filter after reliable retrieval
• Sort for maximum results
• Math functions for clarity
• Custom reports add pizzazz
• User forms for flexibility

?
8
Report formats for fun and profit

• The start determines the end
• Get to know your data
• Link tables one at a time
• Filter after reliable retrieval
• Sort for maximum results
• Math functions for clarity
• Custom reports add pizzazz
• User forms for flexibility

9
Now make it work in BAR!

• The start determines the end
• Get to know your data
• Link tables one at a time
• Filter after reliable retrieval
• Sort for maximum results
• Math functions for clarity
• Custom reports add pizzazz
• User forms for flexibility

10
Better healthcare business
Better healthcare
Better health