Microsoft Access

I use Access to track project timelines, record business expenses, and to manage our client database. For my clients, I use Access to build reports that are not currently built-in to the various Learning Management Systems (LMS) that I support - having the ability to locate records, find missing or inaccurate data, and run reports that combine various tables of information from the LMS' makes Access an invaluable resource for me.

The main reason we used Access was to analyze a database too heavy for Excel. It was a single database and needed to be accessed and updated on a monthly basis with millions of rows of data. We also needed to run complicated vlookups and other functions on this data.

We have several Microsoft Access databases in use across our organization. We have a voucher database that's used to track and pay invoices and other bills. We have a database used by our accounting department as a cross-checking system for our main accounting system. Our IT department uses an Access database to track equipment inventory. Microsoft access makes it quick and easy to enter data and print reports and other forms based on that data.

We use this as our data base. It is a great information management tool that helps us store information for reference, reporting, and analysis. Microsoft Access helps us analyze large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheet applications. It is used across the entire organization. It helps our users store data.

We were a small team that had limited budget for shared services technology. [it was used for] Things that needed to be managed from a shared services perspective such as an applicant tracking system, basic HRIS system (time off aggregator, performance review, and hours entry), and technology asset ownership, etc.

These were across whole organization needs that were mainly used and administered by the finance department (the defacto shared services manager) but it was used from a user perspective by all employees.

Use of MS Access was a way to solve internal data aggregation needs that a spreadsheet couldn't do because of the need for stakeholders to have access to enter data and then to restrict that data from users.

I use Microsoft Access currently, and have in the past for a variety of projects and tracking initiatives. The one I found the system to be most useful involved the need to track daily accounting, accounts payable, and accounts receivable amounts. Not only is the system easy to set-up and edit, but with the ability to pull out and download the data it can be shared among the various departments and sites that need access all to the same information.

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.

We used Access to manage data on faculty, courses, course schedules, and rooms. The database was used by one department only but was used across three sites in the same department. The database was updated for each semester and used to provide a wide variety of forms and reports for use by each campus.

I utilize Microsoft Access for a few different functions within our agency, I use it to track reports and analyses that are required to be completed. By using Access I can quickly see how many of our required documents are past due and also how many of them are coming close to being due. I generate reports to provide my supervisor that display who is responsible for what mandated reports. Access also allows me to print out a document that is in a letter format advising the individual of which reports/analyses are their responsibility and then require them to sign this and return it signed along with the required document. It helps track who is responsible for what and when to put it simply.

I was working with wind turbine data, it was massive 10 minute data with more than 20 columns per turbines. I was handling 4000+ turbines alone to analyze the failure rate and manage the analytical report which I need to extract from the 10 minute data. Excel can't manage large data, whereas Access helped to solve the data management of 4000+ turbines.

In the past, I used it to create databases to track expense reports, later I used it to track charity donations made within the company I worked for. I would create the database from scratch and set it up so that it was user friendly for those who had no prior use with access. The great thing about the program is that you can customize it. Sometimes I'd have pop up screens or instructions baked right into the viewing screen that the end users could easily follow. I also sometimes use access to scrub and organize info that may have similar components of info but they may have been altered over time. I can refrain from having to re-invent everything and just upload using a special query or whatever and still house all my info together. Access is great and is highly adaptable for my needs. I've been able to use it everywhere I go.

As a Data Analyst, my department uses Access for ad hoc analysis, business process automation and recurring reporting. It is used by line of business analysts when a technology budget is not approved and a non IT developed/supported application is an option. Typically this would only be used for single user/departmental solutions to reduce single point of failure analytics.

Currently our department uses Microsoft Access to create ad hoc application tools that are needed by our business. Our application tools are used by all users of our Infusion and Respiratory business but not by other lines of business. It addresses the business problems of needing a solution that promotes data integrity of user inputs, and needing a solution quickly that regular application management methodologies cannot meet the needs of. It's easy and simple to use and provides a user-friendlytool for our users to use on daily basis.

I have employed MS Access in several different organizations, both large corporate entities and at mid-size firms, and even at a number of non-profit agencies. It is typically used by individuals or departmentally, although I have had opportunity in several small to mid-size firms to employ it on a larger scale within the organization. Typically I have found a number of users comfortable with Excel end up developing massive database-like sets of information across spreadsheets that are shared or sent across the org, and Access has presented solutions to migrate these into a more solid data model with a user-friendly interface. I have also seen Access poorly implemented in larger organizations, where it is simply a glorified spreadsheet. The capacity of the tool is enormous, and although the training curve is not steep, it is necessary for some basic user and developer training to be able to employ it effectively.

Mining large amounts of data and pulling meaningful reports for leadership status.

MS access was used to merge two or more excel spreadsheets with related fields.

I am the only one at my organization who uses MS Access. I export information from multiple platforms and import it into Access to generate reports and statistical data.

Access is used for reporting and analysis. It is used by individual departments. Access helps track special projects and allows in depth analysis and reporting production. Flexibility to view data in multiple formats. The ability to use modules and macros to auto processes and export of data is very helpful and reduces labor.

I used Microsoft Access when I was a Litigation Support Analyst. We used the application to run queries to compare data load files for large databases that contained electronic discovery images. We also ran queries that detected issues and mistakes within the load files. Queries also helped to manipulate the data. Access performed tasks that were nearly impossible to do by hand.

The product is being used at the department level. In a lot of cases a competent analyst can use this without the need for direct IT staff intervention so support costs are kept down while department level satisfaction is high. The staff also enjoys the independence and flexibility they have; especially in areas where there is too much data manipulation for Excel to handle.

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

We use Access as our content management system. We're an online daily, so once we write stories in Word, Access uploads them as our report online. We also enter other data into it, and that's reflected on our website. It is used company-wide.