1. Data
Base ΰ?
Information data 츮 ϸ ڷ Ǵ
ִ зؼ ڸ information data̴ information
üȭǴ data ȴ. Data Base ̷ data ̶
̴.
2. Access ΰ?
Access Program data óϿ
ʿ ڿ · ִ α̶
̴.
3. Data Base Ƿ
Access ̿Ͽ ȸ ȸ Data Base
1. ǻ ȸ Data Base
* Access Program Ű
ͺ̽ |
ȭ Access Data Base Ѵ.
database ̸ Բ DB ̸ box file ̸ ECM ̶
ġ ⸦ Ѵ
ECM : ͺ̽ ̺ κ
̺ |
'κ ̺ ' ϰ ''
ϸ Ư ڷ ̸ ڷᰡ ǰ Ǵ Database
⺻̸ ٽ κ ̺ . ̺ Ǿµ
field
record Ѵ.
ECM: ̺ |
||||
|
ʵ̸ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ʵ Ӽ |
||||
|
|
ȭ Ÿ.
ECM: ̺ |
||||
|
ʵ̸ |
|
|
|
|
number |
Ϸùȣ |
|
|
|
name |
text |
|
|
|
id |
text |
|
|
|
code |
|
||
|
E-mail address |
text |
|
|
|
DOB |
¥/ð |
|
|
|
TEL |
text |
|
|
|
mobile phone |
text |
|
|
|
zip code |
text |
|
|
|
address |
text |
|
|
|
school,year |
text |
|
|
|
date of registration |
¥/ð |
|
|
|
sex |
text |
|
|
|
|
|
|
|
|
Ϲ/ȸ |
|
|
|
|
ʵũ |
|
||
|
|
|||
|
Է½ý |
|
||
|
Է ũ |
|
||
|
ĸ |
|
||
|
⺻ |
|
||
|
ȿ ˻ Ģ |
|
|
|
|
ȿ ˻ |
|
|
|
|
ʼ |
|
|
|
|
ڿ |
|
|
|
|
ε |
|
|
|
|
ڵ |
|
|
|
|
|
|
|
field data ּ/ȭȣ/
Ķ ǥõ κ ݵ Է¸ũ Ͽ Ѵ. ̶ Է¸ũ
縦 ȴ.
:
1) Data ǹ
text: ڷᰡ ּó Ǵ ڿ
ڰ յ 츦 ؼ ȭ ȣ ȣ, ȣ ʿ
ȣ Ѵ. 256 ڱ Ѵ.
: ڷᳪ ̰ ڳ
Ѵ. 64000 ڱ ȴ. ַ ڷḦ
· ϰ ȴ.
: ڷᰡ ȭ(ȭ )
꿡 Ǵ Ѵ.
¥/ð: Էµ ڷᰡ -- ¥ Ѵ.
ȭ: ڷᰡ ȭ ϴ 쿡 Ѵ.
ȭ ٴ´ٴ ܿ İ Ѵ. ߿
ݿø ʵ ȭ Ѵ.
Ϸùȣ: ڵ尡 ߰ ڵ ԵǾ
1 ϴ
/ƴϿ: ڷᰡ ϳ Ѵ.
OLE ü: ڷᰡ OLE ؼ ٸ α
MS MS spread sheet, , Ҹ, ü
Ѵ.
۸ũ: ۸ũ ʵ Ѵ.
ȸ: ٸ ̺̳ ڸ Ͽ
ֵ ϴ ʵ带 . ϸ 簡 Ǿ
ش.
̷ ؼ TABLE ϼǸ
DATA Է FORM ȴ.
ٽ ECM database Ʒ
ECM : ͺ̽ ̺ κ
̺ |
߿ '' Ѵ.
ϸ
ECM : ͺ̽ κ
|
Ÿ Ư 찡 ƴ '縦 ̿Ͽ ' Ѵ.
ǥ |
||||
|
ʵ带 ðڽϱ? |
|||
̺ |
|
|
|
|
̺: ECM |
|
|
|
|
|
|
|
|
|
ִ ʵ(A) |
|
ʵ(s) |
|
|
number |
> |
|
|
|
>> |
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
̶ >> Ͽ field Ͽ '' Ѵ.
ϸ
Ͻðڽϱ? |
|||
|
( ) ÷ |
||
|
|
||
|
|
|
|
⼭ Ϲ '÷' Ѵ.
ϴ κ 'ǥ' Ѵ.
Ǿ ִ box Ÿ
'ECM' ϰ ģ.
δ ܰ ̺ ϴ Record
Data ϴ (Query)
ECM ͺ̽ ҷ ü '' ϸ
ȭ鿡
( )
( ) 縦 ̿Ͽ
Ư 찡 ƴϸ Ѵ.
ǥ |
||||
|
ʵ带 ðڽϱ? |
|||
̺ |
|
|
|
|
̺: ECM |
|
|
|
|
|
|
|
|
|
ִ ʵ(A) |
|
ʵ(s) |
|
|
number |
> |
|
|
|
>> |
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
⼭ ʵ 'name, id, code' Ͽ
̵Ų. ߸ ̸ 'penpal' ְ
ħ߸ . penpal Ǹ ĺ penpal ʿ data Ǿ
Ȯ ִ.
4. Data Base Web
4.1 data base table ٷ Homepage ϱ
ģ ȭȣ database table field Homepage Ӽ
'۸ũ' Ͽ ʵ Ӽ
table Ŀ Homepage box ư ۸ũ
Homepage Address ְ Ȯ ȴ.
5. Switch Board
Switch Board ״ switch, ѱ Ҵٰ ϸ ̴.
switch board ϴ Database
ܸ
/Ÿ̽ƿƼ/ġ ذ.
1. ġ ڰ Ÿ
ͺ̽
ȿ ġ带 ã ϴ. θðڽϱ? ϸ
"" Ѵ.
2. ٽ ġ ڰ ""
Ѵ.
3. ġ ȭ ڰ Ÿ ο ߰ Ͽ "θ "" Ѵ.
4. ġ ȭڰ Ÿ "ڿ" κп ߰
Ұ Ÿִ ̸ ԷѴ.
(ȸ˻)
5. ɿ 忡 Ѵ.
6. "table1" Ѵ.
7. ٽ ڿ "űȸ"
߰ϰ ɿ "߰忡 "
Ѵ.
8. ߰Ұ ݱ ϰ ´.
9.
ó access ϰ switch board ϸ
簢BOX
ECM
ȸ˻
űȸ
̶
â .
⼭ ȸ ˻ Ǵ űȸ ȴ.
: switch board ݵ Ⱑ Ͽ Ѵ.
6. filter
: ʹ ϴ ڷḸ field record Ͽ ش.
6.1 : ʵ忡 Էµ ϴ Ŀ ġŰ ڵ// ϴ ʵ尪 شǴ
record Ǿ ȭ鿡 Ÿ. ڵ///
· ȸȴ.
6.2 : field Ѵ. ڵ//
field ܿ ġϰ ȴ. ִ´
εȣ ϸ ȴ. filter Ϸ //
ȴ.
6.3 : ʵ带 콺 ߸
Ͽ ȴ.
Ŀȸ DB