A Search for a Better Search


Q: Our CPA firm has more than 400,000 data files on the file server, and we constantly struggle to locate the right file. For example, recently an audit staffer retrieved an Excel file that contained fixed-asset depreciation calculations and used this in the audit. Unfortunately, the version of the file retrieved was not the most current and, as a result, additional time was wasted updating the older file. We hope to avoid problems like this in the future. What is the best way to manage such a large volume of files?


A: In last month’s column (“Say Goodbye to Wimpy Searches,” JofA, Feb. 2011, page 65), we addressed the concept of indexed searches, but let’s dig a little deeper into this subject. The Explorer window in Windows Vista and Windows 7 provides additional searching capabilities to help you quickly view and narrow your search results. Start by performing a search in an Explorer window. (As you may recall, last month we searched for the term “regression,” and I will continue with this example.) Once Windows returns the search results for the term “regression,” I can further refine my search results by clicking on any of the column headings to view filter options. For example, in the screen below I have clicked the dropdown arrow next to the Type column heading. This action “stacks” the data files according to “type of file.” Notice that I have many file types containing the word “regression” including Excel 2003 and 2007, Word 2003 and 2007, HTML, PowerPoint, XML and others.


The search results can be narrowed by checking the boxes in the Type column next to the desired Group(s). By default, these advanced options narrow search results by file name, date range, file type, file size and folder name. For a more refined search, Windows Vista and Windows 7 provide an additional 281 searchable field names. To access these additional field names, add them to the column headings of the Search Results in Data screen by right-clicking on any column-heading label and selecting More… to display the Choose Details dialog box shown below.


Place a checkmark in the box next to those field names you would like to include in the Search Results in Data dialog box. For example, you might add the fields Authors, Comments and Status to locate files authored by Albert, files containing the comment “very useful,” files containing the status “reviewed,” or files meeting all three criteria.


These additional file search methods may help your audit staff identify and select the correct fixed-asset depreciation files in the future.


Note: The effectiveness of a search improves when document properties are added to the data files. Document properties can be added to Word documents as follows:


Word 2010: Select File, Properties, Show Document Panel.

Word 2007: Click on the Office Button, Prepare, Properties.

Word 2003: Select File, Properties.


The Document Properties panel (shown below) will allow you to insert keywords, authors, titles, comments and other custom information.


Document Properties are used by Instant Search to not only locate files, but also to sort the search results in priority order according to those files that most closely match your search criteria.


More from the JofA:


 Find us on Facebook      Follow us on Twitter



How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.


Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.


News quiz: Scam email plagues tax professionals—again

Even as the IRS reported on success in reducing tax return identity theft in the 2016 season, the Service also warned tax professionals about yet another email phishing scam. See how much you know about recent news with this short quiz.