Table of Contents

Normalisation.. 2

Data Dictionary. 4

tbl_Students. 4

Tbl_Applications. 7

tbl_Courses. 9

tbl_Deadlines. 11

tbl_PersonalTutor 12

tbl_PersonalStatement 13

tbl_Universities. 15

Entity Relationship Diagram.. 17

GUI Designs. 18

Menu Skeleton Outline. 18

Screen shots and Design Notes. 19

Logon Screen.. 19

Main Menu.. 21

Student Details & Personal Application Screen.. 24

Personal Tutor Details Screen.. 26

Application’s Details Screen.. 29

Course Details Screen.. 31

University Details Screen.. 33

Deadline Details Screen.. 35

Personal Statements Screen.. 37

Reports Screen.. 39

 

 


Normalisation

Un-Normalised Form (UNF)

1st Normal Form (1stNF)

2nd Normal Form (2ndNF)

3rd Normal Form (3rdNF)

App_ApplicationID

App_Details

App_Notes

App_Date

Stu_Name

Stu_Address

Stu_TelephoneNo

Stu_MobileNo

Stu_Email

Stu_EmrgContact

Stu_EmergTelNo

PS_Statement

PS_StatementDate

PS_Reviewed

PS_Approved

PT_Title

PT_Name

PT_Surname

UNI_UniversityName

UNI_Address

UNI_TelephoneNo

UNI_Fax

UNI_Email

UNI_CourseID

Courses_CourseName

Courses_Description

Courses_UCASPoints

Deadlines_Date

Deadlines_Description

Deadlines_Priority

App_ApplicationID

App_Details

App_Notes

App_Date

Stu_FirstName

Stu_SecondName

Stu_Surname

Stu_Address01

Stu_Address02

Stu_PostTown

Stu_PostCode

Stu_County

Stu_TelephoneNo

Stu_MobileNo

Stu_Email

Stu_EmrgContact

Stu_EmergTelNo

PS_Statement

PS_StatementDate

PS_Reviewed

PS_Approved

PT_Title

PT_FirstName

PT_Surname

UNI_UniversityName

UNI_Address01

UNI_Address02

UNI_Address03

UNI_PostTown

UNI_PostCode

UNI_County

UNI_TelephoneNo

UNI_FaxNo

UNI_Email

Courses_CourseName

Courses_Description

Courses_UCASPoints

Deadlines_Date

Deadlines_Description

App_ApplicationID

App_Details

App_Notes

App_Date

Stu_StudentID

Stu_FirstName

Stu_SecondName

Stu_Surname

Stu_Address01

Stu_Address02

Stu_PostTown

Stu_PostCode

Stu_County

Stu_TelephoneNo

Stu_MobileNo

Stu_Email

Stu_EmrgContact

Stu_EmergTelNo

PS_PersonalStatementID

PS_Statement

PS_StatementDate

PS_Reviewed

PS_Approved

PT_PersonalTutorID

PT_Title

PT_FirstName

PT_Surname

UNI_UniversityID

UNI_UniversityName

UNI_Address01

UNI_Address02

UNI_Address03

UNI_PostTown

UNI_PostCode

UNI_County

UNI_TelephoneNo

UNI_FaxNo

UNI_Email

Courses_CoursesID

Courses_CourseName

Courses_Description

Courses_UCASPoints

Dealines_DeadLineID

Deadlines_Date

Deadlines_Description

ApplicationID

ApplicationDetails

ApplicationNotes

ApplicationDate

StudentID

Stu_FirstName

Stu_SecondName

Stu_Surname

Stu_Address01

Stu_Address02

Stu_PostTown

Stu_PostCode

Stu_County

Stu_TelephoneNo

Stu_tMobileNo

Stu_Email

Stu_EmrgContact

Stu_EmergTelNo

PS_PersonalStatementID

PS_Statement

PS_StatementDate

PS_Reviewed

PS_Approved

PT_PersonalTutorID

PT_Title

PT_FirstName

PT_Surname

UNI_UniversityID

UNI_UniversityName

UNI_Address01

UNI_Address02

UNI_Address03

UNI_PostTown

UNI_PostCode

UNI_County

UNI_TelephoneNo

UNI_Fax

UNI_Email

Courses_CoursesID

Courses_CourseName

Courses_Description

Courses_UCASPoints

Dealines_DeadLineID

Deadlines_Date

Deadlines_Description

 

1NF involves removing duplicate fields and ensuring that all fields are “simple” (atomic) fields, as there were no duplicate fields all I needed to do was expand names and addresses

2NF involves recognising sub-tables within the data which have partial dependencies. These have been converted into the table structure above.

3NF finds any transitive dependencies and treats these as separate tables also, as there were no such dependencies in this data 2NF and 3NF are the same

 


Data Dictionary

tbl_Students

Table Name

tbl_Student

Description

Table for storing and retrieving all details relating to the student

Properties

The database will be available via the local PC

End user rights

User has access to add, edit, delete and print records

 

Field Names

Description

Data Type

Data Size

Null/not null

Default values

Comments

Validation

Indices

Stu_Address01

Text field for storing the student address line 1 data

Text

35

Not null

 

 

 

 

Stu_Address02

Text field for storing the student address line 2 data

Text

35

Null

 

 

 

 

Stu_County

Text field for storing the student county data

Text

35

Not null

 

 

 

 

Stu_DateOfBirth

Date/Time field for storing the students date of birth

Date/Time

Long date

Not null

 

 

dd/mm/yyyy

 

Stu_Email

Hyperlink field for storing the students e-mail address

Hyperlink

 

null

 

 

 

 

Stu_EmgContact

Text field for storing the emergency contact name

Text

35

null

 

 

 

 

Stu_EmgTelNo

Text field for storing the emergency contact telephone number

Text

15

null

 

 

(99999) 1234567

 

Stu_FirstName

Text field for storing the students first name

Text

25

Not null

 

 

 

 

Stu_Gender

Text field for storing the students gender

Text

6

Not null

Male / Female

 

Lookup dropdown from a list of either Male or Female

 

Stu_MobileNo

Text field for storing the students mobile telephone number

Text

15

null

 

 

(99999) 1234567

 

Stu_PostCode

Text field for storing the students post code

Text

10

Not null

 

 

LL99 99LL

 

Stu_PostTown

Text field for storing the students post town

Text

35

Not null

 

 

 

 

Stu_SecondName

Text field for storing the students second name

Text

25

null

 

 

 

 

Stu_StudentID

Text field for storing the students ID

Text

10

Not null

 

Unique field to identify student record

 

Primary Key

Stu_Surname

Text field for storing the students surname

Text

25

Not null

 

 

 

 

Stu_TelephoneNo

Text field for storing the students telephone number

Text

15

Null

 

 

(99999) 1234567

 

 


Tbl_Applications

Table Name

tbl_Applications

Description

Table for storing all the details of applications made by students

Properties

The database will be available via the local PC

End user rights

User has access to add, edit, delete and print records

 

Field Names

Description

Data Type

Data Size

Null/not null

Default values

Comments

Validation

Indices

App_ApplicationDate

Date/Time field for storing the application date

Date/Time

 

Not null

 

 

dd/mm/yyyy

 

App_ApplicationID

Text field for storing the application ID

Text

10

Not Null

 

Unique field for identifying Applications

 

Primary Key

App_ApplicationNotes

Memo field for storing the application notes

Memo

 

Null

 

 

 

 

App_CourseID

Text field for storing the course ID

Text

10

Not null

 

 

Completed via a lookup table to courses table

Foreign Key

App_DeadlineID

Text field for storing the deadline ID

Text

10

Not null

 

 

Completed via lookup table to the Deadlines table

Foreign Key

App_Details

Memo field for storing the application details

Memo

 

Null

 

 

 

 

App_StudentID

Text field for storing the students ID number

Text

10

Not null

 

 

Completed via a lookup table to the Students table

Foreign Key

 


tbl_Courses

Table Name

tbl_Courses

Description

Table for storing all the information about Courses

Properties

The database will be available via the local PC

End user rights

User has access to add, edit, delete and print records

 

Field Names

Description

Data Type

Data Size

Null/not null

Default values

Comments

Validation

Indices

Course_ApplicationID

Text field for storing the application ID

Text

10

Not null

 

 

Completed via a lookup table to the Applications table

Foreign Key

Course_CourseID

Text field for storing the course ID

Text

10

Not null

 

Unique field for identifying the courses

 

Primary Key

Course_CourseName

Text field for storing the course name

Text

50

Not null

 

 

 

 

Course_DeadlineID

Text field for storing the deadline ID

Text

10

Not null

 

 

Completed via a lookup table to the Deadlines table

Foreign Key

Course_Description

Memo field for storing the description of the course

Memo

 

Null

 

 

 

 

Course_UCASPoints

Text field for storing the number of UCAS points awarded to a course

Text

15

Null

 

 

 

 

Course_UniversityID

Text field for storing the university ID

Text

10

Not null

 

 

Completed via a lookup table to the University table

Foreign Key

 


tbl_Deadlines

Table Name

tbl_Dealdlines

Description

Table for storing the various deadlines used in the applications process

Properties

The database will be available via the local PC

End user rights

User has access to add, edit, delete and print records

 

Field Names

Description

Data Type

Data Size

Null/not null

Default values

Comments

Validation

Indices

Deadline_DeadlineDate

Date/Time field for storing the deadline date

Date/Time

 

Not null

 

 

dd/mm/yyyy

 

Deadline_DeadlineID

Text field for storing the deadline ID

Text

10

Not null

 

Unique field for identifying Deadlines

 

 

Deadline_Description

Memo field for storing the description of the deadline

Memo

 

Null

 

 

 

 

 


tbl_PersonalTutor

Table Name

tbl_PersonalTutor

Description

Table for storing the details of the Personal Tutor

Properties

The database will be available via the local PC

End user rights

User has access to add, edit, delete and print records

 

Field Names

Description

Data Type

Data Size

Null/not null

Default values

Comments

Validation

Indices

PT_FirstName

Text field for storing the first name of the personal tutor

Text

25

Not null

 

 

 

 

PT_PersonalTutorID

Text field for storing the personal tutor ID

Text

10

Not null

 

Unique field for identifying the Personal Tutor

 

 

PT_Surname

Text field for storing the personal tutors surname

Text

25

Not null

 

 

 

 

PT_Title

Text field for storing the personal tutors title

Text

15

Not null

 

 

Lookup list of title: Miss, Ms, Mrs, Mr, Dr, Prof.

 

 

tbl_PersonalStatement

Table Name

tbl_PersonalStatement

Description

Table for storing the details of the students Personal Statements

Properties

The database will be available via the local PC

End user rights

User has access to add, edit, delete and print records

 

Field Names

Description

Data Type

Data Size

Null/not null

Default values

Comments

Validation

Indices

PS_Approved

Yes/No field for storing the status of the approved variable

Yes/No

 

Null

 

 

Check box to indicate Yes or No

 

PS_PersonalStatementID

Text field for storing the personal statement ID

Text

10

Not null

 

A unique field for identifying students Personal Statement

 

Primary Key

PS_Reviwed

Yes/No field for storing the status of the reviewed variable

Yes/No

 

Null

 

 

Check box to indicate Yes or No

 

PS_SatementDate

Date/Time field for storing the personal statement date

Date/Time

 

Not null

 

 

dd/mm/yyyy

 

PS_Statement

OLE field for storing the personal statement

OLE

 

Not null

 

An embedded word document for the personal statement

 

 

PS_StudentID

Text field for storing the students ID

Text

10

Not null

 

 

Completed via a lookup table to the Students table

Foreign Key

 


tbl_Universities

Table Name

tbl_Universities

Description

Table for storing the details of the Universities involved in the UCAS application system

Properties

The database will be available via the local PC

End user rights

User has access to add, edit, delete and print records

 

Field Names

Description

Data Type

Data Size

Null/not null

Default values

Comments

Validation

Indices

UNI_Address01

Text field for storing the university address line 1

Text

35

Not null

 

 

 

 

UNI_Address02

Text field for storing the university address line 2

Text

35

null

 

 

 

 

UNI_Address03

Text field for storing the university address line 3

Text

35

null

 

 

 

 

UNI_ApplicationID

Text field for storing the application ID

Text

10

Not null

 

 

Completed via a lookup table to the Applications table

Foreign Key

UNI_County

Text field for storing the university county

Text

35

Not null

 

 

 

 

UNI_Email

Hypertext field for storing the university email

Hypertext

 

 

 

 

 

 

UNI_FaxNo

Text field for storing the university fax number

Text

15

null

 

 

(99999) 1234567

 

UNI_PostCode

Text field for storing the university post code

text

10

Not null

 

 

LL99 99LL

 

UNI_PostTown

Text field for storing the university post town

Text

35

Not null

 

 

 

 

UNI_TelephoneNo

Text field for storing the university telephone number

Text

15

Not null

 

 

(99999) 1234567

 

UNI_UniversityID

Text field for storing the university ID

Text

10

Not null

 

 

Unique field for identifying the University

Primary Key

UNI_UniversityName

Text field for storing the university name

Text

50

Not null

 

 

 

 

 

Entity Relationship Diagram

 

 


GUI Designs

Menu Skeleton Outline

 

Screen shots and Design Notes

Logon Screen

Rectangular Callout: A5Rectangular Callout: A6Rectangular Callout: A7Rectangular Callout: A4Rectangular Callout: A3Rectangular Callout: A2Rectangular Callout: A1


Logon Screen Design Notes

Control

Name

Events / Actions

Fonts

Font Size

Colour

Background

Explanation

A1 Label

Heading

None

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A large font that is high contrast

A2 Label

Enter UserName

None

Trebuchet MS, Bold

24pt

R31, G71, B125

None

A large font that is high contrast

A3 Label

Enter Password

None

Trebuchet MS, Bold

24pt

R31, G71, B125

None

A large font that is high contrast

A4 Button

OK

Process the logon procedure

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A high contrast large button

A5 Background

Background

None

None

None

None

R150, G175, B207

A high contrast background

A6 Text Field

txtUserName

Field for entering the user name

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A high contrast field for entering the User Name

A7 Text Field

txtPassword

Field for entering the Password

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A high contrast field for entering the Password

A8 Button

Cancel

Cancels the logon procedure

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A high contrast large button

 


Main Menu

Rectangular Callout: B11Rectangular Callout: B5Rectangular Callout: B4Rectangular Callout: B3Rectangular Callout: B2Rectangular Callout: B1Rectangular Callout: B10Rectangular Callout: B9Rectangular Callout: B8Rectangular Callout: B7Rectangular Callout: B6

Main Menu Design Notes

Control

Name

Events / Actions

Fonts

Font Size

Colour

Background

Explanation

B1 Label

Heading

None

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A large font that is high contrast

B2 Button

Student Details

Load the Student Details form

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

A high contrast large button

B3 Button

Personal Tutor Details

Load the Personal Tutor details form

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

A high contrast large button

B4 Button

Application Details

Load the Application details form

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

A high contrast large button

B5 Button

Course Details

Load the Course details form

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

A high contrast large button

B6 Background

Background

None

None

None

None

R150, G175, B207

A high contrast background

B7 Button

University Details

Load the University details form

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

A high contrast large button

B8 Button

Deadline Details

Load the Deadline Details form

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

A high contrast large button

B9 Button

Reports

Load the Reports form

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

A high contrast large button

B10 Graphic

School Logo

None

None

None

None

None

The Schools logo

B11 Button

Quit

Exit the system

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

A high contrast large button

 


Student Details & Personal Application Screen

Rectangular Callout: C7Rectangular Callout: C6Rectangular Callout: C5Rectangular Callout: C4Rectangular Callout: C1Rectangular Callout: C2

Student Details & Personal Application Screen Design Notes

Control

Name

Events / Actions

Fonts

Font Size

Colour

Background

Explanation

C1 Label

Heading

None

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A large font that is high contrast

C2 Labels

Various text labels

None

Trebuchet MS, Bold

12pt

R31, G71, B125

None

A high contrast Label set

C3 Navigation

Navigation Buttons

Navigate through the record set

None

None

None

R31, G71, B125

Iconographic button set for navigating through the record set

C4 Button

Personal Statement

Load the Personal Statements form

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

A high contrast large button

C5 Background

Background

None

None

None

None

R150, G175, B207

A high contrast background

C6 Text Fields

Various Text Fields

Fields for the entry and review of data

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Various text fields for the entry and review of data

C7 Graphic

School Logo

None

None

None

None

None

The Schools logo

 


Personal Tutor Details Screen

Rectangular Callout: D11Rectangular Callout: D10Rectangular Callout: D9Rectangular Callout: D8Rectangular Callout: D7Rectangular Callout: D12Rectangular Callout: D6Rectangular Callout: D5Rectangular Callout: D4Rectangular Callout: D3Rectangular Callout: D2Rectangular Callout: D1

Personal Tutor Details Screen Design Notes

Control

Name

Events / Actions

Fonts

Font Size

Colour

Background

Explanation

D1 Label

Heading

None

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A large font that is high contrast

D2 Label

Personal Tutor ID

None

Trebuchet MS, Bold

12pt

R31, G71, B125

None

A high contrast Label set

D3 Label

Title

None

Trebuchet MS, Bold

12pt

R31, G71, B125

None

A high contrast Label set

D4 Label

First Name

None

Trebuchet MS, Bold

12pt

R31, G71, B125

None

A high contrast Label set

D5 Label

Surname

None

Trebuchet MS, Bold

12pt

R31, G71, B125

None

A high contrast Label set

D6 Navigation

Navigation Buttons

Navigate through the record set

None

None

None

R31, G71, B125

Iconographic button set for navigating through the record set

D7 Background

Background

None

None

None

None

R150, G175, B207

A high contrast background

D8 Text Field

Personal Tutor ID

Field for the entry and review of Personal Tutor ID

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Text field for the entry and review of Personal Tutor ID data

D9 Dropdown Field

txtTitle

Dropdown field for the entry and review of Title data

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Dropdown field for the entry and review of Title data

D10 Text Field

txtFirstName

Text field for the entry and review of First Name data

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Text field for the entry and review of First Name data

D11 Text Field

txtSurname

Text field for the entry and review of Surname data

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Text field for the entry and review of Surname data

D12 Graphic

School Logo

None

None

None

None

None

The Schools logo

 


Application’s Details Screen

Rectangular Callout: E8Rectangular Callout: E7Rectangular Callout: E6Rectangular Callout: E5Rectangular Callout: E4Rectangular Callout: E3Rectangular Callout: E2Rectangular Callout: E1

Application’s Screen Design Notes

Control

Name

Events / Actions

Fonts

Font Size

Colour

Background

Explanation

E1 Label

Heading

None

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A large font that is high contrast

E2 Labels

Various Labels

None

Trebuchet MS, Bold

12pt

R31, G71, B125

None

A high contrast Label set

E3 Navigation

Navigation Buttons

Navigate through the record set

None

None

None

R31, G71, B125

Iconographic button set for navigating through the record set

E4 Background

Background

None

None

None

None

R150, G175, B207

A high contrast background

E5 Text Fields

Various text fields

Text field for the entry and review of data

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Text field for the entry and review of data

E6 Dropdown Fields

Various dropdown fields

Dropdown fields for the entry and review of data

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Dropdown fields for the entry and review of data

E7 Memo Field

txtApplicationDetails

Memo field for the entry and review of Application details data

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Memo field for the entry and review of Application details data

D8 Graphic

School Logo

None

None

None

None

None

The Schools logo

Course Details Screen

Rectangular Callout: F7Rectangular Callout: F6Rectangular Callout: F5Rectangular Callout: F4Rectangular Callout: F2Rectangular Callout: F1Rectangular Callout: F3

Course Details Design Notes

Control

Name

Events / Actions

Fonts

Font Size

Colour

Background

Explanation

F1 Label

Heading

None

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A large font that is high contrast

F2 Labels

Various Labels

None

Trebuchet MS, Bold

12pt

R31, G71, B125

None

A high contrast Label set

F3 Navigation

Navigation Buttons

Navigate through the record set

None

None

None

R31, G71, B125

Iconographic button set for navigating through the record set

F4 Background

Background

None

None

None

None

R150, G175, B207

A high contrast background

F5 Text Fields

Various text fields

Text field for the entry and review of data

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Text field for the entry and review of data

F6 Dropdown Fields

Various dropdown fields

Dropdown fields for the entry and review of data

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Dropdown fields for the entry and review of data

F7 Graphic

School Logo

None

None

None

None

None

The Schools logo

 


University Details Screen

Rectangular Callout: G6Rectangular Callout: G5Rectangular Callout: G4Rectangular Callout: G1Rectangular Callout: G1Rectangular Callout: G3

University Details Screen Design Notes

Control

Name

Events / Actions

Fonts

Font Size

Colour

Background

Explanation

G1 Label

Heading

None

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A large font that is high contrast

G2 Labels

Various Labels

None

Trebuchet MS, Bold

12pt

R31, G71, B125

None

A high contrast Label set

G3 Navigation

Navigation Buttons

Navigate through the record set

None

None

None

R31, G71, B125

Iconographic button set for navigating through the record set

G4 Background

Background

None

None

None

None

R150, G175, B207

A high contrast background

G5 Text Fields

Various text fields

Text field for the entry and review of data

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Text field for the entry and review of data

G6 Graphic

School Logo

None

None

None

None

None

The Schools logo

 


Deadline Details Screen

Rectangular Callout: H7Rectangular Callout: H6Rectangular Callout: H5Rectangular Callout: H4Rectangular Callout: H3Rectangular Callout: H2Rectangular Callout: H1

Deadlines Details Screen Design Notes

Control

Name

Events / Actions

Fonts

Font Size

Colour

Background

Explanation

H1 Label

Heading

None

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A large font that is high contrast

H2 Labels

Various Labels

None

Trebuchet MS, Bold

12pt

R31, G71, B125

None

A high contrast Label set

H3 Navigation

Navigation Buttons

Navigate through the record set

None

None

None

R31, G71, B125

Iconographic button set for navigating through the record set

H4 Background

Background

None

None

None

None

R150, G175, B207

A high contrast background

H5 Text Fields

Various text fields

Text field for the entry and review of data

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Text field for the entry and review of data

H6 Memo Field

txtDeadlineDetails

Memo field for entry and review of deadline details

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Memo field for entry and review of deadline details

H7 Graphic

School Logo

None

None

None

None

None

The Schools logo

 


Personal Statements Screen

Rectangular Callout: I8Rectangular Callout: I7Rectangular Callout: I6Rectangular Callout: I5Rectangular Callout: I4Rectangular Callout: I3Rectangular Callout: I2Rectangular Callout: I1

Personal Statement Screen Design Notes

Control

Name

Events / Actions

Fonts

Font Size

Colour

Background

Explanation

I1 Label

Heading

None

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A large font that is high contrast

I2 Labels

Various Labels

None

Trebuchet MS, Bold

12pt

R31, G71, B125

None

A high contrast Label set

I3 Navigation

Navigation Buttons

Navigate through the record set

None

None

None

R31, G71, B125

Iconographic button set for navigating through the record set

I4 Background

Background

None

None

None

None

R150, G175, B207

A high contrast background

I5 Text Fields

Various text fields

Text field for the entry and review of data

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Text field for the entry and review of data

I6 Chechbox

Various Checkboxes

Checkboxes for the entry and review of data

None

None

None

R75, G172, B198

Checkboxes for the entry and review of data

I7 Memo Field

txtDeadlineDetails

Memo field for entry and review of deadline details

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

Memo field for entry and review of deadline details

I8 Graphic

School Logo

None

None

None

None

None

The Schools logo

 


Reports Screen

Rectangular Callout: J5Rectangular Callout: J4Rectangular Callout: J1Rectangular Callout: J2Rectangular Callout: J3

Reports Screen Design Notes

Control

Name

Events / Actions

Fonts

Font Size

Colour

Background

Explanation

J1 Label

Heading

None

Trebuchet MS, Bold

24pt

R31, G71, B125

R75, G172, B198

A large font that is high contrast

J2 Buttons

Various buttons

Invoke the various reports

Trebuchet MS, Bold

12pt

R31, G71, B125

R75, G172, B198

A high contrast Button set

J3 Navigation

Navigation Buttons

Navigate through the record set

None

None

None

R31, G71, B125

Iconographic button set for navigating through the record set

J4 Background

Background

None

None

None

None

R150, G175, B207

A high contrast background

J5 Graphic

School Logo

None

None

None

None

None

The Schools logo