资源描述:
《总预算项目【外文翻译】》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、本科毕业论文(设计)外文翻译原文:TheMasterBudgetProjectIfyouhadachancetolookovertheExcel-basedMasterBudgetarticlesandpreviousAccesscolumnstoprepareforourproject,youmayhavehadthefeeling—wheredoIstart?Welcometomyworld!Atfirstitmayseemalittleoverwhelming,butit’shelpfultothinkaboutitintermsofiteration
2、sofadesignproject.We’llcompleteouranalysisanddesignbeforewestartworkinginAccessinordertolimitthenumberofthingswehavetoreviseafterlearningsomethingnew.Sowe’llcompletetheworkinthefollowingphases:Analysis,Design,Development,Testing,andImplementation.Onequestiontoconsideris:Whatisthepl
3、aceofAccessasatoolinyourworkplace?It’slikelynotyourprimarysoftwareforaccountingdata.Considerhow/whatwedoinAccesscanusedatafromyourexistingsystemsand/orexportdatatothosesystems.I’mgoingtomakethefollowingassumption—Accessdoesnotreplaceexistingsystemsbutsupportsthem.Withthatinmind,Isu
4、ggestthefollowingobjectivesforthesystem:1.Noduplicatedatastored2.Easytouse3.Easytochangeoradaptasthesituationorneedchanges4.AccurateWe’llusethebikeexamplefromtheExcelarticlesbutcreateourdatastructuresothatanyproductscouldbeused.AsIsystematicallyworkedmywaythroughthesixpartsoftheExc
5、elseries,Iactuallywentthroughthemthreetimes.Thefirsttimewastoseewhatwasthereandtrytotakeitin;thesecondtime,Istartedmakingsomegeneralobservations;andthethirdtime,IstartedsortingmyobservationsintohowtheyrelatetoAccess.InthefirstMasterBudgetarticle(February2010),adatainputspreadsheeti
6、screated.Withinthespreadsheet,variousareasaresetupforspecificdata,suchassalesprojections,collections,productsandmaterials,manufacturing,cashflow,etc.Thesegiveusinsightsintothetableswewouldliketocreate.Oncewehavethetables,we’llconsidertheRelationships.Therearealsoanumberofplacesinth
7、eserieswherecalculationsareincluded.ThisgivesusinsightsintoprocessesinAccessthatmayinvolvequeries,forms,andmacros.TherearealsowhatIwouldcall“whatif”variables.Thesecanbeaddressedbycreatingtextboxesonformstoinputthevalues.Queriesandreportscanbeusedtocompletecalculationsandpresentprof
8、essional-lookingproformafi