1) Recruitment Webpage and 2) Online Database

(1) A database-enabled website that registers job candidates and saves their CV information according to the jobs that we post. We must be able to survey each candidate according to the requirements of the job (i.e. through an interactive form-like interface/ questionnaire, responses to which are recorded in the candidates' profile). The forms must be customizable for each job. As is conventional, each candidate who registers is to have a password-enabled user account. (2) A web-based database for managing/ administrating internal business activities (an administrative Intranet). Currently we use the free Google Spreadsheets for this purpose, but we need to interconnect/ relate our data for better/ quicker navigation, access, and analysis. We also want to upload PDFs/ images into fields within the database. Both of these features are not available in Google Spreadsheets. The intranet (2) mentioned above has additional features which are meant to improve productivity. >>>>Project Details: (1) A recruitment website • A job posting website • Ability to list jobs to which candidates with (or without) link can apply. • Accessible to specified users with unique views and privileges (eg. internal admin, external client, public candidate) • Clients can also launch customized requisitions (post jobs and job specifications) • We need to be able to create a custom form/ questionnaire for each job so that candidates can respond to the unique requirements of the job (multi-page survey that is recorded). • Candidates should be able to upload their CVs and photos (PDF, MS Word, txt, Jpeg, etc.) • We should be able to store their form inputs and CVs in a database. • Candidates should have a user account so they don't have to re-enter their info for every job. (2) An online database/ intranet for administrative purposes • Accessible to specified users/invitees with unique views and privileges (eg. internal admin, external clients). • Tables and query design of the database as per our business model • Batch PDF generator for printing various records, forms, and reports • Date/time stamp record of changes in data by user • Pop up info by mouse pointing • We need to add some automation features on this database; e.g. SMS & Email alerts, auto-generated formula-based calculations, etc. (i.e. some macro functionality that generates subtle outputs)