另一类表单称为子表单。它依附于表单中的每一个条目，记录该条目的内容。例如，一个子表单记录着另一个表单中一个联系人(条目)所有的交往的报告。
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.
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.
处理大批数据时需要一个系统分类以方便使用，就好象我们使用名片盒来装名片，用文件夹来存储文件，用相册来装相片。
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.
1.它包含两个表单，两个数据表，一个表格,一个报表:
a.CONTACTS：这个表单是有关媒体和联系人的详细信息
b.CALLS表单：这个表格是关于公关部经理与媒体联系人之间的
交往接确的记录
c.TRACE数据表：用于将来的跟催
d.CONTACTS-CHN数据表:用于在WORD中生成会面报告
e.CONTACT-CHN表格：是用于在WORD中生成信件
c.Trace Query: This query is used to for future follow up.
d.CONTACTS-CHN query: This query is used to generate Contact Report in Word.
e.CONTACT-CHN table is used to generate letters in Word.
必须要填写的字段名为：
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.数据库一周压缩备份两次，以防电脑故障造成数据丢失。
数据表单是一种能从不同表单中吸收数据的表格。使用数据表单可以在多个表单中建立起相互关联。
Demonstrate the database to trainee the structure of the database.
向学员展示数据库的结构组成。
It contains two forms, two queries, one table and one report:
它就象是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.
培训步骤
时间
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.
f.CONTACT-BRIEF报表：包括每个联系人的基本联系信息
Required components for the CONTACTS form are:
a.Chinese Name
b.Title
c.Department
pany Name
e.Telephone Number
f.Fax Number
2.Generate Label
生成标签
3. Critique评估
Summary with emphasis on the database structure and merginቤተ መጻሕፍቲ ባይዱ.
回顾总结时重点放在数据库结构和合并文件上。
5 min
5分钟
20 min
20分钟
35 min
35分钟
30 min
30分钟
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生成会面报告
20 min
20分钟
10 min
10分钟
数据库要使用密码保护。使用数据库要得到
营业总监和公关部经理的许可。
---------------------------------------------------------------------
Procedures程序部分：
1.Update更新数据库- Refer to procedure 1参看程序1
f.CONTACT-BRIEF: This report contains the every means of communicating the contact person.
----------------------------------------------------------------
在此培训结束后，每一个学员都要学会使用ACCESS管理联系人数据库。
Standard标准：See Attached S&P.参见后附标准与程序。
Resources培训器材：Whiteboard, Mark Pen and Projector.
白板，马克笔、电脑和投影仪。
Method
培训方式
Training Steps
a.CONTACTS: This form is about details of the contact person and his company.
b.CALLS Sub-Form: This form is about detail contents of interactions between the contacts and hotel MC department.
The ST. REGIS SHANGHAI
上海瑞吉红塔大酒店
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.