With the release of Office 2007, Excel introduced cool new conditional formatting rules that gave you the ability to show dashboard-esque icons inside cells. With these icons, you can represent performance using different shapes and colors.
As usual, Access gets the short end of the visualization stick. No such functionality exists in your cache of Access tools. But today, I'll show you how to hack your way into showing dashboard-esque icons in Access queries.
Ahh, the classic story. Boy gets job. Boy becomes the department data collector. Boy meets 25 Admins who send him a spreadsheet every week. Boy copies and pastes into one workbook. Boy lights himself on fire.
Combining multiple Excel worksheets into one data table is such a common task, I would bet a pound of bacon that most of us have been through that ordeal once or twice.
The good news is that you can just scour the internet, and you'll probably find dozens of techniques for combining multiple Excel files together.
Here's one simple way you can leverage Access to combine multiple Excel files (without VBA).
» More: Using Access to Combine Multiple Excel Files: Method 1
