《Access 2010數(shù)據(jù)庫程序設(shè)計(jì)教程》自測題參考答案

單項(xiàng)選擇題填空題判斷題單項(xiàng)選擇題填空題判斷題題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01D02C03B04A05C06D07D08C09C10D11D12A13D14A15C16A17A18D19B20C21C22A23D24C25B26B27C28B29B30B31B32C33C34B35C36A37B38A39A40D空號(hào)01答案二維表空號(hào)02答案關(guān)系模型空號(hào)03答案數(shù)據(jù)操縱語言空號(hào)04答案文件系統(tǒng)05數(shù)據(jù)模型06關(guān)系07實(shí)體-聯(lián)系08記錄09關(guān)系10表11重復(fù)12元組13屬性14域15外部關(guān)鍵字16外部17數(shù)據(jù)獨(dú)立性18交19m+n20用戶自定義的完整性題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01T02T03T04F05F06F07T08F09F10F11F12T13T14F15F16T17F18F19F20T21222324單項(xiàng)選擇題2單項(xiàng)選擇題題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01A02B03A04A05A06C07D08D09D10C11C12D13C14B15B16C17D18A19C20D21B22C23D24C25C26D27C28C29B30B31C32A33C34B35A36D37C38B39B40A填空題空號(hào)答案空號(hào)答案空號(hào)答案空號(hào)答案01參照完整性02DBMS03多對(duì)多04身份證號(hào)05關(guān)系06主關(guān)鍵字07二維表08OLE對(duì)象09超鏈接10參照完整性11表12元組13查詢14主索引15屬性16唯一17貨幣18查找19#20課程號(hào)題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01F02F03T04F05F06F07F08T09F10T判斷題單項(xiàng)選擇題3判斷題單項(xiàng)選擇題題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01C02D03A04B05A06B07D08D09D10C11A12A13C14B15D16A17A18D19B20A21A22B23B24D25A26D27B28C29B30B31A32D33D34C35D36C37B38C39D40D填空題空號(hào)答案空號(hào)答案空號(hào)答案空號(hào)答案01數(shù)值02參數(shù)查詢03表或查詢列表04#05數(shù)據(jù)定義查詢06表或查詢07生成表查詢08使用查詢向?qū)?9設(shè)計(jì)視圖，數(shù)據(jù)表視10查詢11交叉表12Abs圖，SQL視圖13查詢14物理更新15行和列16對(duì)話框17假18計(jì)算判斷題題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01T02F03T04T05F06T07T08T09F10T11F12T13F14T15T16T17F18T19F20F單項(xiàng)選擇題4單項(xiàng)選擇題題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01D02A03A04C05C06B07D08D09B10A11B12C13C14D15C16B17A18C19A20B21B22B23A24B25C26A27A28A29C30D31A32C33B34A35A36B37C38B39C40A空號(hào)答案空號(hào)答案空號(hào)答案空號(hào)答案01HAVING02NULL03WHERE04INSERTINTOUPDATE借書證號(hào)CHAR(4),05INTO06SUM0708總編號(hào)CHAR(6),借書日期DATE09“CI007”，“INT2000”，10出版單位11在a和b之間且包含a12COUNT#3/10/2004#和b13SUM14MIN15DISTINCT16ORDERBY17SET18CREATETABLE19ALTERTABLE20UPDATE題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01F02F03F04T05T06T07F08F09T10F填空題判斷題單項(xiàng)選擇題判斷題填空題判斷題單項(xiàng)選擇題判斷題題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)題號(hào)答案01D02A03A04D05C06C07C08B09A10C11A12A13D14D15D16A17D18A19D20C21C22D23A24D25B26A27A28B29B30A31B32D33C34B35D36A37B38C39B40A填空題空號(hào)答案空號(hào)答案空號(hào)答案空號(hào)答案01顯示和編輯數(shù)據(jù)02控件03字段內(nèi)容04標(biāo)題05節(jié)06窗體頁眉07查詢08多個(gè)表09修改窗體10滾動(dòng)條11數(shù)據(jù)12格式13記錄源14屬性15屬性16鼠標(biāo)17按鈕18控件19數(shù)據(jù)表20輸入數(shù)據(jù)值21輸出22列表框23列表框24復(fù)選框25導(dǎo)航按鈕26排序和篩選27主窗體28否29所有控件300題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01F02T03F04T05T06F07F08T09T10T單項(xiàng)選擇題判斷題6單項(xiàng)選擇題判斷題題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01B02B03C04B05D06B07D08D09A10B11B12A13D14C15B16D17D18D19A20B21222324填空題空號(hào)答案空號(hào)答案空號(hào)答案空號(hào)答案01自然順序02計(jì)算控件031004分頁符05相同06報(bào)表頁腳07組頁腳08=Min（[英語]）09[Page]10文本框1112題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01F02T03F04F05F06T07T08F09T10T111213141516單項(xiàng)選擇題7單項(xiàng)選擇題題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01D02D03B04C05A06C07B08B09A10C11B12B13A14A15B16C17D18A19B20B21A22D23C24B25A26C27B28A29C30B31A32A33C34D35B36A37B38C39B40D填空題空號(hào)答案空號(hào)答案空號(hào)答案空號(hào)答案01OpenForm02宏組03AutoExec04操作和操作參數(shù)05子宏06MessageBox07事件屬性值08單步執(zhí)行宏操作09201011137 55 123題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01T02T03T04F05F06F07T08F09T10Fnmod5=1and16f=13nmod5=1and16f=1313456aBC1415i=5.6,s=5nmod7=1IfNumber<10thena17x=5,y=3018m+21920Digits=2elseDigits=3判斷題單項(xiàng)選擇題題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案題號(hào)答案01C02B03D04A05D06A07B08C09D10A11A12C13B14A15D16A17B18B19C20A2122232425262728293031323334353637383940填空題空號(hào)答案空號(hào)答案空號(hào)答案空號(hào)答案01網(wǎng)絡(luò)02Web03網(wǎng)站04.html05動(dòng)態(tài)網(wǎng)頁06瀏覽器07報(bào)表08事件09重