Access is the relational database management system included in Microsoft Office. It provides Managers with a tool to work with their data that is more powerful than Excel but less so than enterprise systems. It is a very agile platform and can be used to work with data from a variety of sources, including commercial applications or State systems. Although more complex than other applications in Microsoft’s Office suite, MS Access can be learned by most office users and put to good use relatively quickly.
Administrative Systems assists Administration & Finances departments with MS Access training, report writing and customized application development. We also serve as an MS Access resource to other departments here on Geneseo’s campus.
Current Projects Include
- Mail Forwarding
This database is in use my Mail Services. Forwarding address information is entered directly by students using Liquid Office. The data is automatically exported to a MS Access database that Mail Services has access to. Forwarding address labels have been configured to work with Dymo single label printers. So Mail Services is able to select a student's name from a pull down menu and instantly print a forwarding address label with the latest address information provided by the student.
- WebTMA Billing Filter
MS Access database used to filter transactions from WebTMA; applying a dynamic set of billing rules to correctly process cost recovery information related to FAcilities Services Computerized Maintenance Management System.