大學(xué)計(jì)算機(jī)基礎(chǔ)(文)(二)實(shí)驗(yàn)報(bào)告冊(cè)電子稿

PAGE實(shí)驗(yàn)報(bào)告冊(cè)學(xué)生姓名學(xué)號(hào)系、年級(jí)專業(yè)指導(dǎo)教師教務(wù)處印制PAGEI目錄實(shí)驗(yàn)一Access環(huán)境及數(shù)據(jù)庫(kù)的創(chuàng)建實(shí)驗(yàn)二建立數(shù)據(jù)表實(shí)驗(yàn)三使用數(shù)據(jù)表實(shí)驗(yàn)四數(shù)據(jù)查詢實(shí)驗(yàn)五設(shè)計(jì)窗體和報(bào)表實(shí)驗(yàn)六宏與數(shù)據(jù)訪問(wèn)頁(yè)的使用實(shí)驗(yàn)七選擇結(jié)構(gòu)語(yǔ)句實(shí)驗(yàn)八循環(huán)結(jié)構(gòu)語(yǔ)句實(shí)驗(yàn)九VBA模塊PAGE22實(shí)驗(yàn)一Access環(huán)境及數(shù)據(jù)庫(kù)的創(chuàng)建實(shí)驗(yàn)類型：驗(yàn)證性實(shí)驗(yàn)教師評(píng)分：實(shí)驗(yàn)時(shí)間：_________________實(shí)驗(yàn)地點(diǎn)：_________________一、實(shí)驗(yàn)?zāi)康呐c要求1.掌握啟動(dòng)和退出Access系統(tǒng)的常用方法。2.熟悉Access的主窗口界面，并會(huì)用不同的方法關(guān)閉和顯示任務(wù)窗格。3.會(huì)設(shè)置默認(rèn)磁盤(pán)目錄。4.會(huì)用不同的方法建立空數(shù)據(jù)庫(kù)，會(huì)利用向?qū)Ы?shù)據(jù)庫(kù)。5.會(huì)用不同的方法打開(kāi)和關(guān)閉數(shù)據(jù)庫(kù)二、實(shí)驗(yàn)環(huán)境1.硬件環(huán)境：奔ⅣPC。2.軟件環(huán)境：WindowsXP操作系統(tǒng)，Access2003。三、實(shí)驗(yàn)內(nèi)容（1）啟動(dòng)Access2003。（2）顯示和關(guān)閉任務(wù)窗格。（3）在D盤(pán)目錄下創(chuàng)建一個(gè)名為“姓名LX”的文件夾（“姓名”處寫(xiě)上自己的姓名），然后設(shè)置“姓名LX”目錄為默認(rèn)磁盤(pán)目錄。（4）在“姓名LX”目錄中建立一個(gè)名為“教學(xué)管理”的空數(shù)據(jù)庫(kù)。（5）利用數(shù)據(jù)庫(kù)的“講座管理”模板，在“姓名LX”目錄中建立一個(gè)名為“計(jì)算機(jī)系講座管理的數(shù)據(jù)庫(kù)”。（6）打開(kāi)和關(guān)閉“教學(xué)管理”數(shù)據(jù)庫(kù)。（7）退出Access2003。具體操作步驟為：________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________四、實(shí)驗(yàn)體會(huì)____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

實(shí)驗(yàn)二建立數(shù)據(jù)表實(shí)驗(yàn)類型：驗(yàn)證性實(shí)驗(yàn)教師評(píng)分：實(shí)驗(yàn)時(shí)間：_________________實(shí)驗(yàn)地點(diǎn)：_________________一、實(shí)驗(yàn)?zāi)康呐c要求1．以“教學(xué)管理”數(shù)據(jù)庫(kù)為練習(xí)實(shí)例，掌握用向?qū)?、設(shè)計(jì)視圖以及數(shù)據(jù)表視圖方法創(chuàng)建表。2．掌握設(shè)置主鍵和索引的設(shè)置方法。3．掌握字段的格式、字段大小、輸入掩碼、標(biāo)題、小數(shù)位數(shù)、默認(rèn)值、有效性規(guī)則、有效性文本以及必填字段等屬性的設(shè)置方法。4．掌握修改表結(jié)構(gòu)的方法；5．掌握表間關(guān)系的設(shè)置與編輯方法。6．掌握使用查詢向?qū)?chuàng)建查詢列表值的方法。7．掌握預(yù)覽和打印表的方法。二、實(shí)驗(yàn)環(huán)境1.硬件環(huán)境：奔ⅣPC。2.軟件環(huán)境：WindowsXP操作系統(tǒng)，Access2003。三、實(shí)驗(yàn)內(nèi)容實(shí)驗(yàn)內(nèi)容請(qǐng)參見(jiàn)教材P64～P66。具體操作步驟為：_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________四、實(shí)驗(yàn)體會(huì)__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

實(shí)驗(yàn)三使用數(shù)據(jù)表實(shí)驗(yàn)類型：綜合性實(shí)驗(yàn)教師評(píng)分：實(shí)驗(yàn)時(shí)間：_________________實(shí)驗(yàn)地點(diǎn)：_________________一、實(shí)驗(yàn)?zāi)康呐c要求1．以“教學(xué)管理”數(shù)據(jù)庫(kù)為練習(xí)實(shí)例，掌握數(shù)據(jù)記錄的輸入、修改和刪除的方法。2．掌握表的格式的設(shè)置方法。3．掌握記錄的排序和篩選。4．掌握表的重命名、刪除和復(fù)制方法。5．掌握刪除、插入子數(shù)據(jù)表及顯示相關(guān)記錄的方法。6．掌握對(duì)數(shù)據(jù)的導(dǎo)入、導(dǎo)出和鏈接的方法。二、實(shí)驗(yàn)環(huán)境1.硬件環(huán)境：奔ⅣPC。2.軟件環(huán)境：WindowsXP操作系統(tǒng)，Access2003。三、實(shí)驗(yàn)內(nèi)容實(shí)驗(yàn)內(nèi)容請(qǐng)參見(jiàn)教材P87～P88。具體操作步驟為：_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________四、實(shí)驗(yàn)體會(huì)__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

實(shí)驗(yàn)四數(shù)據(jù)查詢實(shí)驗(yàn)類型：綜合性實(shí)驗(yàn)教師評(píng)分：實(shí)驗(yàn)時(shí)間：_________________實(shí)驗(yàn)地點(diǎn)：_________________一、實(shí)驗(yàn)?zāi)康呐c要求1．以“教學(xué)管理”數(shù)據(jù)庫(kù)為練習(xí)實(shí)例，掌握創(chuàng)建選擇、參數(shù)、交叉表和操作查詢和創(chuàng)建方法。2．掌握在查詢中使用條件、執(zhí)行計(jì)算的方法。3．能利用SQL實(shí)現(xiàn)查詢。二、實(shí)驗(yàn)環(huán)境1.硬件環(huán)境：奔ⅣPC。2.軟件環(huán)境：WindowsXP操作系統(tǒng)，Access2003。三、實(shí)驗(yàn)內(nèi)容實(shí)驗(yàn)內(nèi)容請(qǐng)參見(jiàn)教材P129～P130。具體操作步驟為：_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________四、實(shí)驗(yàn)體會(huì)__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

實(shí)驗(yàn)五設(shè)計(jì)窗體和報(bào)表實(shí)驗(yàn)類型：綜合性實(shí)驗(yàn)教師評(píng)分：實(shí)驗(yàn)時(shí)間：_________________實(shí)驗(yàn)地點(diǎn)：_________________一、實(shí)驗(yàn)?zāi)康呐c要求1．以“教學(xué)管理”數(shù)據(jù)庫(kù)為練習(xí)實(shí)例，掌握創(chuàng)建和設(shè)計(jì)各種窗體的方法。2．掌握在窗體中放置常用控件的方法，能使用窗體進(jìn)行數(shù)據(jù)處理。3．掌握創(chuàng)建和設(shè)計(jì)各種報(bào)表的方法。4．熟悉在報(bào)表中使用常用控件的方法，能使用報(bào)表進(jìn)行數(shù)據(jù)統(tǒng)計(jì)、分組和排序。二、實(shí)驗(yàn)環(huán)境1.硬件環(huán)境：奔ⅣPC。2.軟件環(huán)境：WindowsXP操作系統(tǒng)，Access2003。三、實(shí)驗(yàn)內(nèi)容任務(wù)1：實(shí)驗(yàn)內(nèi)容請(qǐng)參見(jiàn)教材P165～P166。具體操作步驟為：________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________任務(wù)2：實(shí)驗(yàn)內(nèi)容請(qǐng)參見(jiàn)教材P190。具體操作步驟為：_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________四、實(shí)驗(yàn)體會(huì)__________________________________________________________________________________________________________________________________________

實(shí)驗(yàn)六宏與數(shù)據(jù)訪問(wèn)頁(yè)的使用實(shí)驗(yàn)類型：綜合性實(shí)驗(yàn)教師評(píng)分：實(shí)驗(yàn)時(shí)間：_________________實(shí)驗(yàn)地點(diǎn)：_________________一、實(shí)驗(yàn)?zāi)康呐c要求1．以“教學(xué)管理”數(shù)據(jù)庫(kù)為練習(xí)實(shí)例，掌握創(chuàng)建宏和宏組以及運(yùn)行和調(diào)試宏的方法。2．掌握創(chuàng)建數(shù)據(jù)訪問(wèn)頁(yè)以及使用數(shù)據(jù)訪問(wèn)頁(yè)處理數(shù)據(jù)的方法。二、實(shí)驗(yàn)環(huán)境1.硬件環(huán)境：奔ⅣPC。2.軟件環(huán)境：WindowsXP操作系統(tǒng)，Access2003。三、實(shí)驗(yàn)內(nèi)容任務(wù)1：實(shí)驗(yàn)內(nèi)容請(qǐng)參見(jiàn)教材P205～P207。具體操作步驟為：___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________任務(wù)2：實(shí)驗(yàn)內(nèi)容請(qǐng)參見(jiàn)教材P221～P222。具體操作步驟為：___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________四、實(shí)驗(yàn)體會(huì)_______________________________________________________________________________________________________________________________________________________________________________________________________________

實(shí)驗(yàn)七選擇結(jié)構(gòu)語(yǔ)句實(shí)驗(yàn)類型：設(shè)計(jì)研究性實(shí)驗(yàn)教師評(píng)分：實(shí)驗(yàn)時(shí)間：_________________實(shí)驗(yàn)地點(diǎn)：_________________一、實(shí)驗(yàn)?zāi)康呐c要求：1．掌握邏輯表達(dá)式的正確書(shū)寫(xiě)形式。2．掌握if條件語(yǔ)句的使用方法，能利用if條件語(yǔ)句解決簡(jiǎn)單的應(yīng)用問(wèn)題。3．掌握selectcase語(yǔ)句的使用，能利用selectcase語(yǔ)句解決簡(jiǎn)單的應(yīng)用問(wèn)題。。二、實(shí)驗(yàn)環(huán)境1.硬件環(huán)境：奔ⅣPC。2.軟件環(huán)境：WindowsXP操作系統(tǒng)，Access2003。三、實(shí)驗(yàn)內(nèi)容任務(wù)1：（1）從鍵盤(pán)任意輸入兩個(gè)數(shù)，按由小到大的順序顯示。要求輸入用InputBox函數(shù)，輸出用MsgBox語(yǔ)句。（2）從鍵盤(pán)輸入年份，判斷該年份是否閏年。判斷閏年的條件是年份能被4整除，但不能被100整除；或者能被400整除。要求輸入用InputBox函數(shù)，輸出用MsgBox語(yǔ)句。具體操作步驟及程序代碼為：___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________