DESIGN AND IMPLEMENTATION OF A CUSTOMIZED BUSINESS MANAGER

ABSTRACT

This project focused on the design and implementation of a customizable business manager that can drive the activities of any small/ medium business. Most of such businesses usually lack the financial strength to initiate the development of a business management system from scratch. For such business to automate their activities, what they require is a customizable business management system such as the one implemented in this project. The project involves creation of a database for business enterprise. It took the following in to consideration; database design and connectivity, prototyping and reporting tools like crystal report or ms access reports, graphics user inter-phasing (GUI) and customizability. This project is aimed at building a system that can fit into the day to day business activities of any small/ medium organization .Visual basic for application (VBA) will be used as the implementation language and platform.

TABLE OF CONTENTS

Title ﾿ i

Certification ﾿ ii

Dedication ﾿ iii

Acknowledgements ﾿ iv

Abstract ﾿ v

Table of Contents ﾿ vi

List of Tables ﾿ vii

List of Figures ﾿ ix

CHAPTER 1: ﾿ INTRODUCTION ﾿ 1

1.1  ﾿ Statement Of Problem ﾿ 2

1.2  ﾿ Objective                                    ﾿ 2

1.3  ﾿ Significance Of The Study ﾿ 3

1.4  ﾿ Scope And Limitation  ﾿ 4

1.5 ﾿ Background Of The Case Study    ﾿ 4

1.6  ﾿ Definition Of Terms ﾿ 5

CHAPTER 2: ﾿ LITERATURE REVIEW ﾿ 7

2.0  ﾿ Literature Review ﾿ 7

2.1  ﾿ Theoretical Scope ﾿ 8

2.2  ﾿ Business Management Today ﾿ 10

2.3  ﾿ Stock Control ﾿ 10

2.4  ﾿ Payroll ﾿ 10

2.5  ﾿ Accounting ﾿ 11

2.6 Personnel ﾿ 12

CHAPTER  3:  ﾿ RESEARCH METHODOLOGY, SYSTEM INVESTIGATION AND ANALYSIS  ﾿ 13

3.0  ﾿ ntroduction ﾿ 13

3.1  ﾿ Research Methodology ﾿ 13

3.2  ﾿ Method Of Data Collection ﾿ 13

3.3  ﾿ System Investigation ﾿ 15

3.4  ﾿ Fact Finding ﾿ 15

3.5  ﾿ Presentation and Discussion of Finding ﾿ 15

3.5.1 ﾿ Questionnaire Presentation ﾿ 16

3.6 ﾿ Analysis ﾿ 23

3.7  ﾿ System Analysis ﾿ 24

3.7.1  ﾿ Hierarchical Portioning ﾿ 24

3.7.2  ﾿ Overview Model Of The System ﾿ 26

3.7.3  ﾿ Entity Relationship Model ﾿ 28

3.8   ﾿ Developing An Entity Relationship ﾿ 28

3.9  ﾿ Choice Of Programming Language ﾿ 29

CHAPTER 4:  ﾿ SYSTEM DESIGN AND IMPLEMENTATION ﾿ 31

 4.0  ﾿ Design Of The System ﾿ 31

4.1   ﾿ Database Design ﾿ 31

4.2   ﾿ Procedural Design ﾿ 34

4.3  ﾿ User Interface ﾿ 41

4.4  ﾿ Architectural Design ﾿ 48

4.5  ﾿ System Implementation ﾿ 49

4.6  ﾿ Implementation Of System Design ﾿ 50

4.6.1 Implementing Overview Module ﾿ 51

4.6.2 Implementing Personnel Module ﾿ 53

4.6.3 Implementation Of Stock And Inventory Module ﾿ 56

4.6.4  ﾿ Implementing Sales Module ﾿ 58

4.6.5  ﾿ Implementing Security Module ﾿ 60

4.7  ﾿ System Testing ﾿ 64

4.7.1  ﾿ Unit Testing ﾿ 64

4.7.2  ﾿ Integration Testing ﾿ 65

4.7.3  ﾿ Discussion Of Results ﾿ 65

4.8  ﾿ System Documentation ﾿ 65

4.8.1  ﾿ Internal Documentation ﾿ 66

4.8.2  ﾿ External Documentation ﾿ 66

CHAPTER 5:  ﾿ SUMMARY AND CONCLUSION ﾿ 67

5.1  ﾿ Summary ﾿ 67

5.2  ﾿ Conclusion ﾿ 70

REFERENCES

APPENDIX A ﾿ Source Code

APPENDIX B ﾿ Screen Shot

LIST OF TABL

Table 1:  ﾿ Response to Manual Business Organization ﾿ 16

Table 2:  ﾿ Responses to Research Question II ﾿ 18

Table 3:  ﾿ Suggested Measures to Reduce Problem ﾿ 19

Table 4:  ﾿ Major Constraints ﾿ 21

Table  Responses ﾿ 22

Table 6:  ﾿ Product Table ﾿ 32

Table 7:  ﾿ Staff Table ﾿ 32

Table 8:  ﾿ Payroll Table ﾿ 33

Table 9:  ﾿ Invoice Table ﾿ 33