Tender

Conversion of MS Access database to SQL

PUBLIC HEALTH ENGLAND

This public procurement record has 1 release in its history.

Tender

16 Feb 2017 at 11:27

Tender Notice
Summary of the contracting process

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.

Find more tenders on our Open Data Platform.
How relevant is this notice?

D3 Tenders Premium

Win More Public Sector Contracts

AI-powered tender discovery, pipeline management, and market intelligence — everything you need to grow your public sector business.

Start Free Trial Book a Demo
All Features Pricing

Notice Information

Notice Title

Conversion of MS Access database to SQL

Notice 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.

Notice Details

Publication & Lifecycle

Open Contracting ID
ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791
Publication Source
Contracts Finder
Latest Notice
https://www.contractsfinder.service.gov.uk/Notice/7e075269-a488-480a-b62a-9c49748d4df1
Current Stage
Tender
All Stages
Tender

Procurement Classification

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

Common Procurement Vocabulary (CPV)

CPV Divisions

72 - IT services: consulting, software development, Internet and support

CPV Codes

72320000 - Database services

Notice Value(s)

Tender Value
£60,000 Under £100K
Lots Value
Not specified
Awards Value
Not specified
Contracts Value
Not specified

Notice Dates

Publication Date
16 Feb 20179 years ago
Submission Deadline
23 Feb 2017Expired
Future Notice Date
Not specified
Award Date
Not specified
Contract Period
30 Mar 2017 - 31 Oct 2017 6-12 months
Recurrence
Not specified

Notice Status

Tender Status
Active
Lots Status
Not Specified
Awards Status
Not Specified
Contracts Status
Not Specified

Buyer & Supplier

Contracting Authority (Buyer)

Main Buyer
PUBLIC HEALTH ENGLAND
Contact Name
Available with D3 Tenders Premium →
Contact Email
Available with D3 Tenders Premium →
Contact Phone
Available with D3 Tenders Premium →

Buyer Location

Locality
LONDON
Postcode
NW9 5EQ
Post Town
North West London
Country
England
Major Region (ITL 1)
TLI London
Basic Region (ITL 2)
TLI7 Outer London - West and North West
Small Region (ITL 3)
TLI71 Barnet
Delivery Location
Not specified
Local Authority
Barnet
Electoral Ward
Colindale South
Westminster Constituency
Hendon

Further Information

Notice Documents

Open Contracting Data Standard (OCDS)

View full OCDS Record for this contracting process

Download

The Open Contracting Data Standard (OCDS) is a framework designed to increase transparency and access to public procurement data in the public sector. It is widely used by governments and organisations worldwide to report on procurement processes and contracts. 

{
    "tag": [
        "compiled"
    ],
    "id": "ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791-2017-02-16T11:27:42Z",
    "date": "2017-02-16T11:27:42Z",
    "ocid": "ocds-b5fd17-4a6a6b35-e17d-43ed-9792-544d17821791",
    "language": "en",
    "initiationType": "tender",
    "tender": {
        "id": "Project 2386",
        "title": "Conversion of MS Access database to SQL",
        "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.",
        "datePublished": "2017-02-16T11:27:42Z",
        "status": "active",
        "classification": {
            "scheme": "CPV",
            "id": "72320000",
            "description": "Database services"
        },
        "items": [
            {
                "id": "1",
                "deliveryAddresses": [
                    {
                        "countryName": "British Oversea Territories"
                    },
                    {
                        "countryName": "Channel Islands"
                    },
                    {
                        "countryName": "Europe"
                    },
                    {
                        "countryName": "Isle of Man"
                    },
                    {
                        "countryName": "Rest of the World"
                    },
                    {
                        "countryName": "United Kingdom"
                    }
                ]
            }
        ],
        "value": {
            "amount": 60000,
            "currency": "GBP"
        },
        "procurementMethod": "open",
        "procurementMethodDetails": "Open procedure",
        "tenderPeriod": {
            "endDate": "2017-02-23T23:59:59Z"
        },
        "contractPeriod": {
            "startDate": "2017-03-31T00:00:00+01:00",
            "endDate": "2017-10-31T23:59:59Z"
        },
        "suitability": {
            "sme": true,
            "vcse": false
        },
        "mainProcurementCategory": "services",
        "documents": [
            {
                "id": "1",
                "documentType": "tenderNotice",
                "description": "Opportunity notice on Contracts Finder",
                "url": "https://www.contractsfinder.service.gov.uk/Notice/7e075269-a488-480a-b62a-9c49748d4df1",
                "datePublished": "2017-02-16T11:27:42Z",
                "format": "text/html",
                "language": "en"
            },
            {
                "id": "2",
                "documentType": "tenderNotice",
                "description": "Representation of current database input form",
                "url": "https://www.contractsfinder.service.gov.uk/Notice/Attachment/858a2a96-e78a-42bf-ae53-3cf5e2ed9753",
                "format": "image/jpeg"
            }
        ]
    },
    "parties": [
        {
            "id": "GB-GOR-EA480",
            "name": "Public Health England",
            "identifier": {
                "legalName": "Public Health England",
                "scheme": "GB-GOR",
                "id": "EA480"
            },
            "address": {
                "streetAddress": "61 Colindale Avenue",
                "locality": "London",
                "postalCode": "NW9 5EQ",
                "countryName": "England"
            },
            "contactPoint": {
                "email": "tenders@phe.gov.uk"
            },
            "roles": [
                "buyer"
            ]
        }
    ],
    "buyer": {
        "id": "GB-GOR-EA480",
        "name": "Public Health England"
    }
}