.

MS Access

Язык: русский
Формат: реферат
Тип документа: Word Doc
83 1556
Скачать документ

Ineianeee Aieueiue oieaa?neoao

Eo?niaay ?aaioa

MICROSOFT ACCESS

nooaeaoia 3 eo?na

oaeoeueoao eioi?iaoeeiiiuo nenoai

Aaiaoiaa Ieaaa Nayoineaaiae/a

Coaaa TH?ey Aeaaeeie?iae/a

Iao/iue eiinoeueoaio: Aanei TH?ee Aa?aiiae/.

a.Ineia 1995a.

NIAeA?AEAIEA

Aaaaeaiea.

Access – /oi yoi oaeia.

1. Ianeieueei neia i …

2. Oaaeeoeu.

3. Cai?inu.

4. Oi?ioey?u.

5. Io/aou.

6. Iae?inu.

7. Iiaeoee.

Iino?iaiea iaaieueoie Aacu aeaiiuo.

Iaaieueoay n?aaieoaeueiay oa?aeoa?enoeea.

1. AAAAeAIEA.

Ia?aae oai eae i?enooieoue e eco/aieth NOAAe ACCESS ?anniio?ei
ianeieueei iniiaiuo iiiyoee.

Aeaiiua – nenoaiaoece?iaaiiay e no?oeoo?e?iaaiiay eaeei-eeai ia?acii
eioi?iaoeey. Nouanoaotho ii e?aeiae ia?a o?e iiaeaee aeaiiuo:
ea?a?oe/aneay, naoaaay, ?aeyoeeiiiay.

Iiaeaee aeaiiuo – i?aaenoaaeaiea aeaiiuo e eo acaeiinaycae, iienuaathueo
iiiyoey i?iaeaiiie n?aaeu. Iiaeaee aeaiiuo eniieuecothony eae aeey
eiioeaiooaeueiiai , oae e aeey eiae/aneiai e oece/aneiai i?aaenoaaeaiey
aeaiiuo.

A aeaiiie ?aaioa iu aoaeai ?anniao?eaaoue oieueei eiae/aneia
i?aaenoaaeaiea aeaiiuo, o.a. n oi/ee c?aiey i?eeeaaeiiai i?ia?aiienoa e
iieueciaaoaey. N eo oi/ee c?aiey aeaiiua aeaeyony ia caiene, oa a naith
i/a?aaeue aeaeyony ia iiey, e iaaeaeo iieyie, a oae aea e iaaeaeo
caienyie iiaoo auoue onoaiiaeaiu ?acee/iua nayce.

Iiea – iniiaiie e ieieiaeueiue yeaiaio aeaiiuo.

Caienue – ianeieueei iieae.

Nayce – eiae/aneea acaeiinayce iaaeaeo caienyie eee iieyie.

Ea?a?oe/anee no?oeoo?e?iaaiiua aeaiiua ninoiyo ec ianeieueeeo caienae
iaeia ec eioi?uo ii?aaeaeaia eae ei?iaaay. I?eia?ii ea?a?oe/aneie
iiaeaee iiaoo neoaeeoue aea?aauey:

Aaea EEEAIO, CAEAC, OI?AIAUE AAAIO yaeythony caienyie (EEEAIO –
ei?iaaay caienue), IIIA?, OAIEEEss, EIss, IO*ANOAI – iiey caiene EEEAIO,
eeieyie iieacaiu nayce.

Aea?aai – i?eaioe?iaaiiue a?ao(a?ao – ia?a iiiaeanoa, iaeii ec eioi?uo
iienuaaao iiiaeanoai aa?oei, a ae?oaia iiiaeanoai naycae iaaeaeo ieie)
aaea ana aa?oeiu, e?iia ei?iy, iaoiaeyony a aieiaa oieueei iaeiie aeoae,
ei?aiue ia iaoiaeeony a aieiaa ie iaeiie ec aeoa e naycai n aa?oeiie
aea?aaa.

Iaaeaeo caienyie a ea?a?oee iiaoo auoue ii?aaeaeaiu nayce: “iaeei ei
iiiaei”, eee “iaeei e iaeiiio”, aaea caienue niioaaonoaothuay yeaiaioo
“iaeei” oeacaiiie nayce, ii?aaeaeyaony eae enoiaeiay, a niioaaonoaothuay
yeaiaioo “iiiai” – eae ii?iaeaeaiiay.

Naoaaay iiaeaeue iiaeiaia ea?a?oe/aneie, ii yaeyaony aieaa iauae
iiaeaeueth, a oii niunea, /oi iaaeaeo caienyie i?enoonoaotho nayce
“iiiai ei iiiaei” e “iiiai e iaeiiio”, a oae aea caeanue iao ei?iaaiai
ocea, o.a. ethaay caienue iiaeao auoue ei?iaaie.

Naoaaay iiaeaeue:

Aaea EEEAIO, CAEAC, OI?AIAUE AAAIO yaeythony caienyie, IIIA?, OAIEEEss,
EIss, IO*ANOAI – iiey caiene EEEAIO, eeieyie iieacaiu nayce.

?aeyoeeiiiay iiaeaeue aeaiiuo yaeyaony iaeiei ec naiuo i?inouo aeaeia
i?aaenoaaeaiey eioi?iaoeee e naiie eaaeie eiioeaioeeae aeey iiieiaiey.
Yoa iiaeaeue i?aaenoaaeyao niaie aeaiiua oii?yaei/aiiua a oaaeeoeu, /aoa
anaai aeaooia?iua. Oaaeeoeu oaeiai aeaea iacuaathony ioiioaieyie
(?aeyoeeyie) e eaaeaeay oaaeeoea i?aaenoaaeyao niaie ioaeaeueiue oaee.

?aeyoeeiiiay iiaeaeue:

No?iea Noieaaoe

Iiea

IIIA? – CAEACA IACAAIEA – CAEACA OI?AIAUE AAAIO

IIIA? – OI?AIAIAI AAAIOA OAIEEEss EIss IO*ANOAI IINOAAEssAIUE OIAA?

Eaaeaeay oaaeeoea ninoieo ec noieaia, no?ie eaaeaeiio noieaoeo i?enaiaii
iaeiicia/iia eiy, iaeei yeaiaio noieaoea iacuaaaony iieai, a no?iea
iacuaaaony caienueth. Aeaiiue i?eia? iieacuaaao, /oi e naoaaay iiaeaeue,
e ea?a?oe/aneay iiaoo auoue i?eaaaeaiu e ?aeyoeeiiiie.

No?oeoo?e?iaaiiua oaeei ia?acii aeaiiua iiaoo o?aieony a YAI a aeaea Aac
Aeaiiuo. Aaca aeaiiuo iiaeao auoue ii?aaeaeaia eae niaieoiiinoue
i?aaeiacia/aiiuo aeey iaoeiiie ia?aaioee e o?aiaiey aeaiiuo, eioi?ua
iiaoo eniieueciaaoueny iaeiei eee ianeieueeeie iieueciaaoaeyie.

A caaeneiinoe io ?anniio?aiiuo auoa iiaeaeae aeaiiuo aacu aeaiiuo iiaoo
auoue ea?a?oe/aneei, naoaauie e ?aeyoeeiiuie. Aeaeueoa iu aoaeai
?anniao?eaaoue oieueei ?aeyoeeiiiua aacu aeaiiuo.

N aacaie aeaiiuo ia?ac?uaii naycaii oaeia iiiyoea eae NOAAe.
NOAAe(nenoaia oi?aaeaiey aacaie aeaiiuo) – i?ia?aiia eioi?ay oi?aaeyao
aeaiiuie, inouanoaeyao o?aiaiea, ecaea/aiea, iiene, ?aaeaeoe?iaaiea
eioi?iaoeee o?aieiie a aaca aeaiiuo. NOAAe oaeaea iiae?acaeaeythony ia
ea?a?oe/aneea, naoaaua e ?aeyoeeiiua a caaeneiinoe io aeaiiuo eioi?ua
iie ia?aaaouaatho. Nouanoaotho iiiaeanoai ?acee/iuo NOAAe: IMS, NAOI?,
ORACLE, CLIPPER, FOX PRO, ACCESS. A aeaiiie ?aaioa iu ?anniio?ei oieueei
MICROSOFT ACCESS.

2. MICROSOFT ACCESS.

Ianeieueei neia i …

Microsoft Access – yoi eioa?aeoeaiay ?aeyoeeiiiay NOAAe(relational
database management system – RDBMS ) aeey WINDOWS . Yoi i?ia?aiia,
eioi?oth Au iiaeaoa eniieueciaaoue aeey o?aiaiey e ecaea/aiey aeaiiuo a
caaeneiinoe io ioiioaiee, eioi?ua Au onoaiiaeee. ?aaioa n iae oi?iuaia
iin?aaenoaii iaieioeyoi?a iuoe. A?aoe/aneea aiciiaeiinoe iaiei/ee
i?iecaiaeyo aieueoia aia/aoeaiea i?e ecaioiaeaiee aunieiea/anoaaiiuo
io/aoia e ?ania/aoie. Ana yoi aeaaiaea?y iiaeaea?aeee True-type
o?eooia e ano?aeaaiey OLE-iauaeoia(Object Linking and Embeding) a ?aieao
n?aaeu WINDOWS. OLE – iauaeo i?aaenoaaeyao niaie nnueeo ia
ii?aaeaeaiioth eioi?iaoeeth, eioi?ay inoaaony a naiae ia?aiia/aeueiie
oi?ia. OLE-iauaeoii iiaeao auoue EXCEL – oaaeeoea, Paintbrush –
eeethno?aoeey eee Sound – oaee.

Iiaeieie i?ia?aiiu Access yaeyaony Cue Cards – Nenoaia nooee?iaaiey. Yoi
iao/athuay nenoaia, i?aaeinoaaeythuay iieueciaaoaeth ?aeiiaiaeaoeee ii
auoiaeo ec ?aaeueiuo neooaoeee i?e ?aoaiee i?eeeaaeiuo caaea/. I?e
ciaiee aiaeeeneiai ycuea iieueciaaoaeue anaaaea niiaeao iieo/eoue
iiaeneaceo i oii, /oi neaaeoao aeaeaoue aeaeaa.

Access oaeaea i?aaeinoaaeyao a ?anii?yaeaiea iieueciaaoaey iaoaieciu
?aaiou n aacaie aeaiiuo ?acee/iuo oi?iaoia. E i?eia?o, iiaeii i?yii
ia?auaoueny e aacai aeaiiuo dBASE, Paradox eee Btrieve aac
eiiaa?oe?iaaiey eo a oi?iao, eniieuecoaiue Access. A ninoaa iaeaoa
Access oaeaea aoiaeeo ycue Access Basic (ano?iaiiue aeeaeaeo ycuea
Visual Basic ), aeathuee aiciiaeiinoue oi?ie?iaaiey niaoeeaeece?iaaiiuo
nenoai oi?aaeaiey aacaie aeaiiuo.

Oaia?ue ia?aeaeai e aieaa iiae?iaiiio ?anniio?aieth nenoaiu Access.
Iniiaiuie iiiyoeyie eee iauaeoaie yoie nenoaiu yaeythony: oaaeeoeu,
cai?inu, oi?ioey?u, io/aou, iae?inu e iiaeoee. E eiia/ii aea aeaaiui
iiiyoeai aoaeao aaca aeaiiuo (database).

Aaca aeaiiuo yoi iaai? aeaiiuo, eioi?ue naycai n ii?aaeaeaiiie oaiie
eee iacia/aieai. Eiaaea Au nicaeaaoa aaco aeaiiuo a Microsoft Access, Au
nicaeaaoa iaeei oaee, eioi?ue niaea?aeeo ana oaaeeoeu, cai?inu,
oi?ioey?u, io/aou e ae?oaea iauaeou, eioi?ua iiiiaatho Aai
eniieueciaaoue eioi?iaoeeth a aaca aeaiiuo. Aeey nicaeaiey aacu aeaiiuo
iaiaoiaeeii auiieieoue neaaeothuea oaae :

Aeoeaece?oeoa ieii Microsoft Access e auaa?eoa a iaith File aee?aeoeao
New Database (eee uaeeieoa eiiieie New Database a no?iea ieeoia?aii).
Microsoft Access aunaa/eaaao aeeaeiaiaia ieii New Database e
aaoiiaoe/anee aeaao eiy Aaoae aaca aeaiiuo , eioi?ia Au iiaeaoa
caiaieoue.

A no?iea File Name, iaia/aoaeoa Aao aa?eaio eiaie aacu aeaiiuo. Iii
iiaeao niaea?aeaoue aei 8 neiaieia aac i?iaaeia. Microsoft Access
aaoiiaoe/anee aeiaaaeyao ?anoe?aiea .MDB e eiaie Aaoae aacu aeaiiuo,
anee Au yoiai ia naeaeaee.

Anee Au oioeoa o?aieoue aaco aeaiiuo a ii?aaeaeaiiii ianoa auaa?eoa
niioaaonoaothuoth aee?aeoi?eth a nienea aee?aeoi?ee Directories list.

Iaaeieoa ia eiiieo OK.

Microsoft Access nicaeaao ionoie oaee aacu aeaiiuo e ioe?uaaao ieii aacu
aeaiiuo Database window.

Ieii Aacu aeaiiuo:

Nicaeaiioth aaco aeaiiuo iiaeii iaiieieoue iauaeoaie ?acee/iiai ?iaea e
auiieiyoue iia?aoeee n ieie. Ii n aacie aeaiiuo iiaeii auiieiyoue
iia?aoeee eae n iaaeaeeiui ia?aciaaieai. Ana iia?aoeee oaeiai ?iaea –
iia?aoeee oi?aaeaiey aacie aeaiiuo – nin?aaeioi/aiu a iaith File
i?eeeaaeiiai ieia Access eee a ieia aacu aeaiiuo. Iai?eia?, iia?aoeey
ioe?uoey aacu aeaiiuo aeeth/aao neaaeothuea oaae:

Anee iaiaoiaeeii, aeoeaece?oeoa Microsoft Access.

Ec iaith File auaa?eoa aee?aeoeao Open Database (eee uaeeieoa eiiieie
Open Database a no?iea ieeoia?aii ). Microsoft Access aunaa/eaaao
aeeaeiaiaia ieii Open Database.

A no?iea File Name auaa?eoa niioaaonoaothuaa eiy aacu aeaiiuo,
i?aaeaa?eoaeueii aua?aa niioaaonoaothuoth aee?aeoi?eth a nienea
aee?aeoi?ee Directories list e niioaaonoaothuee iaeiieoaeue a no?iea
Drives.

Iaaeieoa ia eiiieo OK.

Microsoft Access aunaaoeo ieii niioaaonoaothuae aacu aeaiiuo. I?e
ioe?uoee aacu aeaiiuo iiaeii ia?aie/eoue aiciiaeiua iia?aoeee n aacie
aeaiiuo oieueei /oaieai e ia?aie/eoue e?oa iieueciaaoaeae, eiathueo
aeinooi e aaca aeaiiuo oieueei nianoaaiiie ia?niiie. Oaeea ia?aie/aiey
iiaoo ieacaoueny iieaciuie, anee aaca aeaiiuo yenieoaoe?oaony a
iiiaiiieueciaaoaeueneie nenoaia. Anee iaiaoiaeeii oieueei i?iniio?aoue
aaco aeaiiuo e niaea?aeaueany a iae iauaeou, ii ia eciaiyoue eo, oi i?e
ioe?uoee aacu aeaiiuo iaiaoiaeeii aeoeaece?iaaoue eiio?ieueiue
eiaeeeaoi? Read Only (oieueei /oaiea).

Anee iaiaoiaeeii i?aaeioa?aoeoue eciaiaiey aeaiiuo e iauaeoia aeaiiie
aacu aeaiiuo ni noi?iiu ae?oaeo iieueciaaoaeae, oi i?e ioe?uoee aacu
aeaiiuo iaiaoiaeeii onoaiiaeoue iioeeth Exlusive (eneeth/eoaeueiua
i?aaa).

Aaco aeaiiuo iiaeii iiaeaa?aiooue naeaoeth, aeey yoiai iaiaoiaeeii
aua?aoue a iaith File aee?aeoeao Compact Database (naeaoue aaco
aeaiiuo). Access nicaeaao eiieth aacu aeaiiuo e ii-iiaiio ?aciauaao aa
ia aeenea. Iinea auai?a naeeiaaiiai oaeea a aeeaeiaiaii ieia naeaoey
aacu aeaiiuo iiyaeyaony aeeaeiaiaia ieii oeaee naeaoey(Database to
Compact Into), a eioi?ii iiaeii aua?aoue eiy aeey naeaoie aa?nee aacu
aeaiiuo. Anee eniieuecoaony oi aea naiia eiy, e aaca aeaiiuo ieacuaaaony
oniaoii naeaoie, oi ii caaa?oaiee naeaoey Access aaoiiaoe/anee
oie/oiaeaao enoiaeioth(ianaeaooth) aa?neth.

Aaco aeaiiuo iiaeii caoeo?iaaoue aeey caueou nae?aoiie eioi?iaoeee io
i?iniio?a. Yoi inouanoaeyaony n iiiiuueth aee?aeoeau Encrypt Database
(?anoeo?iaaoue – Decrypt Database). A iiyaeaoainy aeeaeiaiaii ieia
auaa?eoa iiaeeaaeauoth oeo?iaaieth/aeaoeo?iaaieth aaco aeaiiuo e
uaeeieoa ia eiiiea OK. A ?acoeueoaoa ioe?iaony aeeaeiaiaia ieii
oeaeaaiai oaeea, aaea neaaeoao oeacaoue eiy oaeea, a eioi?ue aoaeao
iiiauai ?acoeueoao oeo?iaaiey/aeaoeo?iaaiey. Anee eniieuecoaony oi aea
naiia eiy e aaca aeaiiuo auea oniaoii caoeo?iaaia/?anoeo?iaaia, oi
Access aaoiiaoe/anee caiaiyao i?eaeiaeueiue oaee ia iieo/aiiue a
?acoeueoaoa i?aia?aciaaiey.

A iaeioi?uo neooaoeeyo aaca aeaiiuo iiaeao ieacaoueny iia?aaeaeaiiie.
Aeey ainnoaiiaeaiey aacu aeaiiuo neoaeeo aee?aeoeaa Repair Database
(ainnoaiiaeoue aaco aeaiiuo) a iaith File. Yoo iia?aoeeth ?aeiiaiaeoaony
i?eiaiyoue a oeaeyo i?ioeeaeoeee oae eae Access ia caia/aao, /oi aaca
aeaiiuo auea iia?aaeaeaia. A aeeaeiaiaii ieia ?aiiioa ioaeii aaanoe eiy,
aee?aeoi?eth e iaeiieoaeue iia?aaeaeaiiie(eee iiaeic?aaaaiie a
iia?aaeaeaiee) aacu aeaiiuo e iaaeaoue eiiieo OK. Iinea yoiai Access
caeiaony “ii/eieie” caaeaiiie aacu aeaiiuo e nianao oi, /oi aua iiaeii
nianoe.

Anee iieueciaaoaeue caeii/ee ?aaioo n aacie aeaiiuo, oi aa neaaeoao
cae?uoue. Aeey yoiai:

Aeoeaece?oeoa ieii aacu aeaiiuo, anee yoi iaiaoiaeeii.

A iaith File auaa?eoa aee?aeoeao Close Database.

Iiaeii cae?uoue aaco aeaiiuo e n iiiiuueth aeaieiiai uae/ea iuoueth ia
eiiiea auciaa oi?aaeythuaai iaith ieia aacu aeaiiuo eee iaaeaoeai
eeaaeo (Ctrl + F4).

Oaaeeoeu.

Neaaeothuei oaaii a iino?iaiee aacu aeaiiuo aoaeao aa caiieiaiea, o.a.
nicaeaiea iauaeoia e i?enaiaiea iineaaeiei iaiaoiaeeiuo naienoa. Eaeiai
au oeia ie auee Aaoe aeaiiua, Aai i?eaeaony o?aieoue eo a iaeiie eee
ianeieueeeo oaaeeoeao. Oaeei ia?acii, ia?aui oaaii a iino?iaiee aacu
aeaiiuo aoaeao nicaeaiea oaaeeoeu.

OAAEEOeA – yoi iaai? caienae(no?ie oaaeeoeu), ninoiyueo ec ioaeaeueiuo
iieae(eieiiie oaaeeoeu), a eioi?uo o?aieony eioi?iaoeey e ninoaaeythuay,
nianoaaiii, niaea?aeaiea aacu aeaiiuo.

Oaaeeoeu yaeythony iniiaiie oi?iie i?aaenoaaeaiey eioi?iaoeee,
niaea?aeauaeny a aaca aeaiiuo. Aac oaaeeoeu iaeuecy ni?iaeoe?iaaoue
oi?ioey?, ia aaca oaaeeoe ninoaaeythony cai?inu e io/aou. Nicaeaoue
oaaeeoeo iiaeii aeaoiy niiniaaie:

N iiiiuueth Eiino?oeoi?a oaaeeoe.

A ieia aacu aeaiiuo uaeeieoa ia eiiiea Table.

Auaa?eoa eiiieo New a ieia aacu aeaiiuo.

Microsoft Access aunaaoeo aeeaeiaiaia ieii New Table.

Auaa?eoa eiiieo TableWizards(Eiino?oeoi?a oaaeeoe).

A aeeaeiaiaii ieia Eiino?oeoi?a neaaeoeoa oeacaieyi ii aeiaaaeaieth
iieae a Aaoae oaaeeoea.

Aac iiiiue Eiino?oeoi?a.

A ieia aacu aeaiiuo uaeeieoa ia eiiiea Table (eee auaa?eoa aee?aeoeao
Tables a iaith View).

Iaaeieoa eiiieo New a ieia aacu aeaiiuo.

Microsoft Access aunaaoeo aeeaeiaiaia ieii New Table.

Iaaeieoa eiiieo New Table.

Microsoft Access ioe?iao ionoia ieii i?iaeoe?iaaiey oaaeeoeu. Iii aoaeao
auaeyaeaoue oae:

A yoii ieia caaeathony oa?aeoa?enoeee iieae, ninoaaeythueo caienue
(aeie aeaiiuo) aacu, o.a. aaiaeeony niaoeeoeeaoeey caiene. A ieaeiae
/anoe ieia Access auaeaao ni?aai/ioth eioi?iaoeeth i aeiionoeiuo ia
eaaeaeii oaaa i?iaeoe?iaaiey aeaenoaeyo.

Eaaeaeiio iieth, aeeth/aaiiio a caienue, i?eienuaaaony oei aeaiiuo,
ii?aaeaeythuee aeae eioi?iaoeee, eioi?ay aoaeao o?aieoueny a aeaiiii
iiea. Oei aeaiiuo aiineony a eieiieo Data Type, i?e/ai aai iiaeii
aua?aoue ec nienea aeinooiiuo oeiia.

Access ?acee/aao neaaeothuea oeiu aeaiiuo iieae:

Text Oaenoiaua iiey niaea?aeao oaeno, aeeeia eioi?iai ia iiaeao auoue
aieaa 255 neiaieia. ?aaeueiay aeeeia iiey onoaiaaeeaaaony n iiiiuueth
ia?aiao?a Field Size(?acia? iiey).

Memo A Memo-iieyo nio?aiyaony oaeno aeeeiie aei 32000 neiaieia. Iiey
yoiai oeia aeaiiuo ia iiaoo eiaeaene?iaaoueny.

Number *eneiaua iiey niaea?aeao i?iecaieueiua /eneiaua cia/aieth.
Aeeaiacii aeiionoeiuo cia/aiee ii?aaeaeyaony ia?aiao?ii Field Size
(?acia? iiey).

Date/Time Iiey aeaou/a?aiaie niaea?aeao cia/aiey aeaou e a?aiaie a
aeeaiaciia io 100 aei 9999 aiaea.

Currency A aeaiaaeiuo iieyo iiaeii o?aieoue /enea n oi/iinoueth aei 15
?ac?yaeia neaaa io caiyoie e /aou?ao aeanyoe/iuo ?ac?yaeia ni?aaa io
caiyoie.

Counter Iiea n/ao/eea niaea?aeeo /enei, eioi?ia aaoiiaoe/anee
oaaee/eaaaony Access ia 1, eiaaea a oaaeeoeo aeiaaaeyaony iiaue aeie
aeaiiuo.

Yes/No A oaeeo iieyo nio?aiythony cia/aiey Aea eee Iao. Iiey aeaiiiai
oeia ia iiaoo eiaeaene?iaaoueny.

OLE Object A OLE – iieyo iiiauathony iauaeou, oaeea eae, iai?eia?,
Excel-oaaeeoea eee Microsoft Draw – a?aoeea, ia?aaioaiiua OLE –
na?aa?ii. ?acia? iiey iiaeao auoue aei 128 IA. Iiey aeaiiiai oeia ia
iiaoo eiaeaene?iaaoueny.

Oa?aeoa?enoeee eaaeaeiai iiey ii?aaeaeythony ?yaeii ia?aiao?ia(naienoa).
Yoe ia?aiao?u iauyaeytho niiniau ia?aaioee, nio?aiaiey e eiaeeeaoeee
aeaiiuo. Ia?aiao?u niaoeeoeoee?oaiiai iiey ia?a/eneythony a ?aaeeia
i?iaeoe?iaaiey a ieaeiae /anoe ieia oaaeeoeu. Iaai? oa?aeoa?ecothueo
iiea ia?aiao?ia caaeneo io oeia aeaiiuo, aua?aiiiai iieueciaaoaeai aeey
aeaiiiai iiey.

Field Size ?acia? iiey onoaiaaeeaaao iaeneiaeueioth aeeeio oaenoiaiai
iiey eee niinia i?aaenoaaeaiey /enae a iiea oeia Number.

Format Oi?iao ii?aaeaeyao niinia i?aaenoaaeaiey aeaiiuo. Ia?yaeo n
i?aaeii?aaeaeaiiuie oi?iaoaie aeiioneaaony eniieueciaaiea nianoaaiiuo
oi?iaoia iieueciaaoaey.

Decimal Places Aeanyoe/iua ?ac?yaeu onoaiaaeeaatho eiee/anoai ?ac?yaeia
ni?aaa io aeanyoe/iie caiyoie.

Caption Caaieiaie ii?aaeaeyao iaaeienue, eioi?ay aoaeao
eniieueciaaoueny a ea/anoaa iaeiaiiaaiey iiey a oi?ioey?a eee io/aoa.
Anee aeey yoiai ia?aiao?a ia aoaeao caaeaii ieeaeia cia/aiea, oi a
ea/anoaa iaaeiene aoaeao ii oiie/aieth eniieueciaaii eiy iiey.

Default Value Cia/aiea ii oiie/aieth onoaiaaeeaaao cia/aiea, eioi?ia
aoaeao aaoiiaoe/anee aaaaeaii a iiea i?e aaia?aoeee aeiea aeaiiuo.

Validation Rule Ia?aie/aiea aaiaea – i?aaeei, ia?aie/eaathuaa
aeiionoeiua aeey aaiaea a iiea aeaiiua.

Validation Text Niiauaiea i ia?ooaiee – oaeno aicieeathuee i?e iiiuoea
aaanoe a iiea aeaiiua, ia oaeiaeaoai?ythuea i?aaeeo, noi?ioee?iaaiiiio a
Validation Rule.

Indexed I?eciae eiaeaene?iaaiey.

A aioiaoth niaoeeoeeaoeeth iiaeii aiineoue eciaiaiey. A /anoiinoe,
iiaeii eciaiyoue ia?aiao?u ioaeaeueiuo iieae, aeiaaaeyoue iiey a caienue
a ioaeiuo ianoao e oaeaeyoue eeoiea. Ii i?e yoii neaaeoao iinoa?aoueny
aianoe ana eni?aaeaiey a niaoeeoeeaoeeth aei ia/aea caiieiaiey aacu
aeaiiuo, o.e. iiiuoea eciaieoue ia?aiao?u iieae, caiieiaiiie aacu iiaeao
iiaea/ue ca niaie iioa?th eee eneaaeaiea aeaiiuo.

Ia?aoii?yaei/aiea iieae:

Auaa?eoa iiea, iiaeeaaeauaa ia?a?aciauaieth, uaeeioa eiiieie iuoe a
naeaeoi?iie eieiiea, ?aniieiaeaiiie ia eaaii e?ath ieia oaaeeoeu.

Uaeeieoa a naeaeoi?iie eieiiea iiyoue e oaea?aeeaay i?aaoth eiiieo iuoe
iaaeaoie ia?aoaueoa oeacaoaeue iuoe a ioaeioth iiceoeeth.

Microsoft Access ?aniieiaeeo ia?ee?iaaiiia Aaie iiea a iiaii ianoa.

Oaeaeaiea iieae.

Ioe?ieoa oaaeeoeo a ?aaeeia i?iaeoe?iaaiey.

Ia?ee?oeoa iiaeeaaeauaa oaeaeaieth iiea, uaeeioa eiiieie iuoe a
naeaeoi?iie eieiiea.(Eee eniieuecoeoa eeaaeoe oi?aaeaiey eo?ni?ii e
iiaeaaaey oeacaoaeue e niioaaonoaothuaio iieth iaaeieoa eiiaeiaoeeth
eeaaeo Shift+Spacebar).

Ec iaith Edit auaa?eoa aee?aeoeao Delete Row (eee iaaeieoa eiiieo Delete
Row a no?iea ieeoia?aii).

Microsoft Access oaeaeeo iiea e ana aai aeaiiua ec Aaoae oaaeeoeu.

Anoaaea iieae.

Onoaiiaeoa oeacaoaeue no?iee e iieth, iaae eioi?ui Au au oioaee
?acianoeoue iiaia iiea, n iiiiuueth iuoe eee eeaaeoaie oi?aaeaiey
eo?ni?ii.

Ec iaith Edit auaa?eoa aee?aeoeao Insert Row(eee auaa?eoa eiiieo Insert
Row a no?iea ieeoia?aii).

Microsoft Access anoaaeo ionoia iiea iaae oaeouae no?ieie.

Microsoft Access ?aaioaao iaeaieaa yooaeoeaii, anee Au ii?aaeaeeee
ia?ae/iue eeth/. Ia?ae/iue eeth/ oaaeeoeu ninoieo ec iaeiiai eee
ianeieueeeo iieae, eioi?ua iaeiicia/ii eaeaioeoeoee?otho eaaeaeoth
caienue a Aaoae oaaeeoea. Aai neaaeoao anaaaea ii?aaeaeyoue ia?ae/iue
eeth/ o.e. i?e yoii oaaeeoea eiaao neaaeothuea i?aeiouanoaa:

iicrosoft Access aaoiiaoe/anee nicaeaao eiaeaen aeey ia?ae/iiai eeth/a.
Yoio eiaeaen onei?yao i?ioeannu cai?inia e ae?oaea iia?aoeee.

Eiaaea Au i?iniao?eaaaoa caiene, Microsoft Access iieaaeao eo
oii?yaei/aiiuie ii ia?ae/iiio eeth/o ii oiie/aieth.

Eiaaea Au aeiaaaeyaoa aeaiiua e Aaoae oaaeeoea, Access ia iicaieeo
o?aieoue aeaiiua n iaeiei e oai aea cia/aieai ia?ae/iiai eeth/a. Iiyoiio
Au iiaeaoa auoue oaa?aiu ,/oi eaaeaeay caienue oieeaeueia.

Onoaiiaea ia?ae/iiai eeth/a.

Ia?ee?oeoa iiea, eioi?ia Au oioeoa eniieueciaaoue a ea/anoaa ia?ae/iiai
eeth/a. Aeey iauyaeaiey ianeieueeeo iieae ia?ae/iui eeth/ii, oaea?aeeaay
eeaaeoo Ctrl ia?ee?oeoa ana iaiaoiaeeiua iiey.

A iaith Edit auaa?eoa aee?aeoeao Set Primary Key (eee iaaeieoa eiiieo
Set Primary Key a no?iea ieeoia?aii).

O iieae ii?aaeaeaiiuo eae ia?ae/iue eeth/ neaaa io no?iee aeiaaaeony
eaeaioeoeeaoi? a aeaea eeth/a.

A Access-oaaeeoeu iiaeii ano?ieoue iauaeou ec ae?oaeo iiaeaea?aeeaathueo
eioa?oaen OLE i?eeeaaeiuo i?ia?aii e naycaoue yoe iauaeou n eo
?iaeeoaeueneeie i?ia?aiiaie.

I?e ano?aeaaiee iauaeoa Access nio?aiyao iauaeo a oaaeeoea. Aeaieiui
uae/eii iuoueth ia iauaeoa caioneaaony i?eeeaaeiay i?ia?aiia, n
iiiiuueth eioi?ie ii aue ecaioiaeai – a iae iiaeii i?iecaanoe eciaiaiey
a iauaeoa. Iinea caaa?oaiey ?aaiou n ?iaeeoaeueneie i?ia?aiiie iauaeo a
eciaiaiiie oi?ia aoaeao nio?aiai a oaaeeoea. Iauaeo neaaeoao ano?aeaaoue
oieueei a oii neo/aa, anee aai iaiaoiaeeii ia?aaaouaaoue ia iieeaeay
Access. Iau/ii ?a/ue eaeao ia iauaeoa , eioi?ue aeieaeai noaoue
oeene?iaaiiie ninoaaiie /anoueth aacu aeaiiuo, ii aai iaeuecy
ecaioiaeoue i?yii a Access, iai?eia?, Paintbrush-eeethno?aoeey ia
no?aieoea Access-io/aoa.

Anee aea iauaeo, ii?iaeaeaiiue ae?oaie i?eeeaaeiie i?ia?aiiie,
naycuaaaony n Access-oaaeeoeae aac ano?aeaaiey, oi iauaeo nio?aiyaony ia
a oaaeeoea, a a ioaeaeueiii oaeea, i?e/ai oi?iao yoiai oaeea
ii?aaeaeyaony i?eeeaaeiie i?ia?aiiie, n iiiiuueth eioi?ie iauaeo aue
nicaeai. A iiiaio caa?ocee e ioe?uoey oaaeeoeu Access naycuaaaony n yoei
oaeeii, ecaeaeaao aai niaea?aeeiia e anoaaeyao aai a oaaeeoeo.
Naycuaaiea iauaeoia (a ia ano?aeaaiea) ?aeiiaiaeoaony a oao neo/ayo,
eiaaea a Access-aaco iaiaoiaeeii aeeth/eoue iauaeo, ia iiaeeaaeauee
eciaiaieth i?e ?aaioa n Access. Iai?eia?, ?a/ue iiaeao eaeoe i oaaeeoea
n/aoia, ia?aaaouaaaiie Excel e eniieuecoaiie a ianeieueeeo Access-aacao.
Iaee/ea nayce yoeo aac n iaeiei e oai aea Excel-oaeeii aa?aioe?oao
iaee/ea iineaaeiae aa?nee oaaeeoeu n/aoia ai anao yoeo aacao.
I?aeiouanoai nayce caeeth/aaony a oii, /oi iaeei i?eaeiaeueiue iauaeo
iiaeii naycaoue n ianeieueeeie Access-oaaeeoeaie, e i?e yoii aai ia
ioaeii iiiaie?aoii iiaeaa?aaoue nio?aiaieth.

Ano?aeaaiea iauaeoia.

A iaith Edit ia?aoeoanue e aee?aeoeaa Insert Object (Yoa aee?aeoeaa
aoaeao aeinooiia a oii neo/aa, anee a niaoeeoeeaoeee oaaeeoeu aeoeaiiio
a aeaiiue iiiaio iieth aue i?enaiai oei OLE Object.)

A nienea Object Type auaa?eoa iaiaoiaeeioth Aai, iiaeaea?aeeaathuoth OLE
eioa?oaen i?eeeaaeioth i?ia?aiio.

Anee iauaeo oaea nouanoaoao, uaeeieoa iuoueth ia eiiiea File , /oiau
ioe?uoue aeeaeiaiaia ieii Insert Object from File.

Auaa?eoa ioaeiue oaee e iaaeieoa eiiieo OK.

Naycuaaiea iauaeoia.

A iaith Edit auaa?eoa aee?aeoeao Past Link. (Iaeiaei yoa aee?aeoeaa
noaiiaeony aeinooiiie eeoue iinea oiai , eae iiaeeaaeauee naycuaaieth
iauaeo aoaeao neiie?iaai, o.a. iiiauai a aooa? iaiaia Clipboard .)

Iaaeieoa eiiieo OK.

Access iicaieyao nicaeaaaoue ?aeyoeeiiiua aacu aeaiiuo. A ?aeyoeeiiiie
aaca aeaiiuo iieueciaaoaeue iiaeao iienaoue ioiioaiey iaaeaeo
ianeieueeeie oaaeeoeaie. Access o/eouaaao yoe ioiioaiey i?e iienea
acaeiinaycaiiuo aeaiiuo ai a?aiy ia?aaioee cai?inia, oi?ioey?ia e
io/aoia, aace?othueony ia ianeieueeeo oaaeeoeao.

Onoaiiaea nayce iaaeaeo oaaeeoeaie.

A iaith Edit auaa?eoa aee?aeoeao Relationships, eee uaeeieoa iuoueth ia
eiiiea Relationships a no?iea ieeoia?aii. Ioe?iaony ieii Relationships
, caoai ieii Add Table.

Anee ieii Add Table ia iiyaeeinue, auaa?eoa niioaaonoaothuoth aee?aeoeao
a ieia Relationships.

A no?iea Table/Query auaa?eoa oaaeeoeo aeey eioi?ie au oioeoa nicaeaoue
naycue. Aeey auai?a aieaa /ai iaeiie oaaeeoeu iaeiia?aiaiii, oaea?aeeaay
eeaaeoo Ctrl auaa?eoa ana iaiaoiaeeiua oaaeeoeu. *oiau aua?aoue ana eee
aeie oaaeeoe ioiaoueoa ia?aoth oaaeeoeo, a caoai oaea?aeeaay eeaaeoo
Shift oeaaeeoa iineaaeithth, iaaeieoa eiiieo Add. Au oaeaea iiaeaoa
aeiaaaeyoue oaaeeoeu ia?aoaneeaay eo n iiiiuueth iuoe ec ieia aacu
aeaiiuo a ieii ioiioaiee.

Oaia?ue n iiiiuueth iuoe ia?aoaueoa iiey ia?ae/iiai eeth/a ia?ae/iie
oaaeeoeu a niioaaonoaothuaa iieiaeaiea a naycuaaaiie oaaeeoea. Microsoft
Access auaeano aeeaeiaiaia ieii Relationships.

I?iaa?ueoa eiaia iieae iiaeeaaeaueo naycuaaieth, io?aaeaeoe?oeoa i?e
iaiaoiaeeiinoe. Onoaiiaeoa niioaaonoaothuea iioeee, iai?eia?, oei
ioiioaiey: One(iaeei e iaeiiio) eee Many(iaeei ei iiiaei).

Iaaeieoa eiiieo Create.

Naycaiiua oaaeeoeu, iai?eia?, iiaoo auaeyaeaoue oae:

Oaaeeoeu, iaoiaeyueany a aaca aeaiiuo, nicaeaiiie ae?oaie i?ia?aiiie,
iiaeii eiii?oe?iaaoue a Access, oaeaea iiaeii e yenii?oe?iaaoue
Access-oaaeeoeu, nio?aiyy eo a oi?iaoao, iiiyoiuo ae?oaei i?eeeaaeiui
i?ia?aiiai oi?aaeaiey aacaie aeaiiuo. Ii i?aaeaea /ai iaiin?aaenoaaiii
i?enooieoue e eiii?oo eee yenii?oo, iaiaoiaeeii niaa?oeoue
niioaaonoaothuea onoaiiaee eiii?oa eee yenii?oa.

Onoaiiaea iioeee eiii?oa/yenii?oa.

A iaith File auaa?eoa aee?aeoeao Import|Export Setup

I?iua anaai aua?aoue oaea nouanoaothuoth niaoeeoeeaoeeth ec nienea
Specification Name, e io?aaeaeoe?iaaoue aa i?e iaiaoiaeeiinoe.

Anee Au aoaeaoa eniieueciaaoue naith nianoaaiioth niaoeeoeeaoeeth
iaiaeiie?aoii, iaaeieoa eiiieo Save as e aieoeoa eiy, iaaeieoa OK.

Iaaeieoa OK.

Eiii?oe?iaaiea oaaeeoe.

A iaith File auaa?eoa aee?aeoeao Import eee iaaeieoa eiiieo Import a
no?iea ieeoia?aii.

A aeeaeiaiaii ieia eiii?oa ec nienea Data Source auaa?eoa ioaeiue oi?iao
oaeea aacu aeaiiuo. Ii iiaeao auoue oeia:

– Nianoaaiiue oi?iao

– Oaeno n neiaieii – ?acaeaeeoaeai iaaeaeo iieyie

– Oaeno n oeene?iaaiiui oi?iaoii iieae

– Oaaeeoeu Microsoft Excel

– Oaaeeoeu Lotus 1-2-3 eee 1-2-3/W

– Aacu aeaiiuo Paradox

– Oaeeu dBASE iii eee iv

– Btrieve (n oaeeii neiaa?y Xtrieve)

– Microsoft SQL -na?aa?

Iaaeieoa eiiieo OK. Iiyaeony aeeaeiaiaia ieii aeey auai?a eiii?oe?oaiiai
oaeea.

Auaa?eoa ioaeiue oaee , iaaeieoa eiiieo Import.

Microsoft Access auaeano niiauaiea i ?acoeueoaoa eiii?oe?iaaiey.

Yenii?oe?iaaiea oaaeeoe.

A iaith File auaa?eoa aee?aeoeao Export eee iaaeieoa eiiieo Export a
no?iea ieeoia?aii.(Ia?aiia/aeueii ioaeii aeoeaece?iaaoue Aaco aeaiiuo ec
eioi?ie Au oioeoa yenii?oe?iaaoue oaaeeoeo).

A aeeaeiaiaii ieia yenii?oa ec nienea Data Source auaa?eoa ioaeiue
oi?iao oaeea aacu aeaiiuo, eoaea Au oioeoa yenii?oe?iaaoue oaaeeoeo. Ii
iiaeao auoue oeia:

– oaaeeoeu Microsoft Access

– aacu aeaiiuo Paradox

– oaeeu dBASE iii eee iv

– Btrieve (n oaeeii neiaa?y Xtrieve)

– Microsoft SQL-na?aa?

Iaaeieoa eiiieo OK. A caaeneiinoe io aua?aiiiai oi?iaoa iiyaeony
niioaaonoaothuaa aeeaeiaiaia ieii aeey auai?a oaaeeoe ec aacu-enoi/ieea,
a caoai aeeaeiaiaia ieii aeey auai?a oaeea iacia/aiey.

Auaa?eoa niioaaonoaothuea niaoeeoeeaoeee e auiieieoa yenii?oe?iaaiea.

Microsoft Access auaeano niiauaiea i ?acoeueoaoa yenii?oe?iaaiey.

Cai?inu.

Cai?in iiaeii i?aaenoaaeoue naaa eae oi/eo c?aiey ia aeaiiua,
aeeth/aiiua a oaaeeoeo. Cai?inu neoaeao aeey naeaeoeee e oeeueo?aoeee
iaai?a aeaiiuo. Iie iicaieytho aua?aoue ec aacu oieueei iaiaoiaeeioth
eioi?iaoeeth, o.a. oo, eioi?ay niioaaonoaoao ii?aaeaeaiiiio
e?eoa?eth(oneiaeth) e ioaeia aeey ?aoaiey eiie?aoiie caaea/e. Iai?eia?,
Aai iiaeao iiiaaeiaeony eioi?iaoeey i iinoaaueeao e iinoaaeyaiuo eie
oiaa?ao. Au iiaeaoa nicaeaoue cai?in oeia “Eaeea oiaa?u iinoaaeytho
iineianeea iinoaaueee” eee “Eoi ec iaoa?ao?aneeo iinoaaueeia neaa?ao
i?iaeae ca iineaaeiee eaa?oae iaeaieueooth ia?oeth”. ?acoeueoao
ia?aaioee i?ia?aiiie Access oaeiai cai?ina i?aaenoaaeyao niaie oaaeeoeo
iacuaaaioth Dynaset. A yoo oaaeeoeo aeeth/aiu aua?aiiua ec iniiaiie
oaaeeoeu(eee ianeieueeeo oaaeeoe) aeiee aeaiiuo, eioi?ua oaeiaeaoai?ytho
e?eoa?eyi cai?ina. Dynaset – aeeiaie/aneee, a?aiaiiue iaai? aeaiiuo,
iiyoiio i?e eaaeaeii auiieiaiee cai?ina ii no?ieony aiiaue ia iniiaa
“naaaeeo” oaaee/iuo aeaiiuo.

Microsoft Access aeaao aieueoea aiciiaeiinoe a aeaeinoe i?iaeoe?iaaiey
cai?inia. Au iiaeaoa:

Aua?aoue iiey, Aai ia iaaei aeeth/aoue ana iiey oaaeeoeu a cai?in.

Aua?aoue caiene, Au iiaeaoa niaoeeoeoee?iaaoue cai?in oaeei ia?acii /oi
iieo/eoa aeaiiua ii?aaeaeaiiiai aeaea. Iai?eia?, oeaiu ia oiaa?u ca
ii?aaeaeaiiue ianyoe.

Ioni?oe?iaaoue caiene, Au iiaeaoa i?iniao?eaaoue caiene a ii?aaeaeaiiii
ii?yaeea. Iai?eia?, Au iiaeaoa auaanoe eiaia eeeaioia ia ye?ai a
aeoaaeoiii ii?yaeea.

Cai?aoeaaoue aeaiiua ec ianeieueeeo oaaeeoe, aeaiiua ec ianeieueeeo
oaaeeoe iiaoo ia?aaaouaaoueny aianoa e Au iiaeaoa i?iniio?aoue
niaiauaiiua aeaiiua. Oaeaea Au iiaeaoa cai?aoeaaoue aeaiiua ec ae?oaeo
aac aeaiiuo, oaeeo eae Microsoft FoxPro, Paradox, dBASE, Btrieve e
Microsoft eee Sybase SQL-na?aa?u.

Auiieiyoue au/eneaiey, Au iiaeaoa nicaeaaaoue iiaua iiey eioi?ua aoaeoo
niaea?aeaoue ?acoeueoaou au/eneaiee.

Eniieueciaaoue cai?in a ea/anoaa enoi/ieea aeaiiuo aeey oi?ioey?ia,
io/aoia e ae?oaeo cai?inia. Eaaeaeue ?ac eiaaea Au aoaeaoa ioe?uaaoue
oi?ioey? eee ia/aoaoue io/ao, Aao cai?in aoaeao ecaeaeaoue iiaaeooth
eioi?iaoeeth ec oaaeeoe. Au oaeaea niiaeaoa iiaeeoeoee?iaaoue
nouanoaothuea aeaiiua i?yii a oi?ioey?a iniiaaiiii ia cai?ina.

Eciaiyoue aeaiiua a oaaeeoeao, Au iiaeaoa iaiiaeyoue, oaeaeyoue,
aeiaaaeyoue a?oiiu caienae ana n?aco. Au oaeaea iiaeaoa nicaeaoue iiaoth
oaaeeoeo ia aaca nouanoaothuae oaaeeoeu eee a?oiiu oaaeeoe.

Auaeaeytho aeaa oeia cai?inia:

QBE-cai?inu (Query by Example -Cai?in ii ia?acoeo). Iieueciaaoaeue aeaao
ei ii?aaeaeaiey, niaoeeoeoee?oy ioaeaeueiua ia?aiao?u a ieia
i?iaeoe?iaaiey n eniieueciaaieai iiaeneacie(ia?acoeia).

SQL – cai?inu (Structured Query Language -No?oeoo?e?iaaiiue ycue
cai?inia ). Iieueciaaoaeue oi?ioee?oao eo n eniieueciaaieai eino?oeoeee
e ooieoeee, auno?aeaay iienaiea. QBE-cai?in Access eaaei o?ainee?oao a
niioaaonoaothuee SQL-cai?in. Ia?aoiay iia?aoeey oiaea ia ninoaaeyao
o?oaea. Aiiaua aeey Access aac?acee/ii, n eaeei oeiii cai?ina ?aaioaao
iieueciaaoaeue.

Cai?inu iiaeii nicaeaaaoue n iiiiuueth Eiino?oeoi?a cai?inia. Ii
onei?yao i?iaeoe?iaaiea ianeieueeeo niaoeeaeueiuo oeiia cai?inia:

Cai?inu e?inn-oaaeeoe. I?aaenoaaeytho Aaoe aeaiiua a eiiiaeoiii
noiie?iaaiiii oi?iaoa.

Cai?inu iaoiaeaeaiey aeoaeeeaoia. Iaoiaeyo aeoaeeeaoiua caiene a
aua?aiiie Aaie oaaeeoea eee cai?ina.

Cai?inu iaoiaeaeaiey ianiioaaonoaey. Iaoiaeyo ana caiene a oaaeeoea
eioi?ua ia naycaiu n caienyie a ae?oaie oaaeeoea.

Cai?inu a?oeaia. Eiie?otho caiene ec nouanoaothuae oaaeeoeu a iiaoth e
caoai oaeaeytho (ii aeaeaieth) yoe caiene ec oaaeeoeu i?eaeiaea.

Ii aeey aieueoeinoaa iauaeniieuecoaiuo cai?inia ia ioaeia iiiiuue
Eiino?oeoi?a cai?inia.

Nicaeaiea cai?ina aac iiiiue Eiino?oeoi?a cai?inia

A ieia aacu aeaiiuo iaaeieoa eiiieo Query.

Iaaeieoa eiiieo New. Microsoft Access auaeano aeeaeiaiaia ieii New
Query.

Iaaeieoa eiiieo New. Ioe?iaony ieii Select Query.

Anee Aao cai?in iniiauaaaony ia oaaeeoeao aeoeaece?oeoa eiaeeeaoi?
Tables ia iaiaee View. Anee ia cai?inao – aeoeaece?oeoa Queries, anee
ia iaieo oeiao iauaeoia auaa?eoa Both. A nienea Table / Query auaa?eoa
iaiaoiaeeiua aeey cai?ina enoi/ieee. Aeey auai?a aieaa /ai iaeiie
oaaeeoeu/cai?ina iaeiia?aiaiii, oaea?aeeaay eeaaeoo Ctrl auaa?eoa ana
iaiaoiaeeiua oaaeeoeu/cai?inu. *oiau aua?aoue ana eee aeie ioiaoueoa
ia?aue ioieo, a caoai oaea?aeeaay eeaaeoo Shift oeaaeeoa iineaaeiee .
Iaaeieoa eiiieo Add.

Iaaeieoa eiiieo Close.

Ieii i?iaeoe?iaaiey QBE-cai?ina e nai QBE-cai?ina iiaeao auaeyaeaoue
oae:

E?eoa?ee ioai?a – yoi eino?oeoeee, iin?aaenoaii eioi?uo iieueciaaoaeue
niiauaao Access ,eaeea aeiee aeaiiuo aeieaeiu ioae?aoueny ii cai?ino e
eiaeeoee?iaaoueny a Dynaset. E?eoa?ee iiaoo caaeaaaoueny aeey iaeiiai
eee ianeieueeeo iieae cai?ina.

Niaoeeoeeaoeey e?eoa?ey cai?ina ioai?a.

Aieaeeoa a ?aaeei i?iaeoe?iaaiey cai?ina, aeey yoiai ec iaith View
auaa?eoa aee?aeoeao Query Design eee uaeeieoa iuoueth ia eiiiea Design
View a ieeoia?aoe/aneii iaith.

A ieaeiae /anoe ieia i?iaeoe?iaaiey, a no?iea Criteria a y/aeea Category
Name aaaaeeoa au?aaeaiea e?eoa?ey ioai?a.

Iinea oiai eae au?aaeaiea aaaaeaii e iaaeaoa eeaaeoa aaiaea, Access
i?iaa?yao ei??aeoiinoue au?aaeaiey ii i?aaeeai caiene e?eoa?eaa e
ii?iaeecoao caienue ii yoei i?aaeeai.

Iieueciaaoaeue iiaeao ainiieueciaaoueny cai?inii aeey i?iaaaeaiey
au/eneaiee n aeieaie aeaiiuo. Ii iiaeao caaeaoue a eaaeaeii iiea
iaeioi?oth ooieoeeth, ia?aaaouaathuoth niaea?aeeiia yoiai iiey.
?acoeueoao ia?aaioee auaeaaony a Dynaset. Ooieoeey ia?aaioee caaeaaony a
no?iea Total, eioi?ay iiyaeyaony iinea iaaeaoey a ieeoia?aoe/aneii iaith
eiiiee n a?a/aneie eeoa?ie “neaia”. Naio ooieoeeth iiaeii aua?aoue a
yoie no?iea, ?acaa?ioa nienie aiciiaeiuo cia/aiee.

Iinea oiai eae cai?in ni?iaeoe?iaai, aai iiaeii auiieieoue, uaeeioa
iuoueth a no?iea ieeoia?aii ia eiiiea n aineeeoeaoaeueiui ciaeii eee
aucuaay a iaith Query aee?aeoeao Run. Access eiaeeoee?oao ioia?aiiua ii
cai?ino a Dynaset aeiee a aeaea oaaeeoeu.

N iiiiuueth no?oeoo?e?iaaiiiai ycuea cai?inia SQL a ?aieao Access
iieueciaaoaeue iiaeao noi?ioee?iaaoue neieue oaiaeii neiaeiua ii
no?oeoo?a e?eoa?eaa e au/eneaiee cai?inu. Yoio aea ycue iicaieyao
oi?aaeyoue ia?aaioeie cai?inia. SQL-cai?in i?aaenoaaeyao niaie
iineaaeiaaoaeueiinoue eino?oeoeee, a eioi?oth iiaoo aeeth/aoueny
au?aaeaiey e auciau aa?aaaoiuo ooieoeee. Ia/eiathuei iieueciaaoaeyi
?aeiiaiaeoaony nicaeaaaoue cai?inu a ?aaeeia i?iaeoe?iaaiey, auae?ay
iaiaoiaeeiua iiey, e?eoa?ee ni?oe?iaee e ooieoeee a ciia niaoeeoeeaoeee.
Aeey iienaiey cai?inia ia ycuea SQL ioaeai aeinoaoi/iue iiuo ?aaiou n
aacaie aeaiiuo ia a ea/anoaa iieueciaaoaey, a a ea/anoaa i?ia?aiienoa.

Anee iieueciaaoaeue oi/ao eiaoue ?ac?aaioaiiue i?iaeo cai?ina a naiai
?anii?yaeaiee e ai a?aiy neaaeothueo naainia ?aaiou, oi ii aeieaeai aai
nio?aieoue n iiiiuueth aee?aeoeau Save a iaith File. Anee i?iaeo
nio?aiyaony aia?aua, oi iinea ia?auaiey e yoie aee?aeoeaa iiyaeony
aeeaeiaiaia ieii Save As. A iai neaaeoao iacia/eoue cai?ino eiy, iiae
eioi?ui ii aoaeao nio?aiai e aeeth/ai a nienie cai?inia a ieia aaiea
aeaiiuo. Eiy cai?ina ia aeieaeii niaiaaeaoue n eiaiai oaaeeoeu.

Anee aeaiiue cai?in oaea aue iaeiaaeaeu nio?aiai e iieueciaaoaeue aua?ae
aee?aeoeao Save, oi noa?ay aa?ney aoaeao caiaiaia iiaui, eciaiaiiui
i?iaeoii cai?ina. Anee eciaiaiey ia aeieaeiu enii?oeoue i?aaeuaeouoth
aa?neth, a aeieaeiu auoue nio?aiaiu a ae?oaii cai?ina, oi neaaeoao
aucaaoue aee?aeoeao Save As e iacia/eoue nio?aiyaiiio i?iaeoo iiaia eiy.
Aeey nio?aiaiey oaaee/iiai i?aaenoaaeaiey cai?ina neaaeoao aua?aoue
aee?aeoeao Save Query a iaith File. Yoa aee?aeoeaa nio?aiyao eciaiaiey a
i?iaeoa eiathuaainy cai?ina e caiaiyao i?aaeuaeouoth aa?neth cai?ina ia
aeoeaioth aa?neth. Aeey oiai /oiau nio?aieoue cai?in aia?aua eee
nicaeaoue eiieth aeoeaiiai cai?ina, Dynaset eioi?iai aeaeai ia ye?aia,
neaaeoao aua?aoue aee?aeoeao Save Query As.

Ia?yaeo n cai?inaie auai?a, n iiiiuueth Access iiaeii ?aaeeciaaoue
oaeaea cai?inu aeaenoaee, ia?aiao?e/aneea cai?inu e cai?inu
e?inn-oaaeeoe.

Cai?inu aeaenoaey.

N iiiiuueth cai?ina aeaenoaey iieueciaaoaeue iiaeao eciaiyoue eee
ia?aiineoue aeaiiua oaaeeoeu, a oaeaea aeooaeece?iaaoue, aeiaaaeyoue eee
oaeaeyoue a?oiiu aeieia aeaiiuo ,ecaioaaeeaaoue iiaua oaaeeoeu ec iaai?a
Dynaset. ?acee/atho /aou?a oeia cai?inia aeaenoaee: cai?in aeiaaaeaiey,
cai?in oaeaeaiey, cai?in aeooaeecaoeee e cai?in nicaeaiey oaaeeoeu.

Ia?aiao?e/aneea ai?inu.

*anoi eniieuecothony cai?inu,eioi?ua i?aaenoaaeytho niaie iacia/eoaeueii

aeaeieciaiaiiua aa?eaiou iaeiaaeaeu iiaeaioiaeaiiiai aaciaiai cai?ina.
?a/ue iiaeao eaeoe, iai?eia?, i cai?ina, eioi?ue iicaieyao auae?aoue ec
aacu aeaiiuo oaeaoiiu eeeaioia ii?aaeaeaiiiai ?aaeiia, i?e/ai nai ?aaeii
caaeaaony ioaeaeueii, a aeeaeiaa. Oaeea cai?inu, ia?aiao?e/aneea,
aeaeieciaiythony io neo/ay e neo/ath, ii iacia/eoaeueii. Aeey eo
?aaeecaoeee i?iaeoe?oaony iaeei ia?aiao?e/aneee cai?in, a eioi?ii
oeacuaaaony oio e?eoa?ee (e?eoa?ee), eioi?ue iiaeao eciaiyoueny ii
caeaco iieueciaaoaey.

Cai?inu e?inn-oaaeeoe.

Anee iaiaoiaeeii iauaaeeieoue aeaiiua a oi?iaoa no?ie-eieiiie
(aeaoia?iay oaaeeoea), oi neaaeoao ecaioiaeoue cai?in e?inn-oaaeeoeu.
I?e i?iaeoe?iaaiee cai?ina e?inn-oaaeeoeu iiaeii oeacaoue a ea/anoaa
caaieiaeia aeey eieiiie cia/aiey iaeioi?uo iieae eee au?aaeaiee. Cai?inu
e?inn-oaaeeoe iicaieytho aieaa eiiiaeoii, /ai iau/iua cai?inu,
eiaeeoee?iaaoue aeaiiua, iauaaeeiyy iaeiioeiioth eioi?iaoeeth.

Oi?ioey?u.

I?iniio? aacu aeaiiuo a aeaea oaaeeoeu a ?aaeeia caiieiaiey aeaao
iieueciaaoaeth aiciiaeiinoue ioeaieoue aaco eae aaeeiia oeaeia,
n?aaieoue caiene e o.i. *anoi, iaeiaei, aicieeaao iaiaoiaeeiinoue ?aaiou
n ioaeaeueiuie caienyie aacu. A yoii neo/aa i?enoonoaea ia ye?aia
ae?oaeo caienae (eae yoi eiaao ianoi a ?aaeeia caiieiaiey) oieueei
iaoaao e ioaeaeaao. ?aaioa n ioaeaeueiuie caienyie iin?aaenoaii
oi?ioey?ia iicaieyao nin?aaeioi/eoueny oieueei ia ioiinyuaeny e aeaeo
eioi?iaoeee.

Oi?ioey? i?aaenoaaeyao niaie aeaie, iiaeeaaeauee caiieiaieth, eee ianeo,
iaeeaaeuaaaioth ia iaai? aeaiiuo. Aeaie-oi?ioey? iicaieyao oi?inoeoue
i?ioeann caiieiaiey aacu aeaiiuo, aeaaiaea?y /aio iiyaeyaony
aiciiaeiinoue ii?o/eoue aaiae eioi?iaoeee ia?niiaeo iaaunieie
eaaeeoeeaoeee. Ianea-oi?ioey? iicaieyao ia?aie/eoue iauai eioi?iaoeee,
aeinooiiie iieueciaaoaeth, ia?auathuaiony e aaca. ?a/ue caeanue oaeaea
iiaeao eaeoe i aeiee?iaaiee eiaeeeaoeee neoaeaaiuo eee canae?a/aiiuo
iieae.

I?iua anaai nicaeaoue oi?ioey? niiiiuueth Eiino?oeoi?a.

ieia aacu aeaiiuo aeoeaece?oeoa eiiieo Form. I?e yoii Microsoft Access
iieaaeao iaai? nouanoaothueo oi?ioey?ia Aaoae aacu aeaiiuo, anee iie
anoue.

Iaaeieoa eiiieo New. Microsoft Access aunaaoeo aeeaeiaiaia ieii New
Form.

no?iea Select A Table/Query auaa?eoa iaiaoiaeeioth oaaeeoeo eee cai?in.

Iaaeieoa eiiieo Form Wizard. Microsoft Access aunaaoeo ia?aia
aeeaeiaiaia ieii Form Wizard.

Auaa?eoa AutoForm. Iaaeieoa OK.

A ae?oaeo ieiao Form Wizard Aai aoaeoo i?aaeeiaeaiu aii?inu, e ia iniiaa
Aaoeo ioaaoia Eiino?oeoi? nicaeano oi?ioey?.

Anee iieueciaaoaeue oaa?ai a oii, /oi niiaeao naiinoiyoaeueii
ni?iaeoe?iaaoue oi?ioey? aac iiiiue Eiino?oeoi?a Oi?ioey?ia (aiieia
?aaeueiay neooaoeey i?e iaee/ee aeinoaoi/iiai iiuoa), oi aio neaaeoao
nicaeaoue ionoie oi?ioey? e caoai aianoe a iaai o?aaoaiua iiey, yeaiaiou
ioi?ieaiey e oi?aaeythuea yeaiaiou.

ieia aacu aeaiiuo aeoeaece?oeoa eiiieo Form. I?e yoii Microsoft Access
iieaaeao iaai? nouanoaothueo oi?ioey?ia Aaoae aacu aeaiiuo, anee iie
anoue.

Iaaeieoa eiiieo New. Microsoft Access aunaaoeo aeeaeiaiaia ieii New
Form.

no?iea Select A Table/Query auaa?eoa iaiaoiaeeioth oaaeeoeo eee cai?in.

Iaaeieoa eiiieo Blank Form (Ionoie oi?ioey?). Access eiaeeoee?oao ieii
oi?ioey?a a ?aaeeia i?iaeoe?iaaiey.A iai iiaeii ?acianoeoue iiey e
ae?oaea yeaiaiou.

Aiaoiee aeae, no?oeoo?a e ?aaeeiu ?aaiou ioaeaeueiuo oi?aaeythueo
yeaiaioia e oi?ioey?ia ii?aaeaeythony cia/aieyie oa?aeoa?enoee yoeo
iauaeoia. Oa?aeoa?enoeee iauaeoia aeinooiiu iieueciaaoaeth /a?ac ieii
oa?aeoa?enoee. Aeey onoaiiaee eee eciaiaiey oa?aeoa?enoee yeaiaioa aai
iaaeeaaeeo ia?ee?iaaoue e ec iaith View aucaaoue aee?aeoeao Properties.
Iiaeii oaeaea auiieieoue aeaieiie uae/ie iuoueth ia oii yeaiaioa, ieii
naienoa eioi?iai iaiaoiaeeii auaanoe ia ye?ai.

Aeey eiaeeeaoeee eino?oiaioaeueiiai ieia onoaiiaeoa a iaith View iioeeth
Toolbox. Eaaeaeue eino?oiaio, a oi/iaa, nicaeaaaaiue n aai iiiiuueth
yeaiaio oi?aaeaiey/ioi?ieaiey, ?aniieaaaao nianoaaiiui ieiii
oa?aeoa?enoee, e a iai a aeaea nienea i?aaenoaaeaiu noaiaea?oiua
onoaiiaee aeey niioaaonoaothuaai oi?aaeythuaai yeaiaioa.

Aeeth/aaiua a oi?ioey? iiey iiaeii aua?aoue ec nienea iieae, eioi?ue
aoaeao aeaeai ia ye?aia iinea ia?auaiey e aee?aeoeaa Field List a
iaithView.

I?e i?iaeoe?iaaiee oi?ioey?a a iaai iiaeii anoaaeoue oi?aaeythuea
yeaiaiou. ?a/ue eaeao, iai?eia?, i eiiaiaeiuo eiiieao, nieneao,
eeethno?aoeeyo e i?. Eaaeaeue oi?aaeythuee yeaiaio iiaeao auoue naycai n
iaeioi?ui iauaeoii (iieai) a oaaeeoea (eee cai?ina), ia eioi?ie
aace?oaony oi?ia.Iai?eia?, naycaiiia n iaeioi?ui iieai aeiea oaaeeoeu
oaenoiaia iiea oi?ioey?a aoaeao iinoiyiii ioia?aaeaoue niaea?aeeiia
“naiaai” iiey aeoeaiie caiene oaaeeoeu. Aua?aiiua e ?aciauaiiua a ieia
i?iaeoe?iaaiey oi?ioey?a yeaiaiou oi?aaeaiey i?eia?aoatho naie ?aaeueiue
aeae oieueei a ?aaeeia caiieiaiey eee i?e i?iniio?a i?ioioeia ?ania/aoee
(?aaeei Preview). A ?aaeeia aea i?iaeoe?iaaiey iie iau/ii i?aaenoaaeaiu
oneiaiuie iaicia/aieyie, ca/anooth aeeceeie e ?aaeueiiio aeaeo
iaicia/aaiuo yeaiaioia.

Aeey ?aciauaiey a oi?ioey?a ianaycaiiiai oi?aaeythuaai yeaiaioa neaaeoao
aucaaoue ia ye?ai eino?oiaioaeueiia iaith (View/Toolbox), uaeeioa a iai
iuoueth ia eiiiea n ecia?aaeaieai ?aciauaaiiai yeaiaioa e ?acianoeoue
yeaiaio a ieia i?iaeoe?iaaiey oeenaoeeae eo?ni?a iuoe ia ioaeiii ianoa a
i?ioioeia oi?ioey?a. A ?acoeueoaoa oaeeo aeaenoaee a i?ioioei oi?ioey?a
aoaeao iiiauai aua?aiiue eiio?ieueiue yeaiaio n oa?aeoa?enoeeaie ii
oiie/aieth. Aeey nicaeaiey oi?aaeythuaai yeaiaioa “ianoaiaea?oiiai”
?acia?a iinea oeenaoeee eo?ni?a iuoe neaaeoao, ia ioioneay eiiieo iuoe,
ia?aianoeoue aa, iaicia/ea oai naiui aeaaioth aeeaaiiaeue
i?yiioaieueieea, ioaaouaathuaai ?aciauaaiue eiio?ieueiue yeaiaio.

Oeacaoaeue

Iaaeienue

A?oiia

Naeaeoi?iay eiiiea

Eiiaeie?iaaiiue nienie

Aeeaa?aiia

?aiea ianaycaiiiai iauaeoa

Eeiey

Eiiaoe no?aieoeu

Oaenoiaia iiea

Aeaooiiceoeeiiiue ia?aeeth/aoaeue

Eiio?ieueiue eiaeeeaoi?

Nienie

Iiaeoi?ia/iiaeio/ao

?aiea naycaiiiai iauaeoa

I?yiioaieueiee

Eiiaiaeiay eiiiea

Aeiee?iaea

Nouanoaoao aeaa niiniaa naycuaaiey eiio?ieueiiai yeaiaioa n iieai
oaaeeoeu:

Anee iieueciaaoaeue oi/ao, /oiau Access ecaioiaeea naycaiiue
oi?aaeythuee yeaiaio aaoiiaoe/anee, oi i?e aaia?aoeee e ?aciauaiee
yeaiaioa e?iia eino?oiaioaeueiiai iaith (View/Toolbox) aio neaaeoao
ainiieueciaaoueny aua e ieiii nienea iieae (View/Field List). Ec
eino?oiaioaeueiiai ieia iuoueth auae?aaony oi?aaeythuee yeaiaio, eioi?ue
iaiaoiaeeii anoaaeoue a oi?ioey?. Caoai ec nienea iieae iuoueth
auae?aaony iiea, n eioi?ui neaaeoao naycaoue nicaeaaaaiue oi?aaeythuee
yeaiaio.Iinea yoiai, ia ioioneay eiiieo iuoe, neaaeoao ioaoene?iaaoue
aua?aiiia iiea a oi ianoi i?ioioeia oi?ioey?a, a eioi?ii iaaeeaaeeo
?acianoeoue oi?aaeythuee yeaiaio. I?e inaiaiaeaeaiee eiiiee iuoe a
oeacaiiii ianoa nicaeaaony yeaiaio aua?aiiiai oeia, i?eaycaiiue e
oeacaiiiio iieth. Oaeie oi?aaeythuee yeaiaio eiaao oa aea
oa?aeoa?enoeee, /oi e iiea a oaaeeoea, neioi?ui ii naycai.

Naycaoue n iieai oaaeeoeu iiaeii e ?aiaa ia naycaiiue oi?aaeythuee
yeaiaio. Aeey yoiai aeinoaoi/ii aucaaoue ieii oa?aeoa?enoee
oi?aaeythuaai yeaiaioa aeaieiui uae/eii ia yoii yeaiaioa a ieia
i?iaeoe?iaaiey oi?ioey?a. A ieia oa?aeoa?enoee neaaeoao iaeoe
oa?aeoe?enoeeo ControlSource (Enoi/iee oi?aaeaiey) e caaeaoue a ea/anoaa
aa cia/aiey eiy naycaiiiai iiey.

Anee Au au oioaee ?ania/aoaoue Aao oi?ioey?, oi nia/aea ?aeiiaiaeoaony
i?iniio?aoue aai a aeaea, a eioi?ii ii aoaeao i?aaenoaaeai ia no?aieoea.

Aeey yoiai:

Iaaeieoa eiiieo Print Preview a ieeoia?aoe/aneii iaith (eee auaa?eoa
aee?aeoeao Print Preview a iaith File).

Aeey oaaee/aiey ianooaaa onoaiiaeoa oeacaoaeue iuoe ia no?aieoea oae
/oiau ii i?eia?ae aeae oaaee/eoaeueiiai noaeea e iaaeieoa eiiieo iuoe.

Aeey aica?auaiey i?aaeiaai ianooaaa uaeeieoa eiiieie iuoe aua ?ac.

Aeey ?ania/aoee oi?ioey?a iaiaoiaeeii:

Ec iaith File aua?aoue aee?aeoeao Print (eee iaaeaoue eiiieo Print a
ieeoia?aoe/aneii iaith). Microsoft Access aunaaoeo aeeaeiaiaia ieii
Print.

Iaaeieoa OK. Microsoft Access ?ania/aoaao oi?ioey?.

Oaia?ue ec iaith View auaa?eoa aee?aeoeao Form (eee iaaeieoa eiiieo
Close a ieeoia?aoe/aneii iaith) aeey aica?auaiey a ?aaeei i?iniio?a
oi?ioey?a.

Oaia?ue Au iiaeaoa nio?aieoue e cae?uoue oi?ioey?.

Nio?aiaiea:

Ec iaith File aua?aoue aee?aeoeao Save Form. Microsoft Access aunaaoeo
aeeaeiaiaia ieii Save As.

Iaia/aoaeoa eiy Aaoaai oi?ioey?a e iaaeieoa OK.

Cae?uoea:

Ec iaith File aua?aoue aee?aeoeao Close (eee naeaeaoue aeaieiie uae/ie a
iiea iaith oi?aaeaiey a aa?aeiai eaaii oaeo ieia oi?ioey?a.

Oaia?ue oi?ioey? noae /anoueth Aaoae aacu aeaiiuo.

Io/aou.

Io/ao yoi eioi?iaoeey, eioi?oth Au ioi?ieee a niioaaonoaee n Aaoeie
niaoeeoeeaoeeyie. Io/ao iicaieyao ecaeaeaoue e i?aaenoaaeyoue aeaiiua
eae cia/eioth eioi?iaoeeth, eioi?oth Au iiaeaoa eniieueciaaoue e
?ani?ino?aiyoue. I?eia?aie io/aoia iiaoo neoaeeoue ii/oiaua aae?ana,
iaeeaaeiua, noiiu i?iaeaae eee nienee oaeaoiiia. N iiiiuueth Microsoft
Access Au iiaeaoa ni?iaeoe?iaaoue io/ao eioi?ue i?aaenoaaeo eioi?iaoeeth
a oii aeaea a eioi?ii Au iiaeaeaaoa. Au iiaeaoa eniieueciaaoue
iiiaeanoai ?acee/iuo yeaiaioia i?iaeoe?iaaiey, oaeeo eae oaeno, aeaiiua,
?enoiee, eeiee, iiey e a?aoeee aeey nicaeaiey Aaoaai io/aoa.Io Aan
caaeneo, eae e eaeea yeaiaiou eniieueciaaoue aeey iino?iaiey io/aoa.

Microsoft Access iaania/eaaao ianeieueei niiniaia iieo/aiey eioi?iaoeee
ec Aaoae aacu aeaiiuo – eniieuecoy cai?in, oi?ioey? eee io/ao.Au iiaeaoa
aua?aoue oio iaoiae, eioi?ue iaeaieaa iiaeoiaeeo e ?aoaieth Aaoae
caaea/e.

Iai?eia?:

Aeey i?iniio?a anao oiaa?ia ii?aaeaeaiiie oi?aiaie iinoaaee,
eniieuecoeoa cai?in.

Aeey i?iniio?a iieiie eioi?iaoeee oieueei ia iaeiii oiaa?a eniieuecoeoa
oi?ioey?.

Aeey ?ania/aoee oi?aiauo i?iaeaae aeey oi?iaeueiiai i?aenoaaeaiey,
eniieuecoeoa io/ao.

Io/aou oaeaea yaeythony yooaeoeaiui n?aaenoaii aeey ?ania/aoee
eioi?iaoeee ?aaoey?iiai eniieueciaaiey. Au iiaeaoa nicaeaoue i?iaeo
io/aoa e nio?aieoue aai aeey aeaeueiaeoaai eniieueciaaiey. I?iaeo io/aoa
inoaiaony iaeciaiiui, ii eaaeaeue ?ac Au aoaeaoa iieo/aoue ?ania/aoeo
oaeoueo aeaiiuo.

Ia?aae oai eae nicaeaoue io/ao, iiaeoiaeoa i oii ioeoaea Aao io/ao
aoaeao ecaeaeaoue aeaiiua. Anee ana aeaiiua ec iaeiie oaaeeoeu, oi Aao
io/ao aoaeao iniiauaaoueny ia yoie oaaeeoea.Anee aea Aai iaiaoiaeeiu
aeaiiua aieaa /ai ec iaeiie oaaeeoeu, oi Aao io/ao aeieaeai
iniiauaaoueny ia cai?ina.

Au iiaeaoa nicaeaaaoue io/aou eae i?e iiiiue oae e aac iiiiue
Eiino?oeoi?a Io/aoia. Eiino?oeoi? iaiiiai onei?eo i?ioeann nicaeaiey
io/aoa, oae eae ii naeaeaao ca Aan iniiaioth ?aaioo.

Naiue iaeauno?ue niinia nicaeaiey io/aoa – eniieuecoy Eiino?oeoi?
Aaoiio/aoa.Io/ao aoaeao i?aaenoaaeyoue niaie aaeeinoaaiioth eieiieo,
iieacuaay ana iiey oaaeeoeu eee cai?ina.

N iiiiuueth Eiino?oeoi? Aaoiio/aoa:

A ieia aacu aeaiiuo aeoeaece?oeoa Table eee Query.

Auaa?eoa oaaeeoeo eee cai?in ia eioi?ii aoaeao iniiauaaoueny Aao io/ao.

Iaaeieoa eiiieo AutoReport a ieeoia?aoe/aneii iaith.

N iiiiuueth Eiino?oeoi?a Io/aoa:

A ieia aacu aeaiiuo aeoeaece?oeoa Report (eee auaa?eoa aee?aeoeao
Reports a iaith View).

Iaaeieoa eiiieo New (eee auaa?eoa aee?aeoeao New a iaith File, a caoai
aeoeaece?oeoa Report). Microsoft Access aunaaoeo aeeaeiaiaia ieii New
Report.

A no?iea Select A Table/Query auaa?eoa oaaeeoeo eee cai?in, niaea?aeauee
aeaiiua aeey Aaoaai io/aoa.

Iaaeieoa eiiieo Report Wizard. Microsoft Access aunaaoeo ia?aia
aeeaeiaiaia ieii Report Wizard.

Auaa?eoa Eiino?oeoi? ec nienea e iaaeieoa OK.

Neaaeoeoa oeacaieyi a aeeaeiaiauo ieiao Eiino?oeoi?a. A iineaaeiai ieia
iaaeieoa eiiieo Finish.

Aac iiiiue Eiino?oeoi?a Io/aoa:

A ieia aacu aeaiiuo aeoeaece?oeoa Report (eee auaa?eoa aee?aeoeao
Reports a iaith View).

Iaaeieoa eiiieo New (eee auaa?eoa aee?aeoeao New a iaith File, a caoai
aeoeaece?oeoa Report). Microsoft Access aunaaoeo aeeaeiaiaia ieii New
Report.

A no?iea Select A Table/Query auaa?eoa oaaeeoeo eee cai?in, niaea?aeauee
aeaiiua aeey Aaoaai io/aoa.

Iaaeieoa eiiieo Blank Report.

Microsoft Access aunaaoeo io/ao a ?aaeeia i?iaeoe?iaaiey. Aeey i?iniio?a
nienea iieae oaaeeoeu eee cai?ina iaaeieoa eiiieo Field List a
ieeoia?aoe/aneii iaith.

A i?ioioei io/aoa a i?ioeanna i?iaeoe?iaaiey iiaeii ano?ieoue
oi?aaeythuea yeaiaiou. Oi?aaeythuea yeaiaiou, ano?iaiiua a i?ioioei
io/aoa, iiaoo eniieueciaaoueny aeey ioi?ieaiey caaieiaeia, iaaeienae e
eeethno?aoeee.

Aeey ano?aeaaiey oi?aaeythueo yeaiaioia a io/ao ia ye?aia aeieaeii
i?enoonoaiaaoue eino?oiaioaeueiia iaith Toolbox (iioeey View/Toolbox). A
eino?oiaioaeueiii iaith auae?aaony eiiiea nicaeaaaaiiai oi?aaeythuaai
yeaiaioa. Iinea yoiai neaaeoao auiieieoue iuoueth uae/ie a oie iiceoeee
i?ioioeia io/aoa, aaea iaaeeaaeeo ?acianoeoue aeaiiue oi?aaeythuee
yeaiaio. Access ?aciauaao aua?aiiue yeaiaio, i?eienuaay aio ii
oiie/aieth noaiaea?oiua cia/aiey oa?aeoa?enoee (?acia?, oeaao e o.i.).

Oeacaoaeue

Iaaeienue

A?oiia

Naeaeoi?iay eiiiea

Eiiaeie?iaaiiue nienie

Aeeaa?aiia

?aiea ianaycaiiiai iauaeoa

Eeiey

Eiiaoe no?aieoeu

Oaenoiaia iiea

Aeaooiiceoeeiiiue ia?aeeth/aoaeue

Eiio?ieueiue eiaeeeaoi?

Nienie

Iiaeoi?ia/iiaeio/ao

?aiea naycaiiiai iauaeoa

I?yiioaieueiee

Eiiaiaeiay eiiiea

Aeiee?iaea

Aeey eciaiaiey noaiaea?oiuo cia/aiee oa?aeoa?enoee oi?aaeythuaai
yeaiaioa iiaeii ia?aoeoueny e ieio oa?aeoa?enoee, i?aaeaa?eoaeueii
ia?ee?iaaa iano?aeaaaiue yeaiaio. Ieii oa?aeoa?enoee aeaeii ia ye?aia
i?e onoaiiaeaiiie iioeee View/Properties. ?acia? yeaiaioa e aai
ianoiiieiaeaiea iiaeii eciaieoue “i?yii ia ianoa”, ia?aiauay n iiiiuueth
iuoe aanue yeaiaio eee aai ?acia?iua iaieioeyoi?u.

Caaeneiue oi?aaeythuee yeaiaio a io/aoa naycai n iieai a
niioaaonoaothuae oaaeeoea. N iiiiuueth caaeneiiai (naycaiiiai)
oi?aaeythuaai yeaiaioa iiaeii aaanoe aeaiiua a iiea eee eiaeeoee?iaaoue
e aeooaeece?iaaoue eo a io/aoa.

Naycuaaiea oi?aaeythuaai yeaiaioa iiaeii auiieieoue iaeiei ec aeaoo
niiniaia:

Anee iieueciaaoaeue oi/ao, /oiau Access aaoiiaoe/anee nicaeaea
oi?aaeythuee yeaiaio, naycaiiue n aaciaie aeey aeaiiiai io/aoa
oaaeeoeae, oi neaaeoao ainiieueciaaoueny nieneii iieae oaaeeoeu. Ii
aeaeai ia ye?aia, anee onoaiiaeaia iioeey View/Field List. i?aaeythuee
yeaiaio, ecaioiaeaiiue n iiiiuueth nienea iieae, eiaao oa aea cia/aiey
oa?aeoa?enoee, /oi e iiea oaaeeoeu, n eioi?ui ii naycai. Aeey auiieiaiey
naycuaaiey neaaeoao ioaoene?iaaoue aua?aiiia iiea eee iiey ec nienea a
io/ao. Oai iaaeeaaeeo iiianoeoue eo?ni? iuoe a iiceoeeth, aaea aeieaeai
iaoiaeeoueny eaaue aa?oiee oaie oi?aaeythuaai yeaiaioa (ii ia iiey
iacaaiiiai aeaiiiai oi?aaeythuaai yeaiaioa), e caoai ioionoeoue eiiieo
iuoe.Access nicaeaao aeey eaaeaeiai iiey, aua?aiiiai a nienea iieae,
naycaiiue oi?aaeythuee yeaiaio (oaenoiaia iiea).

Anee caaeiei /eneii iaiaoiaeeii naycaoue n iieai oaea eiathueeny,
ianaycaiiue oi?aaeythuee yeaiaio, oi yoi iiaeii auiieieoue n iiiiuueth
ieia oa?aeoa?enoee.A yoii ieia iinea ia?ee?iaaiey oi?aaeythuaai yeaiaioa
a i?ioioeia io/aoa ia?a/eneaiu oa?aeoa?enoeee yoiai yeaiaioa. I?e
caianaiee eiaie naycuaaaiiai iiey a yoi ieii a ea/anoaa cia/aiey
oa?aeoa?enoeee ControlSource auiieiyaony naycuaaiea.

Au iiaeaoa ?ania/aoaoue io/ao iinueay aai i?yii ia i?eioa? eee ia?anueay
aai a oaee, eioi?ue Au ?ania/aoaaoa iicaea.

Ia/aoue ia i?eioa?:

Ioe?ieoa io/ao a ethaii ?aaeeia.

Ec iaith File auaa?eoa aee?aeoeao Print . Microsoft Access auaeano
aeeaeiaiaia ieii Print.

Auaa?eoa iioeee:

-All ?ania/aoea iieiiai io/aoa

-Selection ?ania/aoea auai?i/iie iaeanoe

-Pages ?ania/aoea aeeaiaciia no?aieoe, eioi?ue Au ii?aaeaeyaoa a noieao
From e To.

A no?iea Print Quality (ea/anoai ia/aoe) auaa?eoa niioaaonoaothuoth
iioeeth.Iie aoaeoo caaeneoue io ae?aeaa?a i?eioa?a.

Aeey onoaiiaee /enea eiiee aaaaeeoa iiia? a no?ieo Copies.

Iinea onoaiiaee anao iaiaoiaeeiuo iioeee iaaeieoa OK.

Anee i?eioa? Aai iaaeinooiai Au iiaeaoa ia?aneaoue io/ao a oaee.

Ioe?ieoa io/ao a ethaii ?aaeeia.

Ec iaith File auaa?eoa aee?aeoeao Print . Microsoft Access auaeano
aeeaeiaiaia ieii Print.

Auaa?eoa iioeee:

-All ?ania/aoea iieiiai io/aoa

-Selection ?ania/aoea auai?i/iie iaeanoe

-Pages ?ania/aoea aeeaiaciia no?aieoe, eioi?ue Au ii?aaeaeyaoa a noieao
From e To.

Aeoeaece?oeoa no?ieo Print To File.

Iaaeieoa OK. Microsoft Access auaeano aeeaeiaiaia ieii Print To File.

Iaia/aoaeoa eiy oaeea iacia/aiey e iaaeieoa OK.

Au iiaeaoa nio?aieoue io/ao aeaoiy niiniaaie:

Nio?aiyy oieueei aai i?iaeo, no?oeoo?o io/aoa, aac aeaiiuo.

A iaith File auaa?eoa aee?aeoeao Save.

Anee io/ao ia aue iacaai, iaia/aoaeoa eiy a no?iea Report Name.

Iaaeieoa OK.

Nio?aiyy ?acoeueoao, iieiue io/ao – i?iaeo aianoa n aeaiiuie – a oaeea,
eioi?ue Au niiaeaoa eniieueciaaoue a ae?oaeo iiaeaea?aeeaaaiuo Windows
i?eeiaeaieyo, iai?eia?, Microsoft Excel.

A iaith File auaa?eoa Output To.

Neaaeoeoa eino?oeoeeyi a aeeaeiaiauo iieyo Output To.

Iae?inu, iae?ieiiaiaeu.

Iae?ieiiaiaea i?aaenoaaeyao ec naay iineaaeiaaoaeueiinoue iia?aoeee,
caienaiiuo a aeaea eino?oeoeee ia niaoeeaeueiii ycuea. I?e i?aaioea
aeaiiuo /anoi i?eoiaeeony aeaeaoue aeeeiiua iineaaeiaaoaeueiinoe
aeaenoaee. Ii ethaua aeaenoaey, iia?aoeee iiaoo auoue caienaiu a aeaea
iae?ieiiaiae. Aucia iae?ieiiaiae i?eaiaeeo e auiieiaieth
iineaaeiaaoaeueiinoe ?aiaa iienaiiuo aeaenoaee. I?eiaiaiea iae?ieiiaiae
iicaieyao aaoiiaoece?iaaoue ?acee/iua iiaoi?ythueany i?ioeannu, oaeea
eae caiieiaiea Aacu, auiieiaiea cai?inia, ioe?uaaiea ?acee/iuo iauaeoia
e o.ae.

Iineaaeiaaoaeueiinoue iia?aoeee aaiaeeony iieueciaaoaeai a ieii
i?iaeoe?iaaiey iaeieiiaiae. Aeey nicaeaiey iae?ieiiaiaeu a ieia Aacu
aeaiiuo iaaeieoa eiiieo Macro, a caoai eiiieo New. Iinea yoiai ioe?iaony
ieii i?iaeoe?iaaiey iae?ieiiaiae. Iieiue aeae yoiai ieia:

A ieia i?iaeoe?iaaiey iae?ieiiaiae eaaeaeay no?iea iiaeao niaea?aeaoue
iaeio eino?oeoeeth a eieiiea Action e eiiiaioa?ee e iae a eieiiea
Comment. Ioaeioth eino?oeoeeth au iiaeaoa aua?aoue ec i?aaeinoaaeyaiiai
nienea.

Eieiiea Condition niaea?aeeo oneiaiua au?aaeaiey aeey oi?aaeaiey
i?ioeannii auiieiaiey iae?ieiiaiaeu. Yoa eieiiea ia iaycaoaeueia e i?e
ia?aiia/aeueiie caa?ocea ieia i?iaeoe?iaaiey iae?ieiiaiae iia ia
aunaa/eaaaony. Aua?aoue aa Au iiaeaoa a iaith View aua?aa iioeeth
Conditions.

Au oae aea iiaeaoa nicaeaoue iae?ia?oiio niaea?aeauoth ianeieueei
iae?ieiiaiae. Eaaeaeay ec iae?ieiiaiae aoaeao auiieiyony iacaaeneii io
ae?oaeo iae?ieiiaiae a a?oiia. Iae?ieiiaiaeu a oiaeyuea a iae?ia?oiio
i?aaenoaaeytho niaie eiaiiaaiiua iineaaeiaaoaeueiinoe eino?oeoeee.
Nicaeaoue iae?ia?oiio Au iiaeaoa oae: nia/aea nicaeaeoa iae?ieiiaiaeo, a
caoai a eieiiea Macro Name a ia?aie no?iea caaeaeoa ae eiy. Yoa eieiiea
oae aea ia iaycaoaeueia e i?e ia?aiia/aeueiie caa?ocea ieia
i?iaeoe?iaaiey iae?ieiiaiae iia ia aunaa/eaaaony. Aua?aoue aa Au iiaeaoa
a iaith View aua?aa iioeeth Macro Names.

A iaeiii ieia i?iaeoe?iaaiey iae?ieiiaiae iiaeao niaea?aeaoueny
ianeieueei iae?ia?oii.

Auiieieoue iae?ieiiaiaeo Au iiaeaoa iaaeaa ia eiiieo

eee aua?ua iioeeth Run Macro… a iaith File.

Iiaeoee.

I?e ?aoaiee aeinoaoi/ii neiaeiuo caaea/ Au nei?i noieeiaoanue n
ia?aie/aiiinoueth iae?ieiiaiae. Aeey i?aiaeieaiey aicieeoeo i?iaeai Au
iiaeaoa iii?iaiaaoue iaienaoue naith i?ia?aiio ia ano?iaiiii a Access
ycuea i?ia?aiie?iaaiey – Access Basic. Ii i?aaenoaaeyao ec naay
n?aaenoai aecoaeueiiai i?ia?aiie?iaaiey e yaeyaony aeeaeaeoii ycuea
Visual Basic. Oaeay i?ioeaaeo?a ioi?ieyaony eae Iiaeoeue.

Iiaeoeue i?aaenoaaeyao ec naay niaieoiiinoue iauyaeaiee (aeaeea?aoeee) e
iineaaeiaaoaeueiinoae eniieiyaiuo eiiaiae (i?ioeaaeo?, ooieoeee)
caienaiiuo ia ycaea Access Basic.

Aeey nicaeaiey iiaeoey iaaeieoa ia eiiieo Modul a ieia Aacu aeaiiuo, a
caoai ia eiiiea New. Au oaeaeaoa oaeia ieii:

Yoi ieii i?aaenoaaeyao ec naay oaenoiaue ?aaeaeoi?, n aaoiiaoe/aneie
i?iaa?eie neioaenena i?e caeai/eaaiee no?iee, aaea au iiaeaoa iaae?aoue
oaeno naiae i?ia?aiiu ninoiyoee ec ia?aiaiiuo, iia?aoi?ia, aucuaaaiuo
ooieoeee.

3. IINO?IAIEA IAAIEUeOIE AACU AeAIIUO.

Aeey oiai /oiau eo/oa iiiyoue Access iino?iei naith Aaco aeaiiuo.
Nia/aea ii?aaeaeeiny eaeoth eioi?iaoeeth aoaeao niaea?aeaoue iaoa Aaca
aeaiiuo. Aaca aeaiiuo iiaeao niaea?aeaoue eioi?iaoeeth i /ai oaiaeii: i
ca?ieaoa, i oi?aiauo iinoaaeao, i aieueiuo a iieeeeeieea, i nooaeaioao
AOCa, i ae?ocueyo, i eieaao a aaoae aeaeeioaea. Iu iinoiei naioth
i?inooth – i nooaeaioao eaeiai-ieaoaeue AOCa. Yoa Aaca aeaiiuo aoaeao
ninoiyoue ec o?ao acaeiinaycaiiuo oaaeeoe:

Nienie AOCia, eioi?ue aoaeoo niaea?aeaoue oaeoth eioi?iaoeeth:

– Iiia? AOCa.

– Iacaaiea AOCa.

Nienie oaeoeueoaoia, eioi?ue aoaeoo niaea?aeaoue oaeoth eioi?iaoeeth:

– Iiia? oaeoeueoaoa.

– Iiia? AOCa, aaea iaoiaeeony yoio oaeoeueoao.

– Iacaaiea oaeoeueoaoa.

Nienie nooaeaioia, eioi?ue aoaeoo niaea?aeaoue oaeoth eioi?iaoeeth:

– Iiia? nooaeaioa.

– Iiia? oaeoeueoaoa.

– nooaeaioa.

– Ia eaeii eo?na nooaeaio.

E yoi aeaeaei ia iieiue nienie oiai /oi iu iiaeai ciaoue i nooaeaioa, ii
aaaeue iu aeaeaai iaaieueooth Aaco e yoiai oaaoeo /oi au iiiyoue eae
no?ieoue Aaco aeaiiuo.

A?aoe/anee yoi iiaeao auoue i?aaenoaaeaii a aeaea o?ao oaaeeoe:

1. Nienie AOCia:

Iiia? AOCa Iacaaiea AOCa

1 IAO

2 IIE NIaAOO

3 IAIE

2. Nienie oaeoeueoaoia:

Iiia? oaeoeueoaoa Iiia? AOCa Iacaaiea oaeoeueoaoa

1 1 Eioi?iaoeeiiiua nenoaiu

2 3 Ei. yc.

3 2 Iao. Iao.

3. Nienie nooaeaioia:

Iia? nooaeaioa Iiia? oaeoeueoaoa O.E.I. Eo?n

1 3 Eaaiia E.E. 5

2 2 Neaei?ia N.N. 1

3 1 Iao?ia I.I. 1

Aaea no?aei/eaie iieacaiu nayce eee ioiioaiey(?aeyoeee) iaaeaeo
oaaeeoeaie (o.e. Access ?aeyoeeiiiay NOAAe).

Eoae, ia/iai.

Caioneaai Access e ioe?uaaai Aaco aeaiiuo, iaciaai aa Students. Nia/aea
iai iaaei iino?ieoue o?e, auoa iienaiiuo oaaeeoeu. Aeey yoiai iaaeeiaai
eiiieo New e ia/iai eiino?oe?iaaoue ia?aoth oaaeeoeo. Aaiaeei eiaia iiea
e eo oeiu, ia?aie caienueth au iiaeaoa aaanoe n/ao/ee(oei counter)
caienae e onoaiiaeoue ia?ae/iue eeth/, ii yoi iaiaycaoaeueii. Access i?e
nio?aiaiee oaaeeoeu ni?ineo: “Nicaeaoue ia?ae/iue eeth/?” anee Au
auaa?eoa Aea, oi ii nicaeano iiaia iiea n eiaiai ID e oeiii counter.
Aeaeueoa iai aoaeoo ioaeiu oieueei iiey n oeiaie Text e Number.

Yoe oaaeeoeu aoaeoo auaeyaeaoue oae:

1.

2.

3.

Aeaeueoa iai ioaeii onoaiiaeoue nayce iaaeaeo oaaeeoeaie, aeey yoiai a
iaith Edit auaa?eoa iioeeth Relationships e onoaiiaeoa nayce iaaeaeo
iieyie. Aeey onoaiiaeaiey nayce auaa?eoa ioaeiia aai iiea, oeaaeeoa ia
iaai iuoeie e oaea?aeeaay i?aaoth eiiieo iuoe iieaaeeoa ia iiea n
eioi?ui Au oioeoa onoaiiaeoue naycue. Ii caeanue anoue iaaieueoia
ia?aie/aiea: iiey iaaeaeo eioi?uie Au oioeoa onoaiiaeoue naycue aeieaeiu
auoue iaeiiai oeia. Iinea onoaiiaeaiey naycae iaoe oaaeeoeu aoaeoo
auaeyaeaoue oae (a aeaiiii neo/aa iu onoaiiaeee naycue iaeei ei iiiaei):

Yoe nayce iai ioaeiu aeey iaeaa/aiey iienea e auai?ee eioi?iaoeee.
Iai?eia? i?e i?iniio?a nienea oieaa?neoaoia Access aaoiiaoe/anee
onoaiaaeeaaao oeacaoaeue(o.a. aeaeaao caienue oaeouae) ia ia?aoth
caienue a oaaeeoea Faculties niaea?aeauoth a iiea Namber_of_univer oaeia
aea /enei, /oi e a oaeouai iiea ID oaaeeoeu Univer.

Oaia?ue iu iiaeai caiieieoue eaeie-eeai eioi?iaoeeae yoe o?e oaaeeoeu.
Aeey yoiai a ieia Aacu Aeaiiuo iaaeieoa eiiieo Open eee a iaith View
auaa?eoa iioeeth Datasheet. E ia/eiaeoa caiieiyoue, iiey n oeiii Ciunter
caiieiythony aaoiiaoe/anee. Iinea caiieiaiey, niaea?aeeiia yoeo oaaeeoe
iiaeao auaeyaeaoue, iai?eia?, oae:

1.

2.

3.

Eae au iiieiaaoa yoi ieieiaeueiue iaai? eioi?iaoeee ii yoie oaia, ii iai
e aai oaaoeo.

E oae ia aeaiiii yoaia iu eiaai Aaco aeaiiuo ninoiyuoth ec o?ao
naycaiiuo oaaeeoe e niaea?aeauoth iaeioi?oth eioi?iaoeeth. Aeaeueoa iai
iaaei eae-oi ?aaioaoue n yoie Aacie e a ia?aoth i/a?aaeue iai iaaei
i?iecaiaeeoue iiene e auai?eo eioi?iaoeee. Aeey yoiai nouanoaotho
cai?inu.

Iino?iei ianeieueei cai?inia.

1. Ioni?oe?oai oaaeeoeo student a aeoaaeoiii ii?yaeea ii iieth name.
Aeey yoiai naeaeaai QBE-cai?in oaeiai aeaea:

E anee iu i?iniio?ei Dynaset oi oaeaeei neaaeothuoth oaaeeoeo:

2. Aeaeueoa iai, iai?eia?, iiaeao iiiaaeiaeoueny aua?aoue ec nienea
nooaeaioia anao iao/athueony ia ia?aii eo?na. Aeey yoiai nouanoaotho
e?eoa?ee auai?ee. Aeey oiai /oiau inouanoaeoue ioaeioth iai auai?eo iai
iaaei a QBE-cai?ina a iiea Criteria noieaoea year iinoaaeoue oeeo?o
‘1’(yoi cia/eo /oi ec oaaeeoeu Student aoaeoo aua?aiu ana caiene o
eioi?uo a iiea noieaoea year noieo ‘1’). E anee iu i?iniio?ei Dynaset oi
oaeaeei neaaeothuoth oaaeeoeo:

3. Oae eae o ian anoue ianeieueei naycaiiuo oaaeeoe, oi iu iiaeai
naeaeaoue cai?in iniiaaiiue ia ianeieueeeo oaaeeoeao. Iai?eia?, ec
eiathueony o ian oaaeeoe naeaeaai oaeoth auai?eo: Iacaaiea AOCa,
iacaaiea oaeoeueoaoa aaea iao/aaony nooaeaio, eiy nooaeaioa e eo?n,
ioni?oe?iaaiioth ii iieyi name_of_university e name. Aeey yoiai
iiaeaioiaei oaeie QBE-cai?in:

E anee iu i?iniio?ei Dynaset oi oaeaeei neaaeothuoth oaaeeoeo:

Oaeei ia?acii au aeaeeoa /oi Access iicaieyao inouanoaeyoue ?acee/ioth
ia?aaioeo eioi?iaoeee.

Ii /oi Au aoaeaoa aeaeaoue anee a Aaoo Aaco aeaiiuo aaiae eioi?iaoeee
aoaeao inouanoaeyaony iaeaaeeoeoee?iaaiiui iieueciaaoaeai. *oiau oaeea
ethaee iiaee niieieii ?aaioaoue n aaoae Aacie e ia aeaeaee oiai, /oi ei
iaioaeii aeaeaoue, Access i?aaeoniao?eaaao oaeoth aauue eae Oi?ioey?u.
Iino?iei iaeei.

Ec i?aaeoniio?aiiuo Access niiniaia nicaeaiey oi?ioey?ia auaa?ai naiue
i?inoie – yoi eniieueciaaiea Eiino?oeoi?a oi?ioey?ia. Naie oi?ioey?
naeaeaai ia iniiaa cai?ina eioi?ue iu, a naith i/a?aaeue naeaeaee ia
iniiaa ianeieueeeo oaaeeoe. Ec i?aaeeaaaaiuo oi?ioey?ia auaa?ai
Single-column, aeaeueoa auaa?ai ana iiey e naeaeaai aai Shadowed. Iinea
anaai yoiai o ian aeieaeii iieo/eoueny /oi-oi a?iaea yoiai:

A yoii ieia iiaeii eae ?aaeaeoe?iaaoue oae e aaiaeeoue iiaoth
eioi?iaoeeth. Iiieii yoiai, oi?ioey?u iiaeii ?ania/aouaaoue ia i?eioa?a.
Iiniio?aoue eae aoaeao auaeyaeaoue aeaiiue oi?ioey? ia eenoa aoiaaa Au
iiaeaoa a eiioea ?aaiou.

E?iia oi?ioey?ia Access i?aaeinoaaeyao niaoeeaeueiia n?aaenoai aeey
?ania/aoee aua?aiiie eioi?iaoeee – Io/aou. Io/aou ioee/athony io
oi?ioey?ia iaeiei: a io/aoa iaeuecy ?aaeaeoe?iaaoue aeaiiua. Aeaaaeoa
nicaeaaeei iaeei, ii iniiaaiiue oieueei ia iaeiie oaaeeoea Univer. Aeey
yoiai oaeaea ainiieuecoainy Eiino?oeoi?ii io/aoia, o.e. yoi aieaa eaaeee
e iiiyoiue niinia iino?iaiey /aai-eeai. Aeey yoiai ec i?aaeeaaaaiuo
cai?inia e oaaeeoe auaa?ai oaaeeoeo Univer, iioii auaa?ai iioeeth
a?oiie?iaee Groups/Totals, ii?yaeie iieae a io/aoa inoaaei oaeie aea,
na?oiie?oai ii iieth name_of_university a ?aaeeia Normal, i/a?aaeiinoue
ni?oe?iaee a a?oiiao naeaeaai ii inoaaoaiony iieo ID, auaa?ai noeeue
oi?iu io/aoa Presentation e ?aniieiaeaiea ia eenoa aoiaae Portrait,
aaaaeai eiy aeey io/aoa University e iaaeiai eiiieo Finish. Access
nicaeano io/ao, aai Au niiaeaoa oaeaeaoue a eiioea ?aaiou.

Ia?aaaouaay oaeei ia?acii eioi?iaoeeth iu /anoi iiaoi?yai ii?aaeaeaiiua
iineaaeiaaoaeueiinoe iia?aoeee e aeey oiai /oiau ecaaaeaoue yoiai, a
oaeaea iiauneoue yooaeoeaiinoue iauaiey n Aacie aeaiiuo e nie?aoeoue
a?aiy ia?aaioee aeaiiuo. Access i?aaeinoaaeyao iaai? Iae?ieiiaiae. A
iaoae Aaca anoue iaeii oaeia iiaoi?ythuaany aeaenoaea: anee i?e eaaeaeie
caa?ocea Aacu aeaiiuo iu oioei ioe?uaaoue n?aco ana iaoe oaaeeoeu,
cai?inu, io/aou eee /oi-ieaoaeue aua, oi iu iiaeai caienaoue
iineaaeiaaoaeueiinoue iae?ieiiaiae aeaeathueo yoi.

Aeey yoiai nicaeaaeei ieii i?iaeoe?iaaiey iae?ieiiaiae, caeanue eaaeaeay
no?iea iiaeao niaea?aeaoue iaeio eino?oeoeeth a eieiiea Action e
eiiiaioa?ee e iae a eieiiea Comment. A eaaeaeie no?iea eieiiee Action
anoue nienie iae?ieiiaiae ec eioi?iai auaa?ai ioaeiua iai iae?ieiiaiaeu:
Opentable(Ioe?uoue oaaeeoeo), OpenQuery(Ioe?uoue cai?in),
OpenReport(Ioe?uoue io/ao), Minimize(Ieieiece?iaaoue), MsgBox(Ieioei
niiauaiey) e ?aciaueai eo ia iae?ia?oiiu n eiaiaie 1, 2, 3. Ia?aay
iae?ia?oiia aoaeao auaeaaaoue niiauaiea, ioe?uaaoue o?e oaaeeoeu e
ieieiece?iaaoue eo. Aoi?ay aoaeao auaeaaaoue niiauaiea, ioe?uaaoue
cai?in e ieieiece?iaaoue aai. O?aouey aoaeao auaeaaaoue niiauaiea,
ioe?uaaoue io/ao e ieieiece?iaaoue aai.

Ieii i?iaeoe?iaaiey iae?ieiiaiae aoaeao auaeyaeaoue oae:

Oaia?ue /oiau caionoeoue yoi, iaaei a iaith File aua?aoue iioeeth Run
Macro e aua?aoue ec nienea ioaeioth aai iae?ia?oiio. Iai?eia?, anee au
caionoeoa ia?aoth, oi nia/aea oaeaeeoa niiauaiea:

Anee Au iaaeiaoa ia eiiieo OK, oi oaeaeeoa /oi-oi a?iaea yoiai:

Iaoa iae?ia?oiia io?aaioaea: ioe?uea oaaeeoeu e ieieiece?iaaea eo. Anee
au caionoeoa inoaeueiua, oi ?acoeueoao aoaeao oaeie aea, oieueei ioe?uou
aoaeoo cai?in e io/ao.

?aaioay n iae?ieiiaiaeaie Au nei?i oaeaeaoa, /oi yoi aeiaieueii
ia?aie/aiiue eino?oiaio oi?aaeaiey Aacie aeaiiuo. Iiieii iae?ieiiaiae
Access eiaao ao?iaiiue ycue i?ia?aie?iaaiey – Access Basic, yoio ycue
i?aaenoaaeyao niaie aeeaeaeo ycuea Visual Basic . Aeey iaienaiey
i?ia?aii Access i?aaeinoaaeyao oaeia n?aaenoai eae Iiaeoeue. Iiaeoeue
i?aaenoaaeyao niaie iaaieueoie oaenoiaue ?aaeaeoi? n i?iaa?eie neoaenena
i?e caaa?oaiee no?iee. Caeanue Au iiaeaoa ienaoue naie ooieoeee e
i?ioeaaeo?u. Access Basic, eae e ethaie ycue i?ia?aie?iaaiey, eiaao
ia?aiaiiua, eiinoaiou, iia?aoi?u oeeeea, oneiaey e iaai? ooieoeee aeey
auiieiaiey ?acee/iuo aeaenoaee.

4. Iaaieueoay n?aaieoaeueiay oa?aeoa?enoeea NOAAe Clipper e Access.

I?iaaaeai iaaieueoea n?aaiaiea yoeo aeaoo NOAAe. Eo aeaaiia ?acee/ea yoi
oi /oi Clipper i?aaeiacia/ai aeey ?aaiou a DOS, a Access – a Windows.
Nouanoaoao oaeaea ?acee/ea a no?oeoo?a ia?aaaouaaaiuo aeaiiuo. Access,
eae auei neacaii auoa, iiaeaea?aeeaaao, aac eiiaa?oe?iaaiey, oaeea
oi?iaou eae dBASE, Paradox eee Btrieve. Clipper a yoii ioiioaiee iaiiiai
aaaeiaa, ii iiaeaea?aeeaaao oieueei dDASE oi?iao.

Clipper ioee/aaony aieaa ?acaeoui ycueii i?ia?aiie?iaaiey a yoii
ioiioaiee ii aieueoa iioiae ia Ne, Ianeaeue, /ai ia /enoi NOAAe, oaeoth
eae Access, iai?eia?. Eiia/ii a Access oiaea aoiaeeo ycue
i?ia?aiie?iaaiey Access Basic (ano?iaiiue aeeaeaeo ycuea Visual Basic
), aeathuee aiciiaeiinoue oi?ie?iaaiey niaoeeaeece?iaaiiuo nenoai
oi?aaeaiey aacaie aeaiiuo, ii aieaa aaaeiue.

Access i?eaoe?iaai aieueoa ia ethaeae ia caieiathoeony
i?ia?aiie?iaaieai. Ii eiaao i/aiue oaeiaiue e iiiyoiue eioa?oaen, i/aiue
iiiaea iia?aoeee o iaai aaoiiaoece?iaaiu n iiiiuueth ?acee/iuo
Eiino?oeoi?ia. Oae aea ia iaaei i?eaeoiuaaoue e ienaoue naie eioa?oaen
aeey naiae Aacu aeaiiuo, iaaei oieueei aua?aoue ec oaea nooanoaothueo.
Clipper a yoii ioiioaiee iaiiiai aaaeiiae e ia eiaao oaeeo n?aaeno
aaoiiaoecaoeee i?iaeoe?iaaiey e ia?aaioee aeaiiuo.

Ia yoii iniiaiua ?acee/ey caeai/eaathony. Oae eae Access e Clipper
yaeythony ?aeyoeeiiiuie NOAAe, oi iniiaiua oa?ieiu i?aeoe/anee ia
ioee/athony. E oai, e oai iieueciaaoaeue eiaao aeaei n oaaeeoeaie,
iieyie, caienyie.

Nienie eeoa?aoo?u:

Microsoft Access, User’Guide. Microsoft Corporation, 1994.

Microsoft Access, Getting Started. Microsoft Corporation, 1994.

Aaia? N., O?aoa? A.: Microsoft Access aeey iieueciaaoaey. Ieeai, Iineaa
1994.

PAGE

PAGE 4

Нашли опечатку? Выделите и нажмите CTRL+Enter

Похожие документы
Обсуждение

Ответить

Курсовые, Дипломы, Рефераты на заказ в кратчайшие сроки
Заказать реферат!
UkrReferat.com. Всі права захищені. 2000-2020