Exercise on Report Design:You have been asked to design a report for the advisement offices (Business, Technologyand Family and Consumer Sciences) for the College of Business and Applied Sciences. Currently, students may apply for graduation in the second semester of their junior year. Students are directly to report to the advisement office to complete the following form:********************************************************************************* ** NAME: ___________________________ SSN: _______________ ** ** MAJOR: ___________________________ ** (ACC/CIS/FIN/MAN/MAR) ** ** SCHOOL: __________________________ ** (Business, Technology, or Home Economics) ** ** ** ANTICIPATED GRADUATION DATE: ** ** SEMESTER: _____________________ ** (Spring, Fall or Summer) ** ** YEAR: _____________________ ** ** ** STARTING DATE AT EASTERN: ** ** SEMESTER: _____________________ ** (Spring, Fall or Summer) ** ** YEAR: _____________________ ** ** ** *********************************************************************************The advisement center has enter this information into a ACCESS database with thefollowing format:field type widthssn character 9name character 20major character 3school character 20gradsem character 1 (1=fall, 2=spring, 3=summer)gradyr character 2startsem character 1 (1=fall, 2=spring, 3=summer)startyr character 2Your users in the advisement office would like to be able to request a listing of all students who anticipate graduation for a particular semester. You have been assigned the responsibility for designing this report, numbered RPT1001.The staff in each advisement office checks the transcript of each student to confirm that the student has met the current graduation requirements or the graduation requirements based on their start date at EIU.Critic the following solution:LUMPKIN COLLEGE OF BUSINESS AND APPLIED SCIENCESGRADUATION REPORTNAME SSN SCHOOL PROPOSED START AT GRADUATION EIU DATE XXXXXXXXXXXXXXXXXXXX XXX-XX-XXXX XXXXXXXXXXXXXXXXXXXX X XX X XXXXXXXXXXXXXXXXXXXXXX XXX-XX-XXXX XXXXXXXXXXXXXXXXXXXX X XX X XXXXXXXXXXXXXXXXXXXXXX XXX-XX-XXXX XXXXXXXXXXXXXXXXXXXX X XX X XXXXXXXXXXXXXXXXXXXXXX XXX-XX-XXXX XXXXXXXXXXXXXXXXXXXX X XX X
View Full Document