Search results

  1. S

    Normalization of DB Tables

    I need to know (I run a query)this information so I know who all needs all their trainings to gather to hive to OCFS. OCFS had records who all are waivered to all sites so the expect me to send all training information to them for all our waivered staff. I come up with these bits of...
  2. S

    Normalization of DB Tables

    I’m adding .... everyone who’s home site is one of the 5 waivered sites they’re waivered to to that site. It’s just staff who are waivered to LCAC or MYAB who are not waivered to their home site due to these 2 sites are not through OCFS because there aren’t any classrooms. Their just offices...
  3. S

    Normalization of DB Tables

    1. We have 5 waivered sites. These sites are where our licensor does her reviews and relicensing. 2 of the home sites are not waivered sites- they have nothing to do with OCFS reviews at all. 2. Each staff person has a specific site in which they work from (Home Site). Then staff (not all)...
  4. S

    Normalization of DB Tables

    Maybe this might explain better. Our director, Managers, myself all work out of "an non-waivered" site because they are just office (LCAC and MYAB) All Center Directors/teachers/Teacher Assistants/builidng clerks/nurses/ all have a home site they work from. Where their classroom/office/desk is...
  5. S

    Normalization of DB Tables

    Home site is where a staff main site is. For me, for instance, my home site is LCAC (not a waivered site) because it's offices. However, I am waivered to a couple of sites like HF and CN when there is a need for me to sub incase too many call off then there are extra staff to fill in to make...
  6. S

    Normalization of DB Tables

    Also, one more thing I am hoping can be done. I love the subfolder showing totals of training hours. Is there a way of adding a Total (adding) all their hours and put it right under the total hours for the 9 categories that are showing.
  7. S

    Normalization of DB Tables

    No ...all home sites are not waivered sites. All the waivered sites are only one I stated in my previous email. There will be one more added, because we opened another classroom at another but I do not know the name or what period it will be because the licensing period will not start until we...
  8. S

    Normalization of DB Tables

    It worked. Thank You!!!
  9. S

    Normalization of DB Tables

    What I did with my excel spread sheet was what i was the first site that is set for review I would delete all trainings that was taken before before the review period started. I had to go to each staff and do it one by one. It was very cumbersome. Once I deleted all those trainings for each...
  10. S

    Normalization of DB Tables

    I tried to figure out in design view for the table for the 9 OCFS categories. I couldn't. Because (I really hate to be picky) but at time a trainer only puts #1 or #6 for a category. OCFS has a standard numeric way for their categories to run. I was going to change it myself but couldn't...
  11. S

    Normalization of DB Tables

    I believe that will work. For the required trainings. However, for the period of time for all training hours due to licensing periods all trainings completed need to be within a specific time. If this is possible. CN review schedule is starting 10.1.20 ends 9.30.22 every 2 yrs; Bush- starts...
  12. S

    Normalization of DB Tables

    I really like that. Any free time, I play around with it some. Trying to grasp the whole thing so when I start entering all data from old DB into the new final version DB I'll know what I'm doing. Boy, I'm working you overtime on this - I do so appreciate this. I would've NEVER gotten all...
  13. S

    Normalization of DB Tables

    I hope I explained it good enough for you to understand. It is quite cumbersome. I'm so sorry about that.
  14. S

    Normalization of DB Tables

    I also started entering more staff in the last DB you sent. I really like how to enter trainings. This will definitely help with typos and other errors that can occur the old way. I was playing around with adding new trainings and such. Looking at the the breakdown of hours the be placed...
  15. S

    Normalization of DB Tables

    Ok... I know this is so complicated. Let me explain what counts for our trainings. No.... all trainings do not have expiration dates. OUr required trainings must me done every 2 yrs. First Aid/CPR is every years (I believe if I remember right-i'm home right now) MAT trainings are every 3...
  16. S

    Normalization of DB Tables

    The First Aid/CPR/AED and MAT can be with the other trainings however i will need a Never Taken field and an expiration date. MAT training I will need an expiration date also. I can do a query to show staff who's never taken it and to show expiration dates.
  17. S

    Normalization of DB Tables

    That is perfect for entering new employees. It get me ahead of the game when they are hired, but it takes some time for HR to get me the employees employee #. As for trainings, that sounds ok. There really is no need to keep trainings on record once they licensing period is complete expect...
  18. S

    Normalization of DB Tables

    This is going to be GREAT!! Once I can add all out staff to this database and start using it - I may have more questions. Once you've got it the way you think it's ready to use I want to add all my staff data to see how it will work and to see what I need to do to keep data up-to-date. When...
  19. S

    Normalization of DB Tables

    Once we get the entire DB going strong would I be able to put it on Access web? I have MS program I've purchased and pay it yearly, but never really used it for anything this important. I would like managers be able to look at anytime regarding their staff they supervised to see where they...
  20. S

    Normalization of DB Tables

    I like it so far. What if there is a new training course that we've never taken, how would I enter that. Also. Once completed will I be able to run a query to list all trainings staff has had and put a date more than a 2 yr period and delete those records? Because when an inspection gets...
Back
Top Bottom