Having summarize often large amounts of data that have been extracted from your corporate database? Access can be very helpful if you need to work with a huge stream of data. We have published a new article that shows how to the data easier to import, analyze, and summarize reports, even if you have not you experts consider access.
The article walks through the creation of an Access database that supports importing monthly sales data from a text file. So that you follow along as we explore this scenario, we have provided the sample data that was used to the article as well as with all imported data create a database file.
The scenario involves the following tasks:
Set up an import specification for access to the same data in future months import.Use the integrated Table Analyzer a normalized structure for which to create data.Create a number of append the incoming data in the normalized structure is analysed.Write a macro that import automates the data.Finally, create and distribute reports that summarize the data.The work this month to import to normalize report, and automate the process will in future months pay when you create the reports take only a few seconds time!
The article is only one possible solution for this scenario. Have you used access to solve a similar problem? Leave a comment and let us know!
--Mike Stowe
No comments:
Post a Comment