资源描述:
《总预算项目【外文翻译】》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、本科毕业论文(设计)外文翻译原文:TheMasterBudgetProjectIfyouhadachancetolookovertheExcel-basedMasterBudgetarticlesandpreviousAccesscolumnstoprepareforourproject,youmayhavehadthefeeling—wheredoIstart?Welcometomyworld!Atfirstitmayseemalittleoverwhelming,butit’shelpfultothinkaboutitin
2、termsofiterationsofadesignproject.We’llcompleteouranalysisanddesignbeforewestartworkinginAccessinordertolimitthenumberofthingswehavetoreviseafterlearningsomethingnew.Sowe’llcompletetheworkinthefollowingphases:Analysis,Design,Development,Testing,andImplementation.One
3、questiontoconsideris:WhatistheplaceofAccessasatoolinyourworkplace?It’slikelynotyourprimarysoftwareforaccountingdata.Considerhow/whatwedoinAccesscanusedatafromyourexistingsystemsand/orexportdatatothosesystems.I’mgoingtomakethefollowingassumption—Accessdoesnotreplacee
4、xistingsystemsbutsupportsthem.Withthatinmind,Isuggestthefollowingobjectivesforthesystem:1.Noduplicatedatastored2.Easytouse3.Easytochangeoradaptasthesituationorneedchanges4.AccurateWe’llusethebikeexamplefromtheExcelarticlesbutcreateourdatastructuresothatanyproductsco
5、uldbeused.AsIsystematicallyworkedmywaythroughthesixpartsoftheExcelseries,Iactuallywentthroughthemthreetimes.Thefirsttimewastoseewhatwasthereandtrytotakeitin;thesecondtime,Istartedmakingsomegeneralobservations;andthethirdtime,Istartedsortingmyobservationsintohowtheyr
6、elatetoAccess.InthefirstMasterBudgetarticle(February2010),adatainputspreadsheetiscreated.Withinthespreadsheet,variousareasaresetupforspecificdata,suchassalesprojections,collections,productsandmaterials,manufacturing,cashflow,etc.Thesegiveusinsightsintothetableswewou
7、ldliketocreate.Oncewehavethetables,we’llconsidertheRelationships.Therearealsoanumberofplacesintheserieswherecalculationsareincluded.ThisgivesusinsightsintoprocessesinAccessthatmayinvolvequeries,forms,andmacros.TherearealsowhatIwouldcall“whatif”variables.Thesecanbead
8、dressedbycreatingtextboxesonformstoinputthevalues.Queriesandreportscanbeusedtocompletecalculationsandpresentprofessional-lookingproformafi