Wednesday, February 25, 2015

Enterprize employment client database (Access)

You work for a private employment agency as an administrative assistant. As part of your responsabilities, you maintain a client database that contains job candidates' basic contact information: name, address, and phone number. The office manager has asked you to add to the database the date each candidate applied at your office, the date they were placed with an employer, and employer's name. Also, because the database is getting rather large, you decide to create a form to make it easier to enter and update records (O'Leary, AC2.94). Please summarize in your own words the general steps that you would use (HINT: look at the example on AC2.94 and AC.2.95).

16 comments:

  1. I currently work at work force a private employment agency as an administrative assistant. My biggest responsibility is to ensure that all the employers and candidate data are always updated and accurate. My office manager has also requested that I add into the database a few more details. She specifically requested me to enter the date each candidate applied at your office, the date they were placed with an employer, and employer's name. Since I already have everything in Microsoft Acess to add these colums and pieces of information but be difficult. Let me run you through a few of the steps. Step 1) Open the application Step 2) Add a field for every detail I want to add for examples if its date employee applied then I add a field for that name it that and it will create a column for that detail and so on. Step 3) Save the data. It’s a few simple steps to adding the information. Since I have performed so well in my office managers duties she has given me a raise.

    ReplyDelete
  2. i"m currently employed through a private employment agency as an administrative assistant.Part of my responsibilities are to maintain a client database containing any information we would need from the client.My office manager asked me to add a few more items to the database. Since the database is expanding,I decided to create a form to make it easier to enter and update records.1) Open the document(Microsoft Access 2010),2) Enter data in the appropriate fields,3) Save the data,4)Close the database.

    ReplyDelete
  3. I Michelle work for a private employment agency as an administrative assistant. I maintain clients current information as it's my duty. To begin you will (1) Open up the database(application). (2) Enter all fields for every detail in the table. (3) Hit the save button to save all your work that was entered. Access 2 is not that hard to do it's very simple and just remember to close it out when you are done.

    ReplyDelete
  4. I work for a private employment agency as an administrative assistant. It’s my responsibility to keep a client database that contains job candidates’ basic contact information. However the office manager has recently asked me to add the date these candidates applied, the date they were placed with an employer and also the employer’s name. Due to the fact that the database was getting large I decided to create a form to make it easier to enter and update records. In order to do so I first, opened the database file, then, I inserted the following names for the fields I needed to add (Application Date, Hire Date, Employed By, and Employer Name). Afterwards, I used the Form Wizard to create the form for the candidates, using the columnar layout. Once the layout was applied, I rearranged the information added to my liking. Lastly, I use the new form to enter the following records in form view. After these few steps, all of the candidates’ information was entered properly and professionally and the office manager along with me was pleased.

    ReplyDelete
  5. I am currently working for a private employment agency as an administrative assistant. My responsibilities are to make sure all the employers and candidate data are always updated and precise. The office manager has requested that I expand the database with a small number of more details. He specially requested for me to enter the date of each candidate that applied at in the office, the date when they were placed with an employer, and employer's name. This information was already stored in Microsoft Access so in order for me to add these columns and sections will not be challenging. Here are the steps you will need to follow: First open the application, second add a column for every feature I need to add, and the Third make sure you Save the data.

    ReplyDelete
  6. I am currently employed at a private employment agency as an administrative assistant. My main responsibilities are: to maintain a client database that contains the candidate basic information. The office manager had asked me to add each candidate information to the database. Since the office already has Microsoft I have decided to create a form to make it easier to enter and update all the records. 1) First I would open the database. 2) Enter details in the correct fields. 3) Save all my work. 4) make sure to close whenever I’m finish working because client’s information is privileged.

    ReplyDelete
  7. This comment has been removed by the author.

    ReplyDelete
  8. I am an administrative assistant at WorkReady and one of my responsibilities is to maintain the client database. The database at the moment is rather large so I am creating a form to make it easier to enter and update records. The first step is to open the database named ac02_Enterprize Employment Agency and the table named Candidates. You will then insert the following fields after the Application# field: Application date, hire date, employed by. Also all the zip codes need to be changed to 72725-1016. Then you will use the Form Wizard to create a form for the Candidate table including all the fields in their current order. Lastly, display all objects types in the navigation pane and print the form for the record containing your name. You will then be able to print the filtered datasheet.

    ReplyDelete
    Replies
    1. Thank you Heidi. However, you did not have to include the file name in the post.

      Delete
  9. I currently work at work as a private employment agency as an customer service administrative.It’s my responsibility to keep the clients database that contains their private information, and to make sure they are always update and accurate. First step is open the application, Second step is put in all the information into the database pertaining to the client, Last step is saving all the info that was entered and making sure that you close out the application when done. Manager was happy that I got all the information into the system and it was that simple.

    ReplyDelete
  10. I work under a private employment agency as an administrative assistant in the local hospital. Part of my job requires me to take in a lot of information at a time, and to update it. Therefore, I use Microsoft access as a way to maintain and organize the patients’ data. The set up that I take is by first #. Clicking on the programs. 2. Then entering a field title for each detail. 3. I start to apply all the necessary data under each category. 4. I finish by saving the entered information, and saving the content. Using Microsoft has really made my job easier, and allow me to complete all my task quickly.

    ReplyDelete
  11. Currently I am working at a private employment agency as an administrative assistant. My most important responsibility is to make sure that I maintain my clients database which may contain job candidates basic contact information such as their name, address, and phone number. Because I will have to add their name ,dates such as when they applied and when they were scheduled to an employer, to information I already had in a database. I will use a different method such as using a form that will allow me to update older records. I would first open up the database file. Enter all of the names for each field in the table. Then I will use the form to make it so that the candidates can use the layout. After I have completed that and the layout is applied and ready to be used. I make sure that I add and fix any information that needs to be fixed. To top it off I will use the new form to enter the information in form view then lastly save my work.

    ReplyDelete