Category Archives: Old Material
Remote Queries in Access
This technology no longer works in Access 2016 What Is A Remote Query ? It always amazes me how I can keep stumbling across features that I never ever noticed or read about in the 8 years that I have … Continue reading
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
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
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
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
