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