Build an Access Database for A/R

  • Status: Closed
  • Hadiah: $110
  • Penyertaan diterima: 3
  • Pemenang: blui88

Ringkasan Peraduan

I need someone to build an access database for accounts receivable. I have a raw file that needs to be delivered in different forms based on different requirements. Reach out with questions. Thanks!

Edit: updated excel file has been attached.

Kemahiran Disyorkan

Maklum balas Majikan

“Still waiting for the final file”

Gambar Profil Dkuka, Bermuda.

Penyertaan teratas dari peraduan ini

Lihat Lagi Entri

Papan Penjelasan Umum

  • atawde65
    atawde65
    • 8 bulan yang lalu

    Thanks for the updates data file. I have checked it and am able to create MS Access table to hold raw data and generate reports as per the tabs.

    • 8 bulan yang lalu
  • blui88
    blui88
    • 8 bulan yang lalu

    Hi there,
    Kindly share your thoughts about my efforts through entry # 15.
    Looking forward to hear more from you.
    Regards
    Santosh

    • 8 bulan yang lalu
  • imfarrukh47
    imfarrukh47
    • 8 bulan yang lalu

    in the aging classification row (on the summary tab) which dates are used?

    • 8 bulan yang lalu
    1. imfarrukh47
      imfarrukh47
      • 8 bulan yang lalu

      so meaning no data filter based on dates. just picking up a base on respective column data.
      dates shown below company name are just labels
      Am i right

      • 8 bulan yang lalu
    2. imfarrukh47
      imfarrukh47
      • 8 bulan yang lalu

      only filter is company name

      • 8 bulan yang lalu
  • imfarrukh47
    imfarrukh47
    • 8 bulan yang lalu

    What is Rc column (what is the source for this column) and will you add comments by yourself

    • 8 bulan yang lalu
    1. Dkuka
      Penganjur Peraduan
      • 8 bulan yang lalu

      RC can be empty, I can fix that. Comments can be manual

      • 8 bulan yang lalu
  • imfarrukh47
    imfarrukh47
    • 8 bulan yang lalu

    please review #14 Discussion required on summary report

    • 8 bulan yang lalu
  • bishalali101
    bishalali101
    • 8 bulan yang lalu

    Hello there!
    I have carefully gone through your job post and understood your requirements. I am offering you my quality service. You can check my profile & portfolio for details about my experiences. If you give me the opportunity, I’ll provide you quality service according to your instructions within your expected budget & estimated time. We can discuss it more over chat and also can show you my plans as well as previous work samples.I am waiting for your positive response. Thanks! Best Regards, Bishal Ali

    • 8 bulan yang lalu
  • MMG2019
    MMG2019
    • 8 bulan yang lalu

    hello,do you also want to design forms for raw tab and reports? or only import data from Excel file to Access database and get reports out of that?

    • 8 bulan yang lalu
    1. Dkuka
      Penganjur Peraduan
      • 8 bulan yang lalu

      design forms would be nice

      • 8 bulan yang lalu
  • imfarrukh47
    imfarrukh47
    • 8 bulan yang lalu

    how you get due date, there is no such date on raw data sheet

    • 8 bulan yang lalu
    1. Dkuka
      Penganjur Peraduan
      • 8 bulan yang lalu

      due date and settlement date is the same

      • 8 bulan yang lalu
  • imfarrukh47
    imfarrukh47
    • 8 bulan yang lalu

    1st) what are the criteria to filter related and unrelated data? note on both sheets is the same.
    2nd) How you will insert data in access (through excel import)?

    • 8 bulan yang lalu
    1. Dkuka
      Penganjur Peraduan
      • 8 bulan yang lalu

      to filter unrelated to related is the column "AG" in the raw data tab. if its "yes" that means its related, if its "no" that means is unrelated

      • 8 bulan yang lalu
  • wissalekouki
    wissalekouki
    • 8 bulan yang lalu

    the sheet "summary" is not really clear, what does represents the date "30/09/2019" ?

    • 8 bulan yang lalu
    1. Dkuka
      Penganjur Peraduan
      • 8 bulan yang lalu

      hi Wissal, feel free to change the 9.30.19 to current quarter. and 6.30.19 to prior quarter. when it comes out if database prior quarter should be empty

      • 8 bulan yang lalu
  • wissalekouki
    wissalekouki
    • 8 bulan yang lalu

    also, there is no company "A", "B" ... they are called company1 company 2 ...etc.

    • 8 bulan yang lalu
    1. asifhakim
      asifhakim
      • 8 bulan yang lalu

      give me chance to do this work, you will get great service from me.

      • 8 bulan yang lalu
    2. Dkuka
      Penganjur Peraduan
      • 8 bulan yang lalu

      Hi Wissal, they are the same, sorry for the naming convention

      • 8 bulan yang lalu
  • imfarrukh47
    imfarrukh47
    • 8 bulan yang lalu

    working on it donot close earlier

    • 8 bulan yang lalu
  • pradeevenkat
    pradeevenkat
    • 8 bulan yang lalu

    Hi there,
    I have few queries regarding the data .Could you please ping me in private chat to discuss further.
    Thanks,
    Pradeepa Venkataswamy

    • 8 bulan yang lalu
  • asifhakim
    asifhakim
    • 8 bulan yang lalu

    I am database expert person, having more then 10 year experience in software development.

    • 8 bulan yang lalu
  • bishalali101
    bishalali101
    • 8 bulan yang lalu

    Hello there!
    I have carefully gone through your job post and understood your requirements. I am offering you my quality service. You can check my profile & portfolio for details about my experiences. If you give me the opportunity, I’ll provide you quality service according to your instructions within your expected budget & estimated time. We can discuss it more over chat and also can show you my plans as well as previous work samples.I am waiting for your positive response. Thanks! Best Regards, Bishal Ali

    • 8 bulan yang lalu
  • subirbbiswas0
    subirbbiswas0
    • 8 bulan yang lalu

    Hi, 1. In the new file .. how do you differentiate between "related" and "unrelated" data from the raw data? 2. You said "Based on the different companies on the Raw Data tab, the classification will be separated in BA, MA, UK, SA".... can you please give an example of how the company information would look like in Raw Data tab?

    • 8 bulan yang lalu
    1. Dkuka
      Penganjur Peraduan
      • 8 bulan yang lalu

      the raw data tab is how the information looks. the rest of the tabs are the output that i want to get from access.

      • 8 bulan yang lalu
  • blui88
    blui88
    • 8 bulan yang lalu

    Hi,
    Attached file is corrupted.
    Kindly attach another copy.
    Thanks
    Santosh

    • 8 bulan yang lalu
    1. Dkuka
      Penganjur Peraduan
      • 8 bulan yang lalu

      Hi! Yes!

      • 8 bulan yang lalu
    2. blui88
      blui88
      • 8 bulan yang lalu

      Please open private chat window to response quickly, without disturbing to others.
      Thanks

      • 8 bulan yang lalu
  • mandarvvaidya
    mandarvvaidya
    • 8 bulan yang lalu

    I cannot open Data File.xlsx. Probably, Data File.xlsx is corrupt. Can you upload the file again?

    • 8 bulan yang lalu
    1. Dkuka
      Penganjur Peraduan
      • 8 bulan yang lalu

      updated file has been uploaded

      • 8 bulan yang lalu
  • Singh0786
    Singh0786
    • 8 bulan yang lalu

    Please upload attached file again.

    • 8 bulan yang lalu
    1. Dkuka
      Penganjur Peraduan
      • 8 bulan yang lalu

      updated file has been uploaded

      • 8 bulan yang lalu
  • impawan29
    impawan29
    • 8 bulan yang lalu

    Data file is corrupted.

    • 8 bulan yang lalu
    1. Dkuka
      Penganjur Peraduan
      • 8 bulan yang lalu

      updated file has been uploaded

      • 8 bulan yang lalu
  • champakbiswas097
    champakbiswas097
    • 8 bulan yang lalu

    can you come to my inbox ?

    • 8 bulan yang lalu

Tunjukkan lebih banyak komen

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!