{"id":3416,"date":"2008-02-01T17:08:43","date_gmt":"2008-02-01T23:08:43","guid":{"rendered":"http:\/\/www.casadeblundell.com\/jonathan\/?p=3416"},"modified":"2008-02-01T17:09:33","modified_gmt":"2008-02-01T23:09:33","slug":"spreadsheet-access-hack","status":"publish","type":"post","link":"http:\/\/casadeblundell.com\/jonathan\/spreadsheet-access-hack\/","title":{"rendered":"Excel\/ Access hack"},"content":{"rendered":"<p>This is probably a simple hack many have already thought of, but it came in super handy for me today.<br \/>\nI 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 &#8220;de-active&#8221; or &#8220;no&#8221; in our database.<br \/>\nAfter several minutes I was getting cross-eyed trying to check the appropriate line.<br \/>\nTo 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.<\/p>\n<p>In other solutions\/ideas to help keep you focused on what you&#8217;re working on?<\/p>\n<p><a href='http:\/\/www.casadeblundell.com\/jonathan\/wp-content\/uploads\/hack.jpg' title='hack.jpg'><img src='http:\/\/www.casadeblundell.com\/jonathan\/wp-content\/uploads\/hack.thumbnail.jpg' alt='hack.jpg' \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &hellip; <a href=\"http:\/\/casadeblundell.com\/jonathan\/spreadsheet-access-hack\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Excel\/ Access hack<\/span><\/a><\/p>\n","protected":false},"author":84,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[23,3,12],"tags":[744,745,746],"class_list":["post-3416","post","type-post","status-publish","format-standard","hentry","category-life-hacks","category-misc","category-techno","tag-access","tag-excel","tag-ms-office"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pEnSo-T6","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"http:\/\/casadeblundell.com\/jonathan\/wp-json\/wp\/v2\/posts\/3416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/casadeblundell.com\/jonathan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/casadeblundell.com\/jonathan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/casadeblundell.com\/jonathan\/wp-json\/wp\/v2\/users\/84"}],"replies":[{"embeddable":true,"href":"http:\/\/casadeblundell.com\/jonathan\/wp-json\/wp\/v2\/comments?post=3416"}],"version-history":[{"count":0,"href":"http:\/\/casadeblundell.com\/jonathan\/wp-json\/wp\/v2\/posts\/3416\/revisions"}],"wp:attachment":[{"href":"http:\/\/casadeblundell.com\/jonathan\/wp-json\/wp\/v2\/media?parent=3416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/casadeblundell.com\/jonathan\/wp-json\/wp\/v2\/categories?post=3416"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/casadeblundell.com\/jonathan\/wp-json\/wp\/v2\/tags?post=3416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}