MS Access. MS Access database. MS Access 2007

MS Access - neeg neeg rau zaub mov paub database system tswj (RDBMS) los ntawm Microsoft. Paub txhais tau tias nws yog raws li nyob rau hauv lub rooj. Peb xav txog qhov no system nyob rau hauv ntau yam.

Yuav ua li cas yog ib tug paub database?

Ib tug paub database muaj ib tug txheej ntawm lub rooj, ntawm uas tsim kev sib raug zoo los yog kev sib txuas lus. Database - ib tug plhaub uas tso cai rau koj los mus tsim thiab siv databases MS Access.

Xav txog qhov zoo thiab qhov tsis zoo ntawm cov DBMS.

Qhov zoo ntawm DBMS Microsorf Access

• Tej yam yooj yim thiab intuitive interface. Tau los ua hauj lwm nrog no database yuav ua tau, muaj tsis muaj kev txawj. Nyob rau hauv tas li ntawd, cov novice kev pab ntawm heev heev reference cov phau ntawv, hauv internet thiab offline kawm.
• MS Access database yog zoo paub thiab nrov heev nyob rau hauv lub desktop PC. Qhov no txhais tau tias koj yeej ib txwm nrhiav kev pab los ntawm ib tug phooj ywg, tau raug siv no database rau tswv yim, raws li zoo li ua hauj lwm ua ke nrog ib tug database rau hauv ib lub network.
• Zoo limitless possibilities rau export ntaub ntawv: cov ntaub ntawv los ntawm lub rooj ib tug nias ntawm tus nas yuav pauv mus rau Excel, Lo lus, export rau XML, luam tawm rau PDF, tsis hais qhov tseeb hais tias tsis muaj teeb meem yuav tawm mus xaiv khoom mus rau lwm database.
• Tsis tshua muaj nqi. Yog hais tias koj yuav MS Access raws li ib feem ntawm lub tag nrho Microsoft Office pob, raws li muab piv mus rau lwm cov them databases, tus nqi yuav txaus nyiam heev.
• Ib tug thoob plaws xaiv ntawm designers rau lub tsev cov ntaub ntawv, ntaub ntawv thiab queries, koj yuav siv tau lim cov ntaub ntawv thiab tso saib lawv nyob rau hauv ib tug yooj yim txoj kev.
• Cov Tsam Thawj import cov ntaub ntawv, yog tias koj muaj tabular cov ntaub ntawv los ntawm kev siv ib lo lus processor MS Word los MS Excel spreadsheet processor, koj siv tau cov wizard yuav hloov lawv mus rau hauv koj database yooj yim. Imports, nyob rau hauv tas li ntawd, yuav ua tau los ntawm ib tug yooj yim ntawv nyeem daim ntawv los ntawm ib tug XML ntaub ntawv, raws li tau zoo raws li database ntaub ntawv tsim nyob rau hauv lwm yam databases (xws li dBASE, Paradox).
• Muaj peev xwm mus tsim tau ib lo lus zais rau koj database.
• Ua-nyob rau hauv high-qib lus VBA.
• Muaj peev xwm sau macros.
• SQL editor.

Rau cov muaj peev xwm xaiv ib cov tseem ceeb kom zoo dua: cov tub ntxhais Access DAV HLAU 4 kos nyob rau hauv Microsoft kev khiav hauj lwm systems, pib nrog lub qhov rais-raws li 98. Qhov no txhais tau tias daim ntawv thov kev siv lub database tsim nyob rau hauv Access, koj yuav tau yooj yim nqa nyob rau hauv tej computer rau ntawm qhov rais. Nws yuav ua hauj lwm tsis muaj rau nruab ib lub DBMS nws tus kheej. Nyob rau hauv ib tug huab ntaub ntawv, tsuas yog xav tau rau nruab Runtime - version, uas yuav ua tau kiag li dawb mus download tau los ntawm lub Microsoft lub website.

Raws li koj tau pom, lub meej mom ntawm lub DBMS MS Access yog muaj. Tab sis tag nrho cov zoo yuav outweigh heev tseem ceeb tsis zoo. Cia peb kawm lawv.

Tsis zoo ntawm cov DBMS Microsoft Access

• MS Access yog hais txog cov ntaub ntawv-neeg rau zaub mov database. Qhov no txhais tau tias tag nrho cov ntaub ntawv yog ua ncaj qha rau tus neeg computer siv. Cov neeg rau zaub mov yog ib feem ntawm ib tug retrieves cov ntaub ntawv thiab hau lawv xav tau. Qhov no ua rau lub fact tias nyob rau hauv ib lub zos network Ply loj cov ntaub ntawv tsev, thiab nrog ib tug loj tus naj npawb ntawm cov neeg siv ua hauj lwm nrog cov database, tej zaum nws yuav network congestion. Lub classic cov ntaub ntawv-neeg rau zaub mov architecture yeej ib txwm txais tsawg productivity thaum ib tug loj tus naj npawb ntawm cov neeg siv. Nyob rau hauv MS Access 2010 version no qhov teeb meem yog cov daws.
• Qhov uas tsis muaj txhim khu kev qha cov ntaub ntawv tiv thaiv cov cuab yeej. Nyob rau hauv qhov tseeb, tsuas yog ib lo lus zais yog siv nyob rau hauv lub hauv paus ntawm cov ntaub ntawv thiab cov neeg siv cov lo lus zais. Rau tej tus kws khomob tshwjxeeb tsis ua tej teeb meem rau tshem tawm no tiv thaiv.
• Multiplayer hom yog tau tsuas yog nyob rau hauv ib tug ad hoc network los yog nyob rau hauv ib tug network ntaub ntawv neeg rau zaub mov.
• Yuav kom tsim ib tug kev cai interface yuav tsum nyiam programmers.
• Editor SQL queries yog txheej thaum ub, nws yog yooj yim siv.
• Qhov no database yog tsis pub dawb.
• MS Access kaw nyob rau hauv lub qhov rais kev khiav hauj lwm systems. Mus sim siv cov ntaub ntawv tsim nyob rau hauv lub database mus rau lwm cov kev khiav hauj lwm systems (piv txwv li, Linux), muaj zoo nkauj lo qhia. Cias hloov cov ntaub ntawv mus rau lwm lub database.

Thaum peb ntsia lub pros thiab cons ntawm MS Access, cov piv txwv ntawm cov 2007 version yuav muab ib co ceev cov lus qhia nyob rau hauv possibilities ntawm no database.

tsim ntxhuav

Muaj yog tsis muaj dab tsi yooj yim dua rau tsim ib tug tshiab rooj uas siv MS Access 2007:

1. "Creation," mus rau lub tab tom qab qhib ib tug database.
2. Nyem rau ntawm qhov icon "Rooj", nws yog ib tus thawj rau sab laug.
3. Ua ntej peb ib tug sawv cev nrig ntawm lub rooj nrog rau tus txheej txheem lub npe "Rooj 1" thiab nws pib-incrementing teb "Code".
4. Koj muaj peev xwm pib tswv yim ntaub ntawv mus rau lub thib ob kem. Tom qab nkag mus rau cov kab, koj yuav tsum nias lub Sau qhov tseem ceeb. Cov kem yog cia renamed mus rau "Field 1," "Code" teb yuav coj tau tus nqi ntawm cov chav nyob yuav tsum muaj tswv yim ntaub ntawv nyob rau hauv lub tom ntej no kab.
5. Yuav kom rename ib kem, cia li nias rau ntawm nws nrog tus nas ob zaug. Nws yog ntshaw kom qhia kom meej rau kem npe uas tsis muaj qhov chaw!
6. Builder ntxhuav nyob rau hauv Access 2007, heev ntse. Nws yog ib nqi rau koj nyob rau thawj kab ntawm lub tshiab rooj mus rau hauv lub teb nqi ntawm lub hom "Hnub", raws li nyob rau hauv cov nram qab no kab nyob rau hauv tib kem koj yuav raug caw mus siv daim ntawv qhia hnub.
7. Mus ua kom tiav cov creation ntawm lub rooj nws yuav tsum tau kev cawm dim los ntawm txhaj rau cov tsim nyog icon los yog tseem ceeb ua ke CTRL + S.

Muaj ntau cov neeg siv yooj yim dua mus rau tsoom fwv ntawm "Designer" rau ntau intuitive lag luam tshaj lub teb ntawm lub rooj, vim hais tias nyob rau hauv no hom, koj yuav qhia lub hom teb, txwv tsis pub rau qhov tseem ceeb. Nyob rau hauv no hom, koj yuav mus thaum twg los tau lub sij hawm mus ua hauj lwm nrog lub rooj, tsuas nias lub sib nug xov khawm rau ntawm qhov vaj huam sib luag.

Tsim ib cov lus nug

Xav txog yuav ua li cas los tsim queries nyob rau hauv MS Access. Nyob rau hauv 2007 yuav tsim ib tug yooj yim cov lus nug nyob rau hauv Tsim saib:

1. Nyob rau hauv "Ntawv qhia zaub mov" pane, nyem rau ntawm qhov "Tsim" khawm "Lus nug Designer" tab.
2. Ntawm no koj yuav tam sim ntawd pom ib lub qhov rais xaiv ntxhuav. Nyem rau ntawm txhua lub rooj uas cov ntaub ntawv yuav tsum tau xaiv. Nws yuav tsum tau nco ntsoov tias koj xaiv yuav tsum tau nqa tawm tsuas yog ntau tshaj ib lub rooj yuav tsum txawj txuas mus rau txhua lwm yam los ntawm tej teb.
3. Yog hais tias koj tau xaiv ntau tshaj ib lub rooj, koj yuav tsum tau tsim ib tug daim ntawv cog lus nruab nrab ntawm lawv, txuas rau lub kab nrog tus nas los ntawm ib tug teb nyob rau hauv ib lub rooj rau ib daim teb raug txuas mus rau lwm yam.
4. Tam sim no ob-nias lub teb los ntawm txhua lub rooj hais tias koj xav pom qhov tshwm sim.
5. Nyob rau hauv lub tshuab raj bar rau lub "Tsim" tab, nyem rau ntawm qhov loj exclamation mark. Ua ntej koj yuav tshwm sim nyob rau hauv tabular rau ntawm koj xaiv.

Qhov no yog qhov kev mis rau tsim queries. Yog xav paub ntxiv complex queries, saib Pab rau qhov kev pab cuam, los yog siv tshwj xeeb pab.

Tej zaum txawm tias ib tug novice neeg siv yuav xav muaj koj cov ntaub ntawv nyob rau hauv ib tug ntau pab hom tshaj ib tug yooj yim lub rooj. Tom qab ntawd nws los rau cov kev pab ntawm MS Access cuab tam - "Cov ntaub ntawv".

daim ntawv Wizard

Nyob rau hauv Access 2007 Piv txwv li, xav txog yuav ua li cas siv lub Form Wizard:

1. Nyob rau hauv "Tsim" tab, nyob rau hauv "Cov ntaub ntawv" mus rau "Daim Ntawv Wizard" los ntawm "Lwm yam ntaub ntawv".
2. Xaiv los ntawm txoj kev nco-down daim ntawv teev, ib lub rooj los yog cov lus nug uas koj xav tau los ua ib tug quas daim ntawv.
3. Siv ">" thiab ">>" ntawm ib ntu hloov lwm lub tsev "Qhov teb" hnub ntawm kab nyob rau hauv lub block "Xaiv teb" los ntawm ib tug los yog tag nrho ib zaug, ntsig txog. Nyem rau ntawm qhov "Tom ntej" khawm.
4. Xaiv cov tsos ntawm daim ntawv no siv tus tes hloov qhov.
5. Tom ntej no, xaiv rau hauv daim ntawv style, thiab koj yuav nias lub "Finish" khawm. Ntawm no yog koj cov lus los yog cov lus nug cov ntaub ntawv nyob rau hauv ib qho kev nthuav hom.

Yuav kom tsim ntau daim yuav tsum tau siv qhov kev tsim nyog constructor.

Thaum pom tias cov lus qhia no, peb yuav xaus uas MS Access - qhov no yog ib tug zoo lub sij hawm rau ib tug me me nqi. Tus phooj ywg interface, lub loj heev ntawm kos cov nyiaj them yug engineers thiab craftsmen - tag nrho cov no ua rau nws yooj yim mus tsim ib tug database thiab ua hauj lwm nrog nws.