Category: Ms-Access projects

The Share Market System project training in a student’s life is like a live experience in the industry. So it is very essential part of the educational qualification. Post Graduation Diploma in Computer Application is the course offering me a unique change to find the place of utilizing computer in meaningful way. It provides me all the theoretical aspects with practical knowledge.

The project training in the 2nd Semester of the course gives me the exposure to the real world. The aim of the project training, by understanding a live project, is to have practical experience of the real world. It also clears the picture of practical field to prompt the students to develop their qualities talents, etc. So that I can expand our view about the implications of the theoretical knowledge in the practical field. we had the opportunity for the same at various Home appliances firm. The period of the trainings would be around one and half month.

Operating System    :  Window XP Service Pack-2
Language    :  Visual Basic 6.0
Backhand Tools    :  Microsoft Access 2k

SOFTWARE DEVELOPMENT -:: LIFE CYCLE ::-

Feasibility Study:-

The main aim of the feasibility study is to determine whether developing the product is financial and technically feasible. The feasibility study involves analysis of the problem and collection of the data which would be input to the system, the processing required to be carried out on these data, the output data required to be produced by the system, as well as study of various constraints on the behaviour of the system.

Requirement analysis and Specification:-

The goal of the requirement analysis and specification phases to clearly understand the exact requirement of proprietor and to systematically organise these requirement into a specification document.

Requirement analysis involve obtaining a clear and through understanding of the developed, with view to removing all ambiguities and inconsistencies from the initial client perception of the problem.

1.    Functional Requirements

The functional requirements of the system documented in the SRS document should Cleary described each function which the system would support along with the corresponding input and output data set.

2.    Non Functional Requirements

The non-functional requirements deal with the characteristics of the system that cannot be expressed as function.

It includes aspects concerning maintainability, portability and usability and also includes reliability issues, accuracy of results, human computer interface and constraints on the system implementation.

The Goal of Implementation :-

The goal of implementations a part of SRS documents gives some general suggestion regarding developments.

Design :

The goal of the design phase is to transform the requirement specification into a structure that is suitable for implementation. In some programming language. Through the design phase we can derive the software architecture from the SRS documents.

Coding and Unit Testing:

The purpose of these phase software development. During the implementation phase, each component of the design is implemented as a program module, and each of these program modules is unit tested, debugged and documented.

Integration and Testing: During this phase the different modules are integrated in a planned manner. The different modules making up a system are almost never integrated in a single shot.

Maintenance:-

Correct errors that were not discovered during the product development phase. This is called corrective maintenance.

Improving the implementation of the system and enhancing the functionalities of the system according to the Client’s requirement.

Porting the software to a new environment, e.g. to a new computer or a to new operating system.

Introduction:

It took us great to develop this software in Visual Basic as Front end and Access as Back end interface. This software is duly tested on different environment of hardware and software. The data security of this software is great as the data stored in various tables with unreadable characters.

This software provide various data such as Stock market Business, Stock information, the Balance details of the firm, Client personal Information, Script detail etc. It also provides data such as various Companies along with its Shares with specific code and type of the category.

The Bank Salary System is useful for the employee‟s of the branch and reduce the manual calculation and saves lot of time and will give precise answers for all the fields of earnings. The reports of pay slip, register and loans are also complete and accurate.

Front – end : Microsoft Visual Basic 6.0
Back – end : Microsoft Access 2000
Project duration : 200 hours approximately

ABOUT EXISTING SYSTEM
In the existing Bank Salary System the salary of the employee of the SBI branch is calculated manually. The staff of the branch is divided in three categories.
1.) Officers (Management).
2.) Award Staff (Clerical).
3.) Subordinate Staff.

The above-described categories are further divided in the following Designations.

1.) Officers (Management): –

i.) JMG (Joint Manager)
ii.) MM – II (Main Manager – II)
iii.) MM – III (Main Manager – III)
iv.) SMG – IV (Subordinate Manager –IV)
v.) SMG – V (Subordinate Manager – V)
2.) Award Staff (Clerical): –

i.) Clerk
ii.) Sr. Assistant
iii.) Special Assistant
 3.) Subordinate Staff :-

i.) Messenger
ii.) Watch Man
iii.) Record Keeper
In the existing Bank Salary System the calculation of the salary is done on the bases of Basic Pay of an employee according to categories of the employee.
The salary of an employee is mainly based on the Earnings and the Deduction. There are number of fields in the earnings and the deduction from the salary of an employee. The calculation of each and every field is mainly based on the Basic Pay of an employee. And some of the fields of earnings and deduction are maintained with fix amount according to the status, seniority, and post or according to the designation of an employee.

The Basic Pay of an employee is fixed according to the designation and seniority of an employee working in the bank. And calculations of other fields are done on some fix percentage of Basic Pay of an employee according to the Memoranda of Settlements.
In the existing system the calculation of the fields of the earnings and deduction is calculated manually. So while calculating the amount of each and every field manually the chances of errors and calculation of wrong values are always possible.
In the existing system the salary of an employee is done manually and the person who is doing the salary of the branch fills the amount of each and every field of earnings and deduction. The fields whose amount are fixed are directly written at proper place and the fields whose value is depend on the fix percentage of Basic Pay is calculate and then are written in the Pay Slip. So the person who is doing the salary of the branch has to first of all fill all the information of an employee like employee number, employee name, designation of an employee, grade of an employee, department, date of salary etc. and then has to calculate the value of each and every field and then total the all fields of Earnings and Deduction and by deducting the total of deduction from the total of earnings the net pay is calculated. Now while doing the salary of an employee the person also has to maintain the Register in which all the information of the salary of an employee is noted. Register is maintained for the purpose of keeping the record of each employee for calculation of Income Tax and for the calculation of Provident Fund etc.
As mentioned above the salary of all employee of the branch are calculated with large calculations, manpower and handling of the large documents with chance of having lots of errors and time consumption.

PROBLEM IDENTIFICATION

Drawbacks of existing system.

1.) Register Maintenance.
2.) Time Consumption.
3.) Pay Slip Preparation.
4.) Problem In Calculating Income Tax.
5.) Problem In Calculating the amount of Loans.
6.) Calculating the field amount.

1.) Register Maintenance: –

At the time of calculating the salary of the branch the register is also maintained and a person who is doing the salary has to copy all the amounts of fields in the pay slip from the register.
A register is maintained for whole year and the salary of each employee is noted in the register. So if an employee wants to know his salary of previous month he/she has to refer the whole register and find his/her employee number from the register, the particular month he/she wants etc. and then he/she will be able to get the salary record. Now if he/she wants the copy of the salary slip he/she has to manually write the whole pay slip. Now there is also problem of storage of all the registers, because there are so many factors by which the registers can be destroyed like fire, water, stolen, etc.

2.) Time Consumption: –

The process of calculating the amount of each field whose value is depend on the basis of percentage of basic pay is very much time consuming and it is having lots of calculations.
If an employee wants more than one copy of the pay slip then also it will take lots of time for preparing another copies of the pay slip. The process of calculating the salary of an employee is very much time consuming and boring for a person who is doing the salary of the whole branch.

3.) Pay Slip Preparation: –

As mentioned above the process of register maintenance, and then the pay slip is prepared from the register is very much time consuming and the chances of errors and mistakes is always present.

4.) Problem In Calculating Income Tax: –

The employer is required to deduct income tax from the salary paid to an employee. The income tax is calculated based on gross salary paid to the employee during a year, if it exceeds a limit. Because of the manual system the calculation the income tax amount become very difficult and time consuming.

5.) Problem in calculating the amount of Loans: –

The handling of the loan amount and the calculation of loan amount is very difficult and time consuming in the existing bank salary system. The problems with the handling of loan amount is that sometimes the amount is wrongly written by the person who is doing the salary, the employee has to pay more amount from his/her salary.

6.) Calculating the field amount: –

The calculation of the field amount of the earnings and deduction is very hard and time consuming when the field amount is based on the basis of the fix percentage of the Basic Pay of the employee. The chances of errors and mistake are very much in the existing bank salary system.The above described are the drawbacks of the manual bank salary system with makes the process difficult, time consuming and very hard for the person who is doing the salary of the branch and is also not beneficial to the employees of the branch

PROJECT SPECIFICATION:

Multi Chain Market Monitoring deals with the processing of accessories rates and product maintenance with the three data files to store data permanently. The user should maintain two databases about the customer and products. The customer database consist of customer code, customer name, address, city are the fields. In product database product code, product name, quantity in hand, price of item are the fields. It has a capability to display all the details in a tabular format.

VALIDATIONS:

–    Customer number shouldn’t repeat.
–    Make sure to save the details of customer after input.
–    Supply customer code to modify the customer records.
–    Restrict unauthorized usage of product details.
–    Make ensure that update the stock when it is purchased.
–    Confirm update of product details.
–    Make sure that customer code is registered.
–    Make ensure the product code is valid while selling product.
–    Allow the user to get discount if he is valid.
–    Discount criteria

PROJECT DESCRIPTION

Sales automation system deals with the purchase, billing system of sales and stock availability information. In this system we have maintain three files, which will store information permanently. The three files consist of customer, stock, transaction information. We can retrieve data when we need of those files. When the purchase transaction done by the user, automatically this information will adds to stock data file. If the sales transaction made by the user then the stock and customer data will get updated. According to the transaction in the sales the stock record should be updated. It doesn’t mean that it should obey the business rules, which are standard. Simultaneously the transaction data file gets updated according to the transaction.

Customer information is maintained with all details about name, address, and customer number. Product information maintains details about product code, product name, quantity available, and amount of product. Transaction information consists of sales and bill of product. Each and every screen has an option to come back to previous screen from where the screen came.

In the first screen we have three options of customer, product, transactions options with the input cursor, which is waiting for any one of these four. Where the fourth option is to come out of the project.
When you get into the customer option it will take to select the options to register a new customer. When you select it, the user has to fill up all the details about the customer. The user can continue this process up to

when the user gives input as no to continue. The second option is to list all the customers in a tabular format who are all registered early. It gives with all information about customer. Third option can be used to modify the customer record. The user should know the customer number to modify his details. When the customer is not available with the given number, it gives a message that the customer is not available. Next option deals to delete the unwanted customer details to reduce the size of the data file. If it doesn’t find the details about the customer, it gives a not found message. At last we return to the main screen when the user selected the corresponding option.

When you get into the customer option it will take to select the options to register a new customer. When you selected this option, the user has fill up all the detail about the customer. The user can continue this process up to when the user gives input as no to add user.  The second option is to list all the customers in a tabular format who are all registered early. It gives with all information about customer.

Third option can be used to modify the customer record. The user should know the customer number to modify his details. When the customer is not available with the given number, it gives a message that the customer is not available. Next option deals to delete the unwanted customer details to reduce the size of the data file. If it doesn’t find the details about the customer, it gives a not found message. When user want to turn back after fulfillment of requirements he has to tap enter key.

If user wants to get into the details about products he has to select product maintenance option from main menu. But it’s restricted. By giving password the user can enter into options available about products. Product menu consist of five options. To add a new product details we have an option called new product details. The user has to input for product code, product name, and quantity on hand, price of individual item.

The user should take care not to repeat the Product code. Is it so, the cursor won’t allow filling the next field information. This option allows storing data about product. It allows adding many products continuously. The next option gives the list of products available in the store in a tabular format. To modify any details of products select ‘Modify the Product details’ option from the main menu of products.

The user should enter the product code, which he wants to edit. When the user gives conformation about the modified information the data will be stored in the disk permanently. To delete an unnecessary product details the user has to select ‘Delete Product details’ from menu of product. User should supply the product code. The deletion will be confirmed when the ‘deletion completed’ message displays else ‘product not found’ message will be followed. To get back to the screens where the user came from, select ‘Back’ option. When user want to turn back after fulfillment of requirements he has to tap enter key.

The third option in main menu is transactions. It consists sales and bills. The members of the Multi Chain Market only can purchase products. The non-member of market is trying to purchase the goods it gives a message to register you. This menu allows the user to buy several products. If the product is out of stock the user may know by ‘quantity on hand’ option. It displays availability of stock.

To get total bill of purchased products get back to transaction menu and select bill option. It gives the total amount. If the customer is allowed to give discount that amount will be subtracted from total amount and net amount be on the screen.  When user want to turn back after fulfillment of requirements he has to tap enter key.
Conclusion:
The automation of Multi Chain Market monitoring is very helpful to maintain data and reduce the time while comparing to manual operations. It improves accuracy. It’s compatible and platform independence. The program can be executed at minimum system requirements also. The project consists of user-friendly a screen that is helpful to the user with out taking any assistance of skilled person.  I hope that this project will help the users and benefit from it immensely.

ABSTRACT:

The allotment of houses for various people is due for automation. There are various data that are maintained. One of them is the employee detail. The various details include the code, the dress, the designation, name the confirmation data and the retirement date etc. there are also details like the various grades and designation that are maintained.

The employee has to request forma quarters and the various details are maintained. The details of allotment of the quarters are also maintained. The details of the persons occupying the quarters are also maintained. Once the above details are automated then the allotment is considered to be completed.

SYNOPSIS

The system provides an easy way to perform computer based testing for small computer firms. It also helps to allotment  of  houses to the employees. This system will be customized according to the clients requirements and will be installed for them. This also focus on to allot the houses depending upon their grades quickly and efficiently.

Managing the activities while allotting the houses is not an easy task to allot the houses if  the no.of  employees is more and the no.of houses is less. if the no.of employees is more and the no.of houses is also more, then it is tougher to allot houses and maintain records manually.

In case of employee details , many activities such as collecting the employee name , employee id , address, grade ….etc. by using this employee details we can allocate houses to them quickly and fastly.

Thus the project house allotments was successfully completed.this software is fully functional and operational. since, this project is implemented using VB 6.0, it provides a more direct and easier way to allotment of houses. This project is very flexible and that are lot of provisions made for the future enhancement of this project.

The project entitled “SALES ORDER PROCESSING” has been designed and developed for any Electrical and Electronics Enterprises or any other.

The main aim of this project is to computerization of daily activities in the enterprise. It is a database system for creating a selective related information, for subsequent analysis manipulation and application.

This project contains several modules to record the details about the Product, Customer details, Order details and Bill details about the goods which the Customer has purchased from the enterprise. And it maintains the reports about the Products, Customers,Orders and Bills. This project is very useful to sale the goods in any enterprise.

The project entitled “SALES ORDER PROCESSING” has been designed and developed for any Electrical and Electronics Enterprises or any other.

The main aim of this project is to computerization of daily activities in the enterprise. It is a database system for creating a selective related information, for subsequent analysis manipulation and application.

The system has different modules for various activities. The various modules of the system are recording of new products(addition,modification,deletion), maintaining the Customer details, maintaining the Order details from the Customer and recording the Bill details of goods which was purchased by the Customer.

Basic

Each module is designed for each activity that should be recorded every time. Using this system the management can record easily and stored in the database. Retrieving the old records also made easy in this system. So that the management can retrieve the records and make use of them.

The database system is developed perfectly which does not allow the user to enter the wrong data hence it facilitate the management. This database management is developed for retrieving records with correct records so that it is reliable. Implementation of this system requires the use of computers with most versatile system. Hence, this software is developed on MS-Windows platform using Visual Basic 6.0

The SALES ORDER PROCESSING is developed for the daily sales that are going in the particular firm or an Enterprise.

The major kind of transactions that are being carried in SALES ORDER PROCESSING are

• PRODUCT DETAILS
• CUSTOMER DETAILS
• ORDERS DETAILS
• BILLS DETAILS
• REPORTS

PRODUCT DETAILS :-

Pcode,desc,companme,capacity,cost,items_available

CUSTOMER DETAILS :-

Ccode,cname,addr,phone,pin

ORDER DETAILS :-

Ordno,order_date,customer_code,pcode,company_name.quantity_ordered,amount

BILLS DETAILS :-

Receipt_no,order_no,receipt_date,type(cash or cheque),amount_paid,

discount,total_amount,cheque_no,cheque_date,bank_name

SOFTWARE ENVIRONMENT:

FRONTEND                  : VISUAL BASIC

BACKEND                    : MS ACCESS

REPORTS                     : DATA REPORTS

This project “STOCK MAINTENANCE SYSTEM”  has been developed for the computerization of the  handling stock of a product.  This project mainly deals with the items, suppliers, sales, purchase basis. The project get all the details about the items stock and how many the product have sold and purchased.  This makes the manager manage the product easily and can retrieve the information easily.

The main goal of this project is to reduce manual works, increase the processing speed and ensure reliability of data. This project “Stock Maintenance System” deals with stock Management in a concern. This project also takes care of maintaining records of all the sales details, purchase details of the concern.

Various reports are generated based on the requirement of the concern, reports will present the management with the current position of the company. The project will be a efficient tool for the company and it will aid in the improvement of the company.

OBJECTIVE OF THE STUDY

The various phases in the study are  the Introduction, System Analysis, System Design, Testing and Implementation.

Introduction Phase deals with the overview of the project, objective of the study organization profile and the chapter scheme. System Analysis lists the existing system in the company and the  system  proposed in the project.

System design lists the logical structure of the project along with the flow of data for each form. The various input forms and the output forms along with its needs and uses are explained.

Code design and its uses are listed.

Item Details:

  The item Module deals with information about the details of the product that the concern handling.  It consist of details such as the name of the product, id generated, quantity, cost, etc.  This information is retrieved during the sales and purchase of a product.

Supplier Details:

The Supplier Module deals with the information about the details of the suppliers giving product to the organization.  It consist of details such as supplier name, address, email id, Phone number, sales tax number etc.  This information is retrieved when a Purchase is done

Purchase Details :

The purchase Module deals with various item name, supplier name, quantity of the product. Color of the product, amount per unit etc

Sales Details:

The Sales Module maintains daily sales of the product of the organization.  It consist of details such as the item name, sales id,  quantity, amount etc.  This information is retrieved from the database when a sales detail report or view activity is made by the concern.

OBJECTIVE OVERVIEW

The first is the study is the Introduction Part, which contains the Overview of the Project and the Objective of the Study along with the Introduction about the Company and the Chapter Scheme.

In the Overview of the Project the various  modules in the project are explained with its needs and uses.Introduction about the Company explains the various activities that are involved in the company.

System Analysis explains the current system which is followed in the company before implementing the project, the drawbacks of the current system is analyzed and the proposed system is build in a way that the problems which are faced in the existing system is eradicated.

System Analysis also lists the various hardware and software requirements that are needed to implement the project.

System Design is a phase which explains the logical structure of the project. Data flow diagram is a action oriented process which explains the flow of information for various  forms.Input design lists the various input forms in the project and the  need for the input form. Output design lists the various output forms in the project along with its needs and uses. Output form also lists the various reports that are used in the project.

Coding design is used to emphasize the need and uses of coding.

SYSTEM SEPCIFICATION

EXISTING SYSTEM 

            The system, which is followed at present, is a manual system.  The system consists of Book Of Accounts that has to be maintained in all aspects. Printing work are difficult.  In the existing system each and every time a reference should be made manually.  There are high possibilities to commit errors and mistakes, which leads to produce the wrong statements to the management.  Report generation  is also not an easy task.

Another important drawback of existing system is time factor.  It will not help the management to solve the problem in time.  The management could not act on any issue purchase of production unless getting the reports in time controls cannot be used.  The above said reasons are overcome by using the Visual Basic 6.0.  Since the security system in this package is more secure than other software packages.

DRAWBACKS OF THE EXISTING SYSTEM

• Manual work.
• Security of information is low.
• Time consumption.
• High Manpower.

SOFTWARE SPECIFICATION 

FRONT END                         –             VISUAL BASIC

BACK END                           –             MS ACCESS

Computerization has become a backbone for today’s world.  It completely changed the manual system in all fields of work.  The change comes out to be very interesting and saving as it helps in storage of data early and efficiently and also helpful in retrieving.

The  project  titled  as “SALES AND SERVICE MANAGEMENT”  was  developed  in  VISUAL BASIC  as  FRONT-END  and  MICROSOFT ACCESS  as  BACK-END

The  main  objective  of  the  project  is  to  mark  required  activities  under

computerization. The  project  holds  to add the details in the software.

1. SALES ENTRY (BILLING) 
2. SERVICE ENTRY (BILLING) 
3. VEHICLES DETAILS              
4. CUSTOMER DETAILS

The Jaya Auto Mobiles is authorized dealer for Bajaj Company so we need to develop the software for using all-purpose to maintain the company. In this software has contains more options to easier use.

PROPOSED SYSTEM: 

Aim

The proposed system is a user-friendly software (GUI) that requires less knowledge incase of the new user, since it requires less or no use of the keyboard entry.  It just involves selection from a list of possible items and selection of menus.  The program requires less coding and the output (report) generation is much simpler and requires less coding.  The data are stored in the database under the system and is easy to retrieve. 

Benefits

The speed of operation can be increased with less time in data input and retrieval.  Being the recent software with existing GUI facility updating or working in future environments becomes easy and functioning in the networked environment is also easy.

It requires less alteration and flexible in case of the database.  The database used is of flexible and reduces redundancy and setting of constraints becomes one of its advantages to its predecessor.  The speed of calculation is also faster.  Data protectively is efficient when compared with existing system.

CONCLUSION

The  system  developed  under  windows  98   using  VB.    It maintains its entire  database  using  MS ACCESS . the  special feature of this software is the generality and it can be worked on any low configuration personal  computers since the menu gives the clear understanding, it is easy to use.

We are very sure that, this software will be very useful for share viewers to use  this software there is no need of knowledge about operating system. Training on moving the mouse and less English knowledge is enough to operate the system. Modifying design at any time can enhance the system. And there is no need to change the code when we want to modify it. new controls can be added to system. This software does not require any manual guidance.

This system has been developed after a detailed investigation of the existing system. this package has developed so as to reduce the strain on the end-users and it is capable of incorporating any additional requirement.

This project computerizes the various processes that are performed which would help a long way in storing, accessing and retrieving information within a short time. The modules are created in a user-friendly manner for easy access. using this system the stored information I the database will be used for future references. The reports are generated required by the company and the system helps they department by reducing erros, time and manual work. At last we say that this software is less expensive and user-friendly.

SOFTWARE REQUIREMENTS

Front End Tool           :           Visual Basic

Back End Tool            :           Access