--- title: "Conversion of MS Access database to SQL" ocid: "ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791" canonical_url: "https://d3tenders.com/contract/?ocid=ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791" markdown_url: "https://d3tenders.com/contract/ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791.md" json_url: "https://d3tenders.com/contract/ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791.json" source: "Contracts Finder" current_stage: "Tender" buyer: "PUBLIC HEALTH ENGLAND" published: "2017-02-16" --- # Conversion of MS Access database to SQL Buyer: PUBLIC HEALTH ENGLAND Current stage: Tender OCID: ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791 [View canonical contract page](https://d3tenders.com/contract/?ocid=ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791) [Download OCDS JSON](https://d3tenders.com/contract/ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791.json) ## Summary Public Health England (PHE) is currently undertaking a tender process for the conversion of an existing MS Access database to an SQL database, which is expected to improve data management and reporting capabilities. The project is classified under database services (CPV 72320000) with a budget of £60,000. Interested suppliers must submit their expressions of interest by 23rd February 2017, at which point PHE will consider up to 30 responses to progress to the formal tender phase. The contract is slated to begin on 31st March 2017 and conclude by 31st October 2017, with delivery addresses spanning the UK and beyond, including British Overseas Territories and Europe. This tender presents significant opportunities for businesses specialising in database services, particularly those experienced in MS Access and SQL. Small and medium-sized enterprises (SMEs) are suited to compete given the nature of the project, which requires expertise in database conversion, quality assurance, and user interface design. The successful contractor will not only upgrade PHE's data system but also contribute to the creation of a more robust platform for handling large datasets, enhancing reporting and data interrogation processes for public health analysis. ## Notice Public Health England (PHE) is inviting expressions of interest from suppliers who want to be included in a tender for the conversion of an existing Access database into an SQL database with extended features and additional facilities. Potential suppliers will have experience of writing MS Access and SQL databases and the conversion of Access data to SQL. PHE expects a considerable response to this notice and may restrict the progression to next please to the first thirty (30) responses. Please include project_3286 in the subject of your email response. The suppliers that progress to the tender phase will receive an invitation via the BravoSolutions tendering portal and further information will be provided as part of the tender documentation. The current MS Access database acts as a repository for data received on Excel spreadsheets and have some inbuilt reports for routine analyses undertaken by the group. The data is currently received in monthly batches from 12 different sources. The spreadsheets are adapted and data cleaned before upload to the database. Further QA of the uploaded data is then undertaken within the database before a series of routine and bespoke reports are run on the data which is exported to Excel for formatting for presentation in PHE and other national publications. 1. Replace and upgrade an ageing Access database to a reliable platform 2. New database to include updated and new taxonomies for coding data 3. Allow validation of data contained within the excel files for upload against a set of rules by the department 4. Streamline existing reports and add new reports (queries) with addition of graphic representations of results 5. Allow multiple levels of users and allow the department to assign user privileges 6. Send automatic notification of concurrent use to users' 7. Allow users to create a secure user ID that allows internal users to securely access (browser based) system to view data and reports and provide an audit trail. 8. Allow the department to interrogate data held within the system on an ad hoc basis 9. Import and store legacy data from existing MS Access system The current database is in need of expansion with an increase in fields and options available from dropdown menus as well as the increase in documents held within the database. ## Key Details | Field | Value | | --- | --- | | Publication source | Contracts Finder | | Latest notice | https://www.contractsfinder.service.gov.uk/Notice/7e075269-a488-480a-b62a-9c49748d4df1 | | Notice type | Tender Notice | | Procurement type | Standard | | Procurement category | Services | | Procurement method | Open | | Procurement method details | Open procedure | | Tender suitability | SME | | Awardee scale | Not specified | | All stages | Tender | ## Dates | Field | Value | | --- | --- | | Publication date | 16 Feb 2017 | | Submission deadline | 23 Feb 2017 | | Future notice date | Not specified | | Award date | Not specified | | Contract period | 30 Mar 2017 - 31 Oct 2017 | | Recurrence | Not specified | ## Values | Field | Value | | --- | --- | | Tender value | £60,000 | | Lots value | Not specified | | Awards value | Not specified | | Contracts value | Not specified | ## Status | Field | Value | | --- | --- | | Tender status | Active | | Lots status | Not specified | | Awards status | Not specified | | Contracts status | Not specified | ## Buyer | Field | Value | | --- | --- | | Main buyer | PUBLIC HEALTH ENGLAND | | Locality | LONDON | | Post town | North West London | | Postcode | NW9 5EQ | | Country | England | | ITL 1 | TLI London | | ITL 2 | TLI7 Outer London - West and North West | | ITL 3 | TLI71 Barnet | | Local authority | Barnet | | Electoral ward | Colindale South | | Westminster constituency | Hendon | | Delivery location | Not specified | ## CPV Codes ### Divisions - 72 - IT services: consulting, software development, Internet and support ### Codes - 72320000 - Database services ## Release History - 16 Feb 2017 at 11:27 - Tender - Tender Notice - https://www.contractsfinder.service.gov.uk/Notice/7e075269-a488-480a-b62a-9c49748d4df1 ## Documents - https://www.contractsfinder.service.gov.uk/Notice/7e075269-a488-480a-b62a-9c49748d4df1 16th February 2017 - Opportunity notice on Contracts Finder - https://www.contractsfinder.service.gov.uk/Notice/Attachment/858a2a96-e78a-42bf-ae53-3cf5e2ed9753 Representation of current database input form ## Provenance This Markdown file is an alternate public rendering of the D3 Tenders contract record. The canonical page is https://d3tenders.com/contract/?ocid=ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791. The underlying structured data is available as OCDS JSON at https://d3tenders.com/contract/ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791.json.