(2012年上学期用)大学计算机基础(文)(二)本科实验报告册电子稿

PAGE实验报告册学生姓名学号系、年级专业指导教师教务处印制PAGEI目录实验一Access环境及数据库的创建实验二建立与使用数据表实验三数据查询实验四设计窗体实验五设计报表实验六宏的使用实验七利用VBA进行数据库应用程序设计PAGE20实验一Access环境及数据库的创建实验类型：验证性实验教师评分：实验时间：_________________实验地点：_________________一、实验目的与要求1.掌握启动和退出Access系统的常用方法。2.熟悉Access的主窗口界面，并会用不同的方法关闭和显示任务窗格。3.会设置默认磁盘目录。4.会用不同的方法建立空数据库，会利用向导建立数据库。5.会用不同的方法打开和关闭数据库二、实验环境1.硬件环境：奔ⅣPC。2.软件环境：WindowsXP操作系统，Access2003。三、实验内容（1）启动Access2003。（2）显示和关闭任务窗格。（3）在D盘目录下创建一个名为“姓名LX”的文件夹（“姓名”处写上自己的姓名），然后设置“姓名LX”目录为默认磁盘目录。（4）在“姓名LX”目录中建立一个名为“教学管理”的空数据库。（5）利用数据库的“讲座管理”模板，在“姓名LX”目录中建立一个名为“计算机系讲座管理的数据库”。（6）打开和关闭“教学管理”数据库。（7）退出Access2003。具体操作步骤为：________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________四、实验体会____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

实验二建立与使用数据表实验类型：验证性实验教师评分：实验时间：_________________实验地点：_________________一、实验目的与要求1．以“教学管理”数据库为练习实例，掌握用向导、设计视图以及数据表视图方法创建表。2．掌握设置主键和索引的设置方法。3．掌握字段的格式、字段大小、输入掩码、标题、小数位数、默认值、有效性规则、有效性文本以及必填字段等属性的设置方法。4．掌握修改表结构的方法；5．掌握表间关系的设置与编辑方法。6．掌握使用查询向导创建查询列表值的方法。7．掌握预览和打印表的方法。8．以“教学管理”数据库为练习实例，掌握数据记录的输入、修改和删除的方法。9．掌握表的格式的设置方法。10．掌握记录的排序和筛选。11．掌握表的重命名、删除和复制方法。12．掌握删除、插入子数据表及显示相关记录的方法。13．掌握对数据的导入、导出和链接的方法。二、实验环境1.硬件环境：奔ⅣPC。2.软件环境：WindowsXP操作系统，Access2003。三、实验内容实验内容请参见教材P64～P66；P87～P88。具体操作步骤为：_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________四、实验体会_______________________________________________________________________________________________________________________________________________________________________________________________________________

实验三数据查询实验类型：综合性实验教师评分：实验时间：_________________实验地点：_________________一、实验目的与要求1．以“教学管理”数据库为练习实例，掌握创建选择、参数、交叉表和操作查询和创建方法。2．掌握在查询中使用条件、执行计算的方法。3．能利用SQL实现查询。二、实验环境1.硬件环境：奔ⅣPC。2.软件环境：WindowsXP操作系统，Access2003。三、实验内容实验内容请参见教材P129～P130。具体操作步骤为：_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________四、实验体会_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

实验四设计窗体实验类型：综合性实验教师评分：实验时间：_________________实验地点：_________________一、实验目的与要求1．以“教学管理”数据库为练习实例，掌握创建和设计各种窗体的方法。2．掌握在窗体中放置常用控件的方法，能使用窗体进行数据处理。二、实验环境1.硬件环境：奔ⅣPC。2.软件环境：WindowsXP操作系统，Access2003。三、实验内容实验内容请参见教材P165～P166。具体操作步骤为：________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________任务2：实验内容请参见教材P190。具体操作步骤为：_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________四、实验体会__________________________________________________________________________________________________________________________________________

实验五设计报表实验类型：综合性实验教师评分：实验时间：_________________实验地点：_________________一、实验目的与要求1．掌握创建和设计各种报表的方法。2．熟悉在报表中使用常用控件的方法，能使用报表进行数据统计、分组和排序。二、实验环境1.硬件环境：奔ⅣPC。2.软件环境：WindowsXP操作系统，Access2003。三、实验内容实验内容请参见教材P190。具体操作步骤为：_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________四、实验体会______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

实验六宏的使用实验类型：设计研究性实验教师评分：实验时间：_________________实验地点：_________________一、实验目的与要求以“教学管理”数据库为练习实例，掌握创建宏和宏组以及运行和调试宏的方法。二、实验环境1.硬件环境：奔ⅣPC。2.软件环境：WindowsXP操作系统，Access2003。三、实验内容实验内容请参见教材P205～P207。具体操作步骤为：___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________