NEAR EAST UNIVERSITY FACULTY OF ECONOMICS AND ADMINISTRATIVE SCIENCES DEPARTMENT OF COMPUTER INFORMATION SYSTEMS 2005/2006 FALL TERM CIS 400 (Graduation Project)

(1)

NEAR EAST UNIVERSITY

FACULTY OF ECONOMICS AND

ADMINISTRATIVE SCIENCES

DEPARTMENT OF COMPUTER

INFORMATION SYSTEMS

2005/2006 FALL TERM

CIS 400

(Graduation Project)

CAMERA STORE SYSTEM

Submitted To:

Dept. Of CIS

Submitted By: MOHMMAD FADIL RABI (20002143)

Nicosia,

2005

(2)

NEAR EAST UNIVERSITY

FACULTY OF ECONOMICS AND

ADMINISTRATIVE SCIENCES

DEPARTMENT OF COMPUTER

INFORMATION SYSTEMS

2005/2006 FALL TERM

CIS 400

(Graduation Project)

CAMERA STORE SYSTEM

Submitted To:

Dept. Of CIS

Submitted By: MOHMMAD FADIL RABI (20002143)

Nicosia,

2005

(3)

,,

!

·'

r, /

ii

,·3

. ,,,··'

\ ,~

<:>

~ " 'v 6. ' /. ~. ·.i;,, ,' /(• \.,-/ ~, 9~&-~ ~

Page

I. ACKNOWLEbGEM13NTS

...

2 II. ABSTRACT

...

3 nt.tNTRODUCTION

...

4 IV. DESIGN OF THE SYSTEM

...

5 - Data Flow Diagram

...

6 - Database Design

...

11 V. USER MANUAL

...

18 - User Guidelines

...

18 - User Flow Charts

·

34 IV.REFRENCES

...

46 • Screen Output

...

47 ...

59 • Source Code

(4)

0

I. ACKNOWLEDGEMENTS

The longest day has an end"

My primary debt of gratitude, of course, goes to God.

I'm profoundly grateful to my parents and my siblings for their endless support,

understanding, patience, prayers and love.

I highly appreciate the academic stuff of the CIS department in Near East University

especially My chairman .Dr. Yalcin Akcali, And my Super Advisor Asst. Proof. Dr Ilham

Huseyinov, Ms. Nadire Cavus and Mr. Mustafa Menekay for their guide ness, excellent

corporation and encouragement.

I'm deeply indebted to my father Fadil Mohammad Rabi for getting me back on track.

Many thanks to my friends, Abdulmajeed, Samer Abu Halemeh , Samer Hattab for

standing beside me through the good days and the bad.

(5)

0

ABSTRACT

This software is an application program is used for some of stores which their sales are depend on selling small figures of products such my project subject which is selling deferent kind of camera . Which that makes business do their transactions easy and connection between the customers and the business to make fewer efforts on the

accountants to keep record and preparing Payments tables in advance ... The Camera store system is divided into four main processes for better user interface and friendly

environment.

My solution to the problem I guess is to understand the way I divided the system into main four processes, such as Stock, Sales, purchase, Reports and payments , Each of the section I designed is easy to understand and learn fast. There are used command buttons were preferred so all is in front of the user for quick access.

I added user messages as well for the correspondence with the program so user may understand a bit the inside logic of the program how his process is handled.

I hope this software will help the Camera stores or any store similar of business manager keep close eye on his business accounts performance, As there are hundreds of ways to solve any problem so if you find any suggestions about my program please do not hesitate telling me bout them.

(6)

0

Introduction.

With the huge technology and easy transportation the number of travelers and visitors increase around the world and the nice days com with. nice memories kept in pictures which our cameras take tij~se pictures while our traveling so number of camera store in tourists places increase arid the need for system manage arid control any store to make the business more profitable and easy to classify the catekory, mark, model of that camera. This system is divided to four

inrlih

processes.

1. Purchase.

,

1

This: ptobess

is

where the business order amount of products and keep

it

stock.

2.

Saies.

This process is where the customer making order to buy this product forms our stock.

3. Accounting. Accounting process is one of the most important processes where this process we

~ail

keep records df purchasing the products'aritl where selling the product and the do tH~:'falculation needed for management reporting. _, · ', ·

, ,

4.

Reports.

:it~porting process :i~ important as well because reporting process help the

managetherit

tb decision makihg and printing receipts

fut

the customet and supplier payments.

The

aiirt

'of this project is try to solve the keeping record problems ahd devolve a system and decrees the system errors

bun

make our business more profitable tl.tt,d fuor~ elastic to be close, ~th the huge developments of this world. I will develop this system by using Access

arid

VB languages. I am using these languages because it is

dsy

to maintain and useful with my ability to deal \VIth such this software.

(7)

0

Design of the system

I designed my system upon of business knowledge and to develop of business transaction

system by database program that can solve the time, cost, errors, missing files, and

communication between departments.

My system designed on database where keeping data and process it to get formatted

information to inform the management about the our business transactions and more

process.

The system dealing with easy and friendly interface to give the user more power to enter

and get the information easy.

The main menu connect the user with four departments of the system.

1. The purchase department or form which allows the user to keep info about our

product supplier and about the product entity.

1.1 The payment form which allows the user to enter how much payment mad

to supplier and the system will inform the user by the result of payment by

the payment balance.

2. The sales department which allow the user to deal with selling products to

customer and customer orders and the customer payments.

3. the reports department which inform the management by the all purchase and

sales by date and more to allow the management to take the necessary action

because of business transactions.

(8)

Data Flow Diagram

Customer (*) 1. Report of Customer 2. Report of Supplier 3. Report of Account 4. Report of Products 5. Report of Order Controlling System process 6

Camera store System Context Level D.F.D

(9)

NOT: Know= knowledge Cust = Customer Supp = Supplier ~~cc: Accounts r.fo: information

Camera store system Top level DFD Customer file

I

~I

Ti /

-;

'

!I

V

El

c., ;-g 'ri C)

I

,::i ____§:

Cust. Acc. file supp. Acc. file · Cust. Acc. Know

3 Account

Control process

(10)

0

Camera Store System Details level DFD l.Sales control process Customer

Customer File _{Orders File} Products file

Camera Store System Details level DFD 2.Purchase Control process

Products file

(11)

0

Camera Store System Details level DFD 3. Account control process

~

l

Addsupp &,0mQ Supplier file

-y-

~~ ~ Customer File

Q!g. Acc. File Supp.

AllJm:

Camera Store System Details level DFD 4.report Control process Supp. Acc. File

-"-'b\ ~O';

C,•

~o

Order file Products file Cust. Acc. File

~

.sY

Supplier file Order file

(12)

Relationship

CotactName Address City Country Phone ,_. -~-~=~- Orders OrderD> Customer ID OrderDate RequairdDate ~ DateOf Purchase QuantityPurchased PurchasePrice _Unit Product id Customer ID OrderDetailsID Order ID City Country Phone

J]

JO

(13)

Supplier Table

Suppli_erName s;omi:ia_r,yName __ CotactName Address 5=ity - Country Phone Fax Text Text l...Text Text --- -r- --··~- --- __ __,Text_ __ Text Field Prol)erties -Gener al

T

Lookup

l

Field Size tone Inteaer New Values Increment Format

Caption

Indexed Yes (No Duplicates) Smart Tags

l1

(14)

Purchase Details Table.

DateOf Purchase QuantityPurchas-ed PurchasePrlce _Unit Product Id AutoNum_beJ _ Date/Time

._J.

Numbe_r __

-+ -- -,

Number

- . r -

_{__ r- - -- .}

_-t-

Field Properties General

I

Lookup

I

Field Size Long Integer New Values Increment Format

Caption

Indexed Yes (No Duolicates) Smart Tags

(15)

Nl.lmber

--1=:---

Nu_rnber_ __ --- Number - - Number -

l

Order ID ProductID Discount Quantitl,'Ordered - -- Intrest Type _ Number ,Number

---

Field Proi::ierties Gener al

I

Lookup J

Field Size Lona Inteaer New Values Increment Format

Caption

(16)

Customer ID Order Date RequairdDa!e AutoN~er_

t- --

= Num~er

---l...-

1 Dat~/Time __ ,. - - - -roate/Tim~ _ .

!

-1

_--;

t-=- .. __

1=--·

I Field Proe_19rties -Gener af

I

Lookup J

Caption

14

(17)

f'i'orlnds

Table

Data Type AutoNumber

_-

_--

_-- uext -- •Number . _

t

Number -- · LText LN~ber ·-

L

- --- --"--~~-I - - - - - fl.

-1

. ----

--l

- -- - -- - I -- - - --- ~ -- • f, I -1-. _LV:, ProductName ~upi:,lierID SellingPrice Mark - Stocklevel Field Pro1J_erties General

I

Lookup J

Caption

15

(18)

Customer Payment

Payment Type IssuedDate -- Paid -- Customer ID OrderDetailsID Order ID Balance Text I Date/Time -- 1Number ~Nurnl~.EL _ Number +Num~er_ Number 1--

l

Field Prop_erties General

I

Lookup

l

Caption

Indexed Yes (No Duolicates) Smart Tags ~ ' 16 , V

(19)

Supplier Pavment

____ ./1uto~~

PaymentType Text

DateOf PaY._~e,t _

=--.

f:Da_telTirre -::_

Paid Number SUpplierID - - -- - - Number Product:i.D · Number PurchaseDetalID tNumber - -I -

---

_L_-_·

t--·- 1 _J

--+---

Fi91d Properties Ge,eral

I

Looh1p

j

Fiek::I Size .ono Inteaer New Values [ncrement Format

Caption

Inli9xed '(es (No Duoicates) Smart Tags

-

17

(20)

0

Customer Table

a

Customer : Table

Field Name Data Type

AutoNumber

_-r---

CustomerNar:ne _ _ 1 ~~t __ ~Oll)panyNam,e __J_~_)(t _ Address Text City_ ~

-=- _ ~-- .. -

-Tex_t

f=__ -

Country . Text Phone ·· ~4 -· _ Fax I Text E-Mail- - ·-- . lTe_x~t-- -_-_-::

--,---

t-

t ---

+---

l Field Pro~rties Gener al

I

Lookup ]

Field Size Lona lnteoer New Values Increment Format

Caption

Indexed Yes {No Duolicates) Smart Tags

(21)

0

V. User Manual

-user guidelines

1. Main menu

COi.era store ~lttm

_,

l .Main menu consist of five command buttons.

1.1 purchase button which open supplier and product sub from to perform registry of

supplier entry and products data entry.

2.1 Customer button which open the customer form to perform the customer data

registry.

3.1 Customer Sales which open form of customer orders and orders details sub form. To

perform the customer orders and maintain its product ordering data entry.

4.1 Find/reports button which open search and reporting form which has tow process to

search the seals and the purchase between tow days. And daily sales, daily purchase

product reports and the revenue reports.

(22)

0

1..

Customer

uata Entry

'ol'm View NUM

Customer form allow user to keep information about the customer entry and to keep contact with this customP:t

(23)

0

3.

Customer Sales Form

'orm View NUM

Customer sales form allows the user to keep records about the customer order and information about the product which such:

1.3 quantitv and the id of product and how the customer will pays cash or credit.

~

21

•

(24)

0

4. Customer

navment bv

_- _- _- credit Form

Customer Payment By credit form is showing result of transaction mad

by

the

customer

resultinz of orcennz nroducts rrom our stocs,

(25)

0

4.1 Customer Pavment

bv

Credit Form.

This form allow the user to select number of order details id and iust write down the amount navment with date of navment of customer from selling nroduct. Then click ~"'""' button.

4.1.1 Save button oerfonn the check total reauired from the customer and comoare the oavmertt if it less then or

zrater

than zero the will

zive

us

messaze

that the

navment

done

- -

successfullv.

In case he navment more than the total monev reauired or nezative value the svstem will _- _- _- inform the user bv messaze tell him the oavment not satisfied and return to oavment field to reenter the correct

navment,

(26)

0

This form inform the user bv details of oavment and total monev and the balance that remain on customer to be oaid.

(27)

0

6. Customer Pavment bv Cash Form.

This form such report inform the user by the required money from the total sales has

mad result of customer ordering a product.

(28)

NEAR EAST UNIVERSITY

FACULTY OF ECONOMICS AND

ADMINISTRATIVE SCIENCES

DEPARTMENT OF COMPUTER

INFORMATION SYSTEMS

2005/2006 FALL TERM

CIS 400

(Graduation Project)

CAMERA STORE SYSTEM

Submitted To:

Dept. Of CIS

Submitted By: MOHMMAD FADIL RABI (20002143)

Nicosia,

2005

(29)

,,

!

·'

r, /

ii

,·3

. ,,,··'

\ ,~

<:>

~ " 'v 6. ' /. ~. ·.i;,, ,' /(• \.,-/ ~, 9~&-~ ~

Page

I. ACKNOWLEbGEM13NTS

...

2 II. ABSTRACT

...

3 nt.tNTRODUCTION

...

4 IV. DESIGN OF THE SYSTEM

...

5 - Data Flow Diagram

...

6 - Database Design

...

11 V. USER MANUAL

...

18 - User Guidelines

...

18 - User Flow Charts

·

34 IV.REFRENCES

...

46 • Screen Output

...

47 ...

59

(30)

0

I. ACKNOWLEDGEMENTS

The longest day has an end"

My primary debt of gratitude, of course, goes to God.

I'm profoundly grateful to my parents and my siblings for their endless support,

understanding, patience, prayers and love.

I highly appreciate the academic stuff of the CIS department in Near East University

especially My chairman .Dr. Yalcin Akcali, And my Super Advisor Asst. Proof. Dr Ilham

Huseyinov, Ms. Nadire Cavus and Mr. Mustafa Menekay for their guide ness, excellent

corporation and encouragement.

I'm deeply indebted to my father Fadil Mohammad Rabi for getting me back on track.

Many thanks to my friends, Abdulmajeed, Samer Abu Halemeh , Samer Hattab for

standing beside me through the good days and the bad.

(31)

0

ABSTRACT

environment.

(32)

0

Introduction.

inrlih

processes.

1. Purchase.

,

1

This: ptobess

is

it

stock.

2.

Saies.

~ail

, ,

4.

Reports.

managetherit

fut

The

aiirt

bun

arid

dsy

(33)

0

Design of the system

I designed my system upon of business knowledge and to develop of business transaction

system by database program that can solve the time, cost, errors, missing files, and

communication between departments.

My system designed on database where keeping data and process it to get formatted

information to inform the management about the our business transactions and more

process.

The system dealing with easy and friendly interface to give the user more power to enter

and get the information easy.

The main menu connect the user with four departments of the system.

1. The purchase department or form which allows the user to keep info about our

product supplier and about the product entity.

1.1 The payment form which allows the user to enter how much payment mad

to supplier and the system will inform the user by the result of payment by

the payment balance.

2. The sales department which allow the user to deal with selling products to

customer and customer orders and the customer payments.

3. the reports department which inform the management by the all purchase and

sales by date and more to allow the management to take the necessary action

because of business transactions.

(34)

Data Flow Diagram

(35)

I

~I

Ti /

-;

'

!I

V

El

c., ;-g 'ri C)

I

,::i ____§:

3 Account

Control process

(36)

0

Products file

(37)

0

~

l

-y-

~~ ~ Customer File

AllJm:

-"-'b\ ~O';

C,•

~o

~

.sY

(38)

Relationship

J]

JO

(39)

Supplier Table

T

Lookup

l

Caption

l1

(40)

Purchase Details Table.

._J.

Numbe_r __

-+ -- -,

Number

- . r -

_{__ r- - -- .}

_-t-

I

Lookup

I

Caption

(41)

Nl.lmber

--1=:---

l

---

I

Lookup J

Caption

(42)

t- --

= Num~er

---l...-

!

-1

_--;

t-=- .. __

1=--·

I

Lookup J

Caption

14

(43)

f'i'orlnds

Table

_-

_--

t

L

- --- --"--~~-I - - - - - fl.

-1

. ----

--l

I

Lookup J

Caption

15

(44)

Customer Payment

l

I

Lookup

l

Caption

(45)

Supplier Pavment

____ ./1uto~~

PaymentType Text

DateOf PaY._~e,t _

=--.

f:Da_telTirre -::_

---

_L_-_·

t--·- 1 _J

--+---

I

Looh1p

j

Caption

-

17

(46)

0

Customer Table

a

Customer : Table

AutoNumber

_-r---

-=- _ ~-- .. -

-Tex_t

f=__ -

--,---

t-

t ---

+---

I

Lookup ]

Caption

(47)

0

V. User Manual

-user guidelines

1. Main menu

_,

l .Main menu consist of five command buttons.

1.1 purchase button which open supplier and product sub from to perform registry of

supplier entry and products data entry.

2.1 Customer button which open the customer form to perform the customer data

registry.

3.1 Customer Sales which open form of customer orders and orders details sub form. To

perform the customer orders and maintain its product ordering data entry.

4.1 Find/reports button which open search and reporting form which has tow process to

search the seals and the purchase between tow days. And daily sales, daily purchase

product reports and the revenue reports.

(48)

0

1..

Customer

uata Entry

'ol'm View NUM

(49)

0

3.

Customer Sales Form

'orm View NUM

~

21

•

(50)

0

4. Customer

navment bv

Customer Payment By credit form is showing result of transaction mad

by

the

customer

resultinz of orcennz nroducts rrom our stocs,

(51)

0

4.1 Customer Pavment

bv

Credit Form.

zrater

than zero the will

zive

us

messaze

that the

navment

done

- -

successfullv.

navment,

(52)

0

(53)

0

6. Customer Pavment bv Cash Form.

This form such report inform the user by the required money from the total sales has

mad result of customer ordering a product.

(54)

0

7.

Searching Data And Reporting

Svstem

From.

This form has six reports such as;

i

.6 dailv sales reoorts tell the user by daily product sold.

2.6

dailv

purchase

reports tell the user bv the daily product has purchased and detail

about that product.

3.6

delivery reminder reports are remind the user day by dav about the product which

shonlrl hP. <:11hm1ttP.rl to customer and information about the customer to could contact

n·

. un.

(55)

0

8. Search Seals Between to dates Form.

This form allow the user to make simple search about product by id within or lie between two davs.

(56)

0

';).Sales Between Tow Dates Bv Name Form.

This from is similar to previous form by search by name to find a product sold between to

d:nP.,

(57)

0

10.

Find Purchase Form.

(58)

0

11~ Find Purchase by name.

This form searching purchased product by name to find the product purchased within zivinz tow dates.

(59)

J

12. Sunnlier and Stock Form.

In this form where we keep information about the supplier and about the product such name. and selling price and more details in the next form 13.

(60)

I

"'

0

13. Purchasing Product Details.

This form allow us to add more quantity and any time we order new quantity form the same nroduct to add new quantity and cost price and date of purchase.

(61)

J

14. Suoolier navment,

_- _- _.

· Ihis

torm

allow

the user to

select

the customer order detans

and

eater the payment tc, supplier that has mad and entering: the tvne of navment naid to sunnlier.

(62)

(63)

(64)

J

Supplier

ENTEi'! Suppll•ro.rta S _Id. Name .etc.

1Sa111 2Edlt :::JOt loll! Hl•CI '5 Nt., 6 ,..,~ ENTEi'! clc,c~ -<Cl'""

(65)

0

Product D~a Entry

1Salll! :2 E<llt :JDtln Hl•d 5NHI 6B~t ENTEfi!CIOC<I: -e c •.•. run 37

(66)

j

Pm.duct Purchase Details

!Sana '2!:dlt ;iou• Hl1(1 5 Nt 11 6 llEk

38

(67)

Customer • .,,1.ostotm,~ dat.a :2..C'Ll:S101l1CT'Si:ilc!!: ENTER Yo, rc•Q~ <.Cl> J

(68)

0

Customer Data Entry

1Saw 2E!Jtt :JS<i1le Hl•ll 5Ntll 16 I a::k fillt ,1 ()

(69)

J Customer Sales ~ 1-.slc £.edit 3.frcd 4.'CCW s .oi<{p,aymctit) l>.b.oc~ ENTEl'lclot·,;, -<Cl;,- ,11 J

(70)

Cash Payment

(71)

NEAR EAST UNIVERSITY

FACULTY OF ECONOMICS AND

ADMINISTRATIVE SCIENCES

DEPARTMENT OF COMPUTER

INFORMATION SYSTEMS

2005/2006 FALL TERM

CIS 400

(Graduation Project)

CAMERA STORE SYSTEM

Submitted To:

Dept. Of CIS

Submitted By: MOHMMAD FADIL RABI (20002143)

Nicosia,

2005

(72)

,,

!

·'

r, /

ii

,·3

. ,,,··'

\ ,~

<:>

~ " 'v 6. ' /. ~. ·.i;,, ,' /(• \.,-/ ~, 9~&-~ ~

Page

I. ACKNOWLEbGEM13NTS

...

2 II. ABSTRACT

...

3 nt.tNTRODUCTION

...

4 IV. DESIGN OF THE SYSTEM

...

5 - Data Flow Diagram

...

6 - Database Design

...

11 V. USER MANUAL

...

18 - User Guidelines

...

18 - User Flow Charts

·

34 IV.REFRENCES

...

46 • Screen Output

...

47 ...

59

(73)

0

I. ACKNOWLEDGEMENTS

The longest day has an end"

My primary debt of gratitude, of course, goes to God.

I'm profoundly grateful to my parents and my siblings for their endless support,

understanding, patience, prayers and love.

I highly appreciate the academic stuff of the CIS department in Near East University

especially My chairman .Dr. Yalcin Akcali, And my Super Advisor Asst. Proof. Dr Ilham

Huseyinov, Ms. Nadire Cavus and Mr. Mustafa Menekay for their guide ness, excellent

corporation and encouragement.

I'm deeply indebted to my father Fadil Mohammad Rabi for getting me back on track.

Many thanks to my friends, Abdulmajeed, Samer Abu Halemeh , Samer Hattab for

standing beside me through the good days and the bad.

(74)

0

ABSTRACT

environment.

(75)

0

Introduction.

inrlih

processes.

1. Purchase.

,

1

This: ptobess

is

it

stock.

2.

Saies.

~ail

, ,

4.

Reports.

managetherit

fut

The

aiirt

bun

arid

dsy

(76)

0

Design of the system

I designed my system upon of business knowledge and to develop of business transaction

system by database program that can solve the time, cost, errors, missing files, and

communication between departments.

My system designed on database where keeping data and process it to get formatted

information to inform the management about the our business transactions and more

process.

The system dealing with easy and friendly interface to give the user more power to enter

and get the information easy.

The main menu connect the user with four departments of the system.

1. The purchase department or form which allows the user to keep info about our

product supplier and about the product entity.

1.1 The payment form which allows the user to enter how much payment mad

to supplier and the system will inform the user by the result of payment by

the payment balance.

2. The sales department which allow the user to deal with selling products to

customer and customer orders and the customer payments.

3. the reports department which inform the management by the all purchase and

sales by date and more to allow the management to take the necessary action

because of business transactions.

(77)

Data Flow Diagram

(78)

I

~I

Ti /

-;

'

!I

V

El

c., ;-g 'ri C)

I

,::i ____§:

3 Account

Control process

(79)

0

Products file

(80)

0

~

l

-y-

~~ ~ Customer File

AllJm:

-"-'b\ ~O';

C,•

~o

~

.sY

(81)

Relationship

J]

JO

(82)

Supplier Table

T

Lookup

l

Caption

l1

(83)

Purchase Details Table.

._J.

Numbe_r __

-+ -- -,

Number

- . r -

_{__ r- - -- .}

_-t-

I

Lookup

I

Caption

(84)

Nl.lmber

--1=:---

l

---

I

Lookup J

Caption

(85)

t- --

= Num~er

---l...-

!

-1

_--;

t-=- .. __

1=--·

I

Lookup J

Caption

14

(86)

f'i'orlnds

Table

_-

_--

t

L

- --- --"--~~-I - - - - - fl.

-1

. ----

--l

I

Lookup J

Caption

15

(87)

Customer Payment

l

I

Lookup

l

Caption

(88)

Supplier Pavment

____ ./1uto~~

PaymentType Text

DateOf PaY._~e,t _

=--.

f:Da_telTirre -::_

---

_L_-_·

t--·- 1 _J

--+---

I

Looh1p

j

Caption

-

17

(89)

0

Customer Table

a

Customer : Table

AutoNumber

_-r---

-=- _ ~-- .. -

-Tex_t

f=__ -

--,---

t-

t ---

+---

I

Lookup ]

Caption

(90)

0

V. User Manual

-user guidelines

1. Main menu

_,

l .Main menu consist of five command buttons.

1.1 purchase button which open supplier and product sub from to perform registry of

supplier entry and products data entry.

2.1 Customer button which open the customer form to perform the customer data

registry.

3.1 Customer Sales which open form of customer orders and orders details sub form. To

perform the customer orders and maintain its product ordering data entry.

4.1 Find/reports button which open search and reporting form which has tow process to

search the seals and the purchase between tow days. And daily sales, daily purchase

product reports and the revenue reports.

(91)

0

1..

Customer

uata Entry

'ol'm View NUM

(92)

0

3.

Customer Sales Form

'orm View NUM

~

21

•

(93)

0

4. Customer

navment bv

Customer Payment By credit form is showing result of transaction mad

by

the

customer

resultinz of orcennz nroducts rrom our stocs,

(94)

0

4.1 Customer Pavment

bv

Credit Form.

zrater

than zero the will

zive

us

messaze

that the

navment

done

- -

successfullv.

navment,

(95)

0

(96)

0

6. Customer Pavment bv Cash Form.

This form such report inform the user by the required money from the total sales has

mad result of customer ordering a product.

(97)

0

7.

Searching Data And Reporting

Svstem

From.

This form has six reports such as;

i

.6 dailv sales reoorts tell the user by daily product sold.

2.6

dailv

purchase

reports tell the user bv the daily product has purchased and detail

about that product.

3.6

delivery reminder reports are remind the user day by dav about the product which

shonlrl hP. <:11hm1ttP.rl to customer and information about the customer to could contact

n·

. un.

(98)

0

8. Search Seals Between to dates Form.

This form allow the user to make simple search about product by id within or lie between two davs.

(99)

0

';).Sales Between Tow Dates Bv Name Form.

This from is similar to previous form by search by name to find a product sold between to

d:nP.,

(100)

0

10.

Find Purchase Form.

(101)

0

11~ Find Purchase by name.

This form searching purchased product by name to find the product purchased within zivinz tow dates.

(102)

J

12. Sunnlier and Stock Form.

In this form where we keep information about the supplier and about the product such name. and selling price and more details in the next form 13.

(103)

I

"'

0

13. Purchasing Product Details.

This form allow us to add more quantity and any time we order new quantity form the same nroduct to add new quantity and cost price and date of purchase.

(104)

J

14. Suoolier navment,

_- _- _.

· Ihis

torm

allow

the user to

select

the customer order detans

and

eater the payment tc, supplier that has mad and entering: the tvne of navment naid to sunnlier.

(105)

(106)

(107)

J

Supplier

ENTEi'! Suppll•ro.rta S _Id. Name .etc.

1Sa111 2Edlt :::JOt loll! Hl•CI '5 Nt., 6 ,..,~ ENTEi'! clc,c~ -<Cl'""

(108)

0

Product D~a Entry

1Salll! :2 E<llt :JDtln Hl•d 5NHI 6B~t ENTEfi!CIOC<I: -e c •.•. run 37

(109)

j

Pm.duct Purchase Details

!Sana '2!:dlt ;iou• Hl1(1 5 Nt 11 6 llEk

38

(110)

Customer • .,,1.ostotm,~ dat.a :2..C'Ll:S101l1CT'Si:ilc!!: ENTER Yo, rc•Q~ <.Cl> J

(111)

0

Customer Data Entry

1Saw 2E!Jtt :JS<i1le Hl•ll 5Ntll 16 I a::k fillt ,1 ()

(112)

J Customer Sales ~ 1-.slc £.edit 3.frcd 4.'CCW s .oi<{p,aymctit) l>.b.oc~ ENTEl'lclot·,;, -<Cl;,- ,11 J

(113)

Cash Payment

(114)

Payment By Credit

(115)

(116)

)

IV.REFRENCES

. Even Callahan, Microsoft Access 2002 Visual Basic, First Edition, 2003 . O'reilly, Access Cookbook, 2000

. www.m1crosoft.com/mspress/developer . www.Oreilly.com

. www.M1crosoftAccess.com . . www.MAVBA.com.

(117)

J

-Screen Output

2. Customer Data l!;ntry

'orm View NUM

(118)

0

1.rm:tome:r

Sales Form

(119)

0

4.Customer payment by credit Form

(120)

J

5. Customer balance Details Form

(121)

J

6. Customer Payment by Cash Form.

7. Searching Data And Reporting System From.

(122)

0

8. Search Seals Between to dates Form.

(123)

NEAR EAST UNIVERSITY

FACULTY OF ECONOMICS AND

ADMINISTRATIVE SCIENCES

DEPARTMENT OF COMPUTER

INFORMATION SYSTEMS

2005/2006 FALL TERM

CIS 400

(Graduation Project)

CAMERA STORE SYSTEM

Submitted To:

Dept. Of CIS

Submitted By: MOHMMAD FADIL RABI (20002143)

Nicosia,

2005

(124)

,,

!

·'

r, /

ii

,·3

. ,,,··'

\ ,~

<:>

~ " 'v 6. ' /. ~. ·.i;,, ,' /(• \.,-/ ~, 9~&-~ ~

Page

I. ACKNOWLEbGEM13NTS

...

2 II. ABSTRACT

...

3 nt.tNTRODUCTION

...

4 IV. DESIGN OF THE SYSTEM

...

5 - Data Flow Diagram

...

6 - Database Design

...

11 V. USER MANUAL

...

18 - User Guidelines

...

18 - User Flow Charts

·

34 IV.REFRENCES

...

46 • Screen Output

...

47 ...

59

(125)

0

I. ACKNOWLEDGEMENTS

The longest day has an end"

My primary debt of gratitude, of course, goes to God.

I'm profoundly grateful to my parents and my siblings for their endless support,

understanding, patience, prayers and love.

I highly appreciate the academic stuff of the CIS department in Near East University

especially My chairman .Dr. Yalcin Akcali, And my Super Advisor Asst. Proof. Dr Ilham

Huseyinov, Ms. Nadire Cavus and Mr. Mustafa Menekay for their guide ness, excellent

corporation and encouragement.

I'm deeply indebted to my father Fadil Mohammad Rabi for getting me back on track.

Many thanks to my friends, Abdulmajeed, Samer Abu Halemeh , Samer Hattab for

standing beside me through the good days and the bad.

(126)

0

ABSTRACT

environment.

(127)

0

Introduction.

inrlih

processes.

1. Purchase.

,

1

This: ptobess

is

it

stock.

2.

Saies.

~ail

, ,

4.

Reports.

managetherit

fut

The

aiirt

bun

arid

dsy

(128)

0

Design of the system

I designed my system upon of business knowledge and to develop of business transaction

system by database program that can solve the time, cost, errors, missing files, and

communication between departments.

My system designed on database where keeping data and process it to get formatted

information to inform the management about the our business transactions and more

process.

The system dealing with easy and friendly interface to give the user more power to enter

and get the information easy.

The main menu connect the user with four departments of the system.

1. The purchase department or form which allows the user to keep info about our

product supplier and about the product entity.

1.1 The payment form which allows the user to enter how much payment mad

to supplier and the system will inform the user by the result of payment by

the payment balance.

2. The sales department which allow the user to deal with selling products to

customer and customer orders and the customer payments.

3. the reports department which inform the management by the all purchase and

sales by date and more to allow the management to take the necessary action

because of business transactions.

(129)

Data Flow Diagram

(130)

I

~I

Ti /

-;

'

!I

V

El

c., ;-g 'ri C)

I

,::i ____§:

3 Account

Control process

(131)

0

Products file

(132)

0

~

l

-y-

~~ ~ Customer File

AllJm:

-"-'b\ ~O';

C,•

~o

~

.sY

(133)

Relationship

J]

JO

(134)

Supplier Table

T

Lookup

l

Caption

l1

(135)

Purchase Details Table.

._J.

Numbe_r __

-+ -- -,

Number

- . r -

_{__ r- - -- .}

_-t-

I

Lookup

I

Caption

(136)

Nl.lmber

--1=:---

l

---

I

Lookup J

Caption

(137)

t- --

= Num~er

---l...-

!

-1

_--;

t-=- .. __

1=--·

I

Lookup J

Caption

14

(138)

f'i'orlnds

Table

_-

_--

t

L

- --- --"--~~-I - - - - - fl.

-1

. ----

--l

I

Lookup J

Caption

15

NEAR EAST UNIVERSITY FACULTY OF ECONOMICS AND ADMINISTRATIVE SCIENCES DEPARTMENT OF COMPUTER INFORMATION SYSTEMS 2005/2006 FALL TERM CIS 400 (Graduation Project)

NEAR EAST UNIVERSITY

FACULTY OF ECONOMICS AND

ADMINISTRATIVE SCIENCES

DEPARTMENT OF COMPUTER

INFORMATION SYSTEMS

2005/2006 FALL TERM

CIS 400

(Graduation Project)

CAMERA STORE SYSTEM

Submitted To:

Dept. Of CIS

Submitted By: MOHMMAD FADIL RABI (20002143)

Nicosia,

2005

NEAR EAST UNIVERSITY

FACULTY OF ECONOMICS AND

ADMINISTRATIVE SCIENCES

DEPARTMENT OF COMPUTER

INFORMATION SYSTEMS

2005/2006 FALL TERM

CIS 400

(Graduation Project)

CAMERA STORE SYSTEM

Submitted To:

Dept. Of CIS

Submitted By: MOHMMAD FADIL RABI (20002143)

Nicosia,

2005

CONTENTS

,,

!

·'

ii

,·3

. ,,,··'

\ ,~

<:>

Page

I. ACKNOWLEbGEM13NTS

...

2

II. ABSTRACT

...

3

nt.tNTRODUCTION

...

4

IV. DESIGN OF THE SYSTEM

...

5

- Data Flow Diagram

...

6

- Database Design

...

11

V. USER MANUAL

...

18

- User Guidelines

...

18

- User Flow Charts

·

34

IV.REFRENCES

...

46

• Screen Output

...

47

...

59

• Source Code

I. ACKNOWLEDGEMENTS

The longest day has an end"

My primary debt of gratitude, of course, goes to God.

I'm profoundly grateful to my parents and my siblings for their endless support,

understanding, patience, prayers and love.

_{__ r- - -- .}

_-t-