DatabaseintroductionandACCESS2000Thedatabaseisthelatesttechnologyofdatamanagement,andtheimportantbranchofcomputerscience.Thedatabase,asitsnamesuggests,isthewarehousetopreservethedata.Thewarehousetostoreapparatusincomputeronly,anddatatodepositaccordingtosureforms。Theso-calleddatabaseisreferstothelong-termstoragethedataacquisitionwhichinthecomputer,organized,mayshare。Inthedatabasedataaccordingtothecertaindatamodelorganization,thedescription,andthestorage,hasasmallerredundance,thehigherdataindependenceandtheeasyextension,andmayaltogethershineforeachkindofuser。Theeffectivemanagementdatabase,frequentlyhasneededsomedatabasemanagementsystems(DBMS)istheuserprovidestodatabaseoperationeachkindoforder,thetoolandthemethod,includingdatabaseestablishmentandrecordinginput,revision,retrieval,demonstration,deletionandstatistics。MicrosoftdevelopsACCESS2000isinWindows95/98/2000andWindowsintheNTplatformtheapplicationrelationsdatabasemanagementsystem,mayaccordingtocarryonthecontrolandthemanagementthrougheachkindofdatabaseobjectlogarithm,nomattertheuserfoundstheindependenttabletopdatabaseissuitableforindividual,thedepartmentortheentireenterprise,ACCESS2000allmaythedatabasewhichiseasyforthemanagementdataproductiontouse,ACCESS2000notonlyhavethefunctionwhichmultitudinoustraditiondatabankadministrationsoftwarehas,meanwhilefurtherstrengthenedwiththewebpageintegration,canamoreconvenientsharingsurmounteachkindofplatformandthedifferentuserrankdata。ACCESS2000certainlydoesnotneedthedatabasesuperintendenttohavetheveryhighspecializedprogramminglevel,thenon-specializeduserdefinitelymayfoundafunctionformidabledatabasesystemusingACCESS2000,usestheACCESS2000databasemanagementsystemonlyifcarriesoutcomplexorthespecializedoperation,intheordinarycircumstancestheuserdoesnotneedtocompiletheprocedurecodetobeallowedtocompletethemajoritydatathesupervisorywork。Nowthesocietyisaninformationsociety,allthevarioustradesandoccupationsdatamessageallquiterich,thishaddecidedtheusedatabasemanagementsystemmanagementdataisextremelyessential,inthelibrarythenmanifestsismoreobvious,themanagermaynotspendthesmalleffortfrominthetensofthousandsofthisbookdatabasetoretrievethebookswhichthereaderwantstoborrow.TheACCESS2000databaseisobject-oriented,usestheeventtoactuatethemechanismthenewrelationshipdatabasemanagementsystem(RDBMS)italreadytobeallowedthroughODBCwithotherdatabases(Sybase,theParadoxconnectedrealizationdataexchangeandsharing,alsomaywithWord,ExceltheOfficeofficesoftwarecarryonthedatamessageexchangewithaltogethertoshine。AfterusestheACCESS2000database,theusermaymanageallinformationinthesoledatabase.Thedataonlyneedsinthetabletosaveatime,theuserthenmayexamineinthedifferentposition,aftersomedatarenewal,alldemonstrationsthisdatapositionallautomaticallywillrenew,likethiswasallowedtoavoidtheredundancymemoryreducingtheworkloadandthewrongACCESS2000databasewillbebythetable,theinquiry,thewindow,thereportform,thedataaccessingpage,greataswellasthemodulesevenkindofdataobjectsiscomposed,thesedataobjectshavethedifferentfunctioninthedatabase,thesedatabaseobjectsmajorityofallsavedinthedatabasetakeACCESS2000apart,ifhadalonetooutputsomedatabaseobject,wasallowedtoprovideusingACCESS2000derivesthefunction,AlthoughACCESS2000canuseitsconformityACCESSVisualthebasic6.0languagesvisiblefoundationsapplicationprocedure,buttheveryfewsomepeopleuseittodevelopadatabaseapplicationprocedure。數(shù)據(jù)庫(kù)概論及ACCESS2000簡(jiǎn)介數(shù)據(jù)庫(kù)是數(shù)據(jù)管理的最新技術(shù)，是計(jì)算機(jī)科學(xué)的重要分支。數(shù)據(jù)庫(kù)，顧名思義，是存放數(shù)據(jù)的倉(cāng)庫(kù)。只不過(guò)這個(gè)倉(cāng)庫(kù)是在計(jì)算機(jī)存儲(chǔ)設(shè)備上，而且數(shù)據(jù)是按一定的格式存放的。所謂數(shù)據(jù)庫(kù)是指長(zhǎng)期儲(chǔ)存在計(jì)算機(jī)內(nèi)的、有組織的、可共享的數(shù)據(jù)集合。數(shù)據(jù)庫(kù)中的數(shù)據(jù)按一定的數(shù)據(jù)模型組織、描述、和儲(chǔ)存，具有較小的冗余度、較高的數(shù)據(jù)獨(dú)立性和易擴(kuò)展性，并可為各種用戶共享。為了有效的管理數(shù)據(jù)庫(kù)，常常需要一些數(shù)據(jù)庫(kù)管理系統(tǒng)（DBMS）為用戶提供對(duì)數(shù)據(jù)庫(kù)操作的各種命令、工具及方法，包括數(shù)據(jù)庫(kù)的建立和記錄的輸入、修改、檢索、顯示、刪除和統(tǒng)計(jì)等。微軟開(kāi)發(fā)的ACCESS2000是在Windows95/98/2000及WindowsNT平臺(tái)中應(yīng)用的關(guān)系型數(shù)據(jù)庫(kù)管理系統(tǒng)，可以通過(guò)各種數(shù)據(jù)庫(kù)對(duì)象對(duì)數(shù)據(jù)進(jìn)行控制和管理，不論用戶創(chuàng)建的獨(dú)立桌面數(shù)據(jù)庫(kù)適用于個(gè)人、部門(mén)還是整個(gè)企業(yè)，ACCESS2000都可以為管理數(shù)據(jù)生成易于使用的數(shù)據(jù)庫(kù)，ACCESS2000不僅擁有眾多傳統(tǒng)數(shù)據(jù)庫(kù)管理軟件所具備的功能，同時(shí)還進(jìn)一步增強(qiáng)了與web頁(yè)集成，能夠更方便的共享跨越各種平臺(tái)和不同用戶級(jí)別的數(shù)據(jù)。ACCESS2000并不需要數(shù)據(jù)庫(kù)管理者具有很高的專業(yè)程序設(shè)計(jì)水平，非專業(yè)的用戶完全可以利用ACCESS2000創(chuàng)建出一個(gè)功能強(qiáng)大的數(shù)據(jù)庫(kù)系統(tǒng)，使用ACCESS2000數(shù)據(jù)庫(kù)管理系統(tǒng)除非執(zhí)行復(fù)雜或?qū)I(yè)的操作，一般情況下用戶無(wú)需編寫(xiě)程序代碼就可以完成大多數(shù)數(shù)據(jù)的管理工作。當(dāng)今社會(huì)是一個(gè)信息化的社會(huì)，各行各業(yè)的數(shù)據(jù)信息都比較豐富，這決定了利用數(shù)據(jù)庫(kù)管理系統(tǒng)管理數(shù)據(jù)是十分必要的，圖書(shū)館中進(jìn)而體現(xiàn)的更加明顯，管理員可以從成千上萬(wàn)本書(shū)的數(shù)據(jù)庫(kù)中不費(fèi)吹灰之力檢索出讀者想要借閱的圖書(shū)等等。ACCESS2000數(shù)據(jù)庫(kù)是一個(gè)面向?qū)ο?，采用事件?qū)動(dòng)機(jī)制的新型關(guān)系數(shù)據(jù)庫(kù)管理系統(tǒng)（RDBMS）它既可以通過(guò)ODBC與其他數(shù)據(jù)庫(kù)(Sybase、Paradox等)相連實(shí)現(xiàn)數(shù)據(jù)的交換與共享，也可以與Word、Excel等Office辦公軟件進(jìn)行數(shù)據(jù)信息交換與共享。使用ACCESS2000數(shù)據(jù)庫(kù)后，用戶可以在單一的數(shù)據(jù)庫(kù)中管理所有的信息。數(shù)據(jù)只需要在表中存儲(chǔ)一次，用戶便可以在不同的位置查看，當(dāng)某一數(shù)據(jù)更新后，所有顯示該數(shù)據(jù)的位置都將自動(dòng)更新，這樣可以避