Consolidating data in access

Databases tend to be very widespread across the enterprise, because they are very efficient for handling relational storage of data and are designed to be platforms for a wide variety of applications.Because databases form the foundation of so many business systems, IT departments can easily lose control of the number of databases that need to be maintained, because each group may simply create their own database to solve a specific problem they may be experiencing.

When using the Office family of products, should you use Excel or should you use Access to manage your tabular data? On the Data tab, in the Data Tools group, click Consolidate. For example, cell B2 (in distric1.xlsx) cell B2 (in district2.xlsx) cell B2 (in district3.xlsx). Note: if you don't check Top row and Left column, Excel sums all cells that have the same position.A companion article, Using Access or Excel to manage your data, recently discussed the benefits of each product and what they "bring to the table". If you store your data in Access and connect to it from Excel, you gain the benefits of both.Here are ten reasons why a marriage between Excel and Access makes lots of sense.Fortunately, there's another alternative: the Consolidate... You typically use it to perform summary calculations on values in corresponding cells in various source ranges.


Leave a Reply