DataTechs Tutorials
DataTechs Tutorials
  • 55
  • 766 593
How to create a Loan Tracking system in MS Access | Part 2
PART 2: SAVINGS AND LOANS DATABASE
Hello family,
I hope this post has found everyone in the community well. As promised in the first video, the second part of the series on how to create a savings and loans database management system is here.
WHAT IS ADDED
In the second of the series, we explore how to come by an amazing but simple loan tracking module to enhance the growth of the system.
TYPE OF INTEREST
It is important to take note that, whilst having the simple interest and the compound interest in Finance, in this video we only made use of the simple interest in our calculation. Feel free to advance the system in any way you find interesting.
LINK TO PROJECT
drive.google.com/drive/folders/1Fl-jxK_sdqngIQfzM7cqoYbQakSgbb_h?usp=sharing
CONTACT ME
EMAIL: arkosmile@outlook.com
PHONE: +233246635752
มุมมอง: 829

วีดีโอ

How to create a Savings and Loans management database
มุมมอง 1.1K2 หลายเดือนก่อน
SAVINGS AND LOANS MANAGEMENT SYSTEM Hello there, It's been long since we met in a wonderful video as this. In this tutorial which had been typically requested in this channel by some users, I choose to share with you on how easy you can configure or create a simple database to track savings and loans operations of your business. This lesson is indeed fundamental and it's objective is to provide...
DATATECH'S HAPPY NEW YEAR WISHES AND COMMUNITY ADDRESS FOR 2024 | HAPPY NEW YOUR FRIENDS!!
มุมมอง 2676 หลายเดือนก่อน
HAPPY NEW YEAR GUYS! It is near the new year and we are wishing everyone in this community a happy and a prosperous new year. We cannot forget the priceless supports and motivations behind the works of this community we came from you. May the good Lord continue to bless us all for the upcoming year. Guys, we are entreating you to utilize this amazing opportunity to let us know your feedbacks of...
Creating Advanced School Fees and Billing Database in MS Access
มุมมอง 4.4K6 หลายเดือนก่อน
SCHOOL FEES MANAGEMENT DATABASE (ENHANCED METHOD) Hello there, thank you for tuning into this wonderful tutorial in this community. In this tutorial, I am sharing another improved method for managing school fees and students billing in Microsoft Access database. This database is an improved version of the earlier videos that have been shared on this channel. In this database, you are able to au...
Building a Church Management Database | Complete Database Framework
มุมมอง 3.8K9 หลายเดือนก่อน
CHURCH MANAGEMENT DATABASE FRAMEWORK Hello! everyone, thank you for tuning into this wonderful lesson in Microsoft Access. A lot of us wanted to get videos on how to create church management systems. This video being the first in that series, I share with you the design document. We get to know all the tables and tables attributes needed in the database. Having a database framework will make th...
How to generate reports between any two dates on a form in MS Access
มุมมอง 8K10 หลายเดือนก่อน
CUSTOMIZED REPORTS GENERATION IN MS ACCESS Hello friends, thank you for tuning into this lesson. In this video I am sharing with you on how to generate report with data between two dates in Microsoft Access. The usefulness of this lesson is that, you will be able to make a report to display any length of data between specified dates on a form. Enjoy this amazing lesson. CONTACT ME: EMAIL: arkos...
Newest Church Management System in MS Access | VBA
มุมมอง 3.7K10 หลายเดือนก่อน
CHURCH MANAGEMENT SYSTEM UPDATE Hello friends, in this video, I share with you the demo video of my recent church management system which is an update to the one posted earlier. This system is completely made in Microsoft Access and modules are written in VBA. It has in it all features to support every church management all over. It is a multi-user database and it's shared over a LAN or Extrane...
Creating Appointment Booking or scheduling Database in Microsoft Access
มุมมอง 13Kปีที่แล้ว
APPOINTMENT BOOKING DATABASE IN MS ACCESS Hello guys, I happily share with you in this video on how to create a mini appointment scheduling database for your business or company. This is termed a mini project because it doesn't have extensive features as logins, flash screens, user management and progress bar. If you had like to obtain a special consultation on upgrading this project for use, f...
How to store and open ANY PC Files in Microsoft Access
มุมมอง 11Kปีที่แล้ว
FILES MANAGEMENT DATABASE IN MS ACCESS Hello friends, I share with you on how to create a simple database in Microsoft Access that we can use to store, manage and open our local PC files directly in our Access Database. Using this approach to handle files in a Database has the potential of keeping the Database capacity below the 2GB limitation in Microsoft Access. I believe this will be such a ...
Creating A Queue Management Database in Microsoft Access
มุมมอง 9Kปีที่แล้ว
QUEUE MANAGEMENT DATABASE SYSTEM TUTORIALS Hello community, You're welcome to the amazing tutorial on Queue Management Database system in Microsoft Access. In this tutorial I share with you on how to create an elegant queue management database in Microsoft Access. Queues evolve daily in businesses and companies and there comes the need for systems to be made in managing such. In this video, I g...
Employee leave management Database in MS Access Full Tutorial Part 1
มุมมอง 19Kปีที่แล้ว
Employee Leave Management Database Hello Friends, I'm so glad to inform that, the much awaiting tutorial on how to create Employee Leave management database is uploaded. The Lesson is in two parts and you're watching the first part of it. In this tutorial, we use the previous Employee Database we created. In here we manage leave types, track employee leaves, report employees leave with Debt add...
How to email reports automatically in MS Access using VBA and querying techniques
มุมมอง 9Kปีที่แล้ว
AUTOMATIC EMAIL OF REPORTS WITH VBA Hello guys, thank you for tuning into this video. In this tutorial I share with you on how to send reports (receipts) automatically to email addresses in Microsoft Access using VBA. This is a video in response to request from members on how to send receipts to customers using VBA with the aid of a button click. With this approach, it's important to note that ...
How to create Customer Payment Receipts in ANY Microsoft Access Database Project
มุมมอง 40Kปีที่แล้ว
How to create Customer Payment Receipts in ANY Microsoft Access Database Project
How to show search results in a sub-form and Export specific data to any file format
มุมมอง 8Kปีที่แล้ว
How to show search results in a sub-form and Export specific data to any file format
Creating Employee Management Database in MS Access FULL LESSON | Leave Management
มุมมอง 134Kปีที่แล้ว
Creating Employee Management Database in MS Access FULL LESSON | Leave Management
How to configure Students Management Database with classes and departments relationships | Tables
มุมมอง 3.3Kปีที่แล้ว
How to configure Students Management Database with classes and departments relationships | Tables
Create multiple certificates in Word using linked data in MS Access through mail merge
มุมมอง 1.6Kปีที่แล้ว
Create multiple certificates in Word using linked data in MS Access through mail merge
How to create a fully Automated Payroll Database in Microsoft Access | Full Lesson for Beginners
มุมมอง 12Kปีที่แล้ว
How to create a fully Automated Payroll Database in Microsoft Access | Full Lesson for Beginners
Introduction to Database Development in Access for beginners Full Lesson | Fundamentals Seminar 1
มุมมอง 1.4Kปีที่แล้ว
Introduction to Database Development in Access for beginners Full Lesson | Fundamentals Seminar 1
Creating Classic Students Profile Data Entry Form with Reports Automations using Macros
มุมมอง 4Kปีที่แล้ว
Creating Classic Students Profile Data Entry Form with Reports Automations using Macros
MS ACCESS SCHOOL MANAGEMENT APPLICATION DEMO
มุมมอง 4.2Kปีที่แล้ว
MS ACCESS SCHOOL MANAGEMENT APPLICATION DEMO
How to insert watermarks in Microsoft Access reports
มุมมอง 2.5Kปีที่แล้ว
How to insert watermarks in Microsoft Access reports
How to create a Dashboard in Microsoft Access for homepages | Front End designing
มุมมอง 20Kปีที่แล้ว
How to create a Dashboard in Microsoft Access for homepages | Front End designing
How to create Course registration and billing database in MS Access | Full tutorial
มุมมอง 11Kปีที่แล้ว
How to create Course registration and billing database in MS Access | Full tutorial
Accounting System for Payroll and Balance sheets in MS Access|| POS features included in system
มุมมอง 1.8Kปีที่แล้ว
Accounting System for Payroll and Balance sheets in MS Access|| POS features included in system
How to calculate Salaries Taxes in Microsoft Access DB
มุมมอง 7Kปีที่แล้ว
How to calculate Salaries Taxes in Microsoft Access DB
How to create invoices in Microsoft Access | Everything you need to know about Invoices in MS Access
มุมมอง 40Kปีที่แล้ว
How to create invoices in Microsoft Access | Everything you need to know about Invoices in MS Access
A Church Management System in MS ACCESS VBA
มุมมอง 6Kปีที่แล้ว
A Church Management System in MS ACCESS VBA
How to Append data from Excel worksheets to Microsoft Access tables
มุมมอง 8Kปีที่แล้ว
How to Append data from Excel worksheets to Microsoft Access tables
How to show opening and Closing Balance in Employee Payroll Database | Reply to a comment
มุมมอง 2.8Kปีที่แล้ว
How to show opening and Closing Balance in Employee Payroll Database | Reply to a comment

ความคิดเห็น

  • @EFolake
    @EFolake 4 วันที่ผ่านมา

    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
      @datatechstutorials 3 วันที่ผ่านมา

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

  • @user-xb5gu6qy3w
    @user-xb5gu6qy3w 6 วันที่ผ่านมา

    Like that one 9:31

  • @user-xb5gu6qy3w
    @user-xb5gu6qy3w 6 วันที่ผ่านมา

    When I go into form view it does not move like yours it's fitted the hole screen please help

  • @credov.k2594
    @credov.k2594 10 วันที่ผ่านมา

    cool, thanks! and the files to work?

  • @yenbirenyaabila9627
    @yenbirenyaabila9627 12 วันที่ผ่านมา

    Good

  • @wimschiphorst8541
    @wimschiphorst8541 13 วันที่ผ่านมา

    Very good and interesting video. One question. You use early binding in your database example?

    • @datatechstutorials
      @datatechstutorials 12 วันที่ผ่านมา

      hey bro! what do you mean by early binding.

  • @user-so2tq9ze7h
    @user-so2tq9ze7h 14 วันที่ผ่านมา

    How can I get download ?

    • @datatechstutorials
      @datatechstutorials 12 วันที่ผ่านมา

      if file is available please check the video description to download.

  • @moundirhzr2596
    @moundirhzr2596 14 วันที่ผ่านมา

    thank u i love u

  • @murumumolly9046
    @murumumolly9046 14 วันที่ผ่านมา

    Who is chasing you.? U need to go slow while teaching

  • @HuzaifaSwati803
    @HuzaifaSwati803 16 วันที่ผ่านมา

    It is Fantastic that you Answer Every Comment!!!!! No TH-camr works on such Policies,,,, Thanks for the explained Content Sir Best of Luck

  • @sumardjo
    @sumardjo 16 วันที่ผ่านมา

    Thanks for file Sample Project thanks very much....

  • @LengweChanda
    @LengweChanda 16 วันที่ผ่านมา

    woinderful

  • @andrewabaye6603
    @andrewabaye6603 19 วันที่ผ่านมา

    Thank you for the great video. Please can you share the expression for the Calculation of the TAX?

    • @datatechstutorials
      @datatechstutorials 17 วันที่ผ่านมา

      sir, is it possible for you to zoom the video at that point and get it from there.

  • @andrewabaye6603
    @andrewabaye6603 20 วันที่ผ่านมา

    Beautiful. Thank you so much sir

  • @mbirigaeric2590
    @mbirigaeric2590 25 วันที่ผ่านมา

    can it be shared and opened on another computer

  • @mohosinrubel5174
    @mohosinrubel5174 27 วันที่ผ่านมา

    Excellent presentation.

  • @jacobt.kolenky1235
    @jacobt.kolenky1235 29 วันที่ผ่านมา

    This is awesome

  • @gsb2578
    @gsb2578 หลายเดือนก่อน

    Amazing exactly what I was looking for...Great job Bro god bless you

  • @ogwangandrew8353
    @ogwangandrew8353 หลายเดือนก่อน

    When shall we possibly receive the next video on this as promised. Otherwise thank you so much for this great work

    • @datatechstutorials
      @datatechstutorials หลายเดือนก่อน

      Glad this helped. We're quite busy at the moment and we hope to make more videos soon..

    • @ogwangandrew8353
      @ogwangandrew8353 หลายเดือนก่อน

      Thank you as we wait for more tutorials on this. It has really helped just waiting for crediting and receipting part

  • @aleksandr4206
    @aleksandr4206 หลายเดือนก่อน

    Hi, can you post the finished file of what you did in this video to the public ?

    • @datatechstutorials
      @datatechstutorials 14 วันที่ผ่านมา

      hi sir. sorry this file we have lost unfortunately.

  • @aleksandr4206
    @aleksandr4206 หลายเดือนก่อน

    Hi, can you post the finished file of what you did in this video to the public ?

    • @datatechstutorials
      @datatechstutorials 7 วันที่ผ่านมา

      did you check the video description to find link?

  • @taiwojoel625
    @taiwojoel625 หลายเดือนก่อน

    Well done sir, very clear and simple.

  • @DONGICHAITheComputerguy
    @DONGICHAITheComputerguy หลายเดือนก่อน

    Nice one.

  • @DONGICHAITheComputerguy
    @DONGICHAITheComputerguy หลายเดือนก่อน

    Good job!

  • @kaaviya8213
    @kaaviya8213 หลายเดือนก่อน

    Your tutorial was very much helpful ❤

  • @donomondi3595
    @donomondi3595 หลายเดือนก่อน

    great video. next time please would you create timestamps for us please for follow up. maybe if some part isnt entirely understood?

    • @datatechstutorials
      @datatechstutorials 25 วันที่ผ่านมา

      okay sir. I will do well to ensure that

  • @kensimba7868
    @kensimba7868 หลายเดือนก่อน

    This is such a wonderful piece. Thanku uncle Smailer 😁

  • @LifeWithCtah
    @LifeWithCtah หลายเดือนก่อน

    I wonder if this can connect with website

  • @scubarandy100
    @scubarandy100 หลายเดือนก่อน

    This video was helpful to create a way to enter payments from a customer. Can you show us how to apply these payments to an invoice that was created already

    • @datatechstutorials
      @datatechstutorials หลายเดือนก่อน

      Hello, you have an invoice database you want us to include? feel free to share the database

  • @dikshyant2.042
    @dikshyant2.042 หลายเดือนก่อน

    A big thanks to you!! It helped me for making my project.

  • @ampeter1982
    @ampeter1982 หลายเดือนก่อน

    The next part has kept long boss

  • @salahaldeen8249
    @salahaldeen8249 หลายเดือนก่อน

    Would you teach us how can we build it sir ?

  • @seesmof
    @seesmof หลายเดือนก่อน

    Hallelujah thank You Jesus Christ our Holy Lord GOD Almighty ✝💗🙏 GOD bless you brother, this was very helpful for me, may Jesus Christ our Holy Lord Almighty Living GOD Most High continue guiding you and building you and directing you into His Righteousness forevermore ✝💗🙏

  • @sudhiryadav1579
    @sudhiryadav1579 หลายเดือนก่อน

    9.01 min not visible what u have done

  • @PRINCELYAKO-su2km
    @PRINCELYAKO-su2km หลายเดือนก่อน

    Appreciate sir, I clap for you while wondering how you know all this . Merde

  • @PRINCELYAKO-su2km
    @PRINCELYAKO-su2km หลายเดือนก่อน

    Appreciate sir, I clap for you while wondering how you know all this . Merde

  • @PRINCELYAKO-su2km
    @PRINCELYAKO-su2km หลายเดือนก่อน

    Appreciate sir, I clap for you while wondering how you know all this . Merde

  • @Michaelkafui
    @Michaelkafui หลายเดือนก่อน

    Do you teach Oracle database? I want to learn

  • @miguelervite
    @miguelervite หลายเดือนก่อน

    Do you have an updated link for the template?

  • @kenyanoxide
    @kenyanoxide หลายเดือนก่อน

    smaila suppose a system allows for clients to apply for full sevices or a number of the services how do you print receipts

    • @datatechstutorials
      @datatechstutorials หลายเดือนก่อน

      this involve a lot that needs to be discussed. Feel free to email

  • @josephmalcolmcaymo4852
    @josephmalcolmcaymo4852 หลายเดือนก่อน

    Wheres the link for the download file? thanks

    • @datatechstutorials
      @datatechstutorials หลายเดือนก่อน

      unfortunately this file is not available

  • @zhanyzhaks7611
    @zhanyzhaks7611 หลายเดือนก่อน

    Good work. Waiting for the next part.

  • @SothearakHeng
    @SothearakHeng หลายเดือนก่อน

    Thank you for the video

  • @CharlotteLasseter
    @CharlotteLasseter หลายเดือนก่อน

    I can help in promoting this channel so how can i contact u

  • @CharlotteLasseter
    @CharlotteLasseter หลายเดือนก่อน

    Mr. Smaila how can I contact you

    • @datatechstutorials
      @datatechstutorials หลายเดือนก่อน

      hi Charlotte, check my video descriptions for my contact.

  • @Michiworkstechnologies
    @Michiworkstechnologies หลายเดือนก่อน

    This is helpful video Mr.Arko Smaila indeed i have got a point for what I have been looking for.

  • @Michiworkstechnologies
    @Michiworkstechnologies หลายเดือนก่อน

    This is helpful video Mr.Arko Smaila indeed i have got a point for what I have been looking for.

  • @alializadeh8195
    @alializadeh8195 หลายเดือนก่อน

    Hello again family ... ;) Thanks

  • @SothearakHeng
    @SothearakHeng หลายเดือนก่อน

    Hello sir I follow your tutorial but my quantity in stockin always multiply by everytime I add stockout and I don't know why it always multiply when I query it to calculate the remainings Can u give me any feedback?

    • @datatechstutorials
      @datatechstutorials หลายเดือนก่อน

      sorry for this sir. Could you check out this video to correct that th-cam.com/video/sTQ9hYMXDe0/w-d-xo.html . If it is still not resolved afterwards, you can send me a message. Good luck