How to Create a Human Resource Management system using Microsoft Access Database

hello guys i wish to take you through the process of creating a simple human resource management system using microsoft access and therefore we can start by demonstration this is an example of a system that we shall create from scratch therefore the system looks like this the system roads that is the human resource mis once the system loads you key in your credentials therefore my credentials here we have done we have done then we key in the password therefore the password is correct and this is my dashboard therefore i'm logged in as done and for that case i have forms and reports for instance now if i open the dashboard i have the forms like for instance i can capture the employment details via this form where i can still go ahead and key in the details of an employee that way before we can fill this then record then from here i can still capture the attendance that i can have the accounts tracker where i have the employee id date of issue number of attendance that is number of these attendance numbers of absentees date of a bit sentencing where i can choose the date from the system also on the other hand you can have the payroll where i have the employee id department name profile job and these other feeds that you can see basic salary over time bonus program then you can also have the employee ribs you can capture the reefs per the policy right now we have the name of the policy riff number start date finish date description you can also have the department capture where we shall be capturing the department details of the employee like you have seen we have department id department name head of department etc on the other hand we can still produce reports on the this end here therefore you can just cross this then go to reports now when we are in the reports dashboard or main form you come in a position to produce employee details for example this is a report where you can print you can also have all other reports right now uh just like you you have seen therefore ladies and gentlemen you realize that microsoft access is very powerful and it can be in a position to do this and just to have an overview we shall have the attendance tracker department employees details employees job profile login payroll promotions recruitment scheduling and training therefore these are the tables that we shall create so that we can be a position to produce various reports and also various forms therefore the first step is to launch around microsoft access from scratch then we go to our database at this point you give your database a name like for example we shall call it our hr pro then you will direct to where you want to save it i want to save mine on desktop therefore from desktop i just go to hr pro here hit desktop then hit on ok then create for that case when you go to my desktop you'll get hr pro then from there we just go and create tables therefore we shall start by creating the attendance tracker where we shall have the the employee we can have the m [Music] then we shall have that one is text we shall also have uh date date of issue then we shall also have the number of attendance number of attendance should also have the number of centers then description description description then we have the date of sentence therefore this is date and time we also have this one as date and time then we have this is the number we also have this as a number then we shall have this one as our primary key then save this table of hours as attendance attendance tracker therefore ladies and gentlemen to save on time allow me to be back once i create all other tables therefore ladies and gentlemen these are our tables if we shall have this one we shall have the attendance tracker we shall have the department the department table with these fields then we have employees table these are the feeds of the employee tables all this also we have employees we have this as the fields then we can go ahead and look at the job profile we have position id position name department and employee then we shall have also the we can remove this one there's a duplicate we shall have the login the login we shall have the that is the the username password uh inside that field then we shall have the the payroll payroll will have these details uh as per as i have indicated there therefore ladies and gentlemen don't forget that you can download this database for free from my website the url or website address are just below this video so that you can be in a position to have a comprehensive captcha or a detailed way of looking at these tables therefore from here ladies and gentlemen we go ahead and create forms therefore we shall just go to this point here we hit on form wizard then i want us to start with the attendance tracker if we just go to where the attendance tracker is up here the dance tracker you hit everything goes to the right hand side then we need it to be coram therefore next then you can still leave this one as attendance tracker remember you can name a file that is a form and a report in the same manner but you cannot really name a table and a query with the same name therefore this and gentlemen this is a form we just do a bit of modification on this form so that um you can be in a position to have a proper capture then you can just go to this added instructor have a heading design you need to have a arroga for that one go to this one then right now you want this one to be our logo therefore we have our logo here this is the tendon strap therefore we just do a modification that we shall copy paste it to the elast for the sort we have as our logo then go to design go to this label here take this label draw it therefore we need to have our human resource management system you click outside inside go to format i increase the font size change the current that way this is still small i need to have a bigger one management system management you can cruise this that way then this one also we need to make it readable but if this is our cadence tracker then you can have this one can change the color of our phone also drag have this one format make it vivid or put this to 14 or something like that then after that you need this one to be right around design uh then i save that one ladies and gentlemen therefore this is my form also i need this form of mind to be smaller and therefore i just go to properties here then i go to form choose from here then make go to this pop-up yes model yes make them pop up and model then we are left with just putting the the scroll that is the operation of buttons just put a box somewhere then go to design put the buttons go to next next record put another one that is for the previous go previous next finish make sure they are somewhere uniform then go back put the cross button those ones are enough cross button cross form operations cross next to finish you can have that one as our cross button somewhere then you'll also need to make these ones vivid but you can go ahead and put some animations therefore we need a backer backer here you need to be black sorry you having i want just one today just want to select the buttons but buttons like that then hover on the car that appears when the mouse rests on that therefore this adjustment that is complete you can see now the hoover is working therefore this is our button in case you need to add a new you can use this one if we have human base source management system attendance tracker therefore this is our form redesign deployment we go ahead create one more i will just go to wizard you can choose something like um promotions go to promotions set everything next next promotion finish this is the form ladies and gentlemen i will still repeat the same same same procedure of coming up with the form therefore we need a form for each and every uh every one of these um tables therefore allow me to be back once i am done doing the forms and now that i have taken you through how i will be doing it so that we can all have now ladies and gentlemen we have the department form this is what we have but you can still go ahead and put this button somewhere else like now you can have all this then remember what we did to the alone you can still this is the department's form or capture therefore you just go to this academic structure design view and copy this can just copy this and uh just paste it copy control c department paste before our work now becomes easier here we are close that one because that one we go to employment in design view that one has at least used a different format if we just go to design take this one change that to logo that way then these ones can remain here and therefore uh having created now this this this uh that is having created the reports sorry the forms i can be in a position now to rank them from where i want right now if you look at this table whatever is being captured here is actually done from the that is from the form point of view right now if we just uh if we just um feed something here it will automatically be stored in these tables therefore ladies and gentlemen we also needed to create a relationship here therefore for this database of ours to work we need to have relationship just like i have done here where employee id is linked to employer id to employer id linked to employer id here department id should be also be linked to where the department id is so we can just remove these ones these ones sounds are not part of our database therefore this is our relationship with this engine truman this is how it works also this one is not part of our relationship those ones were just there therefore this is the relationship remember ladies and gentlemen you can download this database for free from my website just look down the video here is the description for for the ring therefore this is what actually relationship works therefore after having done the relationship that way we save that you come in a position now to uh make sure that um you can come up with your reports therefore we have not created any report and for that case to create uh to create a report you need to [Music] go to you need to go to this point here therefore you just create one report then i can create the others of the camera then explain how the rings work therefore just go to create in case we are creating the reports then we go to report wizard now i want us to create starting with the first one at the dance tracker therefore we just go to send to your right hand side next next next this time around we need to we need it as uh tabira and red escape next attendance tracker can remain that way then finish therefore this sort we have then just go to design view and fix the points that we feel we need to reduce like now this one you can reduce this one then pull this one back backwards so that no feet should be hidden also this one is too large just to reduce these ones then we can bring this one somewhere there and make sure everything is vivid nothing is hidden before we just do this put this back this one should be uh displayed before this sort we have the decent detroit then just i write all this by dragging your mouse got format put a vivid camera you can just call it this curve then bolt then after having done that make sure there is nothing hidden after done having done that just pull this down bring the heading here go to format make sure that one is seen then we can paste our heading our heading is in the memory if we just need it to paste so that you save on time remember programmers should not get so much tired you should actually utilize all the available features therefore this is our this is our our our first report ladies and gentlemen therefore just go to design view then you can also pull this back that way if i can just save this therefore basically this is how you can you come up with a with the report now that um i have created the first report ladies and gentlemen allow me to do the other reports of the camera so that um it can be in a position to say one time then i will come back and explain everything as it unfolds now we have the other reports like department report where we have this one we can just modify this just bring this somewhere there paste to that top then we need these ones to be borrowed format put the card back to it save therefore this is what we have as the department we also have the employees report that way we also have the job profile reports where we have all these reports and therefore after having done that we need to make sure that we have all forms together all these forms should be controlled from one point so that our work becomes easier and therefore for that case we need to come up with a dashboard and therefore just go to create then from design this is our dashboard here therefore we just save it save it save it as our dashboard therefore in our dashboard you can just insert a picture here or a photo just go to properties then go to make sure here you read the form go to picture here choose hit the three dots go to pictures before we need to have this picture here for dashboard before i save i run you see what i have this is what we have therefore in our dashboard we go ahead and uh we have our forms here and also our reports here and therefore we just go to design then we can have a take a box you can take a box here draw a box also go again design go to this point draw another box here then go to design label so we can have variable here and now this is our forms this our forms then go again design repo then we can also have our reports up there then just pull this format as issue you can have it that way therefore this is our dashboard reducing the token where we shall have our forms here and our reports here go to design view back then go to design here take the button the command button then go to form operations open form open form next like now i want the attendance tracker next if i just type the word tenants this attendance tracker finish that's what we have then i go again design i draw then i go to form operations open form next i want to have the departments if i just go to this point here i then type departure that way then finish you draw then again design take that button there then go to form operations open form again now this time round i want employee details next open for this one i want to have employees details then finish then can also take another one this is for showing you how i come up with the dashboard form operations then open form next we need to have job profile next next before here we are opening job job profile then finish on the other hand it is an instrument we can also add our reports here design we go to the same button here you draw then this time round you go to report operations not from operations but report operations when you go to preview report next attempt therefore this is the the attain dance dance dance tracker that way then you go again sign take the next one department go to report operations preview report next department next for preview departments finish go again design then draw the next one the next one is employee details therefore go to employee details next this is employee employee details then finish we then wrap up with the job profile if we just go to job profile preview next job profile next before this is job profile job profile that is next finish then after doing that then we have we can highlight this one's format just like we have done to the others then this one can distinct then arrange them accordingly so these ones can be done the same 16 then after doing this you can also change the the buttons where the bottle looks like back around just have them also these ones just go to backer send them a different current different color then we can also change the on over when the mouse rest on it what happens to that one have that on over what happens that way therefore i save then run this one therefore it is an interval you can see then attendance reports therefore this is our dashboard we still complete our dashboard just go right click go to this point form header and footer then you can paste our heading we did not have our heading here if we need it here then i will just go to this point have this one ask area black yeah good then this photo of ours go to design properties go to zoom size mode here here choose stretch stretch then save therefore this is how now my dashboard looks like human resource human resource management system therefore you see what we have here as this is our dashboard and therefore all our operations can be accomplished from this point where i click on this i can open the track when i click on this i can be the position to come to capture the attendance tracker when i hit on job profile i have been a position to to have my job profile form done and then from there if you just go through my previous videos you've been a position to see how we come up with the arrogant screen this one i have done i have uh done the login screen from scratch both using macro and using the vba code and therefore ladies and gentlemen i will not touch on how to create the user login but i'll show you how to connect this user login with a that is with a with a dashboard so that whenever you launch the system the dashboard after a successful login then you will be redirected to the dashboard but still you can get this one from my website that is how to come up with a login screen therefore there is an instrument now allow me to show you how to connect the dashboard and the login screen so that whenever you log in you get a detail here you are logged in as and then you are allowed to work on this but before we go to that it's also important to add the exit application button if we just go to this point here exit application go to application quit application next then finish we shall have at the bottom go to format have it correct then we want to have a raja size of font therefore let's now go to therefore basically what you do you write click go to design view i'll put a text box here this is the text box a b draw a text box if we shall just draw our textbook somewhere here let's go to design text box draw a text box here therefore this is text that in mark that therefore you are logged again us back to it then this one make it uh similar to this therefore just go to design properties then go to box style here choose transparent therefore if you go back you'll notice it's not it is transparent therefore i write this go to format put in that kara european us can just have this as 15. nothing let's see what we have home run you are logged in you cannot see us before just pull this backwards then this is text 13 then ladies and gentlemen we have these two forms mark we have this form this one this is the splash phone i will also put the address of how to come up with this platform in microsoft access you can review on that video so that you can get a position how to i have come up with a with this brush home then this is where the chord starts this is the first that road then it here comes this one this one therefore we start with there you can just first of all no we don't need to cross if i can just go to this one then go to uh to view code therefore the code for that one ladies and gentlemen we have it here that is the code for that one and therefore what you do this is the most important line the others you can just copy paste from my website therefore do command open from user login therefore it will open this therefore you don't need to change anything there we just need to copy paste that chord there it is but uh we cross this but when we are in the login form here this one we need to go to ok button let me go to this and see the chord therefore previous and determine what you need i took you through how to code this one you can just have that one as reviewed but the our point of interest is this point our point of interest is this main form here this is text 14 we change this one to our text box which is text box that in and i save that one then our form is called dashboard therefore i change it here our form is called dashboard in capital dashboard therefore those are the only two things you need to change the text box and the and the main form then from there we can just give a try but before we give a try you can just do a modification on this splash form just go to design go to properties go to picture change the picture that is the picture we can have the picture that way as our picture and therefore we can just run it and see therefore it will run to run it will run on reaching one hundred percent it will give you this one therefore you put done that's the password text that you see now where the error is we have this one let's fix this the four main dot takes that in to the thing this is there is a problem with that so just go to the side view of this one cross it from here then just go to this point again so this is this is our text that in this one just save that go again to this point design view then go to hit this button go to view code if we have this one as our text text the theme dot text that in then this one is main form main this is from dashboard babies this one will change from this then try to see the same error here comes up from this dashboard therefore make sure make sure this name here dashboard is here and this is the name of the text box therefore for for this case of ours here this text box of mine here you just go to design view properties it is called text 14. you can see here and therefore if you call it that tin and it is 14 it will not work therefore this is text 14 and this is where it will be referenced then we have that code if i just go to launching this and see what happens if our human management system wrote then it brings this one we just type the bone then you see automatically if that one is correct then this one will be done therefore on hitting on ok if i hit on ok you'll get that you are logged in as done then you can be in a position now to operate the system but in case the credentials are wrong uh you'll not be allowed to log in you see now you'll get verified details entering the values of now if example i key in wrong here and wrong password you see now i cannot be around login it will indicate that you are trying to login but you cannot be in a position to log in therefore um you can just cancel this cross database would you want to cross therefore my database will be crossed then i can just launch it from this point okay therefore when i go to my dashboard here this is what i have you see now i'm not logged in therefore you cannot get that one as that is for the that is what they that you cannot get the username and therefore ladies and gentlemen this is how you can come up with a human resource management system using microsoft access where you can be in a position to track payroll promotions recruitment and also training done by to the employees employees employee details departments they belong to etc and therefore remember to download this one from my website also we have referenced to splash form we also reference to login user login screen this one therefore you can also try to go through my old videos or my previous videos on how to accomplish the two tasks so that you can be the position to come up with a complete human resource management system as we have done and therefore ladies and gentlemen thank you very much for watching remember to subscribe if you have not subscribed and also remember to share my videos with your friends thank you very much see you in my next session

Channel: DON GICHAI -THE COMPUTER TEACHER

Views: 3,277

Rating: 4.9298244 out of 5

Keywords:

Id: mPVv_8Ns4LQ

Length: 37min 48sec (2268 seconds)

Published: Tue Apr 13 2021