|
Apr-2005 |
|
|
|
|
Apr-2005 |
|
|
|
|
Smart Access Article Abstracts |
Page |
|
Gold Collection |
2005-04 |
|
--- |
|
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. |
|
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. |
|
Rick Dobson |
10 |
|
Article |
|
It’s an unusual Jet database that will convert smoothly to SQL Server. Rick Dobson shows how to mix your own code with the |
|
Upsizing Wizard. But in many cases it’s not just Access data that you need to convert, so he shows how Access can let you |
|
move Outlook data into SQL Server. |
|
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 |
|
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
|
|
Find all the PDFs and Downloads |
--- |
|
Product Links |
