The Accounting Database is a custom software designed to aid companies in their daily workflow by providing a centralized platform where they can manage their clients and their respective information. This software offers an efficient and user-friendly interface to quickly access and manage client data, reducing time spent on manual tasks and minimizing the chances of human error.
This software was created to address the problems faced by companies in managing their client information. With the increasing workload and tight deadlines, employees were struggling to manage the vast amount of data scattered across different files and folders. The Accounting Database was created to provide a solution to this problem by providing a centralized platform to store and access client data.
The Accounting Database was designed to solve the workflow inefficiencies faced by employees in an accounting business. The use of traditional methods, such as utilizing excel sheets to manage customer data, resulted in an overwhelming amount of work within a short period of time before deadlines. This made it difficult for employees to keep track of all customer information scattered across different files and folders. The Accounting Database provides a centralized solution to store all customer information, enabling quick and easy access to all necessary information about each client and facilitating modifications in a seamless manner.
This project served as an opportunity to learn about several programming technologies, including SQL, PHP, HTML, CSS, and Javascript. Working with data tables was a valuable experience, as was learning how to use them to store and retrieve data in an efficient and user-friendly manner. The CSS skills learned in this project allowed for the customization and organization of buttons and sections, while the SQL skills focused on inserting, updating, and removing data using the database tables. The Javascript and PHP skills were utilized to create specific functions and methods required to solve problems, such as the creation of a notification system for expired cards or a relocalization function. The HTML skills were honed to define the page body and navigation bar, making it easier to search for data and improve the overall user experience.
This software was custom-made, taking into account all the requests made by every employee, ensuring that their daily workflow is as efficient as possible. The database actions and search functions were implemented based on employee suggestions, providing a higher quality of life for their workflow. The tables in the database and the webpage structure were designed specifically to meet the needs of the company's daily work, making their workflow even easier.
- Download and install the latest version of XAMPP.
- Ensure that MYSQL is installed on your system.
- Once XAMPP is installed and Apache and MYSQL are activated, go to your path (e.g. C:\xampp\htdocs).
- Download the repository from this GitHub page: https://github.com/JLopez662/Accounting-Database
- Install the repository folders in the specified path.
- Access the database through your browser by navigating to this URL: http://localhost/public_html/index.php Please note that the installation steps may vary slightly depending on your operating system. If you encounter any issues during the installation process, don't hesitate to reach out for assistance.
- To create an employee account, go to the "New Employee" section on the homepage and enter your credentials. This will store your employee data in the database and allow you to monitor which employee created or modified each client's information.
- Log in with your username and password to access the system.
- On the homepage, access your employee account to modify your credentials or remove your account.
- To create a new client, go to the "Create Client" section and fill out the required forms.
- To search for a client, enter the client's ID in the search box and select the appropriate category from the navbar.
- On the selected category page, view, modify, open the corresponding folder or delete the client's information as needed.
This project wouldn't have been possible without the contributions of various open-source resources. A big thanks to:
- DevCrud.com for providing the free template, Rubic, which served as the foundation for this project. https://wwww.devcrud.com/
- Unsplash for supplying demo images. https://www.unsplash.com
- Themify Icons for providing icons. https://themify.me/themify-icons
- jQuery for providing JavaScript library. https://www.jquery.com
- Bootstrap for providing responsive front-end development framework. https://www.getbootstrap.co
- Bootstrap Affix for providing Affix plugin for Bootstrap. http://getbootstrap.com/javascript/#affix
- The implementation of SQL, JavaScript, PHP, and modification of HTML and CSS were done by the developer of this project.