Open your Access database. Start the Linked Table Manager feature. In Access 2003, from the menu choose Tools, Database Utilities, Linked Table Manager. In Access 2007 from the ribbon choose Database Tools, Linked Table Manager. In Access 2010 from the ribbon choose External Data, Linked Table Manager. In the Linked Table Manager dialog […]
Archive | April, 2013
Excel PivotTable 101
What is a PivotTable? A PivotTable is a useful tool for creating summary reports from Excel data. And the cool thing is you can “Pivot” or move the fields of the report. For example all of the following screen shots are from PivotTables that were created from an Excel list of 5406 movies. Figure 1: […]