海瑞吉红塔酒店
TRAINING ACTIVITY OUTLINE
培训活动纲
Task 务:Database Management 数库理
Code 序号: OHSMMCA201
Objectives目:At the end of this session each trainee will be able to fully understand contact management by using ACCESSS
培训结束学员学会ACCESS理联系数库
Standard标准: See Attached S&P 参见附标准程序
Resources培训器材: Whiteboard Mark Pen and Projector
白板 马克笔电脑投影仪
Method
培训方式
Training Steps
培训步骤
Time
时间
Lecture
讲座式
1 A brief introduction of database
简介绍数库
Ask trainee awareness of database
询问学员数库解
a 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
处理批数时需系统分类方便象名片盒装名片文件夹存储文件相册装相片
b 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行列做成
格式称表单单元
格里输入数
c 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
5 min
5 分钟
20 min
20 分钟
类表单称子表单附表单中条目记录该条目容例子表单记录着表单中联系(条目)交报告
d 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
a CONTACTS This form is about details of the contact person and his company
b CALLS SubForm This form is about detail contents of interactions between the contacts and hotel MC department
c Trace Query This query is used to for future follow up
d CONTACTSCHN query This query is used to generate Contact Report in Word
e CONTACTCHN table is used to generate letters in Word
f CONTACTBRIEF This report contains the every means of communicating the contact person
1 包含两表单两数表 表格 报表
a CONTACTS: 表单关媒体联系详细信息
b CALLS 表单:表格关公关部理媒体联系间
交接确记录
c TRACE 数表:催
d CONTACTSCHN 数表 WORD中生成会面报告
e CONTACTCHN表格:WORD中生成信件
f CONTACTBRIEF报表:包括联系基联系信息
Required components for the CONTACTS form are
a Chinese Name
b Title
c Department
d Company Name
e Telephone Number
f Fax Number
必须填 写字段名:
35 min
35 分钟
a 中文名
b 头衔
c 部门
d 公司名
e 电话号码
f 传真号码
3 The database will be zipped and backed up twice a week and protected against data loss due to any accidental computer problems 数库周压缩备份两次防电脑障造成数丢失
4 Changes made on the structures of the database are subject to MarCom Manager's approval 修改数库结构必须公关部理许
5 The database will be password secured Access to the database is subject to approval of Director of Sales & marketing and MarCom Manager
数库密码保护数库
营业总监公关部理许
Procedures 程序部分:
1 Update 更新数库 Refer to procedure 1 参程序1
2 Merging with Word Refer to procedure 2
参程序2
3 Trace 进 Refer to procedure 3
参程序3
Trainee Practice 学员练
1 Merging to generate Contact Report
合WORD生成会面报告
2 Generate Label
生成标签
3 Critique 评估
Summary with emphasis on the database structure and merging
回顾总结时重点放数库结构合文件
30 min
30 分钟
20 min
20 分钟
10 min
10 分钟
文档香网(httpswwwxiangdangnet)户传
《香当网》用户分享的内容,不代表《香当网》观点或立场,请自行判断内容的真实性和可靠性!
该内容是文档的文本内容,更好的格式请下载文档