View original (French)

Access: Maintenance Contract Management

Solved
Zbrush Posted messages 33 Status Member -  
 castours -
Hello,
I am a beginner in database creation and if anyone could help me please.
I would like to create a database to manage maintenance contracts that are currently in a multitude of Excel files.

I have created my tables, queries, and relationships, but I would like to check with you if my database is good and especially how to display the history of interventions by selecting the year.

I remain available and thank you in advance.

Database: https://www.cjoint.com/c/HJrj0Tacbah

Configuration: Windows / Chrome 69.0.3497.100

10 answers

  1. castours
     
    Bonjour
    The modified database
    Give an answer
    Thank you
    2
    1. Zbrush Posted messages 33 Status Member 2
       
      Hi Castours,
      Thank you for your help and the time spent on this, the base seems pretty good to me
      Good luck going forward
      0
  2. yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   Ambassadeur 1 588
     
    Hello, it's difficult to check if your database is good if you don't explain what you want to store in it and what you'll do with it. However, I suggest storing the year as a number rather than as text.
    If you display the interventions, you can then filter by year.
    1
  3. Zbrush
     
    Hello yg_be, first of all, thank you for your response.
    Now I'm open to any suggestions that could improve my database, so if you tell me that it's better to enter the year as a number, that's absolutely fine with me. I must have certainly forgotten to set it as amber when creating the tables, and my goal is to manage all maintenance contracts in a single database rather than having a collection of Excel spreadsheets. This way, everyone can check the ongoing contracts, interventions, and the associated dates.
    It would also be great to have the number of interventions per year so we can see whether they have been carried out or not.
    Thank you in advance for your help.
    1
  4. castours
     
    Hello
    I've looked at your database.
    Here is my solution: one contract, one provider, multiple interventions.
    On one contract, one provider, and several interventions.
    That's what you want.
    1
    1. Zbrush
       
      Hello beavers,
      Yes, that's right.
      Thank you for your help.
      0
    2. Zbrush Posted messages 33 Status Member 2
       
      Re Castours,
      A question please and I promise I won’t bother you anymore.
      I just revamped my database to something simpler and my question is as follows:
      Is it possible to make it so that when I change pages on my service provider form, it also changes pages in my historical sub-form?

      https://www.cjoint.com/c/HJso2zbXV5h

      Thanks a thousand!
      0
  6. castours
     
    Hello
    if you want, I can create a search form for you taking into account the provider, the year, and the month.
    if that's of interest to you
    1
    1. Zbrush Posted messages 33 Status Member 2
       
      Honestly, I’m open to it, Castours. I copied what you did and I'm trying to create an easier-to-use form for my colleagues, but if you can suggest something better, I won't say no.
      In any case, thank you for all the time you’re dedicating to me.
      0
    2. Zbrush Posted messages 33 Status Member 2
       
      STP Castours, can you tell me if the relationships between my tables are good or not?
      0
  7. castours
     
    Hello
    you're not bothering me.
    As for your question, the tables are related. If you delete a provider, for example, all the records linked to them will be deleted.
    1
  8. castours
     
    Hello
    compress your file before putting it in a link
    1
    1. Zbrush
       
      OK, I'll send it to you tomorrow morning if that's fine.
      0
  9. castours
     
    ok for tomorrow
    1
    1. Zbrush Posted messages 33 Status Member 2
       
      Hello Castours,
      Here is the compressed file: https://www.cjoint.com/c/HJtgxGRheFh
      Thank you for your help.
      0
  10. castours
     

    Hello
    I have the relationships, a form and a subform.
    You can remove datedebut and datefin from the provider.
    You have the same thing in the history.
    Keep me updated.
    0
    1. Zbrush Posted messages 33 Status Member 2
       
      Hello castours,
      I just looked at it and it’s not bad, I will continue along this line
      Thank you so much for your help.
      See you soon
      0
    2. Zbrush Posted messages 33 Status Member 2
       
      Re Castours,
      I wanted to thank you for the help you provided, my database is starting to look like something and will soon be operational for my colleagues.
      You're the BOSS.
      Thanks again and good luck.
      0
  11. castours
     
    Hello
    I'm glad to have contributed to this development.

    If you need help, I will try to assist you based on my knowledge.
    0