Q{,;ır.\hl~Mll~nı §~@~~§§nı~~@

-. -@w~w

§~@~~§§nı~~@

Q{,;ır.\hl~Mll~nı §~@~~§§nı~~@

@rn~&filul§~ll

GJlAAUAlUILIIOJECJ

•!QUıAOJ)

SUPERVISOR

MR ..,,,

' --- .... ,~f

{filı/!J^-....,ı,..'..··,,,^_;,_

} ·~-

NİCOSİA, 1999

ffiEX

... ,.. , _ 1

Database 3

/hat thay are and how they work? 4-8

Tf'\rmc;: ...9-11

Result Summary 13-18

By Assignment 19-23

Result By Student 24-27

dent Schedules 28-29

ent:s , '9 •••••••••••••••••••••••• 30

Coechısion 31

· · · · 3 2

~TRODUCTION

(

ess is really just one part of Microsoft all data management product strategy.

JC -•• Access is not just a database; it also complements other ooucısbecause it has several powerful features.

ess does have a data storage system, and like all

~ - u ...ıcuional databases, it allows you to link related information ple, customer and order data that you enter. One of

of Microsoft Access, as its name implies, is that ata from other sources, including many popular

ııaıaua,;~. pı.'-".51Q.UJ.S and many SQL databases on serves, ı:ninicompuıeı' and mainframes. With the implementation of

ach oczf OLE 2 in version 2, Access now fully integrates with the + 1 , :ıııı,tieations in the Microsoft Office package: Microsoft

soft Excel, Power Point, and Microsoft Mail.

rosoft Access also has a very sophisticated application neı,,ıpınnmentsystem for the Microsoft Windows operating system,

akes extensive use of information about your data

~r the data source to help you build applications quicly. In can build simple applications by defining forms and

ed on your data and linking them together with a few acros or a few Microsoft Access Basic statements; there's

-.-u

. {

{

f

mall businesses, Microsoft Access is all that's required manage the data used to run the business. Microsoft

\o:css coupled with Microsoft SQL Server is an ideal way for

--.,, llA-U.lu.lll sized companies to build new applications for

ery quickly and inexpensively. For large corparations a big investment in mainframe relational database u.ı,:ı,.ucarions that rely on PC databases, Microsoft Access provides

••••• "V~ to easily link host and PC data in a single Windows based

1

'hat Is a Database?

saııpıest sense, a database is a collection of records and

wsyıııu ed for a particular purpose. On your computer

LLLL5""~ xeep the names and addresses of all your friends

erhaps you collect all the letters you write and ., recipient. You might have another set of files in eep all your financial data accounts payable and

· able or your checkbook entries and balances. The uınents that you organize by topic are one type

.,r organized, you can probably manage several 1 ltılsprr.adsbeetsby using directories and subdirectories.

· you are the database manager. But what do you ems you are trying to solve get too big? How can information about all customers and their orders

· ght be stored in several document and spreadsheet can you maintain linkages between the files when you rmation? How do you ensure that data is being entered

at if you need to share your information with many do not want two people to try updating the same data at

es? Faced with these challenges, you need a Database

!'I e,:ment Sysyem.

J

2

ational Databases

'•.._.•

'-2Flv all modern database management systems store and

onnation using the relational database management name relational systems from the fact that each record tlıabase contains information related to a single subject and

subject. Also, data about two classes of information can uıoınpulated as a single entity based on related data values. For e1wople! it would be redundant to store customer name and

ation with every order that the customer placed. So, em, the information about orders contains a data

uaıa, such as a customer number, that can be used

der with customer information.

~ database management system, sometimes called stem manages all data in tables. Tables store iıdmmaiion about a subject and have columns that contain the

information about the subject and rows that ibutes of a single instance of the subject. Even e of DBMS facilities to fetch information from

ıaun.;,, the result is always something that looks like

act, you can execute one query that uses the

3

<H ••ey are and how they work?

base is a collection of informatıon related to a

ubject or purpose, such as tracking student orders. If

••••. dııabase isn't stored on computer, or only parts of it are, you eking information from variety of sources that you are coordinate and organize yourself.

4

ey are and how they work?

·.r

sing Microsoft Access, you can manage all your

ıwliıı- mation from a single database file. Within the file, divide your

into separate storage containers called tables; view, add, and

ıııııuate table data using online forms; find and retrieve just the data 'ant using queries; and analyze or print data in a specific

. out using reports.

5

~un. your data, create one table for each type of - 5+ ztion you track. To bring the data from multiple tables

a query, form, or report, you define relationships e tables.

\f

6

ases: wnar they are and how they work?

d and retrieve just the data that meets conditions you luding data from multiple tables, create a query. A also update or delete multıple records at the same time,

au ••m built-in or custom calculations on your data.

7

at they are and how they work?

--.a.1 view, enter, and change data directly in a table,

.ll'!ıo'!allı.· When you open a form, Microsoft Access retrieves

one or more tables and displays it on screen using the se in the form wizard or using a layout that you scratch. To analyze your data or present it a certain create a report. For example, you might print one oups data and calculates totals, and another report different data formatted for printing mailing labels. To work

~ects in a microsoft access database, use the database

-- a,._^aick a tab to view a list of the available objects of that e buttons to the right of the list, you can open or

•IIElilllf~.existing objects and create new ones. You create the link orm and its record source by using graphical objects

ls. The most common type of control used to display ata is a text box. Most of the information in a form

an underlying record source. Other information in a din the form's design.

8

·oEGtRMENLiıt·~---~--

ı...,.,,,ş_ .•,,,-.~=.••.--=--,-"' »••~:-,... .%.,,,., .. ~ .•~ '"''·'"gita<,<,"' ,,.. «~» ,,

'CEFKOSE..~~·~~~-~.,,_,

· ..!4'!'!', !'.? +::, 1-ı,,~ 4":!'-···*~

,\,·\

-~!'!~'!'l-~'1'!;,

--- ••,,...,"'lrrf!'l",'!"!<!'t'!°"it

-

~·_J

,>zGUR ..;;,ı.._^{.,_,.,,Addre" .--·.} -·~·~··- ^{' • ' •'}

L-. -· '.·· c· fORTAKO·Y·.· . -~·~••---~---· . . .·

. ...,_.J_{.. ...,} ^{tty ,-},tEFKOse"""'"- ^{- ..}

Vo.iij ---~-

1

-.!.-.-.~,-,,.,ı,ı-ı,11"1'1'!'1"rM"f'M1-H"~nm·,·r!"!'?,...li'..-m't"!111•,l"\"!On'!-·~,:,

pR.T AKOY · j:

~c,-+:!.%.Y. "!'! ,_ ..e-r-e+r-t-t-t-rr-trtrrrr :::~

===;;:;::::=~=-] Address

-.a.~ .. :-:;·:::~ ^cny

~:>IH: ·-·""*'",_,...;,.J

:·~:!E}]l

LOZGUR OZ ERDEM O) 555-1234

9

10

11

~ ô gı n

~::

1:5?a~=_{~ 00 "'}

o z_Al n_{•••••}

=

~~

r

-·

~•••••

-·

f

(1Q

g. ~

N w

::ı

'"rJ

- 1*t:

'"rJ

=

~ ~ ~ ii}

3

~

~=

i

<.,.)

=

\;J w C I •••••

::ı;::;:

(II

ı,,- •••••• w r

o o o o

o - o (')

!- a

N -·

o o

::ı

12

w ^oii "Oi

n : ^Dl

ı:: ~

o z

::ı 3

2 ^{111 (I)}

C 3 ::ı

!I> -

3 z

I ^~

er _IIJ

ll) 3

.., •••

il)

~r,..ı r,..ı

20

_I

~ - ^{QC fl>}r,..ı

2 _~

=

tT'J ••••

~ ~

.J ^r,.ı

~ 00

=e e~

~

13

14

15

16

17

18

ment

= 100)

Score 55

" • cı, • _,

• ~~~ •• 1111S:'

-~~

Score 100

Score 90

Score 100

Score 89

19

20

Score 100

Score 190

Score 200

Score

143

100

'f -ıy Assignment (Maxiınum'İ>oints": }00}

Student Name CELIK,ESRA

Score 87

1 • Tables (Maximum Points ""..100).

Student Name CELIK,ESRA

Score

2 - Queries (Maximum~o.mis:=I00) • · l

Student Name CELIK,ESRA

Score 100

3 • Forms Waximuı:n,,Points=100) Student Name

CELIK,ESRA

Score 90

Exam (Maximum Points "'_{. ... .. ;,-· .}300)._{;,. '} ..

Student Name CELIK,ESRA

Score 300

21

Points =200)

.gnment

Score 56

Score 89

Score 90

Score 88

= ¹⁵⁾

Score 98

22

-ESi-il. BAHADIR

,]

Score 99

Sc9re 100

Score

100

Score 89

Score 279

23

'#.

o..•.

w Vı - ⁽ⁱ⁾

Vı V, o :=, o

o o o ^o o Dl

o o o j ^{o o.}

~ ~ ~ ~ ^(O

" ^Q

sı o ^{~ ~} ~ cı

1),1

3

g

1),1 )<

""O

- ^{N N - s·}o

- ^{o 8 8 8 S'}

V, o

U)n

- ^{•.... Vı o}

00 s ^{\O o}

\Cl o o ^Vı ;a

o o o o Da

(O

24

? ^'T1ı ~ I "

g'_- t ^{el: !!?.}

r ^{~ ~ j'< cg}

8 t· ~

a ~_:ı.

-aö' :,

f)(

ı:ı

N 2.

- ^N - ^:,

VI. o s ^{o ı;}

o o o

""t'J

1 ^{~ "t:I ~ )>}

s· ^...•

e:. ^{'-'· .2.} !i·

r

; ^ij_~· ^~i ^aC

a ^ro(I)n

:,, ]:o_::ı

'.>,!I oa

V, - ^{... ... N (j')}

o o f::> o !='

o ^{o o} o ^o a

~ s ^{o o} s ^c:ı.

" ^~ .!-. ~ ~ ^ID

~ o o o om⁾⁽

Al

3

3:Al )(

"ti

o

w - ^{- - - !}

o o o o o

o o o o o

-. -@w~w

§~@~~§§nı~~@

Q{,;ır.\hl~Mll~nı §~@~~§§nı~~@

@rn~&filul§~ll

GJlAAUAlUILIIOJECJ

•!QUıAOJ)

SUPERVISOR

MR ..,,,

' --- .... ,~f

{filı/!J^-....,ı,..'..··,,,^_;,_

} ·~-

NİCOSİA, 1999

ffiEX

... ,.. , _ 1

Database 3

/hat thay are and how they work? 4-8

Tf'\rmc;: ...9-11

Result Summary 13-18

By Assignment 19-23

Result By Student 24-27

dent Schedules 28-29

ent:s , '9 •••••••••••••••••••••••• 30

Coechısion 31

· · · · 3 2

~TRODUCTION

(

ess is really just one part of Microsoft all data management product strategy.

JC -•• Access is not just a database; it also complements other ooucısbecause it has several powerful features.

ess does have a data storage system, and like all

~ - u ...ıcuional databases, it allows you to link related information ple, customer and order data that you enter. One of

of Microsoft Access, as its name implies, is that ata from other sources, including many popular

ııaıaua,;~. pı.'-".51Q.UJ.S and many SQL databases on serves, ı:ninicompuıeı' and mainframes. With the implementation of

ach oczf OLE 2 in version 2, Access now fully integrates with the + 1 , :ıııı,tieations in the Microsoft Office package: Microsoft

soft Excel, Power Point, and Microsoft Mail.

rosoft Access also has a very sophisticated application neı,,ıpınnmentsystem for the Microsoft Windows operating system,

akes extensive use of information about your data

~r the data source to help you build applications quicly. In can build simple applications by defining forms and

ed on your data and linking them together with a few acros or a few Microsoft Access Basic statements; there's

-.-u

. {

{

f

mall businesses, Microsoft Access is all that's required manage the data used to run the business. Microsoft

\o:css coupled with Microsoft SQL Server is an ideal way for

--.,, llA-U.lu.lll sized companies to build new applications for

ery quickly and inexpensively. For large corparations a big investment in mainframe relational database u.ı,:ı,.ucarions that rely on PC databases, Microsoft Access provides

••••• "V~ to easily link host and PC data in a single Windows based

1

'hat Is a Database?

saııpıest sense, a database is a collection of records and

wsyıııu ed for a particular purpose. On your computer

LLLL5""~ xeep the names and addresses of all your friends

erhaps you collect all the letters you write and ., recipient. You might have another set of files in eep all your financial data accounts payable and

· able or your checkbook entries and balances. The uınents that you organize by topic are one type

.,r organized, you can probably manage several 1 ltılsprr.adsbeetsby using directories and subdirectories.

· you are the database manager. But what do you ems you are trying to solve get too big? How can information about all customers and their orders

· ght be stored in several document and spreadsheet can you maintain linkages between the files when you rmation? How do you ensure that data is being entered

at if you need to share your information with many do not want two people to try updating the same data at

es? Faced with these challenges, you need a Database

!'I e,:ment Sysyem.

J

2

ational Databases

'•.._.•

'-2Flv all modern database management systems store and

onnation using the relational database management name relational systems from the fact that each record tlıabase contains information related to a single subject and

subject. Also, data about two classes of information can uıoınpulated as a single entity based on related data values. For e1wople! it would be redundant to store customer name and

ation with every order that the customer placed. So, em, the information about orders contains a data

uaıa, such as a customer number, that can be used

der with customer information.

~ database management system, sometimes called stem manages all data in tables. Tables store iıdmmaiion about a subject and have columns that contain the

information about the subject and rows that ibutes of a single instance of the subject. Even e of DBMS facilities to fetch information from

ıaun.;,, the result is always something that looks like

act, you can execute one query that uses the

3

<H ••ey are and how they work?

base is a collection of informatıon related to a

ubject or purpose, such as tracking student orders. If

••••. dııabase isn't stored on computer, or only parts of it are, you eking information from variety of sources that you are coordinate and organize yourself.

4

ey are and how they work?

·.r

sing Microsoft Access, you can manage all your

ıwliıı- mation from a single database file. Within the file, divide your

into separate storage containers called tables; view, add, and

ıııııuate table data using online forms; find and retrieve just the data 'ant using queries; and analyze or print data in a specific

. out using reports.

5

~un. your data, create one table for each type of - 5+ ztion you track. To bring the data from multiple tables

a query, form, or report, you define relationships e tables.

\f

6

ases: wnar they are and how they work?

d and retrieve just the data that meets conditions you luding data from multiple tables, create a query. A also update or delete multıple records at the same time,

au ••m built-in or custom calculations on your data.

7

at they are and how they work?

--.a.1 view, enter, and change data directly in a table,

.ll'!ıo'!allı.· When you open a form, Microsoft Access retrieves

one or more tables and displays it on screen using the se in the form wizard or using a layout that you scratch. To analyze your data or present it a certain create a report. For example, you might print one oups data and calculates totals, and another report different data formatted for printing mailing labels. To work

~ects in a microsoft access database, use the database

-- a,._^aick a tab to view a list of the available objects of that e buttons to the right of the list, you can open or

•IIElilllf~.existing objects and create new ones. You create the link orm and its record source by using graphical objects

ls. The most common type of control used to display ata is a text box. Most of the information in a form

an underlying record source. Other information in a din the form's design.

8

·oEGtRMENLiıt·~---~--

ı...,.,,,ş_ .•,,,-.~=.••.--=--,-"' »••~:-,... .%.,,,., .. ~ .•~ '"''·'"gita<,<,"' ,,.. «~» ,,

'CEFKOSE..~~·~~~-~.,,_,

· ..!4'!'!', !'.? +::, 1-ı,,~ 4":!'-···*~

,\,·\

-~!'!~'!'l-~'1'!;,

--- ••,,...,"'lrrf!'l",'!"!<!'t'!°"it

-

~·_J

,>zGUR ..;;,ı.._^{.,_,.,,Addre" .--·.} -·~·~··- ^{' • ' •'}

L-. -· '.·· c· fORTAKO·Y·.· . -~·~••---~---· . . .·

. ...,_.J_{.. ...,} ^{tty ,-},tEFKOse"""'"- ^{- ..}

Vo.iij ---~-

1

-.!.-.-.~,-,,.,ı,ı-ı,11"1'1'!'1"rM"f'M1-H"~nm·,·r!"!'?,...li'..-m't"!111•,l"\"!On'!-·~,:,

pR.T AKOY · j:

~c,-+:!.%.Y. "!'! ,_ ..e-r-e+r-t-t-t-rr-trtrrrr :::~

===;;:;::::=~=-] Address

-.a.~ .. :-:;·:::~ ^cny

~:>IH: ·-·""*'",_,...;,.J

:·~:!E}]l

LOZGUR OZ ERDEM O) 555-1234

9

10

11

~ ô gı n

~::

1:5?a~=_{~ 00 "'}

o z_Al n_{•••••}

=

~~

r

-·

~•••••

-·

f

(1Q

g. ~

N w

::ı

'"rJ

- 1*t:

'"rJ

=

~ ~ ~ ii}

3

~

~=

i

<.,.)

=

\;J w C I •••••

::ı;::;:

(II

ı,,- •••••• w r

o o o o

o - o (')

!- a

N -·

o o

::ı

12

w ^oii "Oi

n : ^Dl

ı:: ~

o z

::ı 3

2 ^{111 (I)}

C 3 ::ı

!I> -

3 z

I ^~

er _IIJ

ll) 3

.., •••

il)

~r,..ı r,..ı

20

_I

~ - ^{QC fl>}r,..ı

2 _~

=

tT'J ••••

~ ~

.J ^r,.ı

~ 00

=e e~

~

13

14

15

16

17

18

ment

= 100)

Score 55

" • cı, • _,

• ~~~ •• 1111S:'

-~~

Score 100

Score 90

Score 100

Score 89

19

20

Score 100

Score 190

Score 200

Score

143

100

'f -ıy Assignment (Maxiınum'İ>oints": }00}

Student Name CELIK,ESRA

Score 87

1 • Tables (Maximum Points ""..100).

Student Name CELIK,ESRA

Score

2 - Queries (Maximum~o.mis:=I00) • · l

Student Name CELIK,ESRA

Score 100

3 • Forms Waximuı:n,,Points=100) Student Name

CELIK,ESRA

Score 90

Exam (Maximum Points "'_{. ... .. ;,-· .}300)._{;,. '} ..

Student Name CELIK,ESRA

Score 300

21

Points =200)

.gnment

Score 56

Score 89

Score 90

Score 88

= ¹⁵⁾

Score 98

22

-ESi-il. BAHADIR

,]

Score 99

Sc9re 100

Score

100

Score 89

Score 279

23

'#.

o..•.

w Vı - ⁽ⁱ⁾

Vı V, o :=, o

o o o ^o o Dl

o o o j ^{o o.}

~ ~ ~ ~ ^(O

" ^Q

sı o ^{~ ~} ~ cı

1),1

3

g

1),1 )<

""O

- ^{N N - s·}o

- ^{o 8 8 8 S'}

V, o

U)n

- ^{•.... Vı o}

00 s ^{\O o}

\Cl o o ^Vı ;a

o o o o Da

(O

24

? ^'T1ı ~ I "

g'_- t ^{el: !!?.}

r ^{~ ~ j'< cg}

8 t· ~

a ~_:ı.

-aö' :,

f)(

ı:ı

N 2.

- ^N - ^:,

VI. o s ^{o ı;}

o o o

""t'J

1 ^{~ "t:I ~ )>}

s· ^...•

e:. ^{'-'· .2.} !i·

r

; ^ij_~· ^~i ^aC

a ^ro(I)n

:,, ]:o_::ı

'.>,!I oa

V, - ^{... ... N (j')}

o o f::> o !='

o ^{o o} o ^o a

~ s ^{o o} s ^c:ı.

" ^~ .!-. ~ ~ ^ID

~ o o o om⁾⁽

Al

3

3:Al )(

"ti

o

w - ^{- - - !}

o o o o o

o o o o o

~o

~ ^t..ıı - a^G')

V\ t..ıı p o p

8 o 8 o ^o a

~ ~ ^o g.

~ ~ ~

Q Q

" ^o

~ o ^{~ ~} [SJ !.11

I»

3

s:I»

><

"t1

- ^{N N ... s·}o

ti: 8 ^oo 8 8 ^Q!'

Ch C,

\O OC) o

8 ^{QC) 'J> •••}

C)C) 00 \Q °' cıı

~ODD~t"

-

cıı

27

28

~ee

8

00

ğ

29

O•iI

~I

~i~I

oiNi

~Imı

~l

w'I

!

ı

_!I

o:-!

~

QO

8

30

CONCLUSION

Microsoft Access has all the features of a classic database management system and more. Access is not only a powerful, flexible, and easy to use DBMS but also a complete database

application development facility. You can use Access to create and run under the Microsoft Windows operating system an application tailored to your data management needs. You can limit, select, and total your data using queries. You can create forms for viewing and changing your data. You can also use Access to create simple or complex reports. Both forms and reports inherit the properties of the underlying table or query, so in most cases you need to define such things as formats and validation rules only once. Among the most powerful features of access are the wizards that you can use to create tables and queries and a customize a wide variety of forms and reports simply by selecting from options with your mouse. Access makes it easy for you to link data to forms and reports using macros to fully automate your application. You can build most applications without ever having to write anything that looks remotely like computer program code. But if you need to get really like sophisticated, there's also a comprehensive

programming language, Microsoft Access Basic, that you can use to add complexity to your applications.

Finally, you get all these development facilities not only for working with the access database but also to attach to and work with data stored in many other popular formats. You can build an Access application to work directly with dBase files; with Paradox, Btrieve, and Foxpro databases; and with SQL database that

supports the Open Database Connectivity standard. You can also easily import and export data as text, word processing files, or spreadsheet files.

31

SOURCES

1) Microsoft Access 2

"John L. Viescas"

2) Microsoft Access 7.0

"Faruk Çubukçu"

3) Learn dBase

"Russell A. Stultz"

4) dBase

"Halim Korkmaz"

32

_... -