Did you know that you can use SolveXia to automate and replace your Microsoft Access databases?
Access databases are a popular way to combine and manipulate large data sets. Finance staff sometimes use Access to augment their reporting as follows:
In the example above, Access offers a more scalable way to manage and prepare data - particularly when data sets become large (10,000 rows or more). The Access database is often used to:
a) Join or map data (alternative to vlookups in Excel).
b) Filter data through queries.
c) Aggregate data.
Visual Basic is also sometimes used to orchestrate very complex Access databases. That is, the designer creates buttons and writes code to run queries in the database in a particular order.
A few examples of processes that may use Access:
SolveXia has pre-configured instructions for Access databases. These include:
For example, imagine a data set containing the countries of the world, ranked on their economic freedom:
This data is loaded into an Access database, cleansed and then aggregated to calculate the average economic freedom score for each region. This is then exported into an Excel report:
To automate this in SolveXia, you would start by using the Import from Excel function to copy the data into the Access database:
You can then add a step to export the data from a query in the Access database into an Excel file:
Once the process has run, the summarised data will be available in the Excel report (My Report.xlsx):
In addition to getting data into and out of the Access database, you can also write and run SQL queries. For example, to delete records that have a world economic rank of ’0’ (meaning that the country did not have any data):
Do you have an Access database you want to automate or replace?
If so, we’d love to hear from you - please reach out via firstname.lastname@example.org or call us on +61 2 9386 0202.