- 63
- 180 002
skill header
Pakistan
Приєднався 22 жов 2023
Welcome to the skillheader YT Channel, The Ultimate IT Skills & Trending Tech platform. Our aim is to empower job holders, students and businesses to Master the in-demand Skills. Our dedication is the Easy, Simple and High-Quality Education and Informative Videos.
🔔 For next video timeline and upcoming projects, see News Board at skillheader.com/
✅ Tutorials and Courses
✅ IT & Database Management Skills
✅ Trending & Most Demanding Skills
✅ Free Projects Source Code
Our content covers a wide spectrum of topics and courses from essential software tutorials to advanced techniques. Learning tools step by step is interesting, so we try to make morale high by motivation for maximum productivity. There is no limit to the profession or age to learn computers. Beginners, students, job holders, and business owners, all are invited to.
Let's unlock the full potential of your digital capabilities together!"
🔔 For next video timeline and upcoming projects, see News Board at skillheader.com/
✅ Tutorials and Courses
✅ IT & Database Management Skills
✅ Trending & Most Demanding Skills
✅ Free Projects Source Code
Our content covers a wide spectrum of topics and courses from essential software tutorials to advanced techniques. Learning tools step by step is interesting, so we try to make morale high by motivation for maximum productivity. There is no limit to the profession or age to learn computers. Beginners, students, job holders, and business owners, all are invited to.
Let's unlock the full potential of your digital capabilities together!"
Customer Management | Master Business Accounting 9
Customer management is vital for business success. It involves understanding what customers want and need, which helps create a better experience for them. When businesses manage their customers well, it leads to higher satisfaction, repeat purchases, and referrals. By using customer feedback and data, companies can improve their services and build strong relationships. In a competitive market, good customer management can set a brand apart and foster loyalty, making it essential for growth.
In this Video:
This video will lead us to complete 47% of our project. You will learn to build Sales form, Customer form, Add New Customer form, and Edit Customer.
📈 After this video, you will complete 47% of this project
Complete Playlist of the Project
ua-cam.com/play/PLO_ZMDiQrSzYd3pTZcfp3UT6_y0wJbE-S.html
🌍 Complete Overview of the Project
skillheader.com/building-master-business-financial-accounting-in-ms-access/
📚 Download Files by Subscription
skillheader.com/master-business-accounting-project-subscription/
📣 Join and Visit our Forum for Questions and Discussions
skillheader.com/community/master-business-accounting-project-forum/
🌍 Explore Blog on our Website
Next Video Timeline for this Project
skillheader.com/
☕ Support Us with a Cup of Coffee
skillheader.com/support-us/
#access #customermanagement #sales #invoicing #businessgrowth #financialaccounting
00:00 Project Overview & Main Features
01:08 Sales Form
03:33 Customer Form
06:05 New Customer Form
15:35 Edit Customer Form
21:33 Forms Integration with the Main Form
______________________________________________________________________________
Icons by: icons8.com/icons
Images by: www.freepik.com/
In this Video:
This video will lead us to complete 47% of our project. You will learn to build Sales form, Customer form, Add New Customer form, and Edit Customer.
📈 After this video, you will complete 47% of this project
Complete Playlist of the Project
ua-cam.com/play/PLO_ZMDiQrSzYd3pTZcfp3UT6_y0wJbE-S.html
🌍 Complete Overview of the Project
skillheader.com/building-master-business-financial-accounting-in-ms-access/
📚 Download Files by Subscription
skillheader.com/master-business-accounting-project-subscription/
📣 Join and Visit our Forum for Questions and Discussions
skillheader.com/community/master-business-accounting-project-forum/
🌍 Explore Blog on our Website
Next Video Timeline for this Project
skillheader.com/
☕ Support Us with a Cup of Coffee
skillheader.com/support-us/
#access #customermanagement #sales #invoicing #businessgrowth #financialaccounting
00:00 Project Overview & Main Features
01:08 Sales Form
03:33 Customer Form
06:05 New Customer Form
15:35 Edit Customer Form
21:33 Forms Integration with the Main Form
______________________________________________________________________________
Icons by: icons8.com/icons
Images by: www.freepik.com/
Переглядів: 450
Відео
Improve Brain Power with Automated MCQ Exam System for Parents and Teachers
Переглядів 38414 годин тому
Introducing our innovative Automated MCQ Exam System - a seamless solution designed to enhance the learning experience for students, teachers, and parents alike! Imagine a world, where preparing for exams is stress-free and engaging. With our system, educators can effortlessly create custom MCQ questionnaires tailored to any topic. Whether it’s a complex subject for high schoolers or fun quizze...
Suppliers or Vendors Management | Master Business Accounting 8
Переглядів 79021 годину тому
Managing suppliers or vendors is essential because it ensures a reliable supply chain, maintains quality standards, and optimizes costs. We will build Purchase form, Supplier form, Add New Supplier form, and Edit Supplier form in this video. In this Video: This video will lead us to complete 44% of our project. You will learn to build Purchase form, Supplier form, Add New Supplier form, and Edi...
Expire Renewal System with Random Keys | Security Level 3
Переглядів 513День тому
We have built a dynamic way to set the activation serial number or product keys to validate the duration for your database. Presenting the most unique and innovative solution of its kind for your Databases. You will be able to set these rules: The subscription period like 6 months or an annual Reminder popup message to renew before certain days Grace period before expiry The database will be lo...
Secrets Revealed to Secure and Lock Database | Security Level 2
Переглядів 64314 днів тому
Secure and lock your database before publishing. We are going to reveal secret codes and tactics in this video so you can apply than publish your database. If you really liked this video, please leave your valuable feedback in the comment section, like, and share. Such act will motivate us to bring in depth videos for you. 📚 Download Files by Subscription skillheader.com/secure-and-lock-your-ac...
Stop Publishing Your Database with Risk | Security Level 1
Переглядів 1 тис.21 день тому
Get ready for an exciting journey! This time, we aim to protect you and your valuable work from those who might threaten your hard-earned efforts in building a Database. Creating a website can be easy, but designing a Database requires a special mix of creativity and logical thinking. Only those who are good at logical thinking can truly master this challenge. Join us as we explore the world of...
Inventory and Stock Management | Master Business Accounting 7
Переглядів 1,4 тис.28 днів тому
Welcome to another milestone to integrate the Inventory and Stock management into our Master Business Financial Accounting Database. The Stock items refer to the merchandise that is available for sale to customers. Inventory includes not only the products available for sale but also the raw materials and equipment necessary for producing them. We will gradually build the manufacturing business ...
Advanced Filter and Sorting in Forms | Master Business Accounting 6
Переглядів 1,1 тис.Місяць тому
Welcome to the standard procedures of sorting and filtering data to use in all of the continuous forms of Master Business Accounting Project. The sorting and filtering of the data is only possible through a form containing a default Datasheet view. There are many limitations of this form view. In this Video: This video will lead us to complete 34% of our project. You will learn to build unique ...
How to Link MySQL Database Hosting to Use MS Access Online
Переглядів 835Місяць тому
Welcome to making MS Access database online using MySQL Server, the most popular database management system used on the web. Estimates suggest that around 40-45% of all websites use MySQL as their backend database. It means whenever you fill in the information using a form on a website, most probably the information will be stored in a MySQL database. In this video, we will configure MySQL serv...
Products and Store Management | Master Business Accounting 5
Переглядів 1,6 тис.Місяць тому
Move on to the next phase of building our Items or Products and Store management-related tables and forms to integrate with the Dashboard. This masterpiece is hard work and efforts of more than 3 years which will make you a Master in Financial Accounting because we will learn Accounting-related terminologies in this step-by-step tutorial for better understanding. On the other hand, we will cove...
General Chart of Accounts Grouping and Management | Master Business Accounting 4
Переглядів 1,3 тис.Місяць тому
Welcome to the next phase of handling the Chart of Accounts. How to create General or sub-accounts in Grouping & Management. This masterpiece is hard work and efforts of more than 3 years which will make you a Master in Financial Accounting because we will learn Accounting-related terminologies in this step-by-step tutorial for better understanding. On the other hand, we will cover a majority o...
Best Way to Use MS Access Online using MS SQL Hosting
Переглядів 9452 місяці тому
In today's interconnected world, database management has evolved significantly from its origins in standalone computers to complex systems spanning local networks and the global online landscape. Can MS Access be used globally, online, or worldwide from any location? The simple answer is “Ye, MS Access can be used online”. We have studied and analyzed different platforms but found smarterASP.ne...
Forgot Password in Web Login System with PHP Functionality Part 7
Переглядів 3734 місяці тому
Welcome to the 7th part of the Advanced Web Login system series. This video demonstrates how to make a Forgot Password form and functionality using HTML, CSS, Bootstrap, PHP, and MySQL Server integration with phpmyadmin. The overview of the project: • Login Form Design (HTML, CSS) • Login Form Backend Server Integration (PHP, MySQL) • New User Admin Code Verification • Logged in Users Dashboard...
Change Password in Web Login System with PHP Functionality Part 6
Переглядів 2425 місяців тому
Welcome to the 6th part of the Advanced Web Login system series. This video demonstrates how to make a Change Password form and functionality using HTML, CSS, Bootstrap, PHP, and MySQL Server integration with phpmyadmin. Features of the Activation and Verification of User Login Account: You can use such a system where a client will be granted a code after a certain payment to unlock his or her ...
Digital Notes Database in MS Access Part 1
Переглядів 1,4 тис.5 місяців тому
In the digital world, skillheader presents another unique project related to multi-dimensional and multi-purpose Digital Notes Database. We have divided it into 2 parts. The first is about the user’s personal notes and the second is about the common interface of sharing notes with other users in a multi-user environment. 📚 Download Files skillheader.com/downloads/ 🌍 Explore Blog on our Website ...
Search as Type | Master Search and Filter in MS Access Part 3
Переглядів 1,4 тис.5 місяців тому
Search as Type | Master Search and Filter in MS Access Part 3
Mastering Search and Filter Data in MS Access Forms Part 2
Переглядів 1,9 тис.6 місяців тому
Mastering Search and Filter Data in MS Access Forms Part 2
User Account Activation with Admin Code with HTML CSS PHP MySQL Part 5
Переглядів 5866 місяців тому
User Account Activation with Admin Code with HTML CSS PHP MySQL Part 5
Mastering Access Export Data into Excel and PDF
Переглядів 1,4 тис.6 місяців тому
Mastering Access Export Data into Excel and PDF
Multiple Ways to Search Records in MS Access Form Part 1
Переглядів 3 тис.6 місяців тому
Multiple Ways to Search Records in MS Access Form Part 1
Chart of Accounts | Master Business Accounting in MS Access 3
Переглядів 4,9 тис.6 місяців тому
Chart of Accounts | Master Business Accounting in MS Access 3
Strong Password Secure Criteria in MS Access Ultimate Login System
Переглядів 2,5 тис.6 місяців тому
Strong Password Secure Criteria in MS Access Ultimate Login System
Become a Master of Business Accounting in MS Access | User Management Event Log Part-2
Переглядів 6 тис.6 місяців тому
Become a Master of Business Accounting in MS Access | User Management Event Log Part-2
Become a Master of Business Accounting in MS Access | Mapping & User Rights Login Part-1
Переглядів 16 тис.7 місяців тому
Become a Master of Business Accounting in MS Access | Mapping & User Rights Login Part-1
Welcome to skill header | Explore the Ultimate Learning with Modern Techniques
Переглядів 1,6 тис.7 місяців тому
Welcome to skill header | Explore the Ultimate Learning with Modern Techniques
What is Best to Store Images and Objects in MS Access
Переглядів 1,6 тис.7 місяців тому
What is Best to Store Images and Objects in MS Access
What is Best for Access Form Control | Bound Vs Unbound Forms
Переглядів 2,7 тис.7 місяців тому
What is Best for Access Form Control | Bound Vs Unbound Forms
Multi User Login with PHP and MySQL Backend Server Integration Part 4
Переглядів 5847 місяців тому
Multi User Login with PHP and MySQL Backend Server Integration Part 4
Speedup Access with SQL Backend within Local Network
Переглядів 1,5 тис.7 місяців тому
Speedup Access with SQL Backend within Local Network
Budget and Expense Analysis with Charts and Reports in MS Access Part 5
Переглядів 1,2 тис.8 місяців тому
Budget and Expense Analysis with Charts and Reports in MS Access Part 5
Havving so much fun I lost track of time. love going over the code and then trying it on my own. Always a challenge but fun learning.
Dove trovo la creazione della form frm_msgpupup?
It is in the Part 3 of the series: ua-cam.com/play/PLO_ZMDiQrSzYd3pTZcfp3UT6_y0wJbE-S.html
@skillheader ho visto il video al link segnalato ma non c'è , non.. È presente dal 4 episodio in poi
Great and nice as usual , i need to ask about including services with product as any company might doing setvices with sold products also, product may includes subproducts that compose it also product units say 1 package contains 6 unit of a product thats leads to differant plans of prices per (sub)products or per unit solds 1 unit or package more over it might be per wholesale or retailsale prices I am not trying to complicate the app but all these questions of real life needs a solutions appreciate to know your point of view solving these issues
That shows your keen interest in our project which is appreciated. The drill down of the products, and packaging system with units and pieces is a complex procedure but we not involve such complexity or confusing elements in our project. Good news is that after your valuable comment we have started working to innovate a simple solution. We are in planning stage to dig out the opportunity and after the completion of the framework, it will be forward for approval. Let's see next.
Due to a lack of words, I will simply applaud 👏 👏 👏
Excellent work, Skill Header! I truly appreciate the time you have dedicated to sharing your knowledge. Your insights are of great importance, and I encourage you to keep up the exceptional work.
Superb wish you best of lucks!!! Sir i have not seen any field of status (Active and In-active) and as will dues of customer and supplier
These all are Level 1 forms. Upcoming videos will be more interesting and complex. Stay tuned.
Great video as always! So is it good practice to use Unbound fields & VBA coding when "Adding New" to your database and then using the bound field on the "Edits" form?
You are right, this will avoid many ambiguities of data processing.
🔔 For next video timeline see News Board at skillheader.com/ 📚 Download Files by Subscription skillheader.com/master-business-accounting-project-subscription/ 🌍 Complete Overview of the Project skillheader.com/building-master-business-financial-accounting-in-ms-access/ 📣 Join and Visit our Forum for Questions and Discussions skillheader.com/community/master-business-accounting-project-forum/ ☕ Support Us with a Cup of Coffee skillheader.com/support-us/
Nice this project will fit in perfect with my study for certificayion / credentials. will questions be randomized and answers be shuffled ? Cant wait to learn more from your videos. Thanks for making them.
That's great. Question shuffling is a good idea but it can expand the data into multiple groups with queries. However, it will give you an opportunity to select the questions from bulk to generate an exam. Let's say, from 50 questions saved and you want to generate an exam with 10 questions based on the selection.
@@skillheader Sweet thanks hw about the answers will they be random lets say correct answer may as A next time test gets generated correct answer is C. Also I like the way you do the unbound forms can you show how to find several results with recordset or is it best to do a query with SQL ? Love the challlenge.
Where can I find the creating vid of login form, registration form and forgot password form?
Here is the Ultimate Login System project playlist: ua-cam.com/play/PLO_ZMDiQrSzbFH7YWt-YaZa6WePDy3eJR.html
@@skillheader Thank you 😊
Can wait for this project...am so ecited😃
this is excellent. But the username and password checking is not case sensitive. i.e. ABC123, Abc123 and aBC123 are all the same as strings are compared as database option. What is the solution to this?
Please keep it up until part 5 of the series and you will get it after completion of the project.
🔔 For next video timeline see News Board at skillheader.com/ 📚 Download Project Files by Subscription skillheader.com/downloads/ 🌍 Read more skillheader.com/smart-automated-mcq-exam-system-revolutionizing-iq-learning/ 📣 Join and Visit our Forum for Questions and Discussions skillheader.com/community/smart-automated-mcq-exam-system-project/
I really appreciate it! You’re the top UA-camr in my book. I like following you because you make everything so much clearer. You’re my role model! Hope you have a fantastic day! I’m looking forward to this series!
It means a lot to me and I am so glad that my tireless work is helping you, thank you so much for your encouragement.
bravo love the custom msg box. looking to the next video. Thanks
You guys can get into the depths of your questions on the new forum the folks at Skillheader developed for us. You can show your questions, display code, attach files, and more importantly we can interact with each other to bring together our ideas.
Great and nice work please keep going forward however I need to know your concept for not using the default form behaviour of adding editing with bounded controls it reduces the code efforts and mistakes and no. of used forms
ua-cam.com/video/9JLlCQ1aJ9A/v-deo.htmlsi=UXQHq6LVOb-ReBsT
When you are dealing with a local MS Access database, it can be a good idea to use the default form bound objects but Access marks and adds a new record while entering data into any bound textbox and undo process caused errors sometimes, suppose you want to cancel to enter the record. The other major cause is when your backend is network based Access split database, SQL, or MySQL. There is no way other than using the unbound forms and enter the data into table from an SQL statement.
Thanks @yonasgossa4962 for mentioning.
@skillheader okaaay well noted
So is that possible to make it more dynamic to define in a module or class as a reusable component instead of doing this with each form
Awwwwsoome work and skill..you guys are the best❤
Amazing it's biggest service wish you long life with success from allah
I would like to express my gratitude for your diligent efforts. Your approach has rendered the learning of Microsoft Access an uncomplicated endeavor.
Looks like homework time tomorrow, yayyyyy
🔔 For next video timeline see News Board at skillheader.com/ 📚 Download Files by Subscription skillheader.com/master-business-accounting-project-subscription/ 🌍 Complete Overview of the Project skillheader.com/building-master-business-financial-accounting-in-ms-access/ 📣 Join and Visit our Forum for Questions and Discussions skillheader.com/community/master-business-accounting-project-forum/ ☕ Support Us with a Cup of Coffee skillheader.com/support-us/
You guys are just awesome. You make me love programming in MS Access more and more everyday..God bless you for your good work.
great stuff , how do i re edit the data base when I need to update the db structure?
You have 2 options. Either save your Master ACCDB file to a certain location, copy it and apply all the methods of hiding and securing database, convert it to ACCDE. Second option is to keep your file as ACCDB, create a password protected form with buttons to hide/unhide and secure/unsecure database.
Thanksssss.. This is perfect tutorial👍 I need to be able to re edit database according to customer order !! How can I do it with this method? Thanks for your help 👏
You have 2 options. Either save your Master ACCDB file to a certain location, copy it and apply all the methods of hiding and securing database, convert it to ACCDE to publish. Second option is to keep your file as ACCDB, create a password protected form with buttons to hide/unhide and secure/unsecure database.
@skillheader Thanks I saved file as accdb with a password protection, but the problem is trust location unhide every things when log in form open for the first time!! I must set trust location manually then everything works perfectly. How to disable trust location or set it automatically? Thank for your help👍 Is there any way
That's awesome your videos are always great personally i have ranked Skill Header as no.1 so far of all Ms Access tutorial have ever come across. Thanks for that good and great work.
Very interesting indeed!
This video mainly shows how it functions, but it doesn’t go into detail about the activation key linked to the form. Have you completed this series, or are there more videos planned on this subject? Additionally, when can we expect the next installment of the Master Business Accounting and Digital Note series? We’re really looking forward to it! Thanks for sharing the video tutorial! It has a wealth of ideas to explore.
You can always monitor the upcoming video or projects from home page skillheader.com/
Suparb
Thanks so much for your videos especially this project. It's really helping me a lot with my new project for a company...However the user responsibilities with respect to the Profile is not working well..When i log in as user, it will be given me access to the admin responsibilities, and also when i log in as admin, it will be given me limited responsibilities like you did for the user profile...I have checked all the codes and textbox names which everything is fine, but the profile responsibilities is still not working well.. Sometimes I will have to login twice for both user and admin before it will work. I don't see where the problem is...Please can you help?
Yes, you are doing right. Please join and create a topic in the forum mentioned below so I can answer it for the benefit of all. skillheader.com/community/master-business-accounting-project-forum/
I am facing issues connecting with MySQL Database.
Please join and raise your concerns in the below forum link. I will personally answer it for the benefits of others. skillheader.com/community/connecting-ms-access-with-sql-or-mysql-for-local-or-online/
🔔 For next video timeline see News Board at skillheader.com/ 📚 Download Files by Subscription skillheader.com/master-business-accounting-project-subscription/ 🌍 Complete Overview of the Project skillheader.com/building-master-business-financial-accounting-in-ms-access/ 📣 Join and Visit our Forum for Questions and Discussions skillheader.com/community/master-business-accounting-project-forum/ ☕ Support Us with a Cup of Coffee skillheader.com/support-us/
Very Good
A huge thank you for all your hard work and dedication to enhancing the security features of MS Access! Your efforts have made a real difference in protecting our data and empowering developers to secure their code more effectively. I do have a question, though: the tutorial doesn’t cover how to retrieve the hard drive number, create a system where a user has lifetime access with a single password, or set up access that expires on a specific date. Could you also provide guidance on implementing an activation key?
Thank you so much for the encouragement. Stay tuned, we are on it in upcoming videos of this series.
Amazing Sir.
This is really great and worth learning.Thanks a lot God bless you
I love the concept of locking and not make it look like access on opening. thanks for the tutorial
Very nice……your video was precise and very easy to follow. It is going to be fun to try it all out on my computer, after I have my coffee first of course! 😅
Signed Up Today ....
You have granted the access ua-cam.com/video/Nfv1ZOFXpMw/v-deo.html
Thanks so much for your video. Pls Show us how to copy bulk data from one table to another table using VBA
That is a great suggestion. I will try in furnish in future videos.
I'm trying to open a records while double clicking a phone number. Below code was opening a form where customerID matches MemberID. DoCmd.OpenForm "CustomerMain", , , "CustomerID=" & Me.MemberID, , acDialog But while i linked it into Navigation Form It opens seperately not within that MainDashboard1. and i tried below code. DoCmd.OpenForm "Forms!MainDashBoard1!NavigationSubform!CustomerMain", , , "CustomerID=" & Me.MemberID, , acDialog But it give me error and doesn't open form now. What will be the code for this. Please Help
Please help me if we can open form inside Navigation form or not? If yes then what will be the vba code for that.
docmd.BrowseTo acBrowseToForm "CustomerMain","MainDashBoard.NavigationSubform" above code works fine it opens "Customain" form, But doesn't allow criteria like "CustomerID=" & Me.MemberID. I want the form to be open along with specific records. Please help
Had a clue 🕵️ on some of these methods, but seeing what is coming is blowing my mind 😮. Signed up….
It is great to see you on board.
Sir free itni possible.... cannot afford.
📚 Download skillheader.com/secure-and-lock-your-access-database/ 🌍 Explore Blog on our Website skillheader.com/ ☕ Support Us with a Cup of Coffee skillheader.com/support-us/
hello Sir im you big fan from india AK if Same date have multiple entries how can it store in table and if fetch information on date how can we do that pl do Sir
Good to see you. Hence, every table has a Primary Key ID field, so it doesn't matter how many or same date entries in a table.
Do you have such video, if so kindly give me link. Thank you for your kindness and excellent content on you tube
WOW I am into this project. Always learning new way to do things. I have a request can we add a date criteria lets say I have to do monthly or quaterly report. I lke to provide a start date and end date. can you show how to do this? I appriciate the work you put into the videos clear instructions and easy to follow. Than You.
Date to Date, Weekly, Monthly, Quarterly reports will be included in upcoming videos with the Sales Invoices, Purchase Orders, and Salaries of Employees etc.
@@skillheader You and your team are the best!
For next video timeline see News Board at skillheader.com/
Thank you very much, great work
its great i love this channel😄😄😍😍
Thanks for this video, good job, I learned a lot. I think the code fragment if myfileExt = "JPG" or myfileExt ="JPEG" then could be skipped because there is a .Filters property in the filedialog. By adding .Filters.Add "JPG images", "*.jpg", we only allow jpg files to be selected. Am I right?
While creating the query I ran into the one thing that always causes me trouble and that is Access 365 does not recognize IF statements, has to be entered as IIF. Old habits...haha! If anyone has trouble and forgot as well...hope this helps.
You are right. Perhaps, some Excel users can make this mistake.
Super job! I like how this is coming together step by step. I am saving some of these vba techniques in my MZTools app…going to come in handy. I have many ideas, but I will wait until the final video is released to discuss with everyone. I am racking my brain to predict how you will continue to tie this together. Keep on keeping on folks!