Category Archives: Databases

Art Catalog App and Stat Dashboards

I have long enjoyed tinkering around the edges of the technology and software world. I haven’t shared much on this site lately other than paintings, but over the past year or so, I have been messing around with some of the “low code”/”no code” app development solutions that are available. I built an art catalog app and stat dashboards, which

Read more

Access and VBA Cheat Sheet

As I’ve mentioned many times on this site, I am a huge fan of Microsoft’s data-crunching solutions. I’ve gained a reputation for it too; when I am about to offer a solution to something at work, co-workers usually say something like, “let me guess, it’s a pivot table.” Actually, usually it does involve pivot tables…but when I’m not preaching about

Read more

Database Fun – Art Collection

I’ve posted quite a bit regarding my love for Excel and Pivot Tables, but I haven’t actually mentioned my other source for data-crunching fun – Microsoft Access. Occasionally, I’ll come across some data structure or method of viewing that can’t be accomplished using Excel (or can’t be accomplished well). That’s when I’ll jump into database design. One example of this

Read more