Build a Microsoft Access file out of a given Excel file
- Status: Closed
- Prize: $33
- Entries Received: 11
- Winner: professional800
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.
“Nice professional! I enjoyed the experience of hiring him.”