Home
About SMS Consulting
Project & Client Examples
Contact SMS Consulting

Inquiry Form:

Form Purpose

The Inquiries form is used to store data about telephone inquiries regarding possible enrollment. 

Features

• Auto-fill of today's date: The form defaults to the current date for the "Date Called" field to save data-entry time.
• Children sub-form: The form includes a sub-form for recording information about the student or students on whose behalf the inquiry is being made
• Date Info Sent: When information is sent in response to an inquiry, the date it is sent is recorded in the "Date Sent" field; clicking the button to the right automatically fills in today's date making for quick and easy data-entry.

Class Roster Form/Report:

Form Purpose

The Class Roster form is an input form used to generate the Class Roster report.  The drop-down box contains the names and grades taught for all faculty members (taken from the Faculty table).  The user picks which class to report on and a class roster is then automatically built using data from the students, parents, and class tables.  The roster details information about the class and an alphabetical listing of all students and their parent's names, address and phone contacts.

Class Roster Report (sample page): This report lists all the children in the class picked from the input form above in the following format: 1) Student's last name (in bold) 2) Primary household parents first and last names 3) Primary household address 4) Primary household parents' home phone numbers, cell phone numbers and e-mails (where available) 5) Student's first name, grade and date of birth, underlined.  If there is an Other Household associated with the student, the same information is listed for that household below the Primary Household information.  [Names, addresses, phone numbers have been obscured to protect privacy]