1. Create a detail report that will display all SCR courses in alphabetical order, with the course name and the instructor name in a group header; the Social Security number, name, and telephone number of each current student in the detail section; and the student count in group footer.

Document attached with the assignment.

2. Create a switchboard design with control buttons that lead to students, instructors, courses, course schedules, and course rosters. Allow a user to add, update, or delete records in each area. Jesse wants to see storyboards that show the proposed screens.

Same screen will be used for courses with fields as :

List of courses offered

Academic session:

For courses schedule:

Academic session:

Course name or number

For Class Roster:

Student ID:

Academic session:

Course number

Instructor name:

3. Suggest data validation checks for data entry screens.

FOR STUDENT RECORD:

ID, tuition and Phone number will always nonzero value 0 and is not null.

Name, last name will be strings

Start date and end date will be in date format as month/day/year.

Courses registered and address can have both number and string value.

Amount due should be >=0.

4. Create a source document for an SCR mail-in registration form. Also need a design for a Web-based course registration form.

[pic]

Fill in the form in UPPERCASE.

Fill the form clearly and with black ink. Fields marked with * are mandatory.

FIRST NAME * LAST NAME* MI GENDER *

| | | | |

STREET *

| |

CITY ZIP * COUNTRY * PHONE *

| | | | |

SOCIAL SECURITY NUMBER INCASE OF NO SSN, MENTION TAX IDENTIFICATION NUMBER

| | |

COURSES TO BE TAKEN

| | |
| | |
| | |

SEMESTER ACADEMIC YEAR

| | |

SIGNATURE: DATE:

• Form design for Web

-----------------------

TRAINING INFORMATION MANAGEMENT SYSTEM

▪ STUDENT RECORD

▪ INSTRUCTOR RECORD

▪ COURSES OFFERED

▪ COURSES SCHEDULE

▪ CLASS ROSTER

STUDENT RECORD

STUDENT ID FIRST NAME

COURSES REGISTERED LAST NAME

START DATE ADDRESS

END DATE PHONE

TUITION

AMOUNT DUE

UPDATE

DELETE

ADD

EXIT TO MAIN MENU

SUBMIT

CLEAR

INSTRUCTOR RECORD

INSTRUCTOR ID FIRST NAME

QUALIFICATION LAST NAME

START DATE ADDRESS

END DATE PHONE

SALARY

[pic]

EXIT

SAVE AS DRAFT

CLEAR

SUBMIT

[pic]

Fill in the form in UPPERCASE.

Fill the form clearly and with black ink.

FIRST NAME LAST NAME MI GENDER

| | | | |

STREET

| |

CITY ZIP COUNTRY PHONE

| | | | |

SOCIAL SECURITY NUMBER INCASE OF NO SSN, MENTION TAX IDENTIFICATION NUMBER

| | |

COURSES TO BE TAKEN

| | |
| | |
| | |

SEMESTER ACADEMIC YEAR

| | |

SIGNATURE: DATE:

FOR OFFICE USE ONLY:

Application number:

Accept:

Reject: