• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Query Challenges

Nothing unleashes the power of a database better than a query. Queries are even used behind the scenes in Access to perform many tasks without the user even being aware that they are going on. However, there are situations that can confront the developer that can prove to be challenging, to say the least. The query often is the first place the developer turns to for help. Yet, the best way to apply this powerful tool is not always apparent.

Let’s say you are working for an insurance company and your boss approaches you with what they call a “stratification report” in the insurance business. He wants the dollar amounts to be grouped in levels, or “strata,” sorted with the smallest levels first. To determine the frequency of the losses, you must show the number of claims in these various levels. To determine the severity of the losses, you must show the dollar amounts for the various levels.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint