Category Archives: Visual Basic 6

Billing System Database Design

Billing System Database Design

Billing System Database Design

This article will serve as a guide in the development of your database schema or model about a simple billing system. The project is available in Visual Basic and MySQL/MS Access. iNetTutor.com allows you to copy the database design and modify it based on your requirement, a LIKE and SHARE  will be greatly appreciated.

tblattachedfile (id, customer_id, file_name_uploaded, remarks, file_type, date_uploaded, encoded_by)

Table Description: the tblattachedfile will store the files uploaded in the system, the can only accept pdf and png type of files (receipts, billing and other proofs of billing transaction). The said table has 7 columns; (1) id is the primary key of the table, (2) customer_id is a foreign key that links to the tblcustomer table, (3) file_name_uploaded refers to the file name of the uploaded file, (4) remarks is to the description or additional notes about the uploaded file, (5) file_type refers to the extension type of the file, (6) date_uploaded refers to the date the file was uploaded, (7) encoded_by is a foreign key that links to the user who encoded the transaction.

Billing System Database Design List of Tables

Billing System Database Design List of Tables

Electronic Police Clearance System Capstone Project

Electronic Police Clearance System Capstone Project

Electronic Police Clearance System Capstone Project

Proposed System

Police Clearance is an official document issued by police or government agency of a country to enumerate anti criminal records that the applicant may have. Police Clearance contains the personal information of the applicant, fingerprints and details of the issuing agent. It is very important to have a fast and convenient way of acquiring such clearance because getting it manually takes a lot of effort and time. In the manual system, the applicant who needs police clearance personally went to the police station to get the requirement. It takes a lot of time and effort and is very hassle to the part of the issuing agent and to the person who needed it. Walk- in police clearance application usually takes 30 minutes to an hour unlike the proposed system that would likely not take much of your time. The proposed system would make a development in the existing system of police clearance application. The researcher of the proposed system entitled Electronic Police Clearance System aimed to provide a platform in acquiring a police clearance that is very convenient and hassle free. Using the system would not require so much time and effort. This system is very helpful for the issuing agent and to the person who is in need of police clearance.

Electronic Police Clearance System Capstone Project

Electronic Police Clearance System Capstone Project

Library System with Computer Usage Time Monitoring User Interface

Library Time Monitoring System Book Encoding Form

Library System with Computer Usage Time Monitoring User Interface

The project entitled library system with computer usage time monitoring was developed in Visual Basic and MS Access, it is a LAN based system wherein the system and database can be accessed in the local network by sharing the exe and db file.

Menu Structure

File – User Accounts, User’s Log, Backup, Restore, Logout, Exit

Records – Books Info, Borrowers Info

Transactions – Issue, Return, Fine

Reports – Inventory Report, Borrowed List

Help  – User’s Manual, Help

Library Time Monitoring System List of Borrowers Report

Library Time Monitoring System List of Borrowers Report

Library Resources Management System

Library Resource Management System Use Case Diagram

Library Resources Management System

Introduction

The project entitled Library Resources Management System is an information system that will automate the entire process of library transactions from purchasing of books, processing of purchase orders, borrowing and inventory of library materials such as magazines and digital archive and records of library.

The project is available in Visual Basic and MySQL, web version of the system is also available in PHP and MySQL.

Library Resource Management System Borrowing Form

Library Resource Management System Borrowing Form

Enrolment System with Faculty Loading User Interface

Enrolment with Faculty Loading Student Subject Encoding Form

Enrolment System with Faculty Loading User Interface

Menu Structure

Home – User Accounts, My Account, Theme Settings

Query – Client, Year Level, Sections, Sectioning, Subjects, Student Subjects, Faculty, Faculty Subjects, Faculty Load

Database – Database Backup, Database Restore

Reports – Section List, Masterlist

Development Tools

The project is available in the following programming languages:

  • Visual Basic and MS Access
  • Visual Basic and MySQL
Enrolment with Faculty Loading Student Section Form

Enrolment with Faculty Loading Student Section Form

Personnel Information Management System

List of Personnel Information Form

Personnel Information Management System

The project entitled Personnel Information Management System is a web based project using PHP, MySQL and Bootstrap, Visual Basic and MySQL version is also available.

The system includes the profiling of personnel, keeping track of their academic achievements, seminars attended and many more.

The said project is for the HR or human resource department which will help them in the record and archiving of their employees profile.

Personnel Profile Encoding Form

Medical and Dental Record System User Interface and Features

Medical and Dental Record System Consultation Encoding Form

Medical and Dental Record System User Interface and Features

Project Description

The Medical and Dental Record System is a LAN Based Application written in Visual Basic and MySQL. These include patient’s personal information, official health records, medical and dental history, daily transaction, medicine log and inventory, common and uncommon illness.

The school clinic is responsible in keeping these records secure and accessible. This is because, these records serves as basis in producing patients information like medical and dental history.

Medical and Dental Record System Dental Examination Form

Medical and Dental Record System Dental Examination Form

Barcode Based Activity Attendance System in Visual Basic

Activity Attendance System Activity Attendance Report Form

Barcode Based Activity Attendance System in Visual Basic

The project entitled Barcode Based Activity Attendance System is a LAN based project written in Visual Basic and MySQL, stand-alone version is also available in Visual Basic and MS Access as the database of the project. This article will present several studies and systems that is closely related to this project, the article will also present the system features and the different forms included in the said project.

Activity Attendance System Student Attendance Form

Activity Attendance System Student Attendance Form

Literature

Events Attendance Monitoring System Using Biometrics and SMS

The Institute of Information and Communication Technology of Isabela State University Echague Campus is now facing problems with regards to monitoring the attendance of the students during school’s activities. Most of the time students are required to attend to all activities as required by the university and the institute itself. But as early days experience until today, the student body organization is having a hard time to monitor the attendance of the students.

The presidents of each class require students to sign their names on a piece of paper as a proof of their attendance in a particular activity prior to start the program/activity. The queues of students in the registration area cause the delay and reliability of monitoring the attendance.

Barangay Records Management Features and User Interface

Barangay System Barangay Certification Printable Format

Barangay Records Management Features and User Interface

This system facilitates Barangay management by enabling the client Barangay to maintain their resident records as complete and up-to-date as possible and as easily accessible for verification, monitoring and reference purposes based on the available residents’ census data kept by the client Barangay. Data provided by this system in the form of comprehensive reports are invaluable for planning, program implementation and related purposes.

Barangay System Barangay Certification Printable Format

Barangay System Barangay Certification Printable Format

Menu Structure of the System

File Menu – Backup Database, Change Password, Restore Database, Log-out and Exit menu

Records Menu – Client Records, List of Purok, List of Purok President, Brgy Officials, SK Officials, Blotter, Activities, Budget

Reports Menu – List of Residents, List of Purok, List of Purok President,  List of Brgy Officials, List of SK Officials, Blotter Report, Issue Certificate, Activities, Collection, Budget, Population Report

Business Permit System User Interface and Features

Business Permit System Permit Report Module

Business Permit System User Interface and Features

This article will provide you a guide and will also serve as a reference in developing a computer based business permit system.

The business permit system is a database application written in Visual Basic and MySQL. This article will provide you with the list of modules and user interfaces (forms and layouts) used in our project.

Simplifying your Business Permit process may further be enhanced by incorporating advances in information and communications technology (ICT). This strategy could simply mean acquiring computers for your Business Permit Licensing Office which the staff may use in encoding and storing data as well as in printing relevant documents. Recently, more and more LGUs are starting to realize the advantage of investing on customized computer programs designed to facilitate Business Permit transactions.

The computer-based system for business permit provides a consistent and accurate facility for recording a taxpayer’s dues and payments. It helps the LGU provide better delivery of services through fast and efficient information on billing and processing of payment of taxes and fees. It can also provide automatic computation of Mayor’s Permit fees, business taxes and other fees. Various reports such as master list of business establishments, business tax collections, collectibles and delinquency, among others, can be generated by the system as well. This feature may lead to better planning and delivery of services through accurate, timely and relevant business information.