Microsoft Access

Our team is involved in many asset management projects, particularly projects that deal with physical assets. We manage multiple databases and portfolio with single clients and Microsoft Access solves the problem of not being able to keep up and maintain all the databases at once. This program is used among the whole organization for a number of other projects as well.

Microsoft Access is used by most of our organization. It is the back end of a medical billing application that our users access for reports, do input and export into other formats for sharing that data with providers and payers of medical billing. I directly access the databases to use data for complex reports that the application cannot provide and to repair the databases when there is a problem.

We use Microsoft Access to pull payment reports from our Verisign/PayPal account to track and record all of our online receipts. Our online system has a variety of invoices that we need to book to the appropriate general ledger accounts and using Access to pull reports allows us to enter the revenue by account as a summary rather than by individual payments. This report is pulled daily using a time stamp that matches the credit card processing times so that our cash receipts entries match the bank deposits for all credit card transactions. Our organization also pulls membership reports through Access to send on to our fulfillment company.

Access allows for customized reporting and to bridge the gap in reporting needs not provided by other BI solutions at my company.

[It's] Used across the organization for a multi-site database to collect, organize and report on behavior and incident reports. Also used as a company-wide database for password storage.