Experimentation with Access
|

Revisit Access

I’m revisiting a project that had lots of data – so much that I could not work with it in Excel very well. I was forced to build up the formulas, file by file. I would build a column of formulas to do one thing and if it worked, save that file with the formula. Let’s…

Data Model
|

Discovering Data Model

Before I left on a retreat, I was playing around with Access and data model. Pivot tables have something called data model and I was playing around with it to see how it works. What I found was that it allows you to combine two tables, kind of like Access’ joining of tables and/or queries….