【酒店管理培训】酒店《数据库管理》培训活动纲要.docVIP

A hotel XXX大酒店 TRAINING ACTIVITY OUTLINE 培训活动纲要 Task 任务：Database Management 数据库管理 Code 序号： OH-SM-MC-A201 Objectives目的：At the end of this session, each trainee will be able to fully understand contact management by using ACCESSS. 在此培训结束后，每一个学员都要学会使用ACCESS管理联系人数据库。 Standard标准： See Attached SP. 参见后附标准与程序。 Resources培训器材： Whiteboard, Mark Pen and Projector. 白板， 马克笔、电脑和投影仪。 Method 培训方式 Training Steps 培训步骤 Time 时间 Lecture 讲座式 A brief introduction of database 简要介绍数据库 Ask trainee awareness of database. 询问学员对数据库的了解。 When we handle a great number of items, we need a system to categorize them for easy reference, like we use Cardex for business cards, paper file for documents, albums for photos. 处理大批数据时需要一个系统分类以方便使用，就好象我们使用名片盒来装名片，用文件夹来存储文件，用相册来装相片。 The database is something that can help us with the library. 数据库就可以在处理大批数据时发挥作用。 It is like Excel, with rows and columns. But it has different format, which is called FORM. 它就象是EXCEL，也有行列；但是可以做成 不同的格式，称为表单。我们可以在单元 格里输入数据。 Another type of form is called subform. It is attached to each record in the form regarding information of this record. For example, a subform may contain all interaction report of one contact (record) in a form. 另一类表单称为子表单。它依附于表单中的每一个条目，记录该条目的内容。例如，一个子表单记录着另一个表单中一个联系人(条目)所有的交往的报告。 Query is a type of form that may combine data from different forms and tables. By using query, we can build up relations among forms. 数据表单是一种能从不同表单中吸收数据的表格。使用数据表单可以在多个表单中建立起相互关联。 Demonstrate the database to trainee the structure of the database. 向学员展示数据库的结构组成。 It contains two forms, two queries, one table and one report: CONTACTS: This form is about details of the contact person and his company. CALLS Sub-Form: This form is about detail contents of interactions between the contacts and hotel MC department. Trace Query: This query is used to for future follow up. CONTACTS-CHN query: This query is used to generate