Scholarships using Microsoft Access Presented by Rosiland Garner Mississippi State University September 15 2014 New Freshman and New Transfer Student Academic Scholarship Database Scholarship Awards Database for Renewable Scholarships only store data for current year and 3 years pri ID: 623752
Download Presentation The PPT/PDF document "Tracking Renewable" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Tracking Renewable Scholarshipsusing Microsoft Access
Presented by Rosiland GarnerMississippi State UniversitySeptember 15, 2014Slide2
New Freshman and New Transfer Student Academic Scholarship DatabaseScholarship 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 DatabaseScholarship Access DatabasesSlide3
General Student InformationFall SemesterSpring SemesterSummer SemesterState Pride ScholarshipsPrivate Scholarships
Leadership and Service ScholarshipsDepartmental ScholarshipsData Information Pages in Awards DatabaseSlide4Slide5Slide6Slide7Slide8
New Aid Year Rollover Process – new and current awards (main method)Spreadsheets imports – mainly for State Pride, Leadership & Service, Private, and Departmental ScholarshipsCopy of older data – completely by ITS-EIS staff
Manual entry – completed by Scholarship Office staff (rarely happens)Data Entry MethodsSlide9
Initial aid year filtering for all pagesSearch, save, undo, and add student logic and functionalityLoad logic and functionalitySpreadsheet logic and functionality
Visual Basic Code - Behind the Scene ProcessingSlide10
10th Class Day Update Process – executed by ITS-EIS staffEnd of Semester Update Process – executed by ITS-EIS staff
Summer Updates – handled manually by Scholarship Office StaffSystem UpdatesSlide11
Questions?Slide12
Rosiland Garnerrgarner@its.msstate.edu662-325-9177
Angie Sherrerasherrer@saffairs.msstate.edu662-325-7435Contact Information