余额统计会员查询使用说明积分统计充值记录消费记录积分兑换会员信息Membershipmanagementsystem会员信息表会员卡号会员姓名手机号码性别生日地址A001女2/10/2019北京A002女3/8/2019上海A003男5/10/2019广州会员信息表入会日期2019/1/182019/1/192019/1/20充值记录表充值日期会员卡号会员姓名手机号码充值金额赠送金额2019/1/18A001300502019/1/19A0025001002019/1/20A003500100消费记录表消费日期会员卡号会员姓名手机号码产品名称数量单价2019/1/20A002001682019/1/20A003002882019/1/20A001001882019/1/21A0020011882019/1/22A002001188产品1产品2产品3产品1产品2消费记录表金额积分68681761768888188188188188000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000积分兑换表兑换日期会员卡号会员姓名手机号码兑换积分兑换奖品2019/2/1A00200400湿巾积分兑换表备注会员积分统计表会员卡号会员姓名手机号码总积分已兑换积分剩余积分A0010088088A0020044440044A003001760176000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000会员余额统计表会员卡号会员姓名手机号码充值总金额赠送总金额已消费金额A001003005088A00200500100444A00300500100176000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000会员余额统计表剩余金额26215642400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000会员查询A001▌会员基本信息：会员卡号会员姓名手机号码A00100生日地址入会日期2/10/2019北京2019/1/18▌充值消费信息：充值总金额赠送总金额已消费金额3005088▌积分兑换信息：总积分已兑换积分剩余积分88088输入查询的卡号:会员查询性别女剩余金额262使用说明各表录入及功能：使用小贴士：1、【会员信息】，按照内容填入2、【充值记录】，录入充值信息即可3、【消费记录】，录入消费信息及积分4、【积分兑换】，输入兑换的卡号及积分5、【积分统计】，自动统计6、【余额统计】，自动统计7、【会员查询】，输入卡号，自动查询表格进行了保护，可自行撤销保护，审阅-撤销工作表保护即可
