第2章 案例实践-Access多表操作.pptVIP

第二章 案例实践Microsoft Access数据库多表操作 学习目标 结合汽车经销商数据库WMCRM.mdb实例 举例说明数据库表修改问题 创建表之间的关联 创建多表操作的表单窗口 创建多表操作的报表 数据库表修改问题 当数据库表包含了多个主题数据，容易出现修改问题 WMCRM-Combined-Data.mdb数据库 CONTACT 数据 CUSTOMER_CONTACT 表 Customer-Contact 表单数据输入 Wallingford Motors 顾客联系报表 更新Email 地址 更新过的Wallingford Motors顾客联系报表 多表操作的WMCRM 数据库模式 CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP,Phone, Fax, Email) CONTACT (ContactID, CustomerID, Data, Type, Remarks) CustomerID in CONTACT must exist in CustomerID in CUSTOMER CONTACT 表列特征 设置日期格式 打开关联窗口 在关联窗口中加表 在关联窗口中的表对象 编辑关联的对话框 已完成的关联 CONTACT 表中的数据 CUSTOMER 和CONTACT 数据的表单 Wallingford Motors 顾客联系报表 General interest in a Gaea. Phone 8/15/2005 5 Sent a standard follow-up message. Email 8/10/2005 4 Sent a standard follow-up message. Email 8/3/2005 3 Talked up to a HiLuxury. Customer bought one. Meeting 8/2/2005 4 Bought a SUHi. Meeting 7/27/2005 3 Interested in a HiStandard, set up an appointment. Phone 7/27/2005 4 Sent a standard follow-up message. Email 7/21/2005 1 Interested in a SUHi, set up an appointment. Phone 7/19/2005 3 Bought a HiStandard. Meeting 7/14/2005 1 Set up an appointment. Phone 7/12/2005 1 Sent general information. Email 7/7/2005 1 General interest in a Gaea. Phone 7/7/2005 1 Remarks Type Date CustomerID Au: Update the year in the Date column to 2006? or even later (e.g., 2007)? Make this a global change, as appropriate? Updating these dates will affect countless other figures in the rest of the book. While in principle I agree with the idea, in practice I think it would require too much work at this point. While older dates (2002, 2003, etc.) should be updated, I suggest we live with 2005 in this case. Au: Note how copy is cut off in the Email and Remark columns. OK? YES - This is a lage, wide table, and the Figure needs to show general content, not all details. All fields from the CUSTOMER_CONTACT table appear on the form Form browsing buttons All contact data for each customer is grouped together and sorted by