Build a Microsoft Access file out of a given Excel file

Contest Brief

The attached table contains a series of manholes, where each one has a particular code (ID). Each manhole requires several checks (denoted as ‘features’, subjected to sequential numbering) during their construction process and commissioning.
The manholes are connected to each other with road segments that are also subject to other checks. There is a given Microsoft Excel table in the attached file that contains the aforementioned data.
Each column corresponds to the checks apart from the first one that relates to the road name. Each row contains either the manhole code, or the road segments between two manholes (intermediate rows). The project requires creating a Microsoft Access file, out of the given Microsoft Excel file. This will be done by importing the aforementioned tables.
There is also a requirement to create specific queries, related to which checks have been conducted either for each road segment or for each manhole.
The manhole ID and the intermediate road segment between the manholes should be used as keys for conducting the queries, and will have to be presented as Microsoft Access forms.

Recommended Skills

Employer Feedback

“Nice professional! I enjoyed the experience of hiring him.”

Profile image gb331984gb331984, Greece.

Top entries from this contest

View More Entries

Public Clarification Board

  • imfarrukh47
    imfarrukh47
    • 1 month ago

    please explain the 2nd requirement (queries)

    • 1 month ago

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!