access课程设计(论文)+酒店管理系统

工业大学数据库原理与应用课程设计（论文）题目酒店管理系统设计与实现院（系）软件学院专业班级软件技术081班学号学生姓名指导教师教师职称助教起止时间课程设计（论文）任务及评语院（系）软件学院教研室软件教研窒学号学生姓名专业班级课程设计（论文）题目酒店管理系统设计与实现课程设计（论文）任务课程设计任务及要求（1）掌握设计数据库表及其间的关系的基础知识（2）掌握设计相关的查询、窗体、报表、数据访问页和宏（3）有和具体业务相关的处理功能（不少于5个）（4）用切换面板、主窗体、菜单栏和工具栏三种方式设计用户界面。（5）用SQL设计带统计函数的查询（如MAX，MIN，COUNT，AVG，SUM）6用编写VBA代码实现部分功能课程设计过程中，要G1017G7696G17993G4444实G17353G10627G14422的G7114间G4445G6502，G2560G1186G6363G4560教G5084的G6363G4560。G8503G11842G3332G4448G6116G990G17860G1881G4493，G16772G5417实G1076G7097G16772，G16280G14551G4448G6984G3332G6788写G1998课程设计论文。指导教师评语及成绩G6116G13501G6363G4560教G5084G12626G43952G19G19G28G51921G73886G7097A1A2A3A4A5A6A7A8A9A10A11A12A13A14A15A16A17目录第1章课程设计目的与要求11G171课程设计目的11G172课程设计的实G20576G10627G367111G173课程设计的G20056G3803知识11G174课程设计要G87261第2章课程设计内容22G171系统设计22G172数据库G8181G342332G173设计窗体和报表G282G174窗体和报表G8181G3371主要代码11第3章课程设计总结14参考文献15A0A2A3A4A5A6A7A8A9A10A11A12A13A14A15A16A171第1章课程设计目的与要求G7424课程的课程设计实G19481G7171G11017G4388G2842务和计G12651G7438G1461G5699管理专业学生学G1076G4448G457数据库G2419理及G5224用（ACCG40SS2G19G192）G458课程G2530，G17839G15904的G980G8437G1852面的G13520G2524G16769G13463，其目的G3324于G2164G9157G4557数据库基础理论和基G7424知识的理G16311，掌握G17828用数据库G5224用系统G5332G2469软件的基G7424方G8873。1G172课程设计的实G20576G10627G3671G11840件要G8726能G17828G15904G58G76G81G71G82G90G86G28G17XG6817G1328系统的G5506G7438系统。数据库G5224用系统G5332G2469软件G2499G1209G17885用MG76G70G85G82G86G82G73G87AG70G70G72G86G86，G6122其G1194数据库管理系统。1G173课程设计的G20056G3803知识G10099G5725数据库的基G7424知识及G980种G1209G990数据库系统G5332G2469软件。1G174课程设计要G8726G6365课程设计G6363G4560G1082G6564G1391的课题，G5224G7693据G991G980G14422G13485G1998的基G7424G19668G8726G10432G12447G4448G6116G1855个方面的设计，G7643有G256G2499G17885G257的部分G2499G7693据设计G7114间的G4445G6502及工G1328G18339的G3835G4579G17878G5415G17885G6333。G17885用其G1194课题G6122不G2528的数据库管理系统，G2499G1209组G6116设计G4579组，分G8181G3371G17839G15904,共G2528协G1328G4448G6116G980个G5224用系统的G5332G2469任务。要G8726G1082写详细的设计说明G1082，G4557复杂的代码段和程序段，G5224画G1998程序流程图。G3324界面设计中，画G1998每个窗口的布局，有多个窗口G7114，G6365G8181G3371调用的方式画G1998窗口调用图，用手工画好报表和G7643G12626样式，G1017禁相互抄袭。A0A2A3A4A5A6A7A8A9A10A11A12A13A14A15A16A172第2章课程设计内容21系统功能分析2G171G171系统功能分析酒店管理系统G19668要G4557入住的人员和客房情况G17839G15904详细的管理，其中主要针G4557客房情况和人员入住情况G17839G15904管理。因此G7424系统分为如G991两G3835个方面1）基G7424情况资料，而基G7424情况资料有分为1G17职员资料2G17客房类G34233G17客房资料4G17会员管理G17等2消费结帐管理,G980样分为1G17G20056定G16772G54172G17入住G16772G54173G17消费明细4G17消费结帐G17此外,系统管理员还G2499G1209通过报表G4557系统的明细G980目了然。2G171G172系统功能G8181G3371设计酒店管理系统包括职员资料管理，客房类G3423管理，客房资料管理，会员资料管理，帐目管理分为入住管理，G20056定管理，消费明细管理，消费结帐管理，而G3324查询界面，G2499G1209查到详细的各种管理系统，详细情况如图2G171所示A18A19A20A21酒店管理系统基G7424资料消费结帐职员资料客房类G3423客房资料会员资料G20056定G16772G5417入住G16772G5417消费明细消费结帐A0A2A3A4A5A6A7A8A9A10A11A12A13A14A15A16A173A19A20A19A22A23A24A25A262G172G171数据库G19668G8726分析职员G1461G5699职员ID,姓名,职位,性别,籍贯,G5192龄,民族,健康状况,婚姻状况,省份证号,家庭住址,家庭G11017话,G3803注等G17客房类G3423类G3423ID,类G3423名称,客房价G7696,拼房价G7696,G2499超额定数G17客房资料客房ID,类G3423ID,类G3423名称,楼层编号,额定人数,固有床数,客房状态,客房描G17860,G3803注等G172G172G172数据库概念结构设计职员G1461G5699实体G40R图A18A19A20A19A27A28A29A30A31A32A33A18客房类G3423G40R图A18A19A20A34A35A36A37A26A31A32A33A18客房类G3423类G3423ID类G3423名称客房价G7696拼房价G7696G2499超额定数职员G1461G5699职员ID民族姓名性别职位A0A2A3A4A5A6A7A8A9A10A11A12A13A14A15A16A174酒店管理系统总体G40R图如图2G174所示A18A19A20A38A39A40A41A42A43A44A45A31A32A33A182G172G173数据库逻辑结构设计通过G8181G3371图分析G2499G1209知道,此系统由8个图表组G6116,具体图表如G991职员资料表中包括职员ID,姓名,职位,性别,籍贯,G5192龄,民族,健康状况,婚姻状况,省份证号,家庭住址,家庭G11017话,G3803注等等详细情况如表2G175所示A46A47A48A49A22A23A37A26A27A28A50A51A52A53A54A48A52A53A27A55A52A53A56A57A52A53职员用户会员酒店管理入住拥有会员G1461G5699拥有客房价G7696属于客房拥有G8111111G81G8111G811A0A2A3A4A5A6A7A8A9A10A11A12A13A14A15A16A175A58A59A52A53A60A61A22A46A62A63A52A53A64A65A66A67A52A53A68A69A66A67A52A53A70A71A72A73A22A46A74A75A76A77A52A53A74A75A78A79A22A46A80A81A52A53A82A19A20A83客房类G3423表中包括类G3423ID,类G3423名称,客房价G7696,拼房价G7696,G2499超额定数，G7171否能拼房，G3803注等。详细情况如表2G176A46A47A48A49A22A23A37A26A37A26A50A51A22A46A37A26A48A49A52A53A35A36A84A85A22A46A86A36A84A85A22A46A87A88A89A90A22A22A46A91A92A93A86A36A91A94A92A80A81A52A53A82A19A20A95客房资料表中包括客房ID,类G3423ID,类G3423名称,楼层编号,额定人数,固有床数,客房状态,客房描G17860等。A46A47A48A49A22A23A37A26A35A36A50A51A52A53A37A26A50A51A52A53A37A26A48A49A52A53A96A97A98A73A22A46A89A90A99A22A22A46A100A101A102A22A52A53A35A36A66A103A52A53A35A36A104A105A52A53A82A19A20A106A0A2A3A4A5A6A7A8A9A10A11A12A13A14A15A16A1762G172G174数据库连接说明酒店管理系统G7171G980个要G8726连贯性很强的系统，所G1209G7693据G990面的G4557数据库系统的概念G8181G3423的设计，我们能G7693据表里的主键，连接G1998各个表中的关系和分类，这样才G13485我们做G991面的系统，每个主键，还有每个外主键，都G7171数据库的关键，必G20047做个关系明G11842，这样系统才能明了G9177G7236，数据库关系图如G991A18A19A20A107A82A108A109A110A111A43A0A2A3A4A5A6A7A8A9A10A11A12A13A14A15A16A1772G173设计窗体和报表通过G1209G990G8181G3371和G40R图G2499知这个窗体G7171由基G7424资料、消费结帐、G16772G5417查询、用户管理、G17876G1998系统5部分组G6116，而基G7424资料G2460包括职员资料管理,客房资料管理,客房类G3423管理,会员资料管理,而消费结帐G2460包括G20056定G16772G5417管理,入住G16772G5417管理,消费明细管理,消费结帐管理,所G1209G11343G19482窗体如图所示A18A19A20A112A113A114A115A116系统主体窗体G7171系统中G2819G980G980个G13864系所有窗体的窗体，由基G7424资料，消费结帐，G16772G5417查询，用户管理，G17876G1998系统，所组G6116。系统G17828用了很多G12628单G1363用的SQLG16833G2489，G7171主窗体G7368G2164实用，G13666G16278。G3324功能G17828用状况中，系统有很G20652的G12295定性，能G3827G12295定的G4448G6116酒店的所有G7097G5132管理，和酒店的G7044G13781职工G17839G15904G2524理的G4445G6502，G4557职员的G1461G5699G980目了然，主窗体G7171用现G3324G4557G16280G14551的设计G16282图设计G4448G6116的，能G3827G9397G17287酒店的各种数据G19668要，如图3G17G19所示A0A2A3A4A5A6A7A8A9A10A11A12A13A14A15A16A178A18A34A20A117A118A119A120A121A122A123职员G1461G5699查询窗体G2499通过职员IDG4557职员G17839G15904详细G1461G5699的查询，通过G2031G5326G980个G6365编号查G6226的查询，G1889G1209其G1328为数据G7481G9316G2031G5326G980个职员G1461G5699查询窗体。如图2G17G28所示A124A125A126A127A128A129A130A131A132A133A134A135A136A137A138A139A140A141A142A143A144A145A146A147A148A149A150A151A1529G20056定G16772G5417G1461G5699G6365G20056定姓名,G20056G6922G18341额，G20056定G7114间，G7481G4557G20056定人详细G16772G17745。通过G5326G12447G980个G6365G20056定G16772G5417G1461G5699查询的查询G1328为数据G7481G9316G4557其G17839G15904窗体的设计。如图2G171G19所示A124A125A126A153A154A155A156A157A158A159A160A121查询客房类G3423查询G7171通过类G3423名称和客房价G7696，详细的G6226G1998G7171否用G12366房，和酒店的用房状况。如图3G171所示A124A125A126A125A161A162A163A164A134A135A160A121A136A137A138A139A140A141A142A143A144A145A146A147A148A149A150A151A15210消费明细报表G2499G1209很G9177G7236的G7186示G1998，G1182G3837客人G3324酒店里的消费情况和详细费用情况，和G2164G7393务情况，G1209及G980G3837的明细，如图3G172所示A124A125A126A165A166A167A168A131A169A1702G174设计窗体和报表G8181G3371主要代码G7424课设所用代码，基G7424为通用代码，为实现各个组件连接G17227G11540G18337要G1328用，G11343G19482窗口G7171系统的窗口，代码必G20047G4448G2904和G1363用，代码如G991OG83G87G76G82G81CG82G80G83G68G85G72DG68G87G68G69G68G86G72G51G88G69G79G76G70G41G88G81G70G87G76G82G81G82G83G72G81G85G72G70G82G85G71G86G87G851AG86SG87G85G76G81G74,G85G72G70G82G85G71AG86ADODBG17RG72G70G82G85G71G86G72G87G10G2031G5326G980个查询，G6238G12538G2524G86G87G851中的SQLG16833G2489的G16772G5417G19610G6183G5332到G85G72G70G82G85G71中G10为G16772G5417G19610G85G72G70G82G85G71分G18209G12366间SG72G87G85G72G70G82G85G71G32NG72G90ADODBG17RG72G70G82G85G71G86G72G87G10G1363用G7424数据库的连接G6183G5332G16772G5417G19610G85G72G70G82G85G71G17OG83G72G81G86G87G851,CG88G85G85G72G81G87G51G85G82G77G72G70G87G17CG82G81G81G72G70G87G76G82G81,G68G71OG83G72G81G46G72G92G86G72G87,G68G71LG82G70G78OG83G87G76G80G76G86G87G76G70G40G81G71G41G88G81G70G87G76G82G81G51G85G76G89G68G87G72SG88G69G73G82G85G80G66G82G83G72G81CG68G81G70G72G79AG86IG81G87G72G74G72G85G10设G13634G6183G5332窗体G7114的属性A136A137A138A139A140A141A142A143A144A145A146A147A148A149A150A151A15211G70G80G71G72G81G87G72G85G17G40G81G68G69G79G72G71G32G41G68G79G86G72G41G82G85G80G17G46G72G92G51G85G72G89G76G72G90G32TG85G88G72G40G81G71SG88G69G51G85G76G89G68G87G72SG88G69G2474消G66CG79G76G70G78OG81G40G85G85G82G85GG82TG82G40G85G85G66G2474消G66CG79G76G70G78DG82CG80G71G17QG88G76G87G40G91G76G87G66G2474消G66CG79G76G70G78G40G91G76G87SG88G69G40G85G85G66G2474消G66CG79G76G70G78MG86G74BG82G91G40G85G85G17DG72G86G70G85G76G83G87G76G82G81RG72G86G88G80G72G40G91G76G87G66G2474消G66CG79G76G70G78G40G81G71SG88G69G51G85G76G89G68G87G72SG88G69G11842定G66CG79G76G70G78DG76G80G88G86G72G85IDAG86IG81G87G72G74G72G85IG73IG86NG88G79G79用户名G32G41G68G79G86G72TG75G72G81IG73DLG82G82G78G88G83G5G62G4506码G64G5,G5用户G5,G5G62用户名G64G32G5G5G5G9用户名G9G5G5G5G5G32G4506码TG75G72G81G10G88G86G72G85IDG32DLG82G82G78G88G83G5G62G76G71G64G5,G5系统用户G5,G5G62用户名G64G32G5G5G5G9G70G82G80用户G9G5G5G5G5DG82CG80G71G17CG79G82G86G72G10DG82CG80G71G17OG83G72G81G41G82G85G80G5主界面G5G10G41G82G85G80G66主界面G17UG86G72G85G32G88G86G72G85IDG40G79G86G72G4506码G32G5G5G4506码G17SG72G87G41G82G70G88G86MG86G74BG82G91G5G4506码G19181G16835G701G5,G89G69CG85G76G87G76G70G68G79G40G81G71IG73G40G81G71IG73G40G81G71SG88G69查询职员资料代码如G991OG83G87G76G82G81CG82G80G83G68G85G72DG68G87G68G69G68G86G72G51G85G76G89G68G87G72SG88G69查询G66CG79G76G70G78A136A137A138A139A140A141A142A143A144A145A146A147A148A149A150A151A15212OG81G40G85G85G82G85GG82TG82G40G85G85G66查询G66CG79G76G70G78MG72G4G62查询职员资料G4388窗体G64G17RG72G84G88G72G85G92G40G91G76G87G66查询G66CG79G76G70G78G40G91G76G87SG88G69G40G85G85G66查询G66CG79G76G70G78MG86G74BG82G91G40G85G85G17DG72G86G70G85G76G83G87G76G82G81RG72G86G88G80G72G40G91G76G87G66查询G66CG79G76G70G78G40G81G71SG88G69G51G85G76G89G68G87G72SG88G69关G19393G66CG79G76G70G78OG81G40G85G85G82G85GG82TG82G40G85G85G66关G19393G66CG79G76G70G78DG82CG80G71G17CG79G82G86G72G40G91G76G87G66关G19393G66CG79G76G70G78G40G91G76G87SG88G69G40G85G85G66关G19393G66CG79G76G70G78MG86G74BG82G91G40G85G85G17DG72G86G70G85G76G83G87G76G82G81RG72G86G88G80G72G40G91G76G87G66关G19393G66CG79G76G70G78G40G81G71SG88G69G20056定G16772G5417管理代码如G991OG83G87G76G82G81CG82G80G83G68G85G72DG68G87G68G69G68G86G72G51G85G76G89G68G87G72SG88G69G20056定IDG66DG69G79CG79G76G70G78CG68G81G70G72G79AG86IG81G87G72G74G72G85OG81G40G85G85G82G85GG82TG82G40G85G85G66G20056定IDG66DG69G79CG79G76G70G78G10G6238G4388窗体中G5415G2081G16772G5417G1552G17183G1116主窗体G4557G5224的文G7424G7706G1881G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62G20056定IDG64G32MG72G4G62G20056定IDG64G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62客房IDG64G32MG72G4G62客房IDG64G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62类G3423IDG64G32MG72G4G62类G3423IDG64G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62G20056定人名G64G32MG72G4G62G20056定人名G64G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62G20056定人数G64G32MG72G4G62G20056定人数G64G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62类G3423名称G64G32MG72G4G62类G3423名称G64G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62G20056G6922G18341额G64G32MG72G4G62G20056G6922G18341额G64G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62G16772G5417人员G64G32MG72G4G62G16772G5417人员G64A136A137A138A139A140A141A142A143A144A145A146A147A148A149A150A151A15213G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62客房价G7696G64G32MG72G4G62客房价G7696G64G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62G6281店G7114间G64G32MG72G4G62G6281店G7114间G64G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62G20056定G7114间G64G32MG72G4G62G20056定G7114间G64G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62G13864系方式1G64G32MG72G4G62G13864系方式1G64G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62G13864系方式2G64G32MG72G4G62G13864系方式2G64G41G82G85G80G86G4G62G20056定G16772G5417管理G64G4G62G3803注G64G32MG72G4G62G3803注G64G40G91G76G87G66G20056定IDG66DG69G79CG79G76G70G78G40G91G76G87SG88G69G40G85G85G66G20056定IDG66DG69G79CG79G76G70G78MG86G74BG82G91G40G85G85G17DG72G86G70G85G76G83G87G76G82G81RG72G86G88G80G72G40G91G76G87G66G20056定IDG66DG69G79CG79G76G70G78G40G81G71SG88G69其G1194代码G3835G14280相G2528，这样G4613G4448G6116了酒店管理系统的G2058G1328。G3324工具G2563G2172中设G13634G14270G2172G2563G2172切换面板，G2499G1209G3324G6183G5332G7114G6365住SG75G76G73G87G17839入设计界面。A136A137A138A139A140A141A142A143A144A145A146A147A148A149A150A151A15214第3章课程设计总结数据库课程设计和实G20576都结G7475了，G3324这段G7114间我学到了很多知识。通过这G8437的课程设计，G1363我G3698G2164了G4557数据库基G7424概念的理G16311，G6564G20652G4557知识的理G16311和G5224用能G2159，G5194G1000G4557数据库的G5224用都有了G7368G9157的了G16311，G1363我的数据库编写G8712G5191G2460有了明G7186的G6564G20652。G3324G58INDOG58S的G10627G3671中，用ACCG40SS和VISUALBASIC代码构G5326G980个库G4396管理系统。G16765我了G16311到了G3324实G19481的G10627G3671G991编写数据库的G5224用。我做的课设题目G7171酒店管理系统，G3324做课设的过程G5415中，我G1817分G17828用我们所学的知识，G5415然其中G13955定有不G6038G6122G13785G6089G6038的问题，所有G4613G2447图G1082G20314查G11487相关的资料，G990课G7114G1075G2684询了G13781G5084G2528学，G7380G2530问题G1075都G17826G2007而G16311了。G5332G3999的G11343G19482窗口,我们G17947到了不会写代码的问题,这个G11343G19482窗口G7171G980个有用户名,有G4506码的界面,G5415G1332G17885G6333G980个用户名,G4439有相G5224的口G1208,口G1208G8503G11842才G2499G1209G17839入这G7171G980个要有G2476G18339G7481实现的过程,G5415然G1075要G4557G5224的数据窗口其实,这个问题不会写代码G8821有关系的,我们G2499G1209G1186数据窗口中的G2476G18339设G13634中G6226到SQLG16833G2489,这样G4613G16311G1927了问题。我们的G11343G19482窗口G12907G11065的G4448G6116了G3324G5326G12447职工资料数据G9316G7114,我们G2469现了G980个这样的问题,G4613G7171性别G980栏G2499G1209G3647写G19512G11019,女G1209外的G4395,我们G19668要G980个约G7475,G2499G7171G3324约G7475G16833G2489里,我们有G16833G8873G19181G16835,弄了半G3837还G7171G8821有弄G6038,G2530G7481问别人知道了那G7171由于G8821有弄G9177楚G980些G12538号G7171G5224该G3324英G16833还G7171中文条件G991写G1998,PB的G12538号都G7171G3324英G16833的条件G991实现的我们G980般设主键的G7114候都G7171设G980个，这个主键G3324数据G9316中G7171不能G18337复的。由于G14270己的分析设计和程序经G20576不G17287,该系统设计和实现过程中,还有许多G8821有G4448G2904的G3332方,比如数据冗余,文档组织不G2524理,帮助文档G8821有编写,用户界面设计不G3827G13666G16278,异G5132G1998G19181处理比较差等多方面问题,这些都有待G17839G980步G4448G2904和G6564G20652。总的G7481说，数据库的实G20576G7171我们G990G3835学G1209G7481G17947到的G7380G3835的课题，G4439不像G1209G2081的课题很G4493易G4613G4448G6116，G4439G19668要设计人有G17287G3827的耐心，超强的学G1076能G2159和坐的住的心态。所G1209，这G8437实G20576中，我的许多毛病都有了改G2904。这些都不G7171主要的，G18337要的G7171我们G3324这G8437实G20576A136A137A138A139A140A141A142A143A144A145A146A147A148A149A150A151A15215中，G1209及G5191G7114G990课的G7114候，G1186G13781G5084那里学到了很多做人做事的道理，这些G18341玉良言将G4557我们终身受用。A136