ACCESS上机试题及答案2
绛旓細杩欓噷鏈変竴浠芥渶鍏ㄧ殑鑰冪爺鍘嗗勾鐪熼璧勬枡鍒嗕韩缁欎綘 閾炬帴: https://pan.baidu.com/s/1t0SUkI-X-BW4v7Isl0dk4w 鎻愬彇鐮: w2wt 閫氳繃涓嶆柇鐮旂┒鍜屽涔犲巻骞寸湡棰橈紝涓鸿冪敓鍐插埡闃舵澶嶄範鎻愬垎鎸囩偣杩锋触锛屽仛鐪熼锛屽仛鍘嗗勾鐪熼闆嗭紝瀵圭収鑰冪翰鏌ョ己琛ユ紡锛屾彁楂樺疄鎴樼礌鍏伙紝鍒跺畾鍋氶绛栫暐锛岃鍒掓柟鍚戯紱鑻ヨ祫婧愭湁闂娆㈣繋杩介棶锛
绛旓細2.5 鏁版嵁璁块棶椤: 鏁版嵁璁块棶椤电殑鍩虹鍜屾搷浣滄柟娉曘2.6 瀹: 瀹忕殑姒傝堪銆佸垱寤轰笌杩愯锛屼互鍙婂父鐢ㄦ搷浣溿2.7 妯″潡: 妯″潡鍩虹鍜孷BA绋嬪簭璁捐鍩虹鐭ヨ瘑銆傜3绔犲拰绗4绔犲垎鍒秹鍙 鍏稿瀷棰樺垎鏋 鍜 涓婃満缁冧範棰橈紝娑电洊鍩烘湰鎿嶄綔銆佺畝鍗曞簲鐢ㄥ拰缁煎悎搴旂敤鐨勫疄鎴樼粌涔犮傜5绔犲垯鏄 涓婃満缁冧範棰樼瓟妗锛屾彁渚涗簡姣忛儴鍒嗙粌涔犻鐨勬纭瓟妗...
绛旓細杩欐湰涔︽槸涓撲负浜岀骇ACCESS鐨勪笂鏈鸿冭瘯绮惧績缂栨挵鐨勯搴擄紝瀹氫环涓26.80鍏冦傚畠鐢卞叏鍥借绠楁満绛夌骇鑰冭瘯鍛介鐮旂┒涓績涓庢湭鏉ユ暀鑲叉暀瀛︿笌鐮旂┒涓績鐨勪笓瀹跺叡鍚岀紪钁楋紝纭繚浜嗗唴瀹圭殑涓撲笟鎬у拰鍑嗙‘鎬с傘婁簩绾ACCESS涓婃満鑰冭瘯棰搴撱嬬敱鐢靛瓙宸ヤ笟鍑虹増绀惧嚭鐗堬紝鏄拡瀵逛笁绾х綉缁滄妧鏈鍩熺殑涓椤归噸瑕佸弬鑰冭祫鏂欍傝涔︿簬2009骞10鏈堥鐗堝彂琛岋紝鑷充粖...
绛旓細涔︿腑鐗瑰埆瀹夋帓浜涓婃満棰鐨勫吀鍨嬮瑙ｏ紝閫氳繃瀹炰緥瑙ｆ瀽锛岃鑰冪敓浜嗚В鑰冭瘯涓殑甯歌闂鍜岃В棰樼瓥鐣ワ紝鎻愬崌瑙ｉ鑳藉姏銆傚悓鏃讹紝涔︿腑鐨勪範棰樺拰鍙傝绛旀鏈夊姪浜庤冪敓鑷垜妫娴嬪拰澶嶄範銆傜壒鍒煎緱涓鎻愮殑鏄紝鏈功闅忓厜鐩樿禒閫佺殑Access鏁版嵁搴撲笂鏈烘ā鎷熺郴缁熷拰鎵鏈夎瑙ｄ範棰樼殑婧愭枃浠讹紝涓鸿冪敓鎻愪緵浜嗗疄鎴樻紨缁冪殑骞冲彴锛屼互渚夸粬浠湪鐪熷疄鐨勮冭瘯鐜涓...
绛旓細鍦ㄨ冪敓鏂囦欢澶逛笅锛屽瓨鍦ㄤ袱涓暟鎹簱鏂囦欢鍜屼竴涓収鐗囨枃浠讹紝鏁版嵁搴撴枃浠跺悕鍒嗗埆涓衡渟amp1.mdb鈥濆拰鈥渄Research.mdb鈥濓紝鐓х墖鏂囦欢鍚嶄负鈥滅収鐗囥俠mp鈥濄傝瘯鎸変互涓嬫搷浣滆姹傦紝瀹屾垚琛ㄧ殑寤虹珛鍜屼慨鏀癸細锛1锛夊皢鑰冪敓鏂囦欢澶逛笅鐨勨渄Research.mdb鈥濇暟鎹簱涓殑鈥渢Employee鈥濊〃瀵煎叆鍒皊amp1.mdb鏁版嵁搴撲腑锛涳紙2锛夊垱寤轰竴涓悕涓衡...
绛旓細涔︿腑杩橀殢璧犲厜鐩橈紝鍐呭惈涓板瘜鐨勮冭瘯棰樺簱銆佽缁嗙殑鎿嶄綔婕旂ず浠ュ強妯℃嫙鐨涓婃満鑰冭瘯鐜锛屽叏鏂逛綅婊¤冻鑰冪敓鐨勫疄鎴樻紨缁冮渶姹傘傝鏁欐潗浠ュ叾鍏ㄩ潰瑕嗙洊鑰冭瘯瑕佺偣銆佹繁鍏ラ忓交鐨勮В鏋愪互鍙婁弗璋ㄥ疄鐢ㄧ殑鎸囧锛岀壒鍒傚悎澶囪冪殑鑰冪敓浣跨敤锛屽悓鏍蜂篃閫傚悎楂樼瓑闄㈡牎鐨勫笀鐢熶綔涓烘暀瀛﹀弬鑰冧功銆傛棤璁烘槸瀵逛簬鍑嗗鑰冭瘯鐨勫鐢燂紝杩樻槸鏁欒偛宸ヤ綔鑰咃紝閮芥槸鏋佸叿浠峰肩殑...
绛旓細insert into s1 select 浣滆呭鍚,count(浣滆呭鍚) as 鍥句功缁熻 from author inner join books on author.authorid=books.authorid group by 浣滆呭鍚 having count(浣滆呭鍚)>=3 select left(瀛﹀彿,4) as 骞寸骇, 璇剧▼id,avg(鎴愮哗) as 骞冲潎鍒 from tGrade group by left(瀛﹀彿,4),璇剧▼id order ...
绛旓細鍏ㄥ浗璁＄畻鏈虹瓑绾ц冭瘯绯诲垪杈呭鐢ㄤ功锛氫簩绾Access鏁版嵁搴擄紙涓婃満銆佺瑪璇曘佹櫤鑳借蒋浠朵笁鍚堜竴锛夌洰褰曠1绔 鑰冭瘯澶х翰绗2绔 绗旇瘯鑰冭瘯璇曢 绗1濂 绗2濂 绗3濂 ... (绗10濂)绗3绔 涓婃満鑰冭瘯璇曢 绗1濂 绗2濂 ... (绗26濂)绗4绔 绗旇瘯鑰冭瘯璇曢绛旀涓庤В鏋 绗1濂 绗2濂 ... (绗10濂)绗5绔 涓婃満...
绛旓細浜岀骇Access鍥句功鐩綍鏈功鐩綍鍒嗕负涓ゅぇ閮ㄥ垎锛氱悊璁烘寚瀵煎拰涓婃満鑰冭瘯缁冧範銆傜涓閮ㄥ垎鏄婁笂鏈哄簲璇曟寚瀵笺嬶細绗1绔: 绮捐姒傝堪锛屽寘鎷簡鑰冭瘯椤荤煡銆佽冭瘯鎸囧崡鍜屾祦绋嬶紝浠ュ強Access 2003鐨勫熀纭鎿嶄綔閫熸垚鏁欑▼銆绗簩閮ㄥ垎鏄涓婃満鑰冭瘯璇曢涓绛旀銆嬶細銆婄2绔犮嬮泦涓簡40濂椾笂鏈鸿冭瘯璇曢锛屾瘡濂楄瘯棰樺垎涓轰笁涓儴鍒嗭細鍩烘湰鎿嶄綔棰樸佺畝鍗...
绛旓細杩欐湰涓撲负鍏ㄥ浗璁＄畻鏈虹瓑绾ц冭瘯璁捐鐨勫叏鐪熸ā鎷熻瘯鍗凤紝鏃ㄥ湪甯姪鑰冪敓鍏ㄩ潰浜嗚В鍜屽噯澶囦簩绾Access鏁版嵁搴撶▼搴忚璁＄殑鑰冭瘯銆傚畠鍖呭惈澶氬绮惧績缂栨帓鐨勬ā鎷璇曢锛屾棬鍦ㄦā鎷熻冭瘯鐨勯毦搴︼紝浣胯冪敓鑳藉叏闈綋楠岃冭瘯鐨勫悇涓幆鑺傘傛瘡濂楄瘯棰樼敱鍥涢儴鍒嗙粍鎴愶細绗旇瘯棰樸佽缁嗙殑绗旇瘯棰樼瓟妗堣В鏋愶紝浠ュ強涓婃満棰鍜屽搴旂殑涓婃満棰樼瓟妗瑙ｆ瀽銆傝繖鏍风殑璁捐璁╁涔犺...
