大学计算机基础
实 验 报 告 册
班级、 学号:
姓 名:
辅 导 教 师:
中北大学电子与计算机科学学院
说明:
1. 实验环境
硬件:微型计算机
软件:Visual C++ 6.0
2. 实验学时安排:
实验报告一
实验报告二
实验报告三
实验报告四
实验报告五
实验报告册
学 生 姓 名
学 号
系、年级专业
指 导 教 师
教务处印制
目 录
实验一 Access环境及数据库的创建
实验二 建立与使用数据表
实验三 数据查询
实验四 设计窗体
实验五 设计报表
实验六 宏的使用
实验七 利用VBA进行数据库应用程序设计
实验一 Access环境及数据库的创建
实验类型:验证性实验 教师评分 :
实验时间:_________________
实验地点:_________________
一、实验目的与要求
1. 掌握启动和退出Access系统的常用方法。
2. 熟悉Access的主窗口界面,并会用不同的方法关闭和显示任务窗格。
3. 会设置默认磁盘目录。
4. 会用不同的方法建立空数据库,会利用向导建立数据库。
5. 会用不同的方法打开和关闭数据库
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
(1)启动Access 2003。
(2)显示和关闭任务窗格。
(3)在D盘目录下创建一个名为“姓名LX”的文件夹(“姓名”处写上自己的姓名),然后设置“姓名LX”目录为默认磁盘目录。
(4)在“姓名LX”目录中建立一个名为“教学管理”的空数据库。
(5)利用数据库的“讲座管理”模板,在“姓名LX”目录中建立一个名为“计算机系讲座管理的数据库”。
(6)打开和关闭“教学管理”数据库。
(7)退出Access 2003。
具体操作步骤为:
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
四、实验体会
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
实验二 建立与使用数据表
实验类型:验证性实验 教师评分 :
实验时间:_________________
实验地点:_________________
一、实验目的与要求
1.以“教学管理”数据库为练习实例,掌握用向导、设计视图以及数据表视图方法创建表。
2.掌握设置主键和索引的设置方法。
3.掌握字段的格式、字段大小、输入掩码、标题、小数位数、默认值、有效性规则、有效性文本以及必填字段等属性的设置方法。
4.掌握修改表结构的方法;
5.掌握表间关系的设置与编辑方法。
6.掌握使用查询向导创建查询列表值的方法。
7.掌握预览和打印表的方法。
8.以“教学管理”数据库为练习实例,掌握数据记录的输入、修改和删除的方法。
9.掌握表的格式的设置方法。
10.掌握记录的排序和筛选。
11.掌握表的重命名、删除和复制方法。
12.掌握删除、插入子数据表及显示相关记录的方法。
13.掌握对数据的导入、导出和链接的方法。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
实验内容请参见教材P64~P66;P87~P88。
具体操作步骤为:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
四、实验体会
_______________________________________________________________________________________________________________________________________________________________________________________________________________
实验三 数据查询
实验类型:综合性实验 教师评分 :
实验时间:_________________
实验地点:_________________
一、实验目的与要求
1.以“教学管理”数据库为练习实例,掌握创建选择、参数、交叉表和操作查询和创建方法。
2.掌握在查询中使用条件、执行计算的方法。
3.能利用SQL实现查询。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
实验内容请参见教材P129~P130。
具体操作步骤为:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
四、实验体会
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
实验四 设计窗体
实验类型:综合性实验 教师评分 :
实验时间:_________________
实验地点:_________________
一、实验目的与要求
1.以“教学管理”数据库为练习实例,掌握创建和设计各种窗体的方法。
2.掌握在窗体中放置常用控件的方法,能使用窗体进行数据处理。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
实验内容请参见教材P165~P166。
具体操作步骤为:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________任务2:实验内容请参见教材P190。
具体操作步骤为:
__________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
四、实验体会
__________________________________________________________________________________________________________________________________________
实验五 设计报表
实验类型:综合性实验 教师评分 :
实验时间:_________________
实验地点:_________________
一、实验目的与要求
1.掌握创建和设计各种报表的方法。
2.熟悉在报表中使用常用控件的方法,能使用报表进行数据统计、分组和排序。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
实验内容请参见教材P190。
具体操作步骤为:
__________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
四、实验体会
__________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________
实验六 宏的使用
实验类型:设计研究性实验 教师评分 :
实验时间:_________________
实验地点:_________________
一、实验目的与要求
以“教学管理”数据库为练习实例,掌握创建宏和宏组以及运行和调试宏的方法。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
实验内容请参见教材P205~P207。
具体操作步骤为:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
四、实验体会
_____________________________________________________________________ __________________________________________________________________________________________________________________________________________
实验七 利用VBA进行数据库应用程序设计
实验类型:设计研究性实验 教师评分 :
实验时间:_________________
实验地点:_________________
一、实验目的与要求:
以“教学管理”数据库为练习实例,掌握创建过程的方法,掌握简单的事件过程程序的编写方法,掌握VBA程序的调试方法以及对程序中的错误的处理方法
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
实验内容请参见教材P272。
具体操作步骤及程序代码为:
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
_____________________________________________________________________
__________________________________________________________________________________________________________________________________________
_____________________________________________________________________
_____________________________________________________________________
四、实验体会
__________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________
上机注意事项
1. 爱护实验设备。
2. 听从老师安排,注意机房秩序。
3. 注意卫生,保持机房清洁。
4. 保持机房安静,不得大声喧哗。
5. 上机前预习好实验内容。
6. 实验结束后必须按时完成实验报告并及时交给指导老师检查。
大学计算机基础课程实验报告手册学院年级专业姓名学号2220xx319xx20xx任课教师上机地点以上由学生填写实验教师签字西南大学…
大学计算机基础教学班级课程教师实验报告学号姓名实验辅导教师西南交通大学20xx年9月大学计算机基础实验报告实验一微机基本操作与上网…
电子信息工程学系实验报告适用于计算机课程课程名称计算机基础训练实验项目名称Word基本操作实验时间班级姓名学号实验目的1掌握文档页…
大学计算机基础课程实验报告第二章中文操作系统WindowsXP思考题1将一个文件删除掉然后清空回收站该文件还可以恢复到原来位置吗答…
习题及实验一第一部分习题一简答题略第二部分选择题答案p31C2A3B4CC5BB6A7ABB8BD9D10C注71应为101001…
《大学计算机基础》课程实验报告姓名:天桥卧龙专业:XXXX班级:XXXX级1班学号:XXXXXX第二章中文操作系统WindowsX…
大学计算机基础课程实验报告第二章中文操作系统WindowsXP思考题1将一个文件删除掉然后清空回收站该文件还可以恢复到原来位置吗答…
大学计算机基础课程实验报告手册学院年级专业姓名学号2220xx319xx20xx任课教师上机地点以上由学生填写实验教师签字西南大学…
大学计算机基础教学班级课程教师实验报告学号姓名实验辅导教师西南交通大学20xx年9月大学计算机基础实验报告实验一微机基本操作与上网…
《大学计算机基础》综合性实验实验报告题目:个人简历的制作姓名:陈祥班级:材料1209班学号:20xx26910901指导教师:张翼…