Yuav ua li cas rau tsim ib tug database nyob rau hauv Access. Ua hauj lwm nrog ib tug Access database

Muaj ntau ntawm cov neeg hauv zos paub uas nyob rau ib lub sij hawm tswb sawv hauv qhov MS Office 2007 ib tug hloov interface, thiab yog dab tsi tsis watered nws tsim tawm! "Guru" nyuaj qhov tseeb hais tias tus tshiab chaw ua hauj lwm suite yog "ua tau txawv txawv thiab weird", tab sis vim hais tias nws confidently kwv yees demise thiab tag nrho cov oblivion cov neeg siv.

Tsis muaj dab tsi! Txij li thaum tsis muaj dab tsi tshwm sim, nyob rau hauv tsis tooj, sai sai no nws tau los ua tseeb hais tias cov kev siv ntawm tus tshiab "chaw ua hauj lwm" version tau ua ntau yooj yim dua thiab ntau yooj yim.

Thiab vim hais tias (raws li tau leej twg) hloov, tus nkag tau uas tau raug tsim nyob rau hauv lub "chaw ua hauj lwm 2007" tsis tsuas ntse tsiv mus rau hauv nws cov tshiab subsistence, tab sis kuj tau txais ib cov zajlus kom txoj kev loj hlob ntawm nws. Uas yog vim li cas lub 2010 version tau ua tsis tshua muaj neeg nrov ntawm kev cov neeg siv.

Cov kev hloov nyob rau hauv lub tshiab version ntawm Access

Heev tseem ceeb kev hloov tau ua thiab nto moo daim ntawv thov rau kev tsim databases. Los ntawm lub tshiab Sparklines tivthaiv, koj muaj peev xwm tsim thiab kho kom raug loj nyiaj ntawm cov ntaub ntawv. Thiab ua tsaug rau ib lub cuab tam Slicer muaj ib lub sij hawm ceev ceev thiab yooj yim navigation txawm nyob rau hauv loj databases. Thiab tag nrho ua tsaug rau lub siab zoo thiab txawj xav tig system pom.

Nyob rau hauv tas li ntawd, cov developers muaj ntxiv zoo dua kev koom ua ke nrog Excel, ncaj qha los ntawm qhov uas koj yuav import loj nyiaj ntawm cov ntaub ntawv. Txawm li cas los, novice neeg siv ntau xav txog yuav ua li cas rau tsim ib tug database nyob rau hauv Access.

Yuav ua li cas yog no

Yuav kom zoo teem bases, koj yuav tsum xub to taub lawv essence. Database hu ua nruj me ntsis ncaav qauv tsim los khaws thiab npaj ntaub ntawv. Nws tej zaum yuav muaj sib txawv heev khoom, tab sis lawv cov zajlus kom chav tsev yog lub rooj.

Lawv lub ntsiab sib txawv los ntawm zoo xws li cov lug nyob rau hauv lub spreadsheet editor yog hais tias lawv yog sib xyaw. Ua ib tug variation ntawm tej lub caij, koj yuav tau pib cov kev hloov ntawm tag nrho cov interconnected nrog kab lug. Cias muab, koj tsis tas yuav txhawj txog manually editing loj loj ntaub ntawv ntxhuav.

Yuav ua li cas koj yuav ua tau nrog cov kev pab los ntawm MS Access?

Tsis txhob xav hais tias cov ntawv no yog ib hom ntawm "zajlus kom continuation» Excel. Cov tau qhov kev pab cuam nyob rau hauv lo lus nug yog ntau npaum li cas nrug. Nyob rau hauv kev, tej creation ntawm databases MS Access yuav tsum tau ceev faj thought cov ntaub ntawv qauv ntawm ib qho ntawv, xyuas kev ncaj ncees ntawm cov ntaub ntawv, thiab siv cov ntaub ntawv no rau simulate tus queries, cov ntaub ntawv thiab ntaub ntawv.

piv txwv ntawm txoj kev kom muaj

Yog li ntawd yuav ua li cas rau tsim ib tug database nyob rau hauv Access thiab siv tau cov "Wizard" ua rau nws yooj yim rau novice cov neeg siv, tus txheej txheem ntawm kev complexity yog tsis sib txawv. Tiam sis peb yuav tsis pom zoo kom mus hais tias txoj kev, vim tag nrho cov dab yuav tsum tau to taub yuav tsim.

Thawj khiav hauv daim ntawv thov. kev sib tham yuav tshwm nyob rau hauv lub screen los mus tsim ib tug tshiab daim ntawv. Nyob rau hauv nws koj yuav tsum xaiv "Tshiab Database". Nyob rau hauv lub "Cov ntaub ntawv npe" yog tswvcuab nws muaj nuj nqis. Tsis txhob repetitive thiab meaningless npe ntawm tsis muaj dab tsi: raws li ib tug tshwm sim ntawm tej kev ua yuam los yog tus kheej kev lam ua, koj yuav yooj yim poob ntaub ntawv tseem ceeb.

"Tsim" tom qab no khawm pressed. Tam sim ntawd tom qab ntawd, cov saib yuav tshwm sim lub dialog box los tsim ib tug tshiab ntaub ntawv lub rooj, los ntawm uas koj thiab yuav tsim koj qhov project.

Yuav ua li cas mus xaiv hom?

A rooj yuav ntsia tau rau hauv ntau txoj kev sib txawv, tab sis peb yuav tawm tswv yim rau "Designer", vim nws yog yooj yim los mus tswj tag nrho cov txheej txheem thiab to taub zoo dua cov tag nrho hauv cov qauv ntawm cov ntawv no.

Siv kev hloov "hom-Designer" mus rau nws. Tom qab ntawd nws yog xeem yuav tsum tau kev cov lus lub npe. Txij li thaum tej zaum lawv yuav xav tau ntau tshaj ib tug, peb pom zoo kom rov qab mus rau siv ib co muaj nuj nqis npe.

Tam sim no, ua tau, tus txheej txheem nws tus kheej. Yuav ua li cas rau tsim ib tug database nyob rau hauv Access? Thawj kauj ruam yog yuav xaiv thiab sau nyob rau hauv lub npe ntawm lub teb, txhais tau cov ntaub ntawv hom, raws li zoo raws li teem qhov tseeb tseem ceeb teb. Tsuas yog ces koj yuav tau pib sau nyob rau hauv cov ntaub ntawv nyob rau hauv lub rooj.

Ua li no, siv cov lus txib "saib hom lus." Xyuam xim! Yog hais tias lub teb "yam khoom code" nyob rau hauv koj cov ntaub ntawv nws yog tsim nyog los "txee", ces sau nyob rau hauv ib lub teb yog tsis tsim nyog. Thaum koj tau tiav lawm ua hauj lwm rau cov kev taw qhia ntawm cov ntaub ntawv, nws yuav tsum raug kaw. Yog hais tias ib tug database xav tau ib tug thib ob lub rooj, nws tau koom ua ke ib pab neeg ntawm cov "Creation ntawm ib tug tsim lub rooj."

piv txwv ntawm bases

Tag nrho cov saum toj no yuav tsum yog ib tug tuag tsab ntawv tsis tau muab koj lub ntsiab lus ntawm lub "teb kev", uas tuaj nyob rau hauv muab rau Access database. koj yuav tham txog cov piv txwv nyob rau hauv cov cheeb tsam no yuav luag infinite, tab sis peb yuav tsom rau hauv daim ntawv, uas muaj peev xwm tiag pab txhawb cov ndlwg ntawm txoj kev kawm.

Piav mentsis txog tus creation ntawm daim ntawv nyob rau hauv lub kawm. Yuav ua li cas kuv yuav tsum tau li cas tiag? Qhov no yuav tsum muaj xws li cov nram qab no teb: tshwj xeeb code, pab pawg neeg tus xov tooj, thiab qhov kev kawm cov xib fwb. Thov nco ntsoov: lub teb "Kawm" thiab "tus xib fwb" yuav tsum tau txuam nrog ntxiv ntxhuav, los ntawm uas qhov kev pab cuam yuav kos cov uas tsim nyog ntxiv.

Yuav ua li cas yog nws ua li cas?

Ua ntej, ua tag nrho cov kev ua nyob rau hauv raws li cov saum toj no cov lus qhia. Mus rau lub "Tsim", koj yuav pib sau nyob rau hauv lub teb. Nyob rau hauv txoj kab nrog rau cov cai txog cov ntaub ntawv ntaus nws yuav tsum tau cim raws li "txee, tus yuam sij teb".

Lub "Group" thiab zoo xws li cov kab ntawm lub teb hom yog xa mus rau raws li "cov ntawv nyeem." Tab sis nyob rau hauv lub teb "Kawm" thiab "tus xib fwb" yuav tsum tau xaiv "saib Wizard". Tsis txhob txhawj: sai li sai tau raws li koj xaiv cov nqi no, qhov kev pab cuam yuav qhia rau koj ib tug dialog box. Tom qab nws cov lus qhia, koj muaj peev xwm tsim ib qhov txuas mus rau lwm cov ntxhuav. Raws li koj paub, yuav tsum tau tsim nyob rau hauv ua ntej.

Thaum koj nyem rau ntawm cov "Finish" khawm, ib tug ceeb toom yog tso tawm nyob rau hauv pem hauv ntej ntawm koj hais tias koj yuav tsum tau tsim ib tug kev twb kev txuas rau txuag lub rooj. Paub meej tias qhov kev txiav txim.

Tsim kev sib raug zoo ntawm cov ntxhuav

Peb twb tham txog qhov tseeb hais tias ua hauj lwm nrog ib tug Access database yuav tsum tau lub hav zoov ntawm kev mus ncaj qha ntawm ntau spreadsheets. Yog li ntawd yuav ua li cas rau tsim lawv?

Ua li no, qhib lub qhov kev kawm ntawv no, thiab ces mus nyob rau hauv txoj kev, "Ua hauj lwm nrog Databases - Cov ntaub ntawv Scheme". Yuav kom txiav txim thiab teev cov xwm ntawm kev sib raug, koj yuav tsum muab ob npaug rau-nias rau sab laug nas khawm nyob rau hauv lub dialog box "Change Association." Tom qab ntawd koj yuav tsum nias rau ntawm "OK" khawm. Raws li ib tug tshwm sim, koj teem lub neej ntawd hais kev xaiv, "ib tug rau ntau ntau".

Yog li ntawd peb ntsia cov nqe lus nug ntawm yuav ua li cas rau tsim ib tug database nyob rau hauv Access. Peb cia siab tias cov lus qhia yuav pab tau rau koj.