Apr-2005

<< Click to Display Table of Contents >>

Navigation:  Other Topics > Smart Access 1996-2006 >

Apr-2005

 

Smart Access Article Abstracts

Page

 

 

---

 

How to Tame the Crosstab Missing Column Beast (and Get a Free Lunch)

Michael Watson

1

 

Article

 

Crosstab queries are a powerful means of summarizing data. But they can sometimes lead to unexpected situations. Mike

 

Watson looks at how you can ensure that your data-driven crosstab reports can work reliably. Along the way, he also shows

 

how Access helps you out by ignoring unwanted data.

 

Computing the Median (Again)

Christopher R. Weber

7

 

Article

 

You should never calculate the average value of anything without also calculating the median value. Chris Weber explains why

 

and gives you a clean, step-by-step method for deriving the median value from any numeric series. Unlike other published

 

methods, Chris’ method uses no temporary tables or custom functions—all you need is a single query.

 

 

 

 

 

 

 

 

 

 

 

 

 

Handling Visual Complexity

Peter Vogel

12

 

Article

 

Building a great user interface isn’t simple—but the result should be. No matter how complex the task is, your users should find

 

it easy to figure how to use your application. Peter Vogel discusses two kinds of complexity and the strategies for making
things simple.

 

Access Answers: "Close" Only Counts in Horseshoes

Doug Steele

16

 

Access Answers

 

This month, Doug Steele looks at a couple of techniques to help determine when entries are close enough to be considered the

 

same. My users have problems with the accuracy of their typing. Is there some way that I can check whether something close

 

to the lookup passes the test.

--- Negotiation Another Peter Vogel editorial

 

First page of this magazine

 

 

 

 

---