大学计算机基础(文)(二)实验报告册电子稿
更新时间:2024-01-30 20:11:01 阅读量: 教育文库 文档下载
实验报告册
学 生 姓 名 学 号 系、年级专业 指 导 教 师
教务处印制
目 录
实验一 Access实验二 实验三 实验四 实验五 实验六 实验七 实验八 实验九 VBA
环境及数据库的创建 建立数据表 使用数据表 数据查询 设计窗体和报表 宏与数据访问页的使用 选择结构语句 循环结构语句 模块 I
实验一 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。
具体操作步骤为:
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ 四、实验体会
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
2
实验二 建立数据表
实验类型:验证性实验 教师评分 : 实验时间:_________________ 实验地点:_________________
一、实验目的与要求
1.以“教学管理”数据库为练习实例,掌握用向导、设计视图以及数据表视图方法创建表。 2.掌握设置主键和索引的设置方法。
3.掌握字段的格式、字段大小、输入掩码、标题、小数位数、默认值、有效性规则、有效性文本以及必填字段等属性的设置方法。 4.掌握修改表结构的方法; 5.掌握表间关系的设置与编辑方法。 6.掌握使用查询向导创建查询列表值的方法。 7.掌握预览和打印表的方法。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
实验内容请参见教材P64~P66。
具体操作步骤为:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________
3
_______________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________
4
__________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________
四、实验体会
__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
5
实验三 使用数据表
实验类型:综合性实验 教师评分 :
实验时间:_________________ 实验地点:_________________
一、实验目的与要求
1.以“教学管理”数据库为练习实例,掌握数据记录的输入、修改和删除的方法。 2.掌握表的格式的设置方法。 3.掌握记录的排序和筛选。
4.掌握表的重命名、删除和复制方法。
5.掌握删除、插入子数据表及显示相关记录的方法。 6.掌握对数据的导入、导出和链接的方法。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
实验内容请参见教材P87~P88。
具体操作步骤为:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
6
_______________________________________________________________________________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ _____________________________________________________________________
7
_______________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________
四、实验体会
__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
8
实验四 数据查询
实验类型:综合性实验 教师评分 :
实验时间:_________________ 实验地点:_________________
一、实验目的与要求
1.以“教学管理”数据库为练习实例,掌握创建选择、参数、交叉表和操作查询和创建方法。
2.掌握在查询中使用条件、执行计算的方法。 3.能利用SQL实现查询。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
实验内容请参见教材P129~P130。
具体操作步骤为:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________
9
__________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________
10
__________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________
四、实验体会
__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
11
实验五 设计窗体和报表
实验类型:综合性实验 教师评分 :
实验时间:_________________ 实验地点:_________________
一、实验目的与要求
1.以“教学管理”数据库为练习实例,掌握创建和设计各种窗体的方法。 2.掌握在窗体中放置常用控件的方法,能使用窗体进行数据处理。 3.掌握创建和设计各种报表的方法。
4.熟悉在报表中使用常用控件的方法,能使用报表进行数据统计、分组和排序。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
任务1:实验内容请参见教材P165~P166。
具体操作步骤为:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________
12
_______________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________
任务2:实验内容请参见教材P190。 具体操作步骤为:
__________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________
13
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ 四、实验体会
__________________________________________________________________________________________________________________________________________
14
实验六 宏与数据访问页的使用
实验类型:综合性实验 教师评分 :
实验时间:_________________ 实验地点:_________________
一、实验目的与要求
1.以“教学管理”数据库为练习实例,掌握创建宏和宏组以及运行和调试宏的方法。 2.掌握创建数据访问页以及使用数据访问页处理数据的方法。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
任务1:实验内容请参见教材P205~P207。
具体操作步骤为:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________
15
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________
任务2:实验内容请参见教材P221~P222。 具体操作步骤为:
__________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ 四、实验体会
_____________________________________________________________________ __________________________________________________________________________________________________________________________________________
16
实验七 选择结构语句
实验类型:设计研究性实验 教师评分 :
实验时间:_________________ 实验地点:_________________
一、实验目的与要求:
1.掌握逻辑表达式的正确书写形式。
2.掌握if条件语句的使用方法,能利用if条件语句解决简单的应用问题。 3.掌握select case语句的使用,能利用select case语句解决简单的应用问题。。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
任务1:
(1)从键盘任意输入两个数,按由小到大的顺序显示。要求输入用InputBox函数,输出用MsgBox语句。
(2)从键盘输入年份,判断该年份是否闰年。判断闰年的条件是年份能被4整除,但不能被100整除;或者能被400整除。要求输入用InputBox函数,输出用MsgBox语句。 具体操作步骤及程序代码为:
_____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________
17
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________
任务2:
(1)编写程序实现分数与等级的转换。分数与等级的对应关系如下:分数>=90时,等级为优秀; 分数在80和90之间时(包括80),等级为良好;分数在70和80之间时(包括70),等级为中等;分数在60和70之间时(包括60),等级为及格;分数小于60时,等级为不及格。要求用两种方法实现。
(2)商场实行购物优惠:购物5000元以上(含5000元,)打8折,2000-5000(含2000元)打85折,1000-2000元(含1000元),打95折,小于1000元,不打折。输入购物价格,计算最终价格。
具体操作步骤及程序代码为:
_____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________
18
_____________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ 四、实验体会
__________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________
19
实验八 循环结构语句
实验类型:设计研究性实验 教师评分 :
实验时间:_________________ 实验地点:_________________
一、实验目的与要求:
1.掌握For循环、Do循环、While循环结构的使用方法。 2.掌握多重循环的使用方法。
3.能够利用各种控制语句解决实际问题。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
(1)显示所有100以内且为7的倍数的数,并求这些数的和。 (2)编制程序,输出1000之内的所有完数。“完数”是指一个数恰好等于它的因子之和,如6的因子为1、2、3,而6=1+2+3,因而6就是完数。
(3)把50元钱分成一元、二元和五元的纸币张数共为20张的分法共有多少种?(注:在兑换中,一元、二元、五元的纸币张数可以为0)。 具体操作步骤及程序代码为:
_____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________
20
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ _____________________________________________________________________ _____________________________________________________________________ 四、实验体会
_____________________________________________________________________
21
实验九 VBA模块
实验类型:设计研究性实验 教师评分 :
实验时间:_________________ 实验地点:_________________
一、实验目的与要求:
1.掌握Sub过程和Function过程的定义和调用方法。 2.掌握形参和实参的对应关系。
3.能利用Sub过程和Function过程解决简单的应用问题。
二、实验环境
1.硬件环境:奔ⅣPC。
2.软件环境:Windows XP 操作系统,Access 2003。
三、实验内容
任务1:
编写判断一个数是不是素数的子函数过程,并利用该函数求1到100之间素数的个数。 具体操作步骤及程序代码为:
_____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ _______________________________________________________________________________________________________________________________________________________________________________________________________________
22
_____________________________________________________________________ __________________________________________________________________________________________________________________________________________
任务2:实验内容请参见教材P272。
具体操作步骤及程序代码为:
_____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________
23
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ _____________________________________________________________________ __________________________________________________________________________________________________________________________________________ ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ 四、实验体会
_____________________________________________________________________
24
上机注意事项
1. 爱护实验设备。
2. 听从老师安排,注意机房秩序。 3. 注意卫生,保持机房清洁。 4. 保持机房安静,不得大声喧哗。 5. 上机前预习好实验内容。
6. 实验结束后必须按时完成实验报告并及时交给指
导老师检查。
正在阅读:
网球肘患者的生活小妙招10-22
国开社区护理学形考任务04-20
五年级语文上册期末冲刺阅读短文训练02-06
Erp试题复习范围01-24
对人生感悟的中学作文04-15
汽车保险与理赔试题06-14
供水管网改造项目可行性研究报告11-18
非煤矿山专项整治工作总结定稿12-05
二年级20以内的加减法练习训练04-23
- exercise2
- 铅锌矿详查地质设计 - 图文
- 厨余垃圾、餐厨垃圾堆肥系统设计方案
- 陈明珠开题报告
- 化工原理精选例题
- 政府形象宣传册营销案例
- 小学一至三年级语文阅读专项练习题
- 2014.民诉 期末考试 复习题
- 巅峰智业 - 做好顶层设计对建设城市的重要意义
- (三起)冀教版三年级英语上册Unit4 Lesson24练习题及答案
- 2017年实心轮胎现状及发展趋势分析(目录)
- 基于GIS的农用地定级技术研究定稿
- 2017-2022年中国医疗保健市场调查与市场前景预测报告(目录) - 图文
- 作业
- OFDM技术仿真(MATLAB代码) - 图文
- Android工程师笔试题及答案
- 生命密码联合密码
- 空间地上权若干法律问题探究
- 江苏学业水平测试《机械基础》模拟试题
- 选课走班实施方案
- 实验
- 计算机
- 基础
- 报告
- 大学
- 电子
- 政治学微博反腐
- 唐山和平钢铁物流有限公司加工配送中心改造项目冬季施工方案 - 图文
- 装载机司机安全操作规程
- 综采设备管理办法
- 基于CAD技术的齿轮泵油槽
- 五年级数学下册第三单元导学案
- 液压与气动技术实训指导书 - 图文
- 江苏高院关于当前商事审判若干问题的解答(二)
- 测试仪器示波器使用技巧经验总结
- C - Lab8-1 - 指针基本概念
- 中共上海市浦东新区委员会宣传部
- 潜水泵安全技术交底
- 中国高空逃生缓降器行业竞争分析及投资发展预测报告2016-2021年
- 欧洲文明概论
- 王力《汉语史稿》 复习提纲(练习题)
- 预防医学实习指导参考答案
- 八年级道德与法治上册第二单元遵守社会规则第三课社会生活离不开规则第1框维护秩序教案新人教版
- 2006-2010年一级建造师机电真题及答案 - 图文
- 专科入学考试(数学)复习题
- Technical Regulations of Shanghai Municipality on Urban Planning Administration