Skip to main content

Microsoft Access

Overview

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 Finance & Administration 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 by 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.
  • Human Resources Dashboard System
    Reporting system for data from a variety of HR related systems
  • Gen1 Overtime Management
    Enables Supervisors to quickly and easily offer overtime to employees in adherence to CSEA contract stipulations.
  • Purchase Order Tracking
    Track PO's and Purchase Requests from the office of Procurement Services