Center Name Wiltshire Secondary School

Center Number 030718

Candidate Name Gambiza Albert

Candidate Number 5006

 Table of contains
Contents pages
Appendices 1……………………………………………………………………………………………2
Appendices 2……………………………………………………………………………………………4
Section A……………………………………………………………………………………...………..6
Problem and background analysis…………………………………………………………..…………..7
Investigation of the current system…………………………………………………………..………….8
Feasibility study………………………………………………………………………………………...16
Requirements and specification…………………………………………………………………..….…18
Aims and Objectives………………………………….………………………………………………...19
Evidence that the research has been carried out………………………………………………..…….…20
Section B……………………………………………………………………………………………......21
Consideration of alternative methods…………………………………………..………………………..22
Input design…………………………………………………………………………………………….25
File design…..……………………………………………………………………………………..…….30
Overall plan……………………………………………………………………………………………...32
Output design…………………………………………………………………………………………….33
Testing plan……………………………………………………………………………………………...34
Section C………………………………………………………………………………………………...35
Technic that improve the structures and appearance…………………………………………………….36
Technical documentation………………………………………………………………………………..39
User documentation…………………………………………………………………………….………..47
Section D…………………………………………………………………………………………………48
Testing……………………………………………………………………………………………………49
Evaluation of the system…………………………………………………………………………………52

Page 1 of 53
Appendix 1

Page 2 of 53
Page 3 of 53
Page 4 of 53
Appendix 2

Page 5 of 53
Page 6 of 53
Page 7 of 53
PROBLEM IDENTIFICATION AND BACKGROUND ANALYSIS
Diamond pharmacy is a company which has ventured into medication services like pills, optical
services, drugs, plasters, clashes, wheel chairs, and any form of medical help that someone would
need. This company is located in Chivhu town at number 37 York Street and has been existing for
5 years since 2013. For all these years the company has been using a manual system whereby all
recordings and operations of the company are manually driven. The system is user friendly and
easy to use, but has caused some problems to the company.

The system has caused voluminous work to the users leading to a lot of arithmetical errors,
omission of essential information, some of the work may be illegible since some users work under
pressure and also they would need to share the information yet one can find it difficult to read
one`s writing.

Large piles of files are becoming difficult to store since there is a shortage of space, leading to
misplacing of some sheets of papers hence loss of essential information.

The paper system does not have a reliable backup of files since in a risk of fire outbreak they may
definitely be burnt to such an extent that there will be total loss of records used and essential
information like debtors who owe money to us. The older files are now being messed up and even
eaten by rats that are found within the company premises. The rats are eating and tearing some
pages therefore causing loss of essential information.

All the information is not secured since anyone can open the files whenever he or she gets the
opportunity or some space. This system provides a poor retrieval method which causes
inconveniences in case of a query or emergences like the issues of misplaced documents and in
case of a fire outbreak.

Page 8 of 53
INVESTIGATION OF THE CURRENT SYSTEM
Investigations have been carried out on the current system at diamond pharmacy to provide the
problems stated on this system. This was also done to investigate if it is vital to change the current
system or continue with it. Below are some of the research instruments which I have used and the
data analysis of the system:

Data analysis using FLOW CHARTS

Customer
use Bank
transfer
Supplier 1 Selling

Buying

Point of
Pharmacy Registering all products sell (POS)

Supplier 2

Selling Buying

Customer
use cash

Page 9 of 53
Research instruments
Observations

The first observation I made was torn pages of books that where in a file. Some handwriting in
those files was illegible. Some work was dirty meaning there were spoils on some pages. There
was shortage of space to keep some important files. I also observe that data is lost due to tearing
of papers. It is difficult to find the file that you search for. There is no backup of data when the
data is lost. They do not have ways of preventing data loss for example the use of fire extinguishers.
The system they use is very slow if you want to search for person’s details.

Questionnaires

A document with carefully crafted questions to be answered by the respondent by filling

on the spaces provided. Questionnaires are used when collecting information from a widely
spaced population sample and when collecting information from many people.

Justification of using Questionnaires

1. Effective when collecting a lot of data

2. Questions are very simple to answer.
3. It saves time as questionnaires can be distributes and then collected later.
4. Respondents can fill questionnaires at their own pace.
5. Give guarantees confidential of information, thereby encouraging respondents to give
accurate information.
6. They are cheap to use as travel expense can be low

Page 10 of 53
Preliminary investigation of the current system
Questionnaire

1 What are the problems faced with the current system?

…………………………………………………………………………………………………………
…………………………………………………………………………………………………………
………………………………………………………………………………
2 In your own view, which solutions can be put across to solve the problems?
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
…………………………………………………………

3 How many users are affected by the current system?

Page 11 of 53
 5 4 3 2 1 none of the
given

4 Do you think the system is still viable, if not why?

Yes no

……………………………………………………………………………………………………
……………………………………………………………………………………………………
………………………………………………………………………………

5 Which system would you prefer if there is an option of changing the current one?

……………………………………………………………………

6 Which advantages can you put across to support your suggestion on the above question?
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………
……………………………………………………………………………………………………

7 Why do you think your suggestion in question 6 will be socially feasible to the local people?
………………………………………………………………………………………………………
………………………………………………………………………………………………………
……………………………………………………………………………………………………

Page 12 of 53
 7 how many minutes does it take to serve a customer?

30 20 10 less than given

8 Are all transactions recorded including sales and wages?

Yes no

9 Does the current system have enough backup of the system?

Yes no

Page 13 of 53
Interview guide

This refers to the face-to-face communication between two or more people in order to
obtain information.

Justification of using interview guide

1. Effective when gathering information about a system

2. The researcher can ask for clarification on some points that may not be clear. Encourages
good rapport between the researcher and the respondent.
3. Non-verbal gestures like facial expressions can help the researcher to determine if
the respondent is telling the truth.
4. Information can be collected even from the illiterate since the respondent’s language could
be used.
5. First-hand information is collected.

6. The researcher can probe to get more information.

Page 14 of 53
INTERVIEW GUIDE
1 When was the Company (pharmacy) established?
15 years ago 10 years ago 5 years ago

2 Which system are you using?

……………………………………………………................................................................

3 What are the benefits of using the current system?

……………………………………………………..................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.........................................................................

4 What are the problems faced when using the current system?
……………………………………………………..................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.........................................................................

Page 15 of 53
5 How many workers are using the current system?
…………………………………………………………

6 Should the current system remain in use, after we computerize you system

Yes No

Justify your suggestion you answer

………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
……………….

7 Are there any possible solutions to the problems caused by the current system? What are
they
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………
8 Do you think the company will be able to meet all requirements of the new system?

Yes No

Why do you say so?

………………………………………………………………………………………………………
………………

Page 16 of 53
Problem with the current system
1. Shortage of space, which lead to misplacing of same papers.
2. The system does not have the back up of files.
3. The older files are now missed up and even been eaten by rats that are found in the company
premises, cause loss of essential information.
4. The system does not secured data since everyone can open files whenever he /she can get
opportunity or some space.

FEASIBILITY STUDY
A preliminary investigation has been conducted at the diamond pharmacy to determine if there is
need for a new system or modification on the existing one. I have done this on behalf of the analyst
to examine whether a new system is feasible or not. Through assessment of this problem, I have
decided on what is required of the new system involving the evaluations of the two systems and
request from the users to determine if it is feasible to construct or implement a new system. Various
measurements which are as below have been used in this preliminary investigation.

Economic feasibility

Economically I have investigated and discovered that the new system`s benefits will outweigh the
costs involved in developing, purchasing, installing and maintenance of the new system. Tangible
and quantifiable benefits will be obtained such as profits in monetary value to the company, the
new system have fewer processing errors, increased production since use of machines (computers)
will be faster than sue of manual method and also the response time of the system will be increased.

Technical feasibility

Page 17 of 53
This investigation has been carried out to determine if the organization (diamond pharmacy) could
obtain all the software, hardware requirements such as the operating system, monitor, mouse,
processor, RAM and bar code reader, also the equipment such as furniture, technology (know-how
of the system) and personnel to develop the system and operate the system efficiently. All this
have been made successful and proved as being possible to be done and achieved.

Schedule feasibility

Calculations as estimations have been done to find out how long the system will take to develop,
considering the desired time frame which is about two weeks.

Social feasibility

The social feasibility will help me to assess if the system will be acceptable by the local people,
considering their values or norms in the society. It involves testing if the people accept the new
system. The society here includes the workers of the company since they are the first people to be
tested on the new system. If members of the community do not accept the change this means, there
will be need to convert back to the old system. Therefore if the system is acceptable then I will
proceeds with the implementation of the new system.

Legal feasibility

A legal feasibility would be carried out to determine whether the new system will not violet the
legal requirements of the state, for instance, laws outlined in the data protection Act. Therefore the
pharmacy would use the system if there are no rules violated.

Operational feasibility

A study as operational feasibility will help in confirming whether the current work practices and
procedures are adequate to support the system for effect on social lives of those affected by the
system. Under this feasibility I will also be concerned with social factor such as how the
organization change will affect the working lives of those affected by the system. Therefore the
system must not be violating to the requirements of the operational feasibility.

Page 18 of 53
REQUIREMENTS SPECIFICATION
User
The diamond pharmacy will require two system users that are shopkeeper and manager.

Software
An operating system of windows 7 is required for each user.

A temporary storage RAMS of 256Mband a computer software memory of 80 GB for each user.

Total security as antivirus.

VB.Net 2012

Word processing 2010

Microsoft access 2010

Hardware
256 RAM is need

A processor (Pentium IV processor)

Bar code reader

Printer

AIMS AND OBJECTIVES

Aims

Page 19 of 53
These are long term objectives that the system needs to archive

The main aim of the diamond farmers is to change current manual driven system into a computerize
system that is more efficient and easy, reducing voluminous work. Introducing the system will
help in reducing arithmetical errors which will cause total confusion in the company and this aim
to be accomplished? The pharmacy is at providing a wide range of medication that will be kept in
and updated where deduction or updates should be made.

Objectives

These are short term purposes that the system need to archive

Diamond pharmacy wish to achieve better system which is fast and serves customers quickly.
Security measures are to be improved thereby keeping in watch of any theft or vulnerability that
may occur and if customers are taken care of.

EVIDENCE THAT THE RESEARCH HAS BEEN CARRIED OUT

Page 20 of 53
I carry the research the company. I give the seller of the company some question to answer. Some
of the questions are shown at the appendices, at the top of this book lat. I also use interview guide
to observe the data. The evidence is shown again on the appendices.

Page 21 of 53
Page 22 of 53
CONSIDERATION OF THE ALTERNATIVE METHODS
Introduction

I have chosen one solution from three possible solutions that i had for system development. The
three solutions are:

a) Improving the current manual system

b) Off the shelf package
c) Bespoke software

Possible solutions

a) Improving the current manual system

This involve the removal of some features on the current system or / and addition of some of the
computer related features to improve the current system.

Advantages

1. It is less expensive since few stationery is needed to be used.

2. Better results are reduced.
3. It reduces time taken to carry out calculations and tiresome tasks are reduced.
4. It improves pile security

Disadvantages

1. There is need for training users of the system which might be an extra cost to the
organization.
2. Paperwork is not eliminated.
3. Current users might be dismissed due to lack of some skills and qualifications.
4. The system may not function well hence a cost to the organization.
5. Workers may resist the implementation of the system which leads to failure of
computerization.

Page 23 of 53
Off the Shelf package

It involves the purchasing of a ready-made software package from a software supplier and installs
it right away.

Advantages

1. Paperwork is reduced
2. Efficient backups are introduced
3. Information is made available quickly
4. The software package can be installed right away.
5. Training may be provided from different providers of common software for free.
6. The software can be integrated with the existing software.
7. User can consult other users of the software to hear their views before sending money.
8. The software is well documented.

Disadvantages

1. The software is expensive to buy.

2. The software may contain a lot of unwanted features.
3. Some training may be required which is an expense to the organization.

Chosen solution

Bespoke software

It includes the hiring of an expert to design software that best suits the user’s request.

In this case l will be designing the system by myself.

Advantages

1. Results in reduced duplication of effort.

2. Paperwork is reduced since information is stored on disk.
3. Adios reports are easily provided.

Page 24 of 53
 4. Searching facilities are provided.
5. The software to be produced has no unwanted features.
6. Master files are easily updated and efficient backups are provided.
7. Better securities are provided.
8. The software is made according to the user’s specifications.
9. The software can be designed to run on any specified hardware.
10. The software can be integrated with the existing software

Disadvantages

1. High possibility of data loss.

2. High chances of the system of suffering from bugs.
3. It is expensive to develop own software.
4. The software is not tried and tested.
5. The software is not well documented.

Reasons for choosing bespoke software

1. I have chosen the bespoke because it provides me with many benefits which enable the system
which I will work to be great.

2. Another idea which provokes me to choose it is that bespoke is upgraded software and it is
easy to edit and update rather than other software.

3. Bespoke software provides the system with much easy software.

4. The software have unlimited features which enable me to perform many different tasks that I
need to do.

5. The bespoke software provides me better security since the hired export installs everything
that he thinks will keep me safe and protected.

6. The software is made according to my user`s specification.

7. The bespoke software is designed to run on specification hardware.

8. The system provides searching facilities.

Page 25 of 53
INPUT DESIGN
Data capture forms

Input Form

The input below shows how we add the suppliers for the first time. The form contains the supplier
code, the name, the adders, email and the phone number. To add the supplier “click” add supplier.
To remove “click” clear. To cancel “click” exit.

Product register
Page 26 of 53
The form below shows how we add the products for the first time. The form has the following
aspects product code, product name, and supplier code, cost price, mark up and the selling price.

The order details

Page 27 of 53
The input below show how to enter the order details. The input has the following aspects the order
number, supplier code, supplier name, product code, product name, cost price, quantity, total.

Goods Received Voucher

Page 28 of 53
The input of the goods received voucher is shown below. It has the following details order number,
supplier name, product code, product name, cost price, quantity and total.

Screen layout

Page 29 of 53
Splash screen

Main mane screen layout

Login form

Page 30 of 53
FILE DESIGN
Involves designing tables/files, records and validation rules. It also involves determining

how data is to be stored and accessed, the media to be used for storage and the mode of
file organization.

Orders file

The product file

Page 31 of 53
The sales file

The supplier file

The user file

OVERALL PLAN

POINT OF SALE
Page 32 of 53
 MAIN MENU
V

REGIST SALES PRODUCT

PROCCESS SELLING LOG OFF EXIT
ER PRODUCT REPORT

SUPPLIER PRODUCT

PURCHASE
GVR ORDERS

OUTPUT DESIGN

Page 33 of 53
Products reports

The product report register shows the list of product that has been registered. It consists of the
code, stock name, supplier code, supplier code, cost price, On Hand Qty.

Sales reports

This is the report which shows the product been sold. It consists of product name, sold QTY,
selling price, total sales, Trans NO., Trans date.

TEST PLAN

Page 34 of 53
 a. Testing for the goods received voucher
If you enter the wrong details then the dialog box will told you that you are entered the
wrong details.

b. Testing of how will add the suppliers

If you end a string instead of an integer then a dialog box should warn you on what is supposed
to be done

c. Testing on how to exit the supplier registration form

If you want to exit the system will ask you “are you sure you want to exit” if you are then
click “yes”

d. Testing for the products supplied by the supplier

If you enter the wrong product code the system will told you that, the product you rare
search for is not there.

Page 35 of 53
TECHNIC THAT IMPROVES THE STRUCTURE, APPEARANCE
CLARITY OF THE CODE THAT IS

Page 36 of 53
Procedures
'CALLING THE clear PROCEDURE TO CLEAR ALL THE TEXTBOXES IN THE GROUPBOX1
clear(GroupBox1)
txtProdCode.Focus()
lblSupName.Text = ""

Functions
'Function to calculate the Order Number
Function LoadOrderNum() As Integer
connection()
conn.Open()
MyDataTbl = New DataTable
MyDatAdp = New OleDb.OleDbDataAdapter("Select * from Orders Order by orderID Asc", conn)
MyCmBld = New OleDb.OleDbCommandBuilder(MyDatAdp)
MyDatAdp.Fill(MyDataTbl)
Dim x As Integer = 0
Dim c As Integer = MyDataTbl.Rows.Count
If MyDataTbl.Rows.Count <> 0 Then
x = MyDataTbl.Rows(c - 1).Item(6)
End If

Scope of variables
Local variable
Module Connect
Public found As Boolean
Public conn As New OleDb.OleDbConnection
Public da As OleDb.OleDbDataAdapter
Public MyDatAdp As OleDb.OleDbDataAdapter
Public MyCmBld As OleDb.OleDbCommandBuilder
Public MyDataTbl As New DataTable
Public ds As New DataSet
Public sql, ser As String
Public db As String
Public x, c As Integer
Public bm As BindingManagerBase

Global Variables
Public Sub connection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Database\POS.mdb"

Page 37 of 53
 End Sub

The public sub is used in the connection and it is also used in the clearing of group.
Public Sub clear(grp As GroupBox)
Dim a As Control
For Each a In grp.Controls
If TypeOf (a) Is TextBox Then
a.Text = Nothing
End If
Next
End Sub

Comments
'ASSIGNING VALUES TO THE FIELDS FROM THE TEXTBOXES
With Myrow
.Item(0) = txtProdCode.Text
.Item(1) = txtProdName.Text
.Item(2) = txtQty.Text
.Item(3) = CDbl(txtCostPrice.Text)
.Item(4) = CDbl(txtTotal.Text)
.Item(5) = lblSupName.Text
.Item(6) = lblOrderNum.Text
.Item(7) = FormatDateTime(Date.Now, DateFormat.ShortDate)
.Item(8) = "NOT PROCESSED"
End With

'ADD THE ROW TO THE TABLE IN VB

MyDataTbl.Rows.Add(Myrow)

'UPDATING THE ACCESS DATABASE

MyDatAdp.Update(MyDataTbl)

'CLEARING THE ADAPTER AND THE VB TABLE AND CLOSING THE CONNECTION
MyDatAdp = Nothing
MyDataTbl.Clear()
conn.Close()

Blank lines
Private Sub txtSupCode_KeyPress(sender As Object, e As KeyPressEventArgs) Handles txtSupCode.KeyPress
If Not (Char.IsDigit(e.KeyChar) Or Char.IsControl(e.KeyChar)) Then

Page 38 of 53
 e.Handled = True
MsgBox("This field allows figures ONLY!!", vbExclamation)
End If

End Sub

Private Sub txtProdCode_Validating(sender As Object, e As System.ComponentModel.CancelEventArgs) Handles

txtProdCode.Validating
If txtProdCode.Text = "" Then
Exit Sub
End If

If txtSupCode.Text = "" Then

Exit Sub

Indentation
Private Sub txtProdCode_KeyPress(sender As Object, e As KeyPressEventArgs) Handles txtProdCode.KeyPress
If Not (Char.IsDigit(e.KeyChar) Or Char.IsControl(e.KeyChar)) Then
e.Handled = True
MsgBox("This field allows figures ONLY!!", vbExclamation)
End If
End Sub

TECHNICAL DOCUMENTATION
PSEUDOCODE OF THE SUPPLIER REGISTRATION MODULE

Page 39 of 53
 START

ENTER Supplier Details

ENTER Supplier Code

ENTER Supplier Name

ENTER Supplier Address

ENTER Supplier Phone

ENTER Supplier Email

END

IF ADD ANOTHER SUPPLIER = TRUE THEN

REPEAT ENTERING SUPPLIER DETAILS

ELSE

STOP

PSEUDOCODE OF THE PRODUCT REGISTRATION

STAT

Page 40 of 53
 ENTER Product Details

ENTER Product Code

ENTER Product Name

ENTER Supplier Code

ENTER Supplier Name

ENTER Cost Price

ENTER Mark Up

ENTER Selling Price

END

IF ADD ANOTHER PRODUCT =TRUE THEN

REPEAT ENTERING PRODUCT DETAILS

ELSE

STOP

The flow chart of the supplier registration

Start

Start

Page 41 of 53
 Supplier Details

Supplier Code

Supplier Name

Supplier Address

Supplier Phone

Supplier Email

YES

NO

STOP

Flow chart of the product registration

START

Page 42 of 53
 PRODUCT DATEILS

PRODUCT CODE

PRODUCT NAME

SUPPLIER CODE

SUPPLIER NAME

COST PRICE

MARK UP

SELLING PRICE

Yes
No

STOP

Program codes for pharmacy management system

The code of the main menu
Page 43 of 53
Public Class frmMain

Private Sub mnuSupplier_Click(sender As Object, e As EventArgs) Handles mnuSupplier.Click

frmSupplier.Show()
End Sub

Private Sub mnuProduct_Click(sender As Object, e As EventArgs) Handles mnuProduct.Click

frmProduct.Show()
End Sub

Private Sub frmMain_Load(sender As Object, e As EventArgs) Handles MyBase.Load

Me.CenterToScreen()
Me.Top = 10
End Sub

Private Sub mnuExit_Click(sender As Object, e As EventArgs) Handles mnuExit.Click

Dim sms As String = MsgBox("Are you sure you want to exit the POS Application", MsgBoxStyle.Question +
MsgBoxStyle.YesNo)
If sms = vbYes Then
End
End If
End Sub

Private Sub mnuPurchaseOrder_Click(sender As Object, e As EventArgs) Handles mnuPurchaseOrder.Click

frmOrder.Show()
End Sub

Private Sub mnuGRV_Click(sender As Object, e As EventArgs) Handles mnuGRV.Click

frmGrv.Show()
End Sub

Private Sub mnuSelling_Click(sender As Object, e As EventArgs) Handles mnuSelling.Click

frmSelling.Show()
End Sub

Private Sub REGISTRATIONToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles

REGISTRATIONToolStripMenuItem.Click

End Sub
End Class

The code of connecting to database

Page 44 of 53
The code of how to add the suppliers
Public Class frmSupplier

Private Sub txtSupCode_Validating(sender As Object, e As System.ComponentModel.CancelEventArgs) Handles

txtSupCode.Validating
If txtSupCode.Text = "" Then
Exit Sub
End If

'VALIDATION FOR REDUNDANCY - THAT IS THE SYSTEM SHOULD REJECT AN ALREADY CAPTURED
SUPPLIER
connection()
conn.Open()
MyDataTbl = New DataTable
MyDatAdp = New OleDb.OleDbDataAdapter("Select * from Suppliers Where Suppliercode = " & txtSupCode.Text,
conn)
MyCmBld = New OleDb.OleDbCommandBuilder(MyDatAdp)
MyDatAdp.Fill(MyDataTbl)
If MyDataTbl.Rows.Count > 0 Then
MsgBox("The supplier code is used by " & MyDataTbl.Rows(0).Item(1), MsgBoxStyle.Exclamation)
MyDatAdp = Nothing
MyDataTbl.Clear()
conn.Close()
e.Cancel = True
Else
MyDatAdp = Nothing
MyDataTbl.Clear()

Page 45 of 53
 conn.Close()
End If
End Sub

Private Sub btnOk_Click(sender As Object, e As EventArgs) Handles btnOk.Click

'PRESENCE CHECK VALIDATION

If txtSupCode.Text = "" Then

MsgBox("Please enter the Supplier Code for you to proceed", MsgBoxStyle.Exclamation)
txtSupCode.Focus()
Exit Sub
End If

If txtName.Text = "" Then

MsgBox("Please enter the Supplier Name for you to proceed", MsgBoxStyle.Exclamation)
txtName.Focus()
Exit Sub
End If

If txtAddress.Text = "" Then

MsgBox("Please enter the Address for you to proceed", MsgBoxStyle.Exclamation)
txtAddress.Focus()
Exit Sub
End If

If txtPhone.Text = "" Then

MsgBox("Please enter the Phone for you to proceed", MsgBoxStyle.Exclamation)
txtPhone.Focus()
Exit Sub
End If

If txtEmail.Text = "" Then

MsgBox("Please enter the Email for you to proceed", MsgBoxStyle.Exclamation)
txtEmail.Focus()
Exit Sub
End If

'CALLING THE PROCEDURE WHICH CONNECTS DATABASE

connection()
conn.Open()
MyDataTbl = New DataTable
MyDatAdp = New OleDb.OleDbDataAdapter("Select * from Suppliers", conn)
MyCmBld = New OleDb.OleDbCommandBuilder(MyDatAdp)
MyDatAdp.Fill(MyDataTbl)
Dim Myrow As DataRow = MyDataTbl.NewRow

'ASSIGNING VALUES TO THE FIELDS FROM THE TEXTBOXES

With Myrow
.Item(0) = txtSupCode.Text
.Item(1) = txtName.Text
.Item(2) = txtAddress.Text
.Item(3) = txtPhone.Text
.Item(4) = txtEmail.Text
.Item(5) = FormatDateTime(Date.Now, DateFormat.ShortDate)
End With

'ADD THE ROW TO THE TABLE IN VB

MyDataTbl.Rows.Add(Myrow)

Page 46 of 53
 'UPDATING THE ACCESS DATABASE
MyDatAdp.Update(MyDataTbl)

'CLEARING THE ADAPTER AND THE VB TABLE AND CLOSING THE CONNECTION
MyDatAdp = Nothing
MyDataTbl.Clear()
conn.Close()

'CALLING THE clear PROCEDURE TO CLEAR ALL THE TEXTBOXES IN THE GROUPBOX1
clear(GroupBox1)
txtSupCode.Focus()

'PROMPT THE USER TO ENTER ANOTHER RECORD

Dim sms As String = MsgBox("Supplier has been successfully added. Do you want to add another?",
MsgBoxStyle.Question + MsgBoxStyle.YesNo)
If sms = vbNo Then
frmMain.Show()
Me.Close()
End If
End Sub

Private Sub txtSupCode_KeyPress(sender As Object, e As KeyPressEventArgs) Handles txtSupCode.KeyPress

If Not (Char.IsDigit(e.KeyChar) Or Char.IsControl(e.KeyChar)) Then
e.Handled = True
MsgBox("This field allows figures ONLY!!", vbExclamation)
End If
End Sub

Private Sub txtPhone_KeyPress(sender As Object, e As KeyPressEventArgs) Handles txtPhone.KeyPress

If Not (Char.IsDigit(e.KeyChar) Or Char.IsControl(e.KeyChar)) Then
e.Handled = True
MsgBox("This field allows figures ONLY!!", vbExclamation)
End If
End Sub

Private Sub btnClear_Click(sender As Object, e As EventArgs) Handles btnClear.Click

'CALLING THE clear PROCEDURE TO CLEAR ALL THE TEXTBOXES IN THE GROUPBOX1
clear(GroupBox1)
txtSupCode.Focus()
End Sub

Private Sub btnExit_Click(sender As Object, e As EventArgs) Handles btnExit.Click

Dim sms As String = MsgBox("Are you sure you want to exit supplier registration", MsgBoxStyle.Question +
MsgBoxStyle.YesNo)
If sms = vbYes Then
frmMain.Show()
Me.Close()
End If
End Sub

Private Sub frmSupplier_Load(sender As Object, e As EventArgs) Handles MyBase.Load

Me.Top = 10
End Sub
End Class

USER DOCUMENTATION

Page 47 of 53
Installation

Load the system in the CD Drive, copy the folder “Database” and Paste the database in the local
dick C. take the application put it at the desktop click the install and the system will be installed.

Running the system

USER TYPE USER NAME PASSWORD

SELLER AGAMBIZA agambiza

On the log in form select the user and enter the correct password. After entering the correct
password the user will gain access to the main menu of the POS Pharmacy management System.
It is the main menu which gives the user access to all other modules of the system. If the user
wants to add a new Supplier to the database, he/she clicks REGISTER button and click the
SUPPLIER button. Also if he/she wants to add product he did the same as the Supplier.

Navigation

The main menu is the one which gives the user access to all other modules of the system. If the
user wants to add a new supplier to the database, he/she clicks the register button then goes to
supplier. If the user wants to add product he /she click the register button then go to product. Also
if he /she want to cheek the products in the system he/she click the product reports.

Exiting the System

On the main menu, the user can click LOG OFF button to exit the current logged in user, but the
system will be still running. To completely exit the system, the user must click EXIT button.

Page 48 of 53
TESTING
Page 49 of 53
Standard testing

Testing on whether the supplier has been successfully added.

Abnormal testing

Page 50 of 53
This is when testing if the supplier code can be used by two suppliers

Extreme testing

Page 51 of 53
This is the maximum number of characters which is accepted by the
system to process. If you enter the number when the program is stopped
then the dial log box will appear.

EVALUATION OF THE SYSTEM

Page 52 of 53
Achievements

 To develop a system that is user friendly.

 To develop a system with a backup measures.
 To develop a system with the security secures data from authorized users.
 Also to reduce the working hours.
 First generation reports.

Weaknesses

The system might be expensive for the individual to start since the system requires the analysts to
develop the system, to buy the equipment’s needed for the development of the system. It is difficult
to the person how sales the medicines, so he or she might need to be trained.

Opportunity

The system must be linked to the bank and the buyers can buy using the bank account to transfer
money, and it will no longer be necessary to bring the slip of the bank transfer. The system will
also be linked with Eco cash currently being used by many in our country.

Page 53 of 53