Portland Access User Group

Portland Access User Group Conference

September 28-30, 2019

The PAUG Database Designer International conference brings together a wide range of Access developers, consultants, power users and Access enthusiasts. This marks the 21st anniversary of the conference. We will once again be returning to the peaceful and natural surroundings of the Conference Center at Silver Falls State Park, which lends itself to a climate that fosters learning, creativity, and socializing.

Friday, November 5, 2010

Office DEVCON in Australia

Today, I'm in Australia, speaking at the Office DEVCON 2010.  I'm very excited to be asked to present here and it's a wonderful opportunity to see Australia.

My topic is: Data Warehouse in Access. Ridiculous?  Not so! 

The premise is that there is nothing inherent in the definition of a data warehouse that excludes the use of Access as an implementation platform.  Certainly, Access has limitations of size and speed, and I'm not proposing its use as an Enterprise Data Warehouse.  What I am proposing, however, is you can use the principles of data warehousing (dimensional model, calculated columns, etc) to make a super fast reporting database for your transactional system, especially with respect to aggregate data reporting.

There are two sessions.  Part 1 discusses the structure of an Access data warehouse (or data mart if it makes you more comfortable).  Part 2 discusses various methods of reporting from your warehouse/mart.

For those interested, the session PowerPoint presentations and accompaning articles can be downloaded here:

Datawarehouse_in_Access_Part_1.zip (3 MB)
Datawarehouse_in_Access_Part_2.zip (3.7 MB)

Office Automation Samples:
ExportToExcelCharts.mdb
AutomatingWordFromAccess.mdb

.