Employers will be able to view a list of all current Apprentices and their individual exam results.
This information will be extracted from ASC_Backend.mdb and ROTC_Backend.mdb.

ASC_Backend Details:

• Fields to be extracted are – Surname, Given Name, Component, Test Score, Resit Score and Attendance
• Student names are stored in tbl_ASC_Students under Surname and Given Name.
• tbl_ASC_Students is linked to tbl_ASC_Contracts via the Student ID field, from there tbl_ASC_Contracts is linked to tbl_ASC_Employers via the Employer ID field, and linked to tbl_ASC_Results via the Contract ID field.
• tbl_ASC_Employers contains the Trading Name and Employer ID for each Employer, which will be used to identify the Employer logging into the website.
• Component is located in tbl_ASC_Components, which is linked to tbl_ASC_Results via the Component ID field
• Test Score, Resit Score and Attendance are all located in tbl_ASC_Results (please note: at this point in time the Results section of the ASC database has not been used, this table will need to be populated via a download from an existing ASC excel spreadsheet which will be completed by me)

The ROTC_Backend database is very similar in structure; all fields are located in the same tables (ie tbl_ROTC_Students, tbl_ROTC_Contracts, tbl_ROTC_Employers, tbl_ROTC_Results). The same fields will need to be extracted – the only difference being that the Module field needs to be extracted rather then the Component field. Module is located in tbl_ROTC_Modules and is linked to tbl_ROTC_Results via the Module ID field.

Employers will also have access to view Apprentice Timetables (stored as pdf’s on the system). Timetables will be specific to the Component/Module being completed by the Student and will be stored in the system under the relevant Component/Module name.