CHAPTER FIVE:SCREEN OUTPUTS CHAPTER FOUR:REF'ERENCES CHAPTER THREE:USER MANUAL CHAPTER TWO:DESIGN OF THE SYSTEM CHAPTER ONE:INTRODUCTION ABSTRACT ACKNOWLEDGEMENT CONTENTS

CONTENTS

ACKNOWLEDGEMENT

3

ABSTRACT

4

CHAPTER ONE:INTRODUCTION

s

CHAPTER TWO:DESIGN OF THE SYSTEM

7

-EXPLANATION ...•.•....•.•...

8

-DAT

A FLOW DIAGRAM(DFD) ...••...•.••...•••••.. 11

-SYSTEM BLOCK DIAGRAM

16

-DATABASE DESIGN ...••....••...

17

CHAPTER THREE:USER MANUAL

-USER GUIDELINES

19

-USER FLOWCHART

22

CHAPTER FOUR:REF'ERENCES

47

CHAPTER FIVE:SCREEN OUTPUTS

48

ACKNOWLEDGEMENTS

thank fall our the department head Mr. Yalçın Akçalı and my advisor İlham

ynov.they were very interested.In my whole university period I would like to thank my

e department teachers and especially Nadire Çavuş.because they use all their

formance to us.They were very patient while they were giving us knowledge.Theyalways

. o teach the truest and the best knowledge.Special thanks to mydear friends we have been

really enjoyable and best days in our 4 years university period.Also I would like to thank

. important beings in my life who are my familiy.They were very patient.used to be

erance and show all their respect while I was studing.

tly I would like to thank especially Levent LTD.They helped me very much for my

~ect,they were very kind and show all their attention and it was very helpful.

ABSTRACT

The aim of this project is to present a develop computer software which is called decorative stone coverings.I am going to present a successful,fast and develop computer system through analyzing large stores which sell marble.

While decorative stone coverings information system computer software is being presented the important thing is to use a computer.Therefore its important that the workers have skills about using computer is to gain fast,true and flawless information.

In my project i will show;selling information,customer information.supplier information,product information and stock information.

Selling between two date and purchase between two dates will be seen automatically.

The most important thing in this system is using the computer.The advantages of using computer is that you can take the information needed fast and certain.In other words this means that you will gain this information much slower in a long period of time.But using a computer you can gain information much quicker,true and certain and you can see your mistakes.

CHAPTER ONE

INTRODUCTION

INTRODUCTION

DECORATIVE STONE COVERINGS MANAGEMENT

SYSTEM

The most important thingin this system is using the computer.The advantages of using computer is that you can take the information needed fast and certain.In other words this means that you will gain this information much slower in a long period of time.But using a computer you can gain information much quicker,true and certain and you can see your mistakes.

In my project of decorative stone coverings.I will use DELPHI programming languages and microsoft access databases.

These are the processes I will use for my project:

1 )Purchase Process

In this section I will organize how goods are added,how incorrect goods are corrected,how goods information is searched for,how canceled goods are deleted I will show what material bought from will be added,make current and show searching and deleting programmes.

Purchase process include this subprocess:purchase good,good,supplier.

2)SellingProcess

In this section I will show selling marble .. Also I will show the order contract searching in this section.

In the customer services department I will show how new customers are registered,how to correct customers who have been registered wrongly and how customer services help to find customers. I will show how decorative stone coverings are sold.I will show how decorative stone coverings are added to the stock and decreased from the stock.

3)Report Process

CHAPTER TWO

DESIGN OF THE

SYSTEM

..

DESIGN OF THE SYSTEM

EXPLANATION

The minimum requirements of the system are as follows:

./ Intel Pentium IV processor 2.420

./ 533 Mhz ./ 512 MB DDR RAM ./ 80 GB HDD ./ _{14'' Monitor} ./ Microsoft Windows XP ./ CD-ROM 52xmax ./ 256 MB Graphic Card ../ Modem

The recommended requirements of the system are as follows;

./ _{Intel Pentium IV processor 3.0}

./ _{800 Mhz}

./ _{1 GB DDRRAM}

./ _{120 GB HDD}

_..

1) PROJECT IDENTIFICATION

AND SELECTION

THE AIM OF THE PROJECT :

The aim of this project is to present a develop computer software which is called decorative stone coverings.I am going to present a successful,fast and develop computer

ystem through analyzing large stores which sell marble.

THE PROJECT BOUNDRIES

1)

System can work on a single PC.

2)

System will not connect to internet so can not update itself

3)

System can not communicate with the suppliers because of being an offline system.

4)

Microsoft Access doesn't support multiple users at the same time. So the users of this system can not use the same tables.

RESOURCE LIMITS

1) The project will have a special inteıf ace using flash extensions. Program will start

with a login screen and only the authorized user may have the right to use

program.

2) PROJECT INITIATION AND PLANNING

OPERATIONAL FEASIBILITY

The manager and the other employees who will use the system must have at least low

level computer using skill for being educated about the system.

ECONOMICAL FEASIBILITY

System can replace an employee's work on like basic stock controlling, statistical

report preparing, etc .. This system will cost for the owner about 1500 at total. This

cost includes a computer, a printer with coloured cartridge.

5)

ANALYSIS

THE REQUIREMENT DETERMINATION:

The requirements made by the owner as follows:

To increase the speed of operations

To provide easy and quick Access

System security

Recording of the distribution daily

NEW SYSTEM'S PROVIDENCES

Context DFD of Decorative Stone Covering Information System

~---~ Supplier knowledge

Supplier changing data

Customer knowledge

SUPPLIER Customer changing data _CUSTOMER

Purchased changing good data

Poccha~ "'" ( Customer order

\

Purchase good info

DECORATIVE STONE

COVERINGS Order contract

Produced category info

\

J

Produced product info

,

Supplier list

Purchase report between two date

Customer list Selling report between two date

Stock list cu cu

ro

ro

"O "O o C .S:: ·5C C ~I

•

cu s: Ü Ü ~ ti o

•

..

N

w

oıutJBLUOJsn:ıaıaıap paueuuoj ...J

Ü:

OJU! .ıauıoısro aıepdn paueWJ0.::1 _"'w

::;;

a: OJU) JBWOJSn:.J

~I

~

w

:;; OJU! juarmo rsuıo.srvj t

o o a. ı- _e en o uı ::ı JUB.l.Jn:::ı pnpOJd

~ı

a;

o eıep bu!öue4:ıJawoısn::, E

o ~ .ıapıo Jawoısn:J Ü paJleLUJO.:! (!)en o I ::ı

aöpaıMoU)t J9WOlSnJ zen_w OJUIpnpOJd o_o

"':Jg

_"'o.

PeJJUO'.JJBPJü _.\ Wa,:

enc. _{onoorc aıaıap}

paueLWo.:1

I I I aıep OMluaaM:jaq uooaı aseı.pJnd

w ~

...J

'Bl I I I aıap OMl uaaeqaq uooaı ouıııas Ü: paıetsuerj _>- a. "' e

I

I I I

11 aıetep panewJO:::J o(!) n .9 ~ lf) aıeoon paueWJO.:l <t o (/)I C:' o,

••

I

I

I

,:::'.::::::::::

11

OJU!uooaıÖU!l!BS

.2 C: vı d ,_ı

_•..

I

ı-en a: w cı:: en (!) ·O~ _< M Q.Q IS!I )1:JDJS _z WC:: < cı:: C. :;; :;::.,

j\

Es t 8. ~ ~ w a.a. ...J ~ Ü: lf) "' w :::; o. ~ o. ::ı _t "' o_a.

~I

/

"'~OJD! Ja,ıaons ~ ~ § eıep

I

Wrıı

•• I

d'I IS!IJawoısn:J

pooööuıöueuo paseı.r.:und en en

<w

,..: i3 g

C::cı::

2 (1) "O "O o o Ol Ol C Ol C (1) s:_o "O Cl) en (1) s:

-

e

-

::::ı

-

c, fl) fl)

w

()

o

o::

a.

w

fl) <(

J:

()

o::

::>

a.

LL

o

C LL C C

w

...J <(

ı-w

C eıep s:ı+s:ııs:ıı-ı J.>üüt) o:: UJ ::J a.. a.. ::ı Cl) sıepdn poo9 Cl) C en <D O C UJ ...:oCU (!) c:ı:

o

o:: a.. +Us:lJJJl:J J.>üüt) oıuı poo5 JôJ)Jü ôSBl.PJJld (1)

ro

"O Ol C Ol C (1) s::. o .~ Q.L---ıı Q_ ::::ı CJ) 2 (1) "O 2 Cl) ~ .---41 -~ ::::ı CJ)

..

w ..J Ü: C

o

o

(!) w ..J I.L w Cl) c:ı: :ı: o o:: ::ı a..

•

w ...J u::: ~

o

(!) w ı-< o oju] Aıo6aıe::ı eıaıep peııewıo.:1 OJU!AJ06aıe::ı eıepdn panewıo.:1 e o Ol (I)

ro

Ü w ...J

-n~~

~ z fi::~

i

~

9~

N _<a.. a.. _-

ı--

~ og O

en

(I) "O ::,

en

ı- w U)

~ e

(il a. Co

w

_g

ı- ın

E

2 cı:: () ,.,---..._ _{""""' <} l\ o _(1l a..

o

o::

a.

ıı::: w (!) ~ ~~

~I

~

z

o_ı- w (!)

(/) _{OJUI pnpOJd pe::ınpô)d}

....J ::,

_-c

....J o

_z

w

~

en

~ ~ L1.

o

_{L_J~} ~ ~ v,

'

;::::::

_u

C Nil) o w wı- o o L1. (/) cı:: o_{::, o cı::} C o a.. C cu

w

ro

rn ....J "OCJ

ct

C

~J

ıı:::

ı-

C _{w w} U) (il

w

s: ~ ı- (/) C ÜQl '<fN o w wı- ...Jo_{(/) w o} E ::, o cı:: ~ .El o o a...

_•

t,

w ...J iI o:: w

:ı:

o

I­ m ::>

o

OJü!uocaıJawoısn:::ı

o:: m w m

:ı:

ı- w ..- omu r,; ı-

:J

O m o:: ::> a..

o

w _m ...J ::ıı::: m iI _{MU I- W}

_ı

-ısıı ıt:ıoıs ı- . omu

o OJU!uo aı )f::ıoıs M I- :J Q

::> m o::

-

_I~

a.. M

-en

en

w

(.)

o

~ Q. ~ _{o o::} ~ ~ (.') m w

o

w (.') ...J _{w z m}

_<

Q. iI LO Z I- _ W

aıep OM\ uaaMıaq \JO aı uıııas z

. w <...Ju

<

w

o:: MW ...J Q

~ w_o oju: \JO aı uıııas 3:0wo::_{ı- m a..}

:ı:

u,

o:: w

o

o a) C

u,

C C

w

...J <( w...J ~ LL

"

o:: m

w

o:: w m

C w OJUI )JO aı Jaq ns N :J I- W

-a.mu :J _{Ma..:JO I ısıı Jaııaans} a.. _{::> o::} a.. _{m a..} ::> m

..

SYSTEM BLOCK DIAGRAM FOR DECORATIVE STONE

COVERINGS MANAGEMENT

SYSTEM

1.0

CHASE

OCESS

1.1 CPPLIER ADD PROCESS 1.2 UPPLIER UPDATE PROCESS 1.3 UPPLIER DELETE PROCESS 1.4 PURCHASE GOOD PROCESS 1.5 GOOD ADD PROCESS l.6

ı

UPDATEGOOD PROCESS J .7 GOOD DELETE PROCESS

2.0

SELLING

PROCESS

3.0

REPORT

PROCESS

2.5 PRODUCT ADD PROCESS 2.6 PRODUCT UPDATE PROCESS 2.7 PRODUCT DELETE PROCESS 2.8 CATEGORY ADD PROCESS 3.1 CUSTOMER LIST PROCESS 3.2 SUPPLIER LIST PROCESS 3.3 STOCK LIST PROCESS 3.4 BETWEEN TWO DATE PURCHASE PROCESS 2.1 CUSTOMER ADD PROCESS 2.2 CUSTOMER UPDATE PROCESS 2.3 CUSTOMER DELETE PROCESS 2.4 CUSTOMER ORDER PROCESS 3.5 BETWEEN TWO DATE SELLING PROCESS 2.9 CATEGORY ı •

•

psize pstock ppnre pproperties ctid cttype

•

..

CHAPTER THREE

USER MANUAL

:-... enter the program first you have to enter password.The password is "rıeu" .

· process are as follows;

chase Informatıon System

upplier add process

this process user can add new supplier information and save it.

- Supplier update process

.ser have to enter supplier id and user can see supplier information and update it.

1.3 Supplier delete process

.ser have to enter supplier id and by this way supplier information deleted.

1.4 Purchase good process

User can entering purchase good information and save.

1.5 Good add process

In this process user can add new good information and save it.

1.6 Good delete process

<!I

User have to enter good id and by this way good information deleted.

1.7 Good update process

_•

er customer id and by this way customer information deleted. I 7

zr update process

enter customer id and user can see customer information and update it.

· g order information for customer order.

aımud

delete process

e to enter productr id and by this way product information deleted.

·e to enter product id and user can see product information and update it.

process user can add new category information and save it.

ategory delete process

have to enter category id and by this way category information deleted.

ategory update process

ser have to enter category id and user can see category information and update it.

-"Report Information System

3.lSupplier list

In this process it shows you all the supplier information

o date purchase list

•z

:rs, it

shows between two date purchase good information

o date selling process

••• 1Ce5s it shows between two date selling marble information

..

START ENTER PASSWORD y N

•

o

1-SUPPLIER 2-PURCHASE GOOD

3-GOOD 4-RETURN MAIN MENU

..

1-SUPPLIER ADD 2-SUPPLIER DELETE 3-SUPPLIER UPDATE 4-RETURN PURCHASE MENU

5-RETURN MAIN MENU

ENTER CHOICE N N N

•

(")SUPPLIER NUMBER SUPPLIER NAME SUPPLIER ADDRESS SUPPLIER E-MAIL SUPPLIER PHONE SUPPLIER MANAGER 1.1.1 SUPPLIER NUMBER ADD NEW SUPPLIER n SAVED y

•

.•

1.1.2 SUPPLIER NUMBER SUPPLIER INFO y NOT FOUND

•

(")SUPPLIER NAME SUPPLIER ADDRESS SUPPLIER E-MAIL SUPPLIER PHONE SUPPLIER MANAGER 1.1.3 SUPPLIER NUMBER ENTEfi NEW SUPPLIER INFC y

..

•

•

1.2

1-PURCHASE GOOD ADD 2-RETURN PURCHASE MENU

3-RETURN MAIN MENU

ENTER CHOICE N N CHOICE 3 y A N

.•

•

1.2.t (•)PURCHASE GOOD IC GOOD PRICE GOOD IC PURCHASEGOOD DATE SUPPLIER NUMBER PURCHASE UNIT PURCHASE GOOD IC ADD NEW PURCHASE GOOD(•) SAVED 1.~

..

•

1.3

1-GOODADD 2-GOOD DELETE 3-GOOD UPDATE 4-RETURN PURCHASE MENU

5-RETURN MAIN MENU

ENTER CHOICE y y >---71 1.3.2 y 1.3.3 y N y

•

1 3 1 (·)GOOD ID GOOD NAME GOOD PRICE GOODUNIT GOOD ID SAVED y

•

1.3.2

1.3.3

GOOD ID

THIS Goo·

IS FOUND GOOD INFO

NOT FOUND GOOD ID GOOC INFO(•) y (•)GOOD ID GOOD NAME GOOD PRICE GOOD UNIT

•

1-CUSTOMER 2-0RDER 3-PRODUCT 4-CATEGORY 5-RETURN MAIN MENLi

..

'\-C\lSıClW,'t.R f\DD

1.-~~~-v:::ı~'t.R'\J't.\.'t.\'t.

~-C\lSıClWıt.R \l?Df\W. 4-Rtı\JRN Sl:.l\.\NG Ml:.N\J

5-REı\JRN MAIN MENL

CUSTOMER NUMBER ADD NEW CUSTOMER(') SAVED 2.1.2 CUSTOME R NUMBER CUSTOMER (')CUSTOMER NUMBER CUSTOMER NAME CUSTOMER E-MAIL CUSTOMER PHONE CUSTOMER ADDRESS CUSTOMER MANAGER

•

(•)CUSTOMER NAME CUSTOMER ADDRESS CUSTOMER PHONE CUSTOMER E-MAIL CUSTOMER MANAGER 2.1.3 CUSTOMER NUMBER CUSTOMER INFO ENTER NEW CUSTOMER INFO(•) y

•

..

1-0RDER ADD 2-RETURN SELLING MENU

3-RETURN MAIN MENU

22 SAVED (•)ORDER ID ORDER DATE CUSTOMER IC CUSTOMER NAME PRODUCT IC PRODUCT NAME CATEGORY NAME CATEGORYTYPE ORDER UNIT TOTAL PRICE STOCK

•

CT _2.3

1-PRODUCT ADC 2-PRODUCT DELETE 3-PRODUCT UPDATE 4-RETURN SELLING MENU

5-RETURN MAIN MENL

ENTER CHOICE

2.3.1 PRODUCT ID ADD NEW PRODUCT (') SAVED y PRODUCT INFO (')PRODUCT ID PRODUCT SIZE PRODUCT STOCK CATEGORY ID CATEGORY TYPE PRODUCT TYPE PRODUCT PROPERTIES

•

2.3.3 PRODUCT ID (•)PRODUCT ID PRODUCT TYPE PRODUCT SIZE PRODUCT PROPERTIES CATEGORY ID CATEGORY TYPE STOCK

•

2.4

1-CATEGORY ADD 2-CATEGORY DELETE 3-CATEGORY UPDATE 4-RETURN SELLING MENU

5-RETURN MAIN MENU

(•)CATEGORY ID CATEGORY TYPE CATEGORY ID ADD NEW CATEGORY(·) SAVED y CATEGORY ID y CATEGORY " INFO y

_•

CATEGORY IC CATEGORY INFC ENTER NEW CATEGORY INFO(•) (•)CATEGORY ID CATEGORY TYPE

•

3

1-CUSTOMERLIST 2-SUPPLIER LIST

3-STOCK LIST 4-BETWEEN TWO DATE

PURCHASE LIST 5-BETWEENTWO DATE SELLING

LIST

3.1 CUSTOMER LIST 3 START DATE FINISH DATE 3.2 SUPPLIER LIST START DATE FINISH DATE

•

CHAPTER FOUR

REFERENCES

..Borland Delphi 7"

·ı

Doç.Dr. Soner, "Programlamaya Giriş Ve Algoritmalar"

JI-nevi 1. Baskı-August 2000-Rize

CHAPTER FIVE

SCREEN OUTPUTS

,. - .••' ..• • f·, ;, fc - . I

'# •

I .ı., , l' 1~_.f

-. 2;01ıioôs

sJ?RiNo.rERM

• ., . . . \ . . . l .

""

·, .•

'.

,.

'C":S400

1 ••• . , • • • -. , . . :• . '6J .J,, • ••• ', ;o. ;.,• ' • •••• ~ .•;. '"'~ # # (_,ı,.. i t •••• ' -· , ,• • • •

(DEC9~UVE S;l'ONJ:]'

COVERINGS

Ml.NAGJ~NT

SYSTEM.)

.~ ,-•# • r !· -.. •- ,I ~ ı, .•.-ıı:._ "' - • ıı:- • I • ,...., - .• . .• • ~ 4..~ I' ' • lı.,. •••• ~ • ••• ,, .: 1'41. -ı_.~-~-· ... .,,_• ·"- .•. -ı..,tıı-,., •.. - \ ~\..~ "' ·"•· • ıri-DV~~ ,..: · $ı;61Hu.'.ı._.ı:~·~~:

.... ·.sıı~wsrı·

. 1 . .. .. ' ' .rf A '• ,_'

_.,

_..

..

·

,

..

"'-'

..

.

..•

--~",,

.~ ..

..

_.,

.,

....

•.

. ·, • '~• ..., a,_ ~- • ' ;,• j ..•\ • ' • ' t

..DBPT.

_{•.. *ı..Y·}

ı\F..ctS . · ~ . , . · •·

_{• ..• ,}

ırtJ'CAJr;ADfı (20'0300Z1)

•;. ~-.:, :; ... :-:-.'· .·"' :.>~··· ·~ .

"

..

"' ~ i f :,,,... ,.

..•..

.

,

.

...

~

..

·

.

.

•..

" ~ ,ıı... . • .•..•• ;. -r ,,.

.,,.

I _:. I, v ,

_..

.

..•

·

..

r

,.

....

~

·~

...

ı, ...., v .

,.·.

v ,

,

-::

.'...

.

.

' ~-

..

'

.

.

•

..

t•',

.

..•

.

.

.

•('

...

_,.. '

'

••• " - :"...ı. ••• • ı -·v[ •

,,,

'

\ ,..

'·

Figure 1 (introduction)

•

Figure 2 (password)

CORRECT

PASS/PO.RD

IPELCOME

Ii??

INYALID P-'..SS'll"ORD

GAIN ENTERING

~:,

•

Figure 3 (main menu)

Figufe 4 (purchase menu)

SUPPLIER INFORMATION MAINMENU>

SEAllCHBYNAME

SEAKCBBY:NUMBBR

TOTAL NUMBER OF RECORDS 3

SUPPLlERNVMBER SUPPLIER :NAME SUPPLIER ADDRESS SUPPLIER PBO:NE SUPPLIEllE-MAlL lılANAGERNAME

e

Figure 5 (supplier information)

SUPPLIER INFOR.MA'IION MAINMENU>

TOT AL NUMBER OF RECORDS 3

S0PPL1Ell NUMBER SC"rPllEll NAME SC'rPllERADDRESS SC'rPLIEll PHONE SC"rPLIEll E-lılAlL MANAGER NAME

NOT FOUND THIS SUPPLIER!!!

l!... ::_oK·...:::...

:::ı

SUPPLII.R INFORMATION :MAINMENU>

SEARCHBYNAME

OTAL NUMBER OF RECORDS · 3

StlllLlEll NUMBER StıPlLJER NAME SUPlUEJlADDUSS St1ll'L1ER PHONE St1Pl'L1Ell E-MAIL MANAGER NAME 2 ÇİMSALTD. İSTANBUL 05556831154 CİMSA@MSN.COM SALİH YÜCESOY

e

YES NO

DO YOU WANT TO DEI..ETE?

Figure 7 (delete supplier information)

GOOD INFORMATION MAIN MENU>

TOTAL NUMBER OF RECORDS 5

GOOD NUMBER : jsc5o

GOOD NAME : jcıLA TASI

!iiiil

PRICE

GOOD UNIT 20

Figure 8 (good information)

GOOD INFORMATION ,MAINMENU>

OTAL NUMBER OF RECORDS 5

GOOD NmfflER : ~C50

: [cıLA

TASI 200 GOOD NAME PRICE 20 GOOD UNIT

e

DO YOUWANr TO SK'ılE? YES NO

Figure 9 (good update)

DPLIERADDRESS DPLIERPBONI: RJPPLIERE-1,WL GOOD NUMBER GOOD NAME PRICE GOOD UNIT

FIND SUPPLIER FINDGOOD

PURCHASE JNFORMATION

PURCHASE NUMBER .I _

GOOD NUMBER

PURCHASE DATE

[oi:0_5 2_0_0Jl

PRICE

SUPPLIER NUlIBER PURCHASE UNIT

Figure 10 (purchase good add)

8 ıSAMTASLTD _AME ; iSIANBUL 053563215"15 ; SAMTAS@.ıMSN.COM mıııGIJlN~ ~ FIND SUPPLIER PURCHASE INFORMATION PURCHASE NUMBER . n:,:__ _ GOOD NUMB.ER SC50 06.05.2008 SC50 CILATASI 200 20 FIND GOOD lo3.05.2J!..O_Q_ PURCHASE DATE 200 PRICE 8 SUPPLIER NUMBER 20 PURCHASE UNIT

TOTAL NUMBER OF RECORDS 9

©

Figure 11 (purchase good information)

..

Figure 12 (selling menu)

•

..

CUSTOl\lER ll\TOIWATION

MAINMENU>

SEAltCB BY NtiMBIR

TOTAL NUMBER OF RECORDS . 15

COMPANYNllKBEll ; ----­ COMPANYNAME COMPANYADDRESS : ---­ COMPANYPHONE COMPANYE-MAIL lıL\NAGERNAME (±)

E>

(3)

~

Figure 13 (customer add)

CUST-01\IER 1!\"fORMA.TlON

MAINMENU>

111

TOTAL NUMBER OF RECORDS : 15

11

COMPANY NUMBER

COMPANY NAME CANDEMİR LTD

COMPANYADDRESS ; YUSUF SAHİN SOK. N0:8 COMPANY PHONE ;

Oc..c3:...::.9=22::..::3~5-=-'16::..::5~8~----COMPA.NY Uı1AIL : CANDEMİR@HOTMAİL.COM

MANAGER.NAME : YUSUF KÜCÜK

Figure 14 (search by customer number)

CUSTOIIER ll\'FORMATION _MAINMENU>

CANDEMİR LTOI

SEAJI.CH BY NVMBEII.

TOTAL NUMBER OF RECORDS : 15

11 COMPANYNlllılBER :

---COMPANYNAME CANDEMİR LTD

COMPANY ADD.RESS : YUSUF SAHİN SOK. N0:8

COMJ>ANYPBONE :O _3~9=2=23~5~4=65~8:__ _ COMPANYE-MAIL : CANDEMİR@HOTMAİL.COM

MANAGERNAKB ; YUSUF KÜCÜK

Figure 15 (search

by

customer name)

CUSTOIIERINFORMATION

MAINMENU>

CİMSALTD

TOTAL NUMBER OF RECORDS . 15

COMPANYNVMBER : ---­ COMPANYNAlılE COMPAm'ADDRESS COMPANYıBONE COMPANY i-llAIL KANAGERNAME

NOT FOUND THIS CUSTOMER!!!

CATEGORY INFORMATION

_MAIN

_MENU>

"

TOTAL NUMBER OF RECORDS

CATEGORY NUMBER

D

CA1'EGORYTI1PE

MERMER

e

(~)

Figure 16 (category information)

CAIEGORYINFORl\L.\TION _MAINMENU>

OTAL NUMBER OF RECORDS

CATEGORY NUMBER 1

CATEGORY TYPE MERMER....

©

DO YOUW.A.NT'fO SA\ılJE?

YES

NO

Figure 17 (category update)

SEARCH BY PRODUCT NU1"IBER 114-4000-04

l\lAINMENU>

Find Product lnfurmation

--+- FIND CATEGORY~

PRODUCT

TOTAL NUMBER OF RECORDS 20

PRODUCT NUMBER : [M-4000-04 CATEGORY NUl\IBER.

PRODUCT TYPE

: I

40'40

[:J

CATEGORY 'IYPE

: !UNIT : !MERMER .PRODUCT SIZE 4 YTL PRODUCT PRICE STOCK 3000 PRODUCTPROPERTIES ;_1_.5_C_M_ICA~·~·L~IN~L~IK:._~~~~~~

Figure 18 (product information)

SEARCH BY PRODUCT NUMBER M-4000-04

l\lAINMENU>

~ FIND CATEGORY.,._

PRODUCT

TOTAL NUMBER OF RECORDS · 20

PRODUCT NUMBER : jM-4000-04

: 140•40 : !UNIT

CATEGORY NUMBER

PRODUCT TYPE

E)

CATEGORYTYPE : [MERMER

PRODUCT SIZE

4 YTL

PRODUCT PRICE

STOCK 4000

PRODUCTPROPERTIES: _1_.5_C_M_KA_L::.:IN.:..:L::.:IK.:__ _

Figure 19 (product update)

SEAR.CB BY PRODUCT NUMBER t.1-4000-08

l\lAINMENU>

_.,.. FIND CATEGORY

--4-PRODUCT

TOTAL NUMBEROF RECORDS 20

PRODUCT NUMBER

: I

El

CATEGORY NUJ\IBER

STOCK

: I

3

PRODUCT TYPE PRODUCT SIZE PRODUCT PRICE

OOT FOUf\D THIS PRODUCT!!!

PRODUCTPROPERTIES : ---ı

Figure 20 (search by product number)

ORDER INFOIUIATION

42 3510

ORDER NUlIBER PRODUCT STOCK

ORDER DATE 22.05.2008 118.05.2008

..:.J

PRODUCT PRICE 11 YTL

5

ORDER UNIT 600

CUSTOMERNmIBER

CUSTOMER NAME : jALMARA LTD

..:.J

TOTAL 6600 YTL

MAıı~AGERNAME . HÜSEYİN İHSAN REMAINING STOCK; 3510

PRODUCT NUMBER : jM-4290-06

..:.J

_OK

PRODUCT TYPE 60"60

PRODUCT SIZE UNIT

GRANİT ~TICILI MERMER CATEGORY TYPE

<

©

~

>

®

Figure 21 (order information)

ORDER CONTRACT LEVENT MOZAİK LTD

ORGANİZE SANAYİ BÖLGESİ

LEFKOŞA

CUSTOMER NAME IALMARA LTD ORDER DA ,17.05.2008

ORDER ORDER NUMBER DATE 6 17.05.2008 20 17.05.2008 CUSTOMER NAME ALMARA LTD ALMARA LTD PRODUCT ORDER NUMBER UNIT MG-4050-0 ~ M-4290-06 ~ TOTAL (YTL)

OK

TOTAL PRICE : 14000

CUSTOMER SIGNATURE _{PRINT RETURN BACK} MANAGER.SIGNATURE

Figure 22 (order contract)

•

CALCULATION OFlJNITSOFMARBI.E

m2 200

_m2

20_(!

OK

OK

YOU NEED ONLY 600

UNIT OF J.\.lARBLE •.•

YOU NEED ONLY l-400

UNIT OF MARBLE ...

-....ı•ı..-

RETURNBACK •••-E~·

--Figure 23 (calculate units of marble)

•

Figure 24 (report menu)

llllJSTOMER NO AND NAME /\LM/\Rlı LTD - 6 TEIWEN LTD 7 HARPER LTD 8 H/\SANŞlıllİR LTD 9 MES/IN iNŞAAT ŞTI 10 TENA.I LTD 19!SARIC/ı LTD CUSTOMER MANAGER 'HÜSEYİN İHSAN

I

uı;IN TEKJEN HULUSİHARPER H/\SANŞMİR

CUSTOMERADDRESS CUSTOMERPHONE CUSTOMERE-MAIL

15.06.2008 HffSEYIN/\LTIPARMA!; ·llEMAL TOil ~uçilı; -lçııGRI ı;ABAT/\Ş MEHMET/\RPALl!;LI ~ıİEfı-CEMALBULUTOGLU SOYSALS/\YGINER MUSTAFASARIC/\

i

I

l

SHT.AHMETsııoıı;sus,N0:5 O:J92223~~ALMAHA~U 1"'AIL.I..UJl'I

MEHMET AKiF CAD.TEIWENiş HANI io392227~EN@MSN.COM-H/\SPOL/\TSANAYiBÖLGESİHARPER -lo392235"""HIIRPER@HOTMAİLCOM MEHMETAKİF CAD.N07 T0392227425HASN@HOTMAİL.COM BÜRÜNCÜKsos,MES/INİŞ HANI

I

039222546~MESAN@MSN.COM

OSMANPAŞACAD-ND2 LEF!;OŞ/ı - 039222545İl;TENAJ~HDTM/ıİ~IJ"4_ _ YUSUFŞAHINSOK.N0:8 I0392235465CANOEMIA@HOTM/\İLCOM ŞHT. AHMETS/\DIK SOKN0:1 \03922274251(AB/\T/\S@HOTMAIL.CDM ~/\Yİ BÖLGESiHASPOLlıT__ -,03922356911/\APALİII.Ll@HDTMAIL.COM

HASTANEYOLU 11./\NER iŞ HANI lro9225654Sıı.NR@MSN.COM

---/\TATÜR!;sux,TEMELAPT:1-N0:3 i03922253168ULUTOGLU@HOTMAİL.COM KUZUCUKSOIi.. ONARAPT. N0:6 1o392225B4SSAY61NER@HDTMAIL.COM SHT.IIHMET SADIKSOIi..N0:3 I 0392223!il:SSARICA@HOTMAIL.COM

PRINT RETURN REPORTS

SUPPLIERNO AND NAME çlMSlı LTD. 8 S/\MT/\Ş LTD 9 ERTAŞ LTD

Figure 25 (customer list)

SUPPLIER LIST SUPPLIERADDRESS SUPPLIERPHONE ~STANBUL tı 105556831154 1STANBUL 05356321545 SÜRERsor.. ı;/10111.ÖY/İSTANBU05356328659 SUPPLIERE-MAIL CIMSA@MSN.COM SAMTAS@MSN.COM ERTAS@MSN.COM 15.06.2008 SUPPLIERMANAGER !SALiHYÜCESOY 1ALi BATURAY AHMETERTAŞ

•

PRODUCT NO AND TYPE MG.-.050-0 611"60 M.-.200-04 411"40 G~ 60·60 M-4200-06 60·60 M-4290-04 411"40 l..".11:[,P'..:ııı:uı~ 60·60 M-4000-04 40·40 M-4000·06 60·60 M-4007-04 411"40 M-4010·68 68·153 LEVHA M.-.090-68 68•153 LEVHA MG.-.058-060·60

-MG-4093·0411"40 MG.-.097-040•40 MG.-.098-6SUPURGELlı:: PRODUCTSIZE STOCK UNIT 40001 32001 4000,

f

t

f

STOCKUST 15.06.2008 PRODUCTPRICEAND PROPERTIES 12 2 CM KALINLlı:: -+---4 1.5 CM KALINLIK 13 2 CM KALINLIK ~iALrnLii ~CMKALINLIK 11 2 CM KALINUı:: CATEGORYTYPE GRANiT ı::ATKILIMERMEF, GRANİTKATKILI MERME-PRINT 4 1.5 CM KALINLIK T ' 11 2 CM KALINLIK 4 1.5 CM KALINLIK T E. 3~~

t

11 33 CM UZUNLUK _-·-· -

..

12 2 CM KAUNLIK

-5 1.-5 CM KALINLIK

-

T 5 1.5 CM KALINLIK I 2 7 CM GENİŞLiK40 CM UZUNL~. GRANİTKATKILI MERME GRANİT KATKILI MERME

RETURN REPORTS

Figure 27 (stock list)

15.06.2008

PURCHASEREPORT BETWEEN1WO DATE

[iii:iiiia

OK

PURCHASENO GOODNO

""

DATE PRICE SUPPLIERNO UNIT

1 [sese Ios.05.2000

i

200'

ı

~ 16.05.2008 25İi 118.05.2008 t .•.

·=m.

I

03.05.2008

J

.EL

•

15.06.2008

SELLING REPORT BElWEEN lWO DATE

r,

0.115.2000

ORDER ORDER CUSTOMER NUMBER DATE NAME

42122.05.2008 ALMARA LTD 43 25.05.2008 HARPER LTD 50123.05.2008 HASAN ŞAKI A LTD HASANŞAKİR LTD CANDEMIALTİ>° 1 18.05.2008 - ALMAAALTD 2 18.05.2008 HARPER LTD 3 18.05.2008 ~ı;JENLTD 419.05.2008 TEı;JEN LTD 5 19.05.2008 TEı;JEN LTD 6 17.05.2008 ALMAAA LTD 8 19.05.2008 TEIWEN LTD 9 15.05.2008 TEı;JEN LTD PRINT [29.05.2000 OK PRODUCT OROER NUMBER UNIT ~ MG--4058-0 M-4000-04 M-4000-041 ~ MG-4050-01 M-4200-04! MG-4050-0 20 TOTAi. 6600 106801

i

1600 1200 soo1 ~ 500 4000 RETURN REPORTS

Figure 30 (selling list between two date)

BU PROGRAM ME.BMER FABlUKASI içl:N TASARLANMIŞ OLUP GELİŞTıİRiLMEYE IBTİYACI OLAN BİR

STOCKPROGRAMIDIR.

PROGRAMDADEI,;PBİ 7.0 PROGRAMLAMADbJNİ.Mi'CROSOF-TACCESS VERi TABANINIVB DİZAYN İÇİNDE ADOBE .PBOl'OSB.OP CS2 KULLANDIM.

©

--+

.BIR ONOEJd RECORD

(±) -+

!K'.AYlT EXLE

@

-+

BUSöJ\ı'.MJCi.Qi()()lU)

8

--+,

UYlTSİLME

ALIŞ işLE'MiNDE(PUllCBAS.E) FABRİKADA "ÖRETİMl>EKULLANILAN OR:DNLERİN BİLGİLERİ,

ORtiNLER:IN FİRMA BİLGİLERİVE ALlNAN OltON BıtGILERlNI RAllATLIKLA EKLEM:E,stLMEGONCE~ LEME VE ARAMA YAPABİLtB.SiNtz.

SATIŞiŞLEMiNDE(SELLING) FABRİKADAOılETİLEN''ÖRIDfl.~JUN STOCKBİl.GU.ERİ,tlılE'JiLEN

IOR()'NLEBJNBiLGİLERİ'VE GELEN SİPARİŞ BİLGİLERİNİ KO.LAYCABULABiLİRSİNİZ

illAPAOR.İŞLEMİNDE(REPOllT) M.tl'ŞT.ERİLE.RİN Wl'ESbd,ANLAŞM.ALI OLDUÖUNUZıımMALAIUN LİSTESbdVE:fıd TAJUBARASIALIŞ~SAIIŞ L1STEslNi GÖREBİLiıl VE PlUNTYAPABtı.iRstNtZ.

ANLAŞIUıt\YAl'i.llllBIIAt'IGiJWlPllOllLDIOL1l'ŞTVOONDAB1zıım.AŞ.UUC:w:lNU.1"EIDON ~.

fBONE: OJl2•2U~·

~•z.ı:z;ş4ffl

RETURN MAIN MENU

Figure 31 (help)

•

Figure 32 (about me)

Figure 33 (exit program)

•

DO YOU WA.NT TO CON

YES NO

Figure 34 (exit)