Tracking renewable scholarships using microsoft access
This presentation is the property of its rightful owner.
Sponsored Links
1 / 12

Tracking Renewable Scholarships using Microsoft Access PowerPoint PPT Presentation


  • 73 Views
  • Uploaded on
  • Presentation posted in: General

Tracking Renewable Scholarships using Microsoft Access. Presented by Rosiland Garner Mississippi State University September 15, 2014. Scholarship Access Databases. New Freshman and New Transfer Student Academic Scholarship Database

Download Presentation

Tracking Renewable Scholarships using Microsoft Access

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Tracking renewable scholarships using microsoft access

Tracking Renewable Scholarshipsusing Microsoft Access

Presented by Rosiland Garner

Mississippi State University

September 15, 2014


Scholarship access databases

Scholarship Access Databases

  • New Freshman and New Transfer Student Academic Scholarship Database

  • Scholarship Awards Database – for Renewable Scholarships (only store data for current year and 3 years prior)

  • Scholarship Awards Archival Database – for Renewable Scholarships (1998 – 2010 data)

  • Engineering Awarding Database


Data information pages in awards database

Data Information Pages in Awards Database

  • General Student Information

  • Fall Semester

  • Spring Semester

  • Summer Semester

  • State Pride Scholarships

  • Private Scholarships

  • Leadership and Service Scholarships

  • Departmental Scholarships


Data entry methods

Data Entry Methods

  • New Aid Year Rollover Process – new and current awards (main method)

  • Spreadsheets imports – mainly for State Pride, Leadership & Service, Private, and Departmental Scholarships

  • Copy of older data – completely by ITS-EIS staff

  • Manual entry – completed by Scholarship Office staff (rarely happens)


Visual basic code behind the scene processing

Visual Basic Code - Behind the Scene Processing

  • Initial aid year filtering for all pages

  • Search, save, undo, and add student logic and functionality

  • Load logic and functionality

  • Spreadsheet logic and functionality


System updates

System Updates

  • 10th Class Day Update Process – executed by ITS-EIS staff

  • End of Semester Update Process – executed by ITS-EIS staff

  • Summer Updates – handled manually by Scholarship Office Staff


Tracking renewable scholarships using microsoft access

Questions?


Contact information

Contact Information

Rosiland Garner

[email protected]

662-325-9177

Angie Sherrer

[email protected]

662-325-7435


  • Login