Build a Microsoft Access file out of a given Excel file
- Status: Closed
- Prize: $33
- Entries Received: 11
- Winner: professional800
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.”
gb331984gb331984, Greece.
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!