Creating Employee Management Database in MS Access FULL LESSON | Leave Management

EMPLOYEE MANAGEMENT DATABASE SYSTEM
Hello family,
I thank you for tuning into this wonderful tutorial about how to create a robust employee management database in Microsoft Access. It is always important to have a working database that can track the records of your company information.
I entreat you to follow this video with rapt attention and by end, you would be able to create a database to manage your company employees.
MODULES IN THE DATABASE
1. Employee information management
2. Department management
3. Managing worker roles
4. Managing job roles of employees
5. Search to export search results
6. Manage employees leaves
DOWNLOAD THE PROJECT FILE HERE:
drive.google.com/file/d/1MLl4...
CONTACT ME:
EMAIL: [e-mail]
WHATSAPP/CALL: [phone]

[@dimagri123Latvia]

Thank you so much for such amazing lesson of Microsoft access!!

[@Sillywitchlove]

I am an Access dummy! This tutorial was PERFECT! VERY VERY well explained in great detail so that I can retain the information. Thank you!

[@datatechstutorials]

Glad it helped.

[@urielwise1398]

well done boss. Thank you for the perfect explanation. clear and simple

[@msuma9762]

wow this is really good i was finding it difficult to create employment database. but this one is clear and understood thank you very much.

[@user-vt3qv8db8l]

Thank you so much for the beautiful explanation. You are indeed a teacher in blood!

[@datatechstutorials]

I'm glad it helped you

[@mthangzou]

Very helpful.. Thank you.. You just got new subscriber!. 🎉

[@berlinemoscow]

Wooow, what a session we had with this awesome tutor, taking your time was indeed guaranteed, thanks in advance I learned how to export from creating a button, wonderful Ghana❤❤

[@datatechstutorials]

Glad it was helpful! Thank you for watching sir.

[@user-ho6wo3iu1v]

Thank You DataTechTutorials. I have been able to create my employee database seeing your video. Thank You very much

[@datatechstutorials]

I'm glad to hear. Thanks for your support.

[@faiqzaman4405]

Really helpful for all HR person

[@naysonmurona3817]

This was a very good lesson my brother, you're very clear 👏🏾.. I look forward to implementing something similar to this 🧐

[@datatechstutorials]

Glad it helps

[@evelinarriaza2340]

Wow this video is the best tutorial for access Ive been able to see on KZbin for free!! Thank you.

[@datatechstutorials]

You're welcome Evelin. Thanks for your support

[@ekhallo]

Wow, very thorough. Thank you.

[@alejo.systems]

Thank you very much for your effort and for sharing your knowledge. You have earned a subscriber. Keep up the good work!

[@ghiassadiiqi7907]

Great Job

[@chrissackey5465]

I love your DB Tutorials. You are a good Lecturer

[@datatechstutorials]

Thank you sir.

[@BLESSINGOGUESIE]

God bless you, sir! This tutorial has been insightful Looking forward to the leave management tutorial

[@datatechstutorials]

Glad it helps. Part will be uploaded in no time. Thanks

[@BLESSINGOGUESIE]

@@datatechstutorials Hello sir! I am having troubles with the query. I keep getting the error message "the SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect". How do I solve this? Thank you!

[@BLESSINGOGUESIE]

I have sorted it out sir. Thank you!

[@datatechstutorials]

@@BLESSINGOGUESIE Glad to hear Blessing

[@mkgeidam]

Thanks@Smaila for the video its helpful

[@datatechstutorials]

I'm glad it helps

[@dennisdalili5158]

A fantastic lesson indeed be blessed brother

[@datatechstutorials]

Thank you

[@iangaunala2791]

This was really helpful thanks a lot. Please upload next part.

[@datatechstutorials]

Glad it helps

[@super-infotrainingchannel4662]

Some good work done bro. But am requesting you come up with a complete POS system also.

[@lskao722]

Very good practical guide to using Access. I learn a lot. Please keep on this good work!

[@datatechstutorials]

Thanks, will do!

[@alirezamosavi3924]

It's about two months that we all are waiting for you..... ❤ Please upload the last part!!!!!!!🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻

[@datatechstutorials]

It will surely be uploaded

[@qasimalmujaini7198]

Thank you very much my Teacher, it very clear and helpfull🌷

[@datatechstutorials]

You are welcome

[@doug1307]

Excellent video on database application

[@datatechstutorials]

Glad it was helpful!

[@taiwojoel625]

Well done sir, very clear and simple.

[@datatechstutorials]

I am glad it helps

[@logiclogic6177]

god bless you ma buddy, u r just wonderful....

[@datatechstutorials]

I'm glad it helps sir

[@azraarshad3765]

Thank you a lot, it really helped.

[@datatechstutorials]

I am glad it helped

[@thushara691]

I would like to express my gratitude for all the Microsoft Access tutorial videos you have created. I have found them to be very helpful as a beginner trying to learn about Microsoft Access. I am writing to request a video tutorial on how to create buttons on a form that can transfer data to a table. For instance, I have created several tables, namely: ReceivedTable, IssuedTable, ReturnedTable, and DamagedTable. All tables have the same field names: Item Number, Serial Number, Item Description, Item Category, Quantity, and Received Date. I would like to create a form that includes fields for Item Number, Serial Number, Item Description, Item Category, Quantity, Date, and Note. Additionally, I would like to include four buttons for Received, Issued, Returned, and Damaged items. When I click on any of these buttons, the data should be transferred to the designated table. Thank you for your help, and I hope to hear from you soon. Kind regards, Thushara

[@datatechstutorials]

Hello, have you ever used append queries before?

[@thushara691]

No, and I Can look into it @@datatechstutorials

[@faiqzaman4405]

Appreciated you're work

[@datatechstutorials]

I appreciate that!

[@abdikhaliqmohamoud3373]

Thanks so much Smaila.

[@datatechstutorials]

I'm glad it helps

[@darareachseng]

Thank you so much, this video helpful.

[@datatechstutorials]

Glad it was helpful!

[@dadams5402]

This was great. Thank you

[@datatechstutorials]

Glad you enjoyed it!

[@maro_2002]

you are awesome

[@sesughgabriel2647]

Very Interesting Lesson

[@datatechstutorials]

Glad you think so!

[@mtop3147]

thank you so muth

[@ghazanfarali7080]

It helped me alot, thank you

[@datatechstutorials]

you're welcome

[@msajit596]

Excellent sir😊😊😊 👍 now I am a big fan of you

[@datatechstutorials]

Thank you so much 😀

[@macutejackieann1681]

thank you so much!!!

[@datatechstutorials]

You are welcome

[@samnangthorn7894]

It's good I like your videos.

[@datatechstutorials]

Glad you like them!

[@palawenavibe1951]

Thanks for this❤❤❤❤ I learnt today

[@datatechstutorials]

Glad you learned with this. Thank you

[@TheNacerd]

I personally can't thank you enough. I can't wait for the second part (leave management). Can you, sir, tell us when will you upload it. I hope it will be soon. Thank you again.

[@datatechstutorials]

Yes I will upload soon

[@TheNacerd]

@@datatechstutorials Thank you, sir.

[@halleibrahim943]

Thanks brother 🙏

[@datatechstutorials]

you are welcome

[@Khizarsokhta]

Very well explained....

[@datatechstutorials]

Glad you liked it

[@ahmedjabbar5589]

Thank you.

[@datatechstutorials]

Welcome sir.

[@AbifajTv]

Lovely lesson Weldon my dear brother, can you add direct biometric capture to it from web cam capture and thumb capturing ? Thanks

[@datatechstutorials]

Okay. This is well noted with thanks.

[@danshashbrowser8425]

you are the best bro when is the second part coming?

[@datatechstutorials]

it's uploadded. check

[@muhannedmtd22]

Thank you

[@datatechstutorials]

You're welcome

[@mickconnolly3608]

This is exactly what I was looking for. Quick question though how would I update the database once the excel file was returned to me from department that was updating it.

[@datatechstutorials]

import the data into the data tables sitting at the backend

[@Khizarsokhta]

Thanks for such beneficial and easy tutorial. But I face one problem and that is how to stop entering multiple data for a transaction I.e in salary record entering Staff ID and press enter also saves the data on same transaction number. I need that if once we enter data and saved then it must be stop from editing in from.

[@datatechstutorials]

contact me on email. Thanks

[@datatechstutorials]

Hello guys, this is the link to the Leave Management Tutorial. Thanks for the patience kzbin.info/www/bejne/p5CZYmyKoLCdbLc

[@molamola5573]

Hello Senior, thanks so much for this edifying tutorial. I have a problem at the 49th minute; when I run the query, it gives me an error message which is "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect" . I restarted the work and got stuck again

[@datatechstutorials]

Sorry, send this issue via mail

[@marywood6484]

This is great. Where can we find part 2

[@datatechstutorials]

Hello, we are hoping to upload the next parts soon.

[@EFolake]

Hello, I appreciate the training. However, some of your steps are really not for beginners like me who is just exploring Access for the first time. I am stuck at the point of linking my filter Employee and Department in the query section. Can you kindly show the steps in a more explanatory way for first-timers on Microsoft Access?

[@datatechstutorials]

Hello, thank you for bringing this up. We will work to upload a fundamental video soon. Thank you.

[@attayaw1706]

I would like to create a software database or registry. I would need assistance please. How do I reach you? Thanks

[@datatechstutorials]

My contact details are in the video description below pls.

[@44hgda]

30:23

[@khadimhussainmomin1315]

i m husen from india its good lesson. Can you make a multi user app which can be use by multiple user at the same time if the app is shared to my department LAN.

[@datatechstutorials]

Yes. Check the playlist. We have a video about sharing on LAN

[@agyeijoseph187]

can I get the link to the second video pls

[@datatechstutorials]

Check the description, if it's available you can send request to have it.

[@44hgda]

6:42

[@MaMbOyAtOwN]

what type of microsoft office are you using ?, I have tried access 2010

[@datatechstutorials]

I am using 2013

[@MaMbOyAtOwN]

@@datatechstutorials can i get a link to download that Microsoft office

[@datatechstutorials]

@@MaMbOyAtOwN check the video description

[@MaMbOyAtOwN]

@@datatechstutorials ok

[@marapuna9327]

insert a print button or slicer for print out.

[@datatechstutorials]

Very good suggestion. Thank you sir.

[@GhosiaAurangzaib286]

Where is it's relation???

[@miremberebecca1218]

How do i delete a staff who has left the work place without loosing their data. Thank you🙏

[@datatechstutorials]

Steps: deletion shouldn't be mentioned here even since you still need their records to be in the system though they have stopped the job. Let's use some basic query to get our database form to show us only the active staff members and that those you mark as inactive shouldn't show. steps: 1. Add a field with options (Active, inactive) to the employee table 2. when staff leaves the work mark him as inactive on the profile 3. create a query to filter only the active staff members and store that query as record source of the employee profile form or payroll form or attendance. I believe this helps. you can contact me by getting the details from the video description

[@muhammadhassan6002]

What about access 2007??

[@datatechstutorials]

Access 2007 is quite old to be used now.

[@lynetembinya5135]

Where is part two

[@haroonkhattak8645]

When u upload a module of Leave management system of employee

[@datatechstutorials]

Will be uploaded soon sir

[@haroonkhattak8645]

@@datatechstutorials Thanks sir ..I m waiting for this module. Ur information too much meaningfully & good. Thanks sir

[@datatechstutorials]

@@haroonkhattak8645 thanks sir

[@TheNacerd]

Hello Sir, When will you the leave management part. Can't wait to watch it.

[@faiqzaman4405]

@haroon ?

[@muhammadhassan6002]

You can going so fast

[@datatechstutorials]

sorry sir, will slow down in next videos.

[@gratefulgrowth1]

so boring lesson

[@datatechstutorials]

Sorry sir. Let me know your concerns on how to improve. Thank you

[@44hgda]

40:34

[@44hgda]

43:51

[@44hgda]

39:04