Conversion of MS Access database to SQL
key details
| Value | £60,000 |
|---|---|
| Status | active |
| Category (CPV) | 72320000 |
| Deadline | 23 Feb 2017 |
| Contract start | 31 Mar 2017 |
| Contract end | 31 Oct 2017 |
| Procedure | open |
| SME suitable | Yes |
| OCID | ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791 |
description
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.
documents
- https://www.contractsfinder.service.gov.uk/Notice/7e075269-a488-480a-b62a-9c49748d4df1 , tenderNotice
- https://www.contractsfinder.service.gov.uk/Notice/Attachment/858a2a96-e78a-42bf-ae53-3cf5e2ed9753 , tenderNotice
Documents are linked, not mirrored. They are served by the publishing authority and may require registration.
notice history
1 notice published against this procurement.
| Published | Type | Regime | Notice |
|---|---|---|---|
| 16 Feb 2017 | Tender (tender) | · | 7e075269-a488-480a-b62a-9c49748d4df1-130684 |
more from Public Health England
- PHE - Marketing Evaluation Partner · £60,000 · 29 Oct 2021
- PHE - Corporate - Marketing Contact Centre Services · £35,000,000 · 21 Jan 2021
- PHE - Corporate - Strategic Evaluation Services · £200,000 · 21 Jan 2021
- SoftMax Pro Upgrade · £25,000 · 21 Feb 2018
- Business Resilience and Support Services during Transformation: Soft Market Test · 17 Jan 2018
- Personal Relocation Services and Outplacement and Addtional Services: Soft Market Test · 17 Jan 2018
- MOLIS Labaratory Information Management SystemUpgrade · 13 Dec 2017
- PHE - Corporate -Plant Room Door Replacement and Duct Work Removal · £10,000 · 5 Dec 2017
all contracts from this buyer →
similar contracts awarded
Other awarded contracts in the same category. Useful for seeing who normally wins this kind of work, and at what value.
- Media Monitoring and Press Release distribution platform · HEALTH DATA RESEARCH UK · £75,000
- P26-0046 Scottish Enterprise Research Databases · Scottish Enterprise · £2,039,913
- Award of Elsevier Read and Publish 2026-2028 (JISC) · University of Strathclyde
- Award of Springer Nature Read and Publish 2026-2028 (JISC) · University of Strathclyde
- Clinical Registry Services for Cystic Fibrosis · NHS England · £131,794
- Provision of Cystic Fibrosis Registry · NHS England
- CBC-1864-Q-SM DVLA's KADOE Access - AWARD · Central Bedfordshire Council
- TEN-2526-005 Macroeconomic and Markets Database Provider · National Employment Savings Trust (NEST) Corporation
source
Published on Contracts Finder. Contact details for named individuals are not reproduced on this site.