• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Designing Access Queries > In the Real World—Query Design Optimizati...

In the Real World—Query Design Optimization

The objective of select query design is to convert raw data to useful information. The design of decision-support queries in production database applications is a combination of art and science.

The Art of Query Design

An artful query design returns the result set in the format that's most meaningful to the recipient. For example, a query that displays orders sorted by customer and uses the customer code for identification might be understandable by a salesperson, but not management. Salespeople are likely to know the codes for their particular customers. Few sales or marketing managers, however, are capable of memorizing hundreds or thousands of codes. This is especially true if the codes are numeric, rather than based on the first few letters of customers' names, as is the case for the Northwind Customers table. Fortunately, Access's table lookup feature propagates to queries; when you specify CustomerID as a query column, table lookup in the Customers table automatically substitutes CompanyName for CustomerID in the query result set.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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