Category: Ms-Access projects

Ms-Access projects listed here are for Computer science final year students. Ms-Access is used for back end application as database for storing data. Ms-Access projects database is used for vb, .net, c# projects. Download full project reports and database with source code.

Posted on

Mysql Project for Students on Report Programs Code Generator Tool Project Report

The main aim of ‘Report Programs’ Code Generator Tool system is to produce code assisted by necessary features and the user needs to provide some input related to the application. Those collected inputs would be saved on to the tablets and an ASCII file would be developed on the basis of the information gathered.

All batch programs consenting to a particular logic would be imposed with a similar structure by an automated code generator. Based on limited user inputs, the generator would produce the highest amount of program code. It would not only assist in decreasing coding time of programmers, but also extend the productivity by letting the programmers to concentrate on the application logic. This would lead to decrease in development costs and make code maintenance easy.

The Lexical Analyzer would examine the ASCII file and the necessary information from it would be gathered in data structures and they would be used to produce the required code. As soon as the entire data is extracted from the file, four files would be generated by the chief control file. These four files comprise the code required for the depicted features of main flow. In order to complete the application, the application specific code needs to be assimilated.

The Project modules include Input module, Interface module and Code generation module. The Database layouts include table layouts, namely Program table (PGM_TBL), Input table (INPUT_TBL), Field table (FIELD_TBL) and Report table (RPT_TBL). Output layouts include extract ASCII file structure. The information gathered from the front-end screens is used to create the ASCII files and that data is present in the tables too.

Download Mysql Project for Students on Report Programs Code Generator Tool Project Report.

Posted on

Payroll Management System Project in Visual Basic VB

The entire Payroll Management System Project in Visual Basic system is menu driven and highly interactive. The system provides maximum flexibility to the user. All validity checks are taken care by the system during data entry. The timely and well-designed reports helped the management to make critical decisions in time. The actual user of the system is very much pleased by its efficient performance and the user of the package have extremely reduces duplication of words. 

                     Since the requirements may increase in future, the system can be easily modified accordingly, as the system has been modularized. The future expansion can be done in a concise manner in order to improve the efficiency of the system.

SUGGESTIONS FOR FUTURE WORK   

        This system is very flexible so that the maintenance and further amendments based on the changing environment and requirements can be made easily. Any changes that may lead to the system failures are prevented with security measures. The project will support for multi user environment, that is more than one user can access simultaneously. 

            It can be further developed to include more operations and analysis, as changes are required in the system to adapt to the external developments.   Further enhancements can be made to the system at any later point of time.

             Coding procedures can be modified according to the needs of the user. The system code is also well designed that it will form the basis for further enhancement and also new operations can be included in the system. The reports can be represented in all necessary propection. Added options can be design in reports.

Posted on

Payroll Management System MS Access Project Database Tables

  • Department Master
  • Leave Register
  • Employee Master
  • Pay Slip
  • Staff Appointment Master
  • Staff Relive Master 

Table Name: Department 

Field Name Data Type Constrains Description
Dcode Text P/K Department Code
Dname Text NOT NULL Department Name

 Table Name: Employee 

Field Name Data Type Constrains Description
Ecode Text P/K Employee Code
Ename Text NOT NULL Employee Name
Dname Text NOT NULL Department Name
Shift Number NOT NULL Shift
Salaryday Number NOT NULL Salaryday
Apno Number NOT NULL Appoinment Number
Esiper Number NOT NULL Esi Percentage
Pfper Number NOT NULL Pf Percentage
Esino Text NOT NULL Esi Number
Pfno Text NOT NULL Pf Number

 Table Name: Leave Register 

Field Name Data Type Constrains Description
Ecode Text NOT NULL Employee Code
Ename Text NOT NULL Employee  Name
Monthyear Text NOT NULL Month Year
Flag Text NOT NULL Flag
Nod Number NOT NULL No Of Days                  
         

 Table Name: Pay slip

Field Name Data Type Constrains Description
Ecode Text R/K Employee Code
Ename Text NOT NULL Employee Name
Sdate Date/Time NOT NULL Salarydate
Myear Number NOT NULL Month Year
Sday Number NOT NULL Salary Day
Noofday Number NOT NULL No Of Day
Pay Number NOT NULL Pay
Esino Text NOT NULL Esi Number
Pfno Text NOT NULL Pf Number
Pfper Number NOT NULL Pf Percentage
Esiper Number NOT NULL Esi Percentage
Pfamt Number NOT NULL Pf Amount
Hramt Number NOT NULL Hra Amount
Daamt Number NOT NULL Da Amount
Taamt Number NOT NULL  Travel Amount
Oaamt1 Number NOT NULL  Other Amount 1
Oaamt2 Number NOT NULL Other Amount 2
Totalsal Number NOT NULL Total Salary
Canteen Number NOT NULL Canteen
Sadvance Number NOT NULL Salary Advance
Netpay Number NOT NULL Net Pay
         

 Table Name: Staff Appointment 

Field Name Data Type Constrains Description
Apno Number P/K Appoinment Number
Apdate Date/Time NOT NULL Appoinment Date
Name Text NOT NULL Name
Sex Text NOT NULL Sex
Dob Date/Time NOT NULL Date Of Birth
Addr Text NOT NULL Address
Quality Text NOT NULL Quality
Salary Text NOT NULL Salary
Fname Text NOT NULL Father Name
Martialst Text NOT NULL Marital Status
Appas Text NOT NULL Appointed As
Std Text NOT NULL Standard
Prevexp Text NOT NULL Previous Experience
         

 Table Name: Relive 

Field Name Data Type Constrains Description
Relno Number P/K Releive Number
Apno Number R/K Appoinment Number
Ename Text NOT NULL Employee Name
Reason Text NOT NULL Reason
Posted on

Main Objective of Payroll Management System Visual Basic Project

The “Payroll Management System” has been developed with Visual Basic programming in a user friendly manner. The system has been designed so as to get minimum amount of inputs from the user. The system promotes the data entry operator with menus and screens. The form has been designed in such a way that the cursor is placed in the first entry where the data must be entered. Validations are made for each and every data entered. Whenever the user types erroneous data, error messages are displayed and the user is allowed to correct the input data. Dropdown boxes have been provided for the list of valid data for certain fields where the user can make the selection. 

Specific Objective:

                       The system focuses upon imparting better services to the company. It helps the company to maintain its Employee Details, Department Details, Staff Appointment Details , Staff Relive Details, Pay Roll Management etc., 

It is highly user friendly. At the design and development stages it ensures data integrity and security. It requires not much computer knowledge to operate this system. Functions such as data entry, addition, deletion, modification, navigation etc., have been made simpler and interactive and provides a user interface.

Payroll Management System Project abstract provides detailed information on Hardware and software requirements and development details. This project is implemented in java and Asp.net platforms.

Posted on

Payroll Management System VB and MS Access Project

In this phase the existing system has been studied, the problem is identified, the alternative solutions are analyzed and the best solution has been selected after the feasibility analysis. 

In this step the following steps are carried out: 

                                      1. Existing System

                                      2. Proposed System

                                      3. Comparative System 

              The need for the system stems from the nature of the organization.  In order to justify and appreciate the need for the system, we have to study the existing system.  By conducting the system study, we are able to find out what are the goals specified, whether all the objectives are satisfier, what are the disadvantages of the existing system etc. Here the existing system is maintained manually.  So to computerize this, we must bind the system by identifying the scope of the function and performance that are desired.

                The existing system is maintained manually. In the present system whenever the customer gives an order it is maintained manually in the notebook. Manually they have to update the production order, production plan of items, production monitoring etc.  So the present system is not good enough for the company.

      The disadvantage of the existing system is

  • File maintenance is extremely difficult as every thing is done manually.
  • Information retrieval is difficult and time consuming.
  • Quick analysis of delivery is not possible.
  • Not enough security and privacy.
  • Requires much human effort.
  • Information need not be accurate. 

          The proposed “Payroll Management System” is developed to systematically maintain the employee details and their Appointment Details and their Payroll calculations. This system reduces the Manual File Maintenance and easy to view the details about the particular employee details. This system reduces the manual calculation for employee pay slip. 

Comparative Systems Study

While Comparing the Existing system and proposed system, proposed system is best due to the following reasons 

  • Speed of process increases.
  • After performing a long period human becomes tired, but computer works for a long time continuously (Diligence).
  • Accuracy is more.
  • Deleting, Copying, Updating is possible.
  • Processing Time will be decreased.
  • More Security. 
  • Backup is available.

Salient Features of the system

Hardware Specification

Processor Type          Pentium II

Ram                             128 Megabytes

Clock speed                 866 MHz

Hard disk                    20 Gigabytes

Floppy disk                 1.44 Megabytes

Mouse                         Logitech

Monitor                       Hcl

Keyboard                    Hcl (101 Keys)

Printer                         Epson FX_100 

Software Specification

 Front end                         Visual basic 6.0

Back end                         Ms-Access 7.0 

Operating System            Windows 98

Posted on

Wine Dealer management System Project Database Tables

The below added Counter Details MS Access table provides details about item (food, wine), number,  date of purchase, stock details and total quantity of each item for Wine dealer Project.

Counter_Detail

ITem_No

Date

Stock

Qty

 Employee Salary Management MS access database table explains how staff salary calculates, it includes advance taken, advance date, reason for advance, amount paid, remarks, employee number.

Emp_Sal_Det

ADV_Taken

ADv_Date

Reason

Amt_Paid

Remark

Eno

Amt_taken

Fine

 Employee information MS access table explains about how total employee details can be stored in the database. Here Employee name, Employee attendance, dates of joining, employee phone number, employee salary, and others.

Employee_Information

Ename

ET_Add

D_O_J

Remark

Eno

ph_no

E_sal

et_no
               

 Employee Job table explains you about the employment name, duties, number, duties and amount.

Employee_Job

ET_Name

ET_Duties

Et_no

Et_period

Et_amt

 Employee Expenses Table Below

Expenses

Particular

Date

total_amt

amt_paid

 Hotel Registration MS access table provides total information about the hotel includes Hotel name, place, Licensee number, etc.

H_Registration

H_Name

H_add

H_city

H_state

Licence_No

Type

Remark

Pincode

Ph_No

Fax_No

H_No

 

Hotel_Part_Det

Part_Name

H_Add

Cit

State

Pager_No

Per_Buss

Comment

part_no

Hotel_no

pincode

ph_no

fax_no

Mobile

Item Information table provides item names and numbers.

Item_Information

Item_Name

Item_no

 Item Stock table provides total Item stock, renew items, remarks.

Item_Stock

Item_No

Total_Stock

Re_Level

Remark

Purchase Item table provides item number, bill number, transaction type, transaction date, Total amount.

Purchase_Item

SNo

Item_No

Bill_No

Transe_Type

Paid

Transition_Date

 

Total_Amt

Last_Pay_Date

Check_Cash

order_qty

Receive_qty

 

Shop Information database table below:

Shop_Information

Shop_No

Shop_Name

Owner_Name

Address

Mobile_No

Fax

Remark

ph_no

 Wine dealer information provides below details:

Wine_Dealer_Information

D_COmp_Name

D_Add

City

State

License_No

Mobile_No

 

Pager_No

Fax_No

Remark

D_No

pincode

ph_no

 

Wine Item Order details below:

Wine_Item_Information

Item_No

Item_Name

company_Name

QTY

 Wine Stock details below:

Wine_Main_Stock

T_Stock

DT_Purchase_Ord

Sell_Price

Cost_Price

Remark

I_No

D_NO

BROKAGE

 Download Wine Dealer management System Project Database Tables.

Posted on

Society Resident Management System Project VB Source Code Download

Main modules developed for Society Resident Management System are login details for society members, monthly bill payments, generate reports for proper payments.

Here 1) Login details module contains username and password options to new users login into the society resident system. 2) Members module includes member code, member flat number, first name, middle name, last name, contact number, monthly maintenance charges. 3) Monthly bill payment module include billing month, member code, monthly payments, billing date. 4) Generate reports module includes receipt number, receipt date, payment method by cash or card, check number, recipient name recipient designation, amount, amount in words, paid per month, received on, bank name and finally branch name.

This Society Resident Management System more helpful for colony or society members to make their colony idle without any mistakes. This windows application written in Visual basic (VB) with MS Access database. Find the below sample source developed for different web forms to this system.

 

Posted on

Online Database Manager VB Project with Source Code

This Online Database Manager Visual basic Web application introduces a new way of making a database, which provides a grasped environment to all to create a rich data sector in an easiest way.  

Through this final year project users can easily make a new database, which provides a way to create a table structure. For accessing this site users have to register their identity to the corresponding page.

After that this site verify the authentication of the respective user, if he/she is an authenticated person then they can easily make their visualization into this site.

This allow the users to make a new table, creating many rows, altering the row which we are inserted, drop the row if it’s not required, and many more. Database tables stored in Microsoft Access database.

Posted on

Library Management System Project in VB with full Source Code

This post provides full visual basic (VB) Script source code for the Library Management System Project. Here VB code works for server side scripting validations and like be a windows based application.

The main advantage of this project is to useful for college libraries, school libraries for book management system.

The below added Vb code explains how Student details, Book details, Book Issue details, Admin book add and delete features, Library details. Database tables are stored in MS Access database.

 

Posted on

Cable Management System Source Code

We are providing VB Source Code for Cable Management System. Mainly this project useful for Cable operators in villages and Rural areas.

Computer Science Engineering Students can take this Cable Management System project as their final year mini project or major project to help cable operators and customers.

Reports Source Code for Cable Management System: