And checking for correct totals

SCR Case Simulation #3

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.

This is the New Student form:

This is the form a user would see when using the Instructor button.

This is the form a user would see when using the Courses button.

Data type check – This check will be used to ensure that the correct data type is entered. For example, only numbers or only letters.

Range check – This check will be used to verify and test that the data is between a maximum and a minimum.

4. Create a source document for an SCR mail-in-registration form. You will also need to design a Web-based course registration form.

From	T	Did you graduate?	YES	NO
From	o	Did you graduate?	YES	NO
College	T	Did you graduate?		NO
From	T		YES
From	o		YES
Other	T	Did you graduate?	Address	NO	Degree
From	T		YES
From	o		YES

Signature Date