MS Access 2007: 15 years of contract

25 pts.
Microsoft Access
Hello, I'm a student in an intern program right now. My organization give me a MS Access file that contain information of contract workers. They asked me to separate which of the workers that almost work for 15 years and make a reminder for user 6 months before due date.
My department scope is manage contract worker. Their contract usually tied up for 2 years and who is near the due date contract can apply for a continuation of the contract.
Example this year 2016, workers that joined in 2001 has completed 15 years in this year. So my organization will propose the worker change to permanent. No more contract anymore organization only choose by adding each of the contract duration before and after their contract reach total of 15 years, their name will be chosen
For a right now, the table that I got contains: Name, ID, Position, The first appointment date, New contract duration
I got many name right here and many different date for the first time their start to work. I want to separate which of the worker that reach 15 years and remind user so user can alert that there always have a worker that need to change to permanent
I'm not familiar with Access and I never used it before. Please I need help. I don't care who you are and I really want to say terima kasih (thankyou)

Answer Wiki

Thanks. We'll let you know when a new response is added.

Since you are an intern, I suggest you do some research on the web. You are just starting your career and you need to learn how to find the information you need. This is a skill set that will assist you the rest of your life, If you cannot find a solution, then talk with you supervisor and explain the research you were doing and ask them to point you in the right direction. This action will show them you are competent and willing to learn.

Discuss This Question: 3  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Vencro
    yeah you are right but willing to learn has a lot of ways..
    this is one of the way that I choose to gain knowledge..

    pardon me sir..
    25 pointsBadges:
  • Subhendu Sen
    Before accepting the job, did you inform them that you are not familiar with MS access. Did they know you never use access before. It is better to ask them to provide an expert who can guide you through this process. Only web search is not enough to learn. However, navigate here and it helps you a lot:
    142,210 pointsBadges:
  • Vencro
    actually I been placed at human resource department. they also not familiar using Access and they just key-in the new data and each of the data is the information about contract worker. 

    they ask me for my help to make the access more systematic as I got IT background. what I succeed right now is make a reminder and pop up to tell user that they are worker that near the due date.

    before this the user need to scroll out checking one by one.
    that is the first task that I already did to make a reminder to tell the user due date of the contract.

    the second task is I need to identify which of the worker that already reach 15 years of services with the company.
    the problem that I face right now is to create new field in the query that show the day left before reach 15 years. 

    I accept the task given because I sure that I can do that as I got my supervisor at my back. I get late reply from her make me try to ask help at here. Im apologize if Im make a mistake for post my problem at here.
    25 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: