Build a Microsoft Access file out of a given Excel file

  • Status: Closed
  • Hadiah: $33
  • Penyertaan diterima: 11
  • Pemenang: professional800

Ringkasan Peraduan

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.

Kemahiran Disyorkan

Maklum balas Majikan

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

Gambar Profil gb331984gb331984, Greece.

Penyertaan teratas dari peraduan ini

Lihat Lagi Entri

Papan Penjelasan Umum

  • imfarrukh47
    imfarrukh47
    • 1 bulan yang lalu

    please explain the 2nd requirement (queries)

    • 1 bulan yang lalu

Bagaimana mula dengan peraduan

  • Paparkan peraduan anda

    Paparkan Peraduan Anda Cepat dan mudah

  • Dapatkan berjuta penyertaan

    Dapatkan Bertan-tan Penyertaan Dari serata dunia

  • Anugerahkan penyertaan terbaik

    Anugerahkan penyertaan terbaik Muat turun fail-fail - Mudah!

Paparkan Peraduan Sekarang atau Sertai kami Hari Ini!