Access: Maintenance Contract Management
Solved
Zbrush
Posted messages
33
Status
Membre
-
castours -
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
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 réponses
yg_be
Posted messages
23437
Registration date
Status
Contributeur
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.
If you display the interventions, you can then filter by year.
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.
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.
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.
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.
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!
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!
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
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
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.
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.
Thank you for your help and the time spent on this, the base seems pretty good to me
Good luck going forward