PivotTables and charts have found wide usability in the industry thanks to their inclusion in the Ms Office package, most notably in Ms Excel. They effectively gives you the flexibility to query the data from different points of view. They also allow you to briskly summarize a large data set and drill down through a summary to the underlying data. Most importantly a whole array of analysis done in financial and business process today harness the powerful filtering and group features that PivotTables offer. Initially a lot of people relied on Ms Excel to create PivotChart and slowly some of them started using the same features in Ms Access. In fact some small business owners who have to deal with lot of data and consequent analysis have always relied on PivotTables and charts to summarize the data. However in the Outlook 2013 edition Microsoft seems to have taken away the feature. Hence the only solution lies is exporting the data to Ms Excel and using its superior PivotChart features to create detailed graphical representations.
Exporting Data from Ms Access to Excel
When you are looking at transferring data from an Ms Access database to an Excel spreadsheet you can look at several available options. The simplest way to achieve the same involves using the copy function to place the relevant data in clipboard and then paste the same on a spreadsheet. You can also export the data from Access to Excel, you can choose to export the files by performing the tasks listed below
- Launch the Ms Access application and choose the object, say table, that you wish to export
- Next you need to go to the Export group and head to the External data choices available and choose Excel
- Once done in the subsequent dialog box assign a relevant filename to the Excel spreadsheet and file format, say .xls and complete the action.
Once the data is placed in Excel you can quickly create PivotTable reports and charts based on it. It is important to note that Excel also allows you to directly import an Access object as long they are queries or tables.
Dealing with a corrupted MDB file in Ms Access
While the Ms Access application is often counted as a great database application for anyone looking to store information in an RDBMS without burning a fortune, it has its share of drawbacks. For instance if the MDB file where Access stores all its data gets compromised, every thing you have stored in the database can go for a toss. All records that you have, all the tables that you have painfully created and associated relations can be lost. Only a powerful access repair tool like the DataNumen Access Repair can help you get back your data. Powered with a highly sophisticated recovery algorithm, this tool can extract contents from a botched up MDB file without much effort. Moreover it can extract the contents from nearly any media type including flash media drives often used to backup Access files.
Alan Chen is President & Chairman of DataNumen, Inc., which is the world leader in data recovery technologies, including access repair and sql recovery software products. For more information visit www.datanumen.com