Connect to Multiple Data Sources
Not only can Access store data in its own tables, but it can link to data from a large range of sources within the one Access database. Data from SQL Server, SharePoin, Oracle, text files and even Excel workbooks can be queried and referenced in the same Access database.
MS Access Database Data Analysis and Reporting
Many industry software packages in finance, mining and asset management, use high end database systems like SQL Server or Oracle to store their data. However, the data extraction and reporting tools on the front end of these applications can be limited, and may require consultants to produce the desired reports. Access can connect directly to the database tables, and use its powerful query and reporting tools to generate custom analysis and reporting. In fact, it can be a used as a “middle layer” between database servers and Excel reports.
Stand-Alone MS Access Databases in Perth
Access has the capability to build complete applications; thanks to its easy-to-build user forms and programmable interface and data handling. It can be a self-contained application managing its own data, or act as a “front-end” to data stored on SQL Server, SharePoint or Oracle.
Macros and Visual Basic for Applications
Access, like all other Office applications, can utilise Visual Basic for Applications (VBA) to extend the capabilities of an Access database. Not only does VBA give control over Access data management, forms and reports, but it can also give an Access database capabilities such as sending emails, downloading data from webservers, creating Word documents and populating Adobe forms.