Navigation:  Articles >


Previous pageReturn to chapter overviewNext page


Smart Access Article Abstracts








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

Michael Watson





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





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.


Migrating Access (and Outlook Data) to SQL Server

Rick Dobson





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.


Handling Visual Complexity

Peter Vogel





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



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


Purchase Smart AccessFirst page of this magazine



Find all the PDFs and Downloads



Product Links



Workbench for Access

Access To SQL Upsizer

FMS Software