Hello,
I work for a the doctors' HR department in a hospital. This fall, we will have to review our systems and make a lot of changes. I was wondering if we should consider changing our database made in an Ecxel spreadsheet to Ms Access.
Ultimately, we would like to be able to keep data on retired members as well as current ones. I would like to have a field that fills with the current date when personnal information changes for a doctor. We need to be able to create letters with somekind of mailpost (like Ms Word) to selected members. These letters then need to be converted into PDF with password to protect the image of the signature on the lettre.
The database needs to be shared by a few people but can only be updated by one or 2 people. The fields listed in blue should only be viewed by me.
I would appreciate any input you may want to share me before I have to present this file to the decision makers.
Thank you so much for your help!
Chantal
Field Name Field size, description, limit list
<colgroup><col><col></colgroup><tbody>
</tbody>
I work for a the doctors' HR department in a hospital. This fall, we will have to review our systems and make a lot of changes. I was wondering if we should consider changing our database made in an Ecxel spreadsheet to Ms Access.
Ultimately, we would like to be able to keep data on retired members as well as current ones. I would like to have a field that fills with the current date when personnal information changes for a doctor. We need to be able to create letters with somekind of mailpost (like Ms Word) to selected members. These letters then need to be converted into PDF with password to protect the image of the signature on the lettre.
The database needs to be shared by a few people but can only be updated by one or 2 people. The fields listed in blue should only be viewed by me.
I would appreciate any input you may want to share me before I have to present this file to the decision makers.
Thank you so much for your help!
Chantal
Field Name Field size, description, limit list
| Permis | 2 digits-3 digits or 3 digits-3 digits |
| Titre | Dr or Dre or M. or Mme |
| Nom | Max 25 letters |
| Prénom | Max 25 letters |
| O/S | O or S |
| Type de permis | Régulier or Restrictif or Temporaire |
| Statut | Actif or Associé or Conseil or Honoraire or Actif à venir or Associé à venir or Actif temporaire or Associé temporaire |
| # Assurance | Max 9 digits |
| Date assurance | YYYY-MM-DD |
| Département1 | Max 72 letters - People can be part of 2 or 3 different departements, hense why we have a département 2 and a département 3 |
| Service1 | Max 45 letters - There are many services within each of the department. People can be part of more than one service from the same departement, hense why we have a service 2 and a service 3 |
| Département2 | Max 72 letters - People can be part of 2 or 3 different departements, hense why we have a département 2 and a département 3 |
| Service2 | Max 45 letters - There are many services within each of the department. People can be part of more than one service from the same departement, hense why we have a service 2 and a service 3 |
| Département2 | Max 72 letters - People can be part of 2 or 3 different departements, hense why we have a département 2 and a département 3 |
| Service2 | Max 45 letters - There are many services within each of the department. People can be part of more than one service from the same departement, hense why we have a service 2 and a service 3 |
| Autres | Here I created codes to represent de multiple departments in ordre to be able to select desired departments with more ease. The departments where membres could belong to another department at the same time were listed separately (AN, SI, ♥, PN) |
| AN | Here I created codes to represent de multiple departments in ordre to be able to select desired departments with more ease. The departments where membres could belong to another department at the same time were listed separately (AN, SI, ♥, PN) |
| SI | Here I created codes to represent de multiple departments in ordre to be able to select desired departments with more ease. The departments where membres could belong to another department at the same time were listed separately (AN, SI, ♥, PN) |
| ♥ | Here I created codes to represent de multiple departments in ordre to be able to select desired departments with more ease. The departments where membres could belong to another department at the same time were listed separately (AN, SI, ♥, PN) |
| PN | Here I created codes to represent de multiple departments in ordre to be able to select desired departments with more ease. The departments where membres could belong to another department at the same time were listed separately (AN, SI, ♥, PN) |
| Privilèges en … | Max 802 letters (memo field) |
| Engagement académique | Yes/No |
| Engagement règlements | Yes/No |
| Formation continue | Yes/No |
| Remarques formation continue, assurance, poste réseau | Memo field |
| Établissement Primaire | Max of 60 lettres - This could be coded and then the info would be looked up in antoher table |
| Adresse1-Primaire | Max of 60 lettres - This could belooked up in antoher table |
| Adresse2-Primaire | Max of 60 lettres - This could belooked up in antoher table |
| Adresse3-Primaire | Max of 60 lettres - This could belooked up in antoher table |
| Téléphone-Primaire | 3 digits "space" 3 digits "-" 4 digits - This could belooked up in antoher table |
| Poste-Primaire | 4 or 5 digits |
| Secrétaire-Primaire | Max of 60 lettres - This could belooked up in antoher table |
| Poste secrétaire-Primaire | Max of 60 lettres - This could belooked up in antoher table |
| Adresse1-Résidence | Max 60 lettres |
| Adresse2-Résidence | Max 60 lettres |
| Téléphone-Résidence | 3 digits "space" 3 digits "-" 4 digits |
| Cellulaire | 3 digits "space" 3 digits "-" 4 digits |
| Téléavertisseur | 3 digits "space" 3 digits "-" 4 digits |
| Courriel1 | Memo field |
| Courriel2 | Memo field |
| Spécialité MSSS | This could be from a list |
| Date de naissance | YYYY-MM-AA |
| Date d'entrée | YYYY-MM-AA |
| Date de nomination | YYYY-MM-AA |
| Date de renouvellement | YYYY-MM-AA |
| Date de démission / Non-renouvellement | YYYY-MM-AA |
| Endroit du PEM | Max of 60 lettres - This could be coded and then the info would be looked up in antoher table |
| Commentaires arrivée, départ, congé | Memo field |
| Cotisations payées par | Memo field - We need a new of this every year as dues are paid |
| MONTANT | $ - We need a new of this every year as dues are paid |
| Payé | Yes/No - We need a new of this every year as dues are paid |
| Titre chef Dpt | Dr or Dre or M. or Mme - If the member is part of more than 1 department, there sould be more than 1 of these - could be looked up in another table |
| Nom chef Dpt | Max 25 letters - If the member is part of more than 1 department, there sould be more than 1 of these - could be looked up in another table |
| Prénom chef Dpt | Max 25 letters - If the member is part of more than 1 department, there sould be more than 1 of these - could be looked up in another table |
| Titre chef service | Dr or Dre or M. or Mme - If the member is part of more than 1 service there sould be more than 1 of these - could be looked up in another table |
| Nom chef service | Max 25 letters - If the member is part of more than 1 service there sould be more than 1 of these - could be looked up in another table |
| Prénom chef service | Max 25 letters - If the member is part of more than 1 service there sould be more than 1 of these - could be looked up in another table |
<colgroup><col><col></colgroup><tbody>
</tbody>
