Excel/ Access hack

This is probably a simple hack many have already thought of, but it came in super handy for me today.
I had to search an Access database for college courses that are no longer offered in our district. Apparently a number of colleges still show them as active at their college though so I wanted to be sure they were all set to “de-active” or “no” in our database.
After several minutes I was getting cross-eyed trying to check the appropriate line.
To remedy the solution I simply posted a post-it note above the bottom line. Every time I did a search for no in the appropriate column, that row appeared right below my post-it note and kept me focused on the line I needed to make changes to.

In other solutions/ideas to help keep you focused on what you’re working on?

hack.jpg

Published by

Jonathan Blundell

I'm a husband, father of three, blogger, podcaster, author and media geek who is hoping to live a simple life and follow The Way.

Share your thoughts and snarky comments...