Record keeping in Stock photography discussion and contributor experience Posted August 19, 2014 I use an Access database, but before that it was a spreadsheet, and I imported the data into Access tables. It works for me, but I do have a fair bit of VBA knowledge so there's lots of nice fun buttons to press and lists to view! Yeah, whether you use Access or Excel, good knowledge of Formula building and VBA is required. I learned out of necessity when the company I worked for didn't want to pay the licence fee for Access for some 3000 staff and only had Excel 97 :-) I had to build an loan application decisioning system with god knows how many rules in it...... and of course store details of its 1/2 million accounts. Learning a bit of VBA is key really, if you do, you can make it do anything you want!