MIME-version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_0076_01C29953.BE473C30"; type="text/html" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 This is a multi-part message in MIME format. ------=_NextPart_000_0076_01C29953.BE473C30 Content-Type: text/html; Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/Users/LENOVO~1/AppData/Local/Temp/~tmp1459909992454789222.TMP.html

Access数据库应用进阶

基本信息
  2020/2/20 0:00:00~2020/2/21 0:00:00

  上海市 上海市

  

市场价2000.00

会员价2000.00 

 

课程介绍

培训对象

课程适合已能熟练使用 Access ,或学习过《 Access 数据库应用基础》课程的各类人员

课程大纲

数据表高级设计
数据表结构的详细设计;设置数据表字段的各种属性;完善数据表设计的主要技术,即主关键字,创建字段间的约束关系和输入掩码


数据关系
介绍Access数据关系重要性;创建Access数据关系的方法和实践;实现一对一,一对多,多对多的数据表关系;理解,创建和修改“数据关系实施参照完整性”;在查询中创建内连接和外连接


高级查询
创建多个数据表的查询;应用查询向导查找重复记录;应用查询向导查找不匹配记录;创建交叉表查询分析数据;创建各类动作查询批量修改数据表数据;应用特殊查询技术创建数据定义查询;应用特殊查询技术创建联合查询;主要查询属性和查询技术的优化


窗体设计
窗体的详细设计和各种操作;窗体各种设计工具的应用;各种控件属性的设置和应用;创建窗体中控件事件行为及计算字段等


报表设计
报表的详细设计和各种操作;报表的自定义设计;调整报表设计区域和创建汇总;用各种工具修饰报表;创建按前缀,日期等分组的报表
 

 

讲师简介 ()

 

汇款信息

公司名称:北京中人网信息咨询股份有限公司

  行:招商银行北京分行大屯路支行

    号:866180508610001

    号:976

 

联系我们

客服热线:010-52725400-800

客服传真:010-52725273

客服邮箱:exposerv@chinahrd.net

------=_NextPart_000_0076_01C29953.BE473C30 Content-Type: application/octet-stream; Content-Transfer-Encoding: base64 Content-Location: file:///C:/Users/LENOVO~1/AppData/Local/Temp/~tmp1459909992454789222.files/~tmp1459909992454789222142.png iVBORw0KGgoAAAANSUhEUgAAAi0AAAACCAYAAACUjOy4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAAOxAAADsQBlSsOGwAAACpJREFUWIXtySEOAAAIAzH4/6PBYPGQ9MySNUKSJOlBOVvLzxhjjDF2 whqZilAB0jq9QQAAAABJRU5ErkJggg== ------=_NextPart_000_0076_01C29953.BE473C30 Content-Type: application/octet-stream; Content-Transfer-Encoding: base64 Content-Location: file:///C:/Users/LENOVO~1/AppData/Local/Temp/~tmp1459909992454789222.files/~tmp145990999245478922215.png iVBORw0KGgoAAAANSUhEUgAAAi0AAAACCAYAAACUjOy4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAAOxAAADsQBlSsOGwAAACpJREFUWIXtySEOAAAIAzH4/6PBYPGQ9MySNUKSJOlBOVvLzxhjjDF2 whqZilAB0jq9QQAAAABJRU5ErkJggg== ------=_NextPart_000_0076_01C29953.BE473C30 Content-Type: application/octet-stream; Content-Transfer-Encoding: base64 Content-Location: file:///C:/Users/LENOVO~1/AppData/Local/Temp/~tmp1459909992454789222.files/~tmp1459909992454789222164.png iVBORw0KGgoAAAANSUhEUgAAAi0AAAACCAYAAACUjOy4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAAOxAAADsQBlSsOGwAAACpJREFUWIXtySEOAAAIAzH4/6PBYPGQ9MySNUKSJOlBOVvLzxhjjDF2 whqZilAB0jq9QQAAAABJRU5ErkJggg== ------=_NextPart_000_0076_01C29953.BE473C30 Content-Type: application/octet-stream; Content-Transfer-Encoding: base64 Content-Location: file:///C:/Users/LENOVO~1/AppData/Local/Temp/~tmp1459909992454789222.files/~tmp1459909992454789222204.png iVBORw0KGgoAAAANSUhEUgAAAi0AAAACCAYAAACUjOy4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAAOxAAADsQBlSsOGwAAACpJREFUWIXtySEOAAAIAzH4/6PBYPGQ9MySNUKSJOlBOVvLzxhjjDF2 whqZilAB0jq9QQAAAABJRU5ErkJggg== ------=_NextPart_000_0076_01C29953.BE473C30 Content-Type: application/octet-stream; Content-Transfer-Encoding: base64 Content-Location: file:///C:/Users/LENOVO~1/AppData/Local/Temp/~tmp1459909992454789222.files/~tmp1459909992454789222286.png iVBORw0KGgoAAAANSUhEUgAAAi0AAAACCAYAAACUjOy4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAAOxAAADsQBlSsOGwAAACpJREFUWIXtySEOAAAIAzH4/6PBYPGQ9MySNUKSJOlBOVvLzxhjjDF2 whqZilAB0jq9QQAAAABJRU5ErkJggg== ------=_NextPart_000_0076_01C29953.BE473C30--