资源描述：
《A_Quick_Microsoft_Access_2007_Tutorial》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、AQuickMicrosoftAccess2007TutorialByCharlesW.Neville,©CharlesW.Neville,withmodificationbyLeithChan,VickyWongandStevenLuVerbatimcopyingandredistributionofthistutorialarepermittedinanymediumprovidedthisnoticeandthecopyrightnoticearepreserved.Thistutorialisintend
2、edforstudentswhoneedaquickintroductiontoMicrosoftAccess,butitwillbeusefultoanyoneneedingsuchanintroduction.Togetthefullbenefitofthistutorial,youwillneedacomputerwith500megahertz(MHz)processororhigherandrunningoneofMicrosoftWindowsXPwithServicePack(SP)2,Window
3、sServer2003withSP1,orlateroperatingsystem.Youwillalsoneedatleast1.5gigabyte(GB)harddiskspacetohaveMicrosoftAccess2007installed(aportionofthisdiskspacewillbefreedafterinstallationiftheoriginaldownloadpackageisremovedfromtheharddrive).MicrosoftAccess2007provide
4、salibraryofprebuiltdatabasesolutionstogetyoustartedquicklyIntroductionThoughMicrosoftAccessisNOTsynonymouswithdatabasesystems;therearemorecopiesofMicrosoftAccessinusethananyotherdatabasesystem.Itthereforebehoovescomputersciencestudentstobeatleastsuperficially
5、familiarwithMSAccess.Thistutorialwillguideyouthroughsomeofthebasicpoint-and-clickstuff,andwillevenshowyouhowtoissuecomplexSQL(StructuredQueryLanguage)queries.YouwillopentheNorthwindMicrosoftsampledatabaseandqueryitinvariousways.ThisisaHANDS-ONtutorial;itgives
6、youstep-by-stepdirectionsforcarryingoutsimpletasksinAccess.Asyouread,youshouldhaveacopyoftheNorthwinddatabaseopeninMicrosoftAccess2007,andyoushouldcarryoutthetasksyourself,exactlyasdirected.First,afewwordsaboutwhatMicrosoftAccess2007isandisn't.Peoplewhodon'tr
7、eallyunderstandwhatarelationaldatabasesystemis,andpeoplewhodon'tactuallyunderstandwhatMicrosoftAccess2007is,willIMSE1013:Database:AQuickMicrosoftAccess2007TutorialPage1tellyouthatMicrosoftAccessisnotafullyrelationaldatabasesystem.Inthedatabaseworld,notbeingfu
8、llyrelationalisverybad.Don'tworry!ThepeoplewhotellyouthatarelikethosewhotrytotellyouthatLinuxisnota32bitoperatingsystem.MicrosoftAccess2007,anditspredecessorsAccess95,97,02and03,areexcell
