Category Archives: Old Material

Programming Pivot Tables for Access Forms

Pivot tables represent a powerful way to convey the data in Access databases, and they empower users to perform many tasks that used to require custom programming. In this article, Rick Dobson shows how you can enable your users to … Continue reading

Posted in Old Material | Leave a comment

Printing Pesky ZIP Codes and Setting the Starting Page Number for Reports

This month, Ken takes on two questions: how to most efficiently store ZIP codes (and how to deal with printing or not printing the pesky hyphens), and how to set the starting page number for a report. I’m having a … Continue reading

Posted in Old Material | Leave a comment

Preparing To Upgrade Access Tables to SQL Server 2005/2008

This article discusses some of the subtleties that you can apply to your database tables prior to upsizing your tables to SQL Server. I do this because once you are in an environment where you have Access as a front-end … Continue reading

Posted in Old Material | Leave a comment

PivotTables in Access

Russell Sinclair shows how to summarize data using PivotTables. ONE of the great new features of Access 2002 and beyond is actually one that’s been included in Excel for some time—the ability to create dynamic information summaries in tables and … Continue reading

Posted in Old Material | Leave a comment

Persistent Recordsets in ADO

There are things ADO can do that no other data access method can. Among the coolest features is persistent datasets. In this article, one of the gurus of ADO shows you how to use this technology in your Access applications. … Continue reading

Posted in Old Material | Leave a comment