① Access資料庫是什麼特點以及優缺點
Access的優點：
（1）存儲方式簡單，易於維護管理，Access的對象有表、查詢、窗體、報表、頁、宏和模塊，以上對象都存放在後綴為（.mdb或.accdb）的資料庫文件中，便於用戶的操作和管理。
(2)面向對象 Access是一個面向對象的開發工具，這種基於面向對象的開發方式，使得開發應用程序更為簡便。
（3）界面友好、易操作，Access是一個可視化工具，是風格與Windows完全一樣，用戶想要生成對象並應用，只要使用滑鼠進行拖放即可，非常直觀方便。系統還提供了表生成器、查詢生成器、報表設計器以及資料庫向導、表向導、查詢向導、窗體向導、報表向導等工具，使得操作簡便，容易使用和掌握。
（4）集成環境、處理多種數據信息，Access基於Windows操作系統下的集成開發環境，該環境集成了各種向導和生成器工具，極大地提高了開發人員的工作效率，使得建立資料庫、創建表、設計用戶界面、設計數據查詢、報表列印等可以方便有序地進行。
（5）Access支持ODBC（開發資料庫互連，Open Data Base Connectivity），利用Access強大的DDE（動態數據交換）和OLE（對象的聯接和嵌入）特性，可以在一個數據表中嵌入點陣圖、聲音、Excel表格、Word文檔，還可以建立動態的資料庫報表和窗體等。Access還可以將程序應用於網路，並與網路上的動態數據相聯接。利用資料庫訪問頁對象生成HTML文件，輕松構建Internet/Intranet的應用。
（6）支持廣泛，易於擴展，彈性較大 能夠將通過鏈接表的方式來打開EXCEL文件、格式化文本文件等，這樣就可以利用資料庫的高效率對其中的數據進行查詢、處理。還可以通過以Access作為前台客戶端，以sql Server作為後台資料庫的方式（如ADP）開發大型資料庫應用系統。
總之，Access是一個既可以只用來存放數據的資料庫，也可以作為一個客戶端開發工具來進行資料庫應用系統開發；即可以開發方便易用的小型軟體，也可以用來開發大型的應用系統。
Access的缺點：
ACCESS是小型資料庫，既然是小型就有它的局限性（下面關於性能方面的缺點僅指用Access作為資料庫的情況下，不包括用Access作為客戶端前台，用SQL Server作為後台資料庫的情況）：
1. 資料庫過大，一般百M以上（純數據，不包括窗體、報表等客戶端對象）性能會變差。
2. 雖然理論上支持255個並發用戶，但實際上根本支持不了那麼多，如果以只讀方式訪問大概在100個用戶左右，而如果是並發編輯，則大概在10-20個用戶。
3. 記錄數過多，單表記錄數過百萬性能就會變得較差，如果加上設計不良，這個限度還要降低。
4. 不能編譯成可執行文件（.exe），必須要安裝Access運行環境才能使用。
綜上，所以access一般用作小型網站的資料庫，以及小公司的資料庫或應用軟體開發。
② 如何創建access本地資料庫
首先安裝安裝Microsoft Office Access，這個程序一般都是集成在office這套程序中。
1、打開Microsoft Office Access 2003程序
建成了一個新的Microsoft Office Access 2003資料庫。
③ 求一個sql或access 的中國省市資料庫
全國省市縣無刷新多級關聯菜單[網頁特效JS代碼]-
2006-3-21 22:56:27
<html>
<head>
<title>省市縣關聯菜單</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
body,select
{
font-size:9pt;
font-family:Verdana;
}
a
{
color:red;
text-decoration:none;
}
a:hover{
text-decoration:underline;
}
</style>
<SCRIPT LANGUAGE="JavaScript">
<!--
function Dsy()
{
this.Items = {};
}
Dsy.prototype.add = function(id,iArray)
{
this.Items[id] = iArray;
}
Dsy.prototype.Exists = function(id)
{
if(typeof(this.Items[id]) == "undefined") return false;
return true;
}
function change(v){
var str="0";
for(i=0;i<v;i++){ str+=("_"+(document.getElementById(s[i]).selectedIndex-1));};
var ss=document.getElementById(s[v]);
with(ss){
length = 0;
options[0]=new Option(opt0[v],opt0[v]);
if(v && document.getElementById(s[v-1]).selectedIndex>0 || !v)
{
if(dsy.Exists(str)){
ar = dsy.Items[str];
for(i=0;i<ar.length;i++)options[length]=new Option(ar[i],ar[i]);
if(v)options[1].selected = true;
}
}
if(++v<s.length){change(v);}
}
}
var dsy = new Dsy();
dsy.add("0",["安徽","北京","福建","甘肅","廣東","廣西","貴州","海南","河北","河南","黑龍江","湖北","湖南","吉林","江蘇","江西","遼寧","內蒙古","寧夏","青海","山東","山西","陝西","上海","四川","天津","西藏","新疆","雲南","浙江","重慶"]);
dsy.add("0_0",["安慶","蚌埠","巢湖","池州","滁州","阜陽","合肥","淮北","淮南","黃山","六安","馬鞍山","宿州","銅陵","蕪湖","宣城","亳州"]);
dsy.add("0_0_0",["安慶市","懷寧縣","潛山縣","宿松縣","太湖縣","桐城市","望江縣","岳西縣","樅陽縣"]);
dsy.add("0_0_1",["蚌埠市","固鎮縣","懷遠縣","五河縣"]);
dsy.add("0_0_2",["巢湖市","含山縣","和縣","廬江縣","無為縣"]);
dsy.add("0_0_3",["池州市","東至縣","青陽縣","石台縣"]);
dsy.add("0_0_4",["滁州市","定遠縣","鳳陽縣","來安縣","明光市","全椒縣","天長市"]);
dsy.add("0_0_5",["阜南縣","阜陽市","界首市","臨泉縣","太和縣","穎上縣"]);
dsy.add("0_0_6",["長豐縣","肥東縣","肥西縣"]);
dsy.add("0_0_7",["淮北市","濉溪縣"]);
dsy.add("0_0_8",["鳳台縣","淮南市"]);
dsy.add("0_0_9",["黃山市","祁門縣","休寧縣","歙縣","黟縣"]);
dsy.add("0_0_10",["霍邱縣","霍山縣","金寨縣","六安市","壽縣","舒城縣"]);
dsy.add("0_0_11",["當塗縣","馬鞍山市"]);
dsy.add("0_0_12",["靈璧縣","宿州市","蕭縣","泗縣","碭山縣"]);
dsy.add("0_0_13",["銅陵市","銅陵縣"]);
dsy.add("0_0_14",["繁昌縣","南陵縣","蕪湖市","蕪湖縣"]);
dsy.add("0_0_15",["廣德縣","績溪縣","郎溪縣","寧國市","宣城市","涇縣","旌德縣"]);
dsy.add("0_0_16",["利辛縣","蒙城縣","渦陽縣","亳州市"]);
dsy.add("0_1",["北京"]);
dsy.add("0_1_0",["北京市","密雲縣","延慶縣"]);
dsy.add("0_2",["福州","龍岩","南平","寧德","莆田","泉州","三明","廈門","漳州"]);
dsy.add("0_2_0",["長樂市","福清市","福州市","連江縣","羅源縣","閩侯縣","閩清縣","平潭縣","永泰縣"]);
dsy.add("0_2_1",["長汀縣","連城縣","龍岩市","上杭縣","武平縣","永定縣","漳平市"]);
dsy.add("0_2_2",["光澤縣","建陽市","建甌市","南平市","浦城縣","邵武市","順昌縣","松溪縣","武夷山市","政和縣"]);
dsy.add("0_2_3",["福安市","福鼎市","古田縣","寧德市","屏南縣","壽寧縣","霞浦縣","周寧縣","柘榮縣"]);
dsy.add("0_2_4",["莆田市","仙游縣"]);
dsy.add("0_2_5",["安溪縣","德化縣","惠安縣","金門縣","晉江市","南安市","泉州市","石獅市","永春縣"]);
dsy.add("0_2_6",["大田縣","建寧縣","將樂縣","明溪縣","寧化縣","清流縣","三明市","沙縣","泰寧縣","永安市","尤溪縣"]);
dsy.add("0_2_7",["廈門市"]);
dsy.add("0_2_8",["長泰縣","東山縣","華安縣","龍海市","南靖縣","平和縣","雲霄縣","漳浦縣","漳州市","詔安縣"]);
dsy.add("0_3",["白銀","定西","甘南藏族自治州","嘉峪關","金昌","酒泉","蘭州","臨夏回族自治州","隴南","平涼","慶陽","天水","武威","張掖"]);
dsy.add("0_3_0",["白銀市","會寧縣","景泰縣","靖遠縣"]);
dsy.add("0_3_1",["定西縣","臨洮縣","隴西縣","通渭縣","渭源縣","漳縣","岷縣"]);
dsy.add("0_3_2",["迭部縣","合作市","臨潭縣","碌曲縣","瑪曲縣","夏河縣","舟曲縣","卓尼縣"]);
dsy.add("0_3_3",["嘉峪關市"]);
dsy.add("0_3_4",["金昌市","永昌縣"]);
dsy.add("0_3_5",["阿克塞哈薩克族自治縣","安西縣","敦煌市","金塔縣","酒泉市","肅北蒙古族自治縣","玉門市"]);
dsy.add("0_3_6",["皋蘭縣","蘭州市","永登縣","榆中縣"]);
dsy.add("0_3_7",["東鄉族自治縣","廣河縣","和政縣","積石山保安族東鄉族撒拉族自治縣","康樂縣","臨夏市","臨夏縣","永靖縣"]);
dsy.add("0_3_8",["成縣","徽縣","康縣","禮縣","兩當縣","文縣","武都縣","西和縣","宕昌縣"]);
dsy.add("0_3_9",["崇信縣","華亭縣","靜寧縣","靈台縣","平涼市","庄浪縣","涇川縣"]);
dsy.add("0_3_10",["合水縣","華池縣","環縣","寧縣","慶城縣","慶陽市","鎮原縣","正寧縣"]);
dsy.add("0_3_11",["甘谷縣","秦安縣","清水縣","天水市","武山縣","張家川回族自治縣"]);
dsy.add("0_3_12",["古浪縣","民勤縣","天祝藏族自治縣","武威市"]);
dsy.add("0_3_13",["高台縣","臨澤縣","民樂縣","山丹縣","肅南裕固族自治縣","張掖市"]);
dsy.add("0_4",["潮州","東莞","佛山","廣州","河源","惠州","江門","揭陽","茂名","梅州","清遠","汕頭","汕尾","韶關","深圳","陽江","雲浮","湛江","肇慶","中山","珠海"]);
dsy.add("0_4_0",["潮安縣","潮州市","饒平縣"]);
dsy.add("0_4_1",["東莞市"]);
dsy.add("0_4_2",["佛山市"]);
dsy.add("0_4_3",["從化市","廣州市","增城市"]);
dsy.add("0_4_4",["東源縣","和平縣","河源市","連平縣","龍川縣","紫金縣"]);
dsy.add("0_4_5",["博羅縣","惠東縣","惠陽市","惠州市","龍門縣"]);
dsy.add("0_4_6",["恩平市","鶴山市","江門市","開平市","台山市"]);
dsy.add("0_4_7",["惠來縣","揭東縣","揭西縣","揭陽市","普寧市"]);
dsy.add("0_4_8",["電白縣","高州市","化州市","茂名市","信宜市"]);
dsy.add("0_4_9",["大埔縣","豐順縣","蕉嶺縣","梅縣","梅州市","平遠縣","五華縣","興寧市"]);
dsy.add("0_4_10",["佛岡縣","連南瑤族自治縣","連山壯族瑤族自治縣","連州市","清新縣","清遠市","陽山縣","英德市"]);
dsy.add("0_4_11",["潮陽市","澄海市","南澳縣","汕頭市"]);
dsy.add("0_4_12",["海豐縣","陸豐市","陸河縣","汕尾市"]);
dsy.add("0_4_13",["樂昌市","南雄市","曲江縣","仁化縣","乳源瑤族自治縣","韶關市","始興縣","翁源縣","新豐縣"]);
dsy.add("0_4_14",["深圳市"]);
dsy.add("0_4_15",["陽春市","陽東縣","陽江市","陽西縣"]);
dsy.add("0_4_16",["羅定市","新興縣","鬱南縣","雲安縣","雲浮市"]);
dsy.add("0_4_17",["雷州市","廉江市","遂溪縣","吳川市","徐聞縣","湛江市"]);
dsy.add("0_4_18",["德慶縣","封開縣","高要市","廣寧縣","懷集縣","四會市","肇慶市"]);
dsy.add("0_4_19",["中山市"]);
dsy.add("0_4_20",["珠海市"]);
dsy.add("0_5",["百色","北海","崇左","防城港","桂林","貴港","河池","賀州","來賓","柳州","南寧","欽州","梧州","玉林"]);
dsy.add("0_5_0",["百色市","德保縣","靖西縣","樂業縣","凌雲縣","隆林各族自治縣","那坡縣","平果縣","田東縣","田林縣","田陽縣","西林縣"]);
dsy.add("0_5_1",["北海市","合浦縣"]);
dsy.add("0_5_2",["崇左市","大新縣","扶綏縣","龍州縣","寧明縣","憑祥市","天等縣"]);
dsy.add("0_5_3",["東興市","防城港市","上思縣"]);
dsy.add("0_5_4",["恭城瑤族自治縣","灌陽縣","桂林市","荔浦縣","臨桂縣","靈川縣","龍勝各族自治縣","平樂縣","全州縣","興安縣","陽朔縣","永福縣","資源縣"]);
dsy.add("0_5_5",["桂平市","貴港市","平南縣"]);
dsy.add("0_5_6",["巴馬瑤族自治縣","大化瑤族自治縣","東蘭縣","都安瑤族自治縣","鳳山縣","河池市","環江毛南族自治縣","羅城仡佬族自治縣","南丹縣","天峨縣","宜州市"]);
dsy.add("0_5_7",["富川瑤族自治縣","賀州市","昭平縣","鍾山縣"]);
dsy.add("0_5_8",["合山市","金秀瑤族自治縣","來賓市","武宣縣","象州縣","忻城縣"]);
dsy.add("0_5_9",["柳城縣","柳江縣","柳州市","鹿寨縣","融安縣","融水苗族自治縣","三江侗族自治縣"]);
dsy.add("0_5_10",["賓陽縣","橫縣","隆安縣","馬山縣","南寧市","上林縣","武鳴縣","邕寧縣"]);
dsy.add("0_5_11",["靈山縣","浦北縣","欽州市"]);
dsy.add("0_5_12",["蒼梧縣","蒙山縣","藤縣","梧州市","岑溪市"]);
dsy.add("0_5_13",["北流市","博白縣","陸川縣","容縣","興業縣","玉林市"]);
dsy.add("0_6",["安順","畢節","貴陽","六盤水","黔東南苗族侗族自治州","黔南布依族苗族自治州","黔西南布依族苗族自治州","銅仁","遵義"]);
dsy.add("0_6_0",["安順市","關嶺布依族苗族自治縣","平壩縣","普定縣","鎮寧布依族苗族自治縣","紫雲苗族布依族自治縣"]);
dsy.add("0_6_1",["畢節市","大方縣","赫章縣","金沙縣","納雍縣","黔西縣","威寧彝族回族苗族自治縣","織金縣"]);
dsy.add("0_6_2",["貴陽市","開陽縣","清鎮市","息烽縣","修文縣"]);
dsy.add("0_6_3",["六盤水市","六枝特區","盤縣","水城縣"]);
dsy.add("0_6_4",["從江縣","丹寨縣","黃平縣","劍河縣","錦屏縣","凱里市","雷山縣","黎平縣","麻江縣","三穗縣","施秉縣","台江縣","天柱縣","鎮遠縣","岑鞏縣","榕江縣"]);
dsy.add("0_6_5",["長順縣","都勻市","獨山縣","福泉市","貴定縣","惠水縣","荔波縣","龍里縣","羅甸縣","平塘縣","三都水族自治縣","甕安縣"]);
dsy.add("0_6_6",["安龍縣","冊亨縣","普安縣","晴隆縣","望謨縣","興仁縣","興義市","貞豐縣"]);
dsy.add("0_6_7",["德江縣","江口縣","石阡縣","思南縣","松桃苗族自治縣","銅仁市","萬山特區","沿河土家族自治縣","印江土家族苗族自治縣","玉屏侗族自治縣"]);
dsy.add("0_6_8",["赤水市","道真仡佬族苗族自治縣","鳳岡縣","仁懷市","綏陽縣","桐梓縣","務川仡佬族苗族自治縣","習水縣","余慶縣","正安縣","遵義市","遵義縣","湄潭縣"]);
dsy.add("0_7",["白沙黎族自治縣","保亭黎族苗族自治縣","昌江黎族自治縣","澄邁縣","定安縣","東方","海口","樂東黎族自治縣","臨高縣","陵水黎族自治縣","瓊海","瓊中黎族苗族自治縣","三亞","屯昌縣","萬寧","文昌","五指山","儋州"]);
dsy.add("0_7_0",["白沙黎族自治縣"]);
dsy.add("0_7_1",["保亭黎族苗族自治縣"]);
dsy.add("0_7_2",["昌江黎族自治縣"]);
dsy.add("0_7_3",["澄邁縣"]);
dsy.add("0_7_4",["定安縣"]);
dsy.add("0_7_5",["東方市"]);
dsy.add("0_7_6",["海口市"]);
dsy.add("0_7_7",["樂東黎族自治縣"]);
dsy.add("0_7_8",["臨高縣"]);
dsy.add("0_7_9",["陵水黎族自治縣"]);
dsy.add("0_7_10",["瓊海市"]);
dsy.add("0_7_11",["瓊中黎族苗族自治縣"]);
dsy.add("0_7_12",["三亞市"]);
dsy.add("0_7_13",["屯昌縣"]);
dsy.add("0_7_14",["萬寧市"]);
dsy.add("0_7_15",["文昌市"]);
dsy.add("0_7_16",["五指山市"]);
dsy.add("0_7_17",["儋州市"]);
dsy.add("0_8",["保定","滄州","承德","邯鄲","衡水","廊坊","秦皇島","石家莊","唐山","邢台","張家口"]);
dsy.add("0_8_0",["安國市","安新縣","保定市","博野縣","定興縣","定州市","阜平縣","高碑店市","高陽縣","滿城縣","清苑縣","曲陽縣","容城縣","順平縣","唐縣","望都縣","雄縣","徐水縣","易縣","淶水縣","淶源縣","涿州市","蠡縣"]);
dsy.add("0_8_1",["泊頭市","滄縣","滄州市","東光縣","海興縣","河間市","黃驊市","孟村回族自治縣","南皮縣","青縣","任丘市","肅寧縣","吳橋縣","獻縣","鹽山縣"]);
dsy.add("0_8_2",["承德市","承德縣","豐寧滿族自治縣","寬城滿族自治縣","隆化縣","灤平縣","平泉縣","圍場滿族蒙古族自治縣","興隆縣"]);
dsy.add("0_8_3",["成安縣","磁縣","大名縣","肥鄉縣","館陶縣","廣平縣","邯鄲市","邯鄲縣","雞澤縣","臨漳縣","邱縣","曲周縣","涉縣","魏縣","武安市","永年縣"]);
dsy.add("0_8_4",["安平縣","阜城縣","故城縣","衡水市","冀州市","景縣","饒陽縣","深州市","武強縣","武邑縣","棗強縣"]);
dsy.add("0_8_5",["霸州市","大廠回族自治縣","大城縣","固安縣","廊坊市","三河市","文安縣","香河縣","永清縣"]);
dsy.add("0_8_6",["昌黎縣","撫寧縣","盧龍縣","秦皇島市","青龍滿族自治縣"]);
dsy.add("0_8_7",["高邑縣","晉州市","井陘縣","靈壽縣","鹿泉市","平山縣","深澤縣","石家莊市","無極縣","辛集市","新樂市","行唐縣","元氏縣","贊皇縣","趙縣","正定縣","藁城市","欒城縣"]);
dsy.add("0_8_8",["樂亭縣","灤南縣","灤縣","遷安市","遷西縣","唐海縣","唐山市","玉田縣","遵化市"]);
dsy.add("0_8_9",["柏鄉縣","廣宗縣","巨鹿縣","臨城縣","臨西縣","隆堯縣","南宮市","南和縣","內丘縣","寧晉縣","平鄉縣","清河縣","任縣","沙河市","威縣","新河縣","邢台市","邢台縣"]);
dsy.add("0_8_10",["赤城縣","崇禮縣","沽源縣","懷安縣","懷來縣","康保縣","尚義縣","萬全縣","蔚縣","宣化縣","陽原縣","張北縣","張家口市","涿鹿縣"]);
dsy.add("0_9",["安陽","鶴壁","濟源","焦作","開封","洛陽","南陽","平頂山","三門峽","商丘","新鄉","信陽","許昌","鄭州","周口","駐馬店","漯河","濮陽"]);
dsy.add("0_9_0",["安陽市","安陽縣","滑縣","林州市","內黃縣","湯陰縣"]);
dsy.add("0_9_1",["","鶴壁市","浚縣","淇縣"]);
dsy.add("0_9_2",["濟源市"]);
dsy.add("0_9_3",["博愛縣","焦作市","孟州市","沁陽市","溫縣","武陟縣","修武縣"]);
dsy.add("0_9_4",["開封市","開封縣","蘭考縣","通許縣","尉氏縣","杞縣"]);
dsy.add("0_9_5",["洛寧縣","洛陽市","孟津縣","汝陽縣","新安縣","伊川縣","宜陽縣","偃師市","嵩縣","欒川縣"]);
dsy.add("0_9_6",["鄧州市","方城縣","南陽市","南召縣","內鄉縣","社旗縣","唐河縣","桐柏縣","西峽縣","新野縣","鎮平縣","淅川縣"]);
dsy.add("0_9_7",["寶豐縣","魯山縣","平頂山市","汝州市","舞鋼市","葉縣","郟縣"]);
dsy.add("0_9_8",["靈寶市","盧氏縣","三門峽市","陝縣","義馬市","澠池縣"]);
dsy.add("0_9_9",["民權縣","寧陵縣","商丘市","夏邑縣","永城市","虞城縣","柘城縣","睢縣"]);
dsy.add("0_9_10",["長垣縣","封丘縣","輝縣市","獲嘉縣","衛輝市","新鄉市","新鄉縣","延津縣","原陽縣"]);
dsy.add("0_9_11",["固始縣","光山縣","淮濱縣","羅山縣","商城縣","息縣","新縣","信陽市","潢川縣"]);
dsy.add("0_9_12",["長葛市","襄城縣","許昌市","許昌縣","禹州市","鄢陵縣"]);
dsy.add("0_9_13",["登封市","鞏義市","新密市","新鄭市","鄭州市","中牟縣","滎陽市"]);
dsy.add("0_9_14",["鄲城縣","扶溝縣","淮陽縣","鹿邑縣","商水縣","沈丘縣","太康縣","西華縣","項城市","周口市"]);
dsy.add("0_9_15",["泌陽縣","平輿縣","確山縣","汝南縣","上蔡縣","遂平縣","西平縣","新蔡縣","正陽縣","駐馬店市"]);
dsy.add("0_9_16",["臨潁縣","舞陽縣","郾城縣","漯河市"]);
dsy.add("0_9_17",["范縣","南樂縣","清豐縣","台前縣","濮陽市","濮陽縣"]);
dsy.add("0_10",["大慶","大興安嶺","哈爾濱","鶴崗","黑河","雞西","佳木斯","牡丹江","七台河","齊齊哈爾","雙鴨山","綏化","伊春"]);
dsy.add("0_10_0",["大慶市","杜爾伯特蒙古族自治縣","林甸縣","肇源縣","肇州縣"]);
dsy.add("0_10_1",["呼瑪縣","漠河縣","塔河縣"]);
dsy.add("0_10_2",["阿城市","巴彥縣","賓縣","方正縣","哈爾濱市","呼蘭縣","木蘭縣","尚志市","雙城市","通河縣","五常市","延壽縣","依蘭縣"]);
dsy.add("0_10_3",["鶴崗市","蘿北縣","綏濱縣"]);
dsy.add("0_10_4",["北安市","黑河市","嫩江縣","孫吳縣","五大連池市","遜克縣"]);
dsy.add("0_10_5",["虎林市","雞東縣","雞西市","密山市"]);
dsy.add("0_10_6",["撫遠縣","富錦市","佳木斯市","湯原縣","同江市","樺川縣","樺南縣"]);
dsy.add("0_10_7",["東寧縣","海林市","林口縣","牡丹江市","穆棱市","寧安市","綏芬河市"]);
dsy.add("0_10_8",["勃利縣","七台河市"]);
dsy.add("0_10_9",["拜泉縣","富裕縣","甘南縣","克東縣","克山縣","龍江縣","齊齊哈爾市","泰來縣","依安縣","訥河市"]);
dsy.add("0_10_10",["寶清縣","集賢縣","饒河縣","雙鴨山市","友誼縣"]);
dsy.add("0_10_11",["安達市","海倫市","蘭西縣","明水縣","青岡縣","慶安縣","綏化市","綏棱縣","望奎縣","肇東市"]);
dsy.add("0_10_12",["嘉蔭縣","鐵力市","伊春市"]);
dsy.add("0_11",["鄂州","恩施土家族苗族自治州","黃岡","黃石","荊門","荊州","潛江","神農架林區","十堰","隨州","天門","武漢","仙桃","咸寧","襄樊","孝感","宜昌"]);
dsy.add("0_11_0",["鄂州市"]);
dsy.add("0_11_1",["巴東縣","恩施市","鶴峰縣","建始縣","來鳳縣","利川市","咸豐縣","宣恩縣"]);
dsy.add("0_11_2",["紅安縣","黃岡市","黃梅縣","羅田縣","麻城市","團風縣","武穴市","英山縣","蘄春縣","浠水縣"]);
dsy.add("0_11_3",["大冶市","黃石市","陽新縣"]);
dsy.add("0_11_4",["荊門市","京山縣","沙洋縣","鍾祥市"]);
dsy.add("0_11_5",["公安縣","洪湖市","監利縣","江陵縣","荊州市","石首市","松滋市"]);
dsy.add("0_11_6",["潛江市"]);
dsy.add("0_11_7",["神農架林區"]);
dsy.add("0_11_8",["丹江口市","房縣","十堰市","鄖西縣","鄖縣","竹山縣","竹溪縣"]);
dsy.add("0_11_9",["廣水市","隨州市"]);
dsy.add("0_11_10",["天門市"]);
dsy.add("0_11_11",["武漢市"]);
dsy.add("0_11_12",["仙桃市"]);
dsy.add("0_11_13",["赤壁市","崇陽縣","嘉魚縣","通城縣","通山縣","咸寧市"]);
dsy.add("0_11_14",["保康縣","谷城縣","老河口市","南漳縣","襄樊市","宜城市","棗陽市"]);
dsy.add("0_11_15",["安陸市","大悟縣","漢川市","孝昌縣","孝感市","應城市","雲夢縣"]);
dsy.add("0_11_16",["長陽土家族自治縣","當陽市","五峰土家族自治縣","興山縣","宜昌市","宜都市","遠安縣","枝江市","秭歸縣"]);
dsy.add("0_12",["常德","長沙","郴州","衡陽","懷化","婁底","邵陽","湘潭","湘西土家族苗族自治州","益陽","永州","岳陽","張家界","株洲"]);
dsy.add("0_12_0",["安鄉縣","常德市","漢壽縣","津市市","臨澧縣","石門縣","桃源縣","澧縣"]);
dsy.add("0_12_1",["長沙市","長沙縣","寧鄉縣","望城縣","瀏陽市"]);
dsy.add("0_12_2",["安仁縣","郴州市","桂東縣","桂陽縣","嘉禾縣","臨武縣","汝城縣","宜章縣","永興縣","資興市"]);
dsy.add("0_12_3",["常寧市","衡東縣","衡南縣","衡山縣","衡陽市","衡陽縣","祁東縣","耒陽市"]);
dsy.add("0_12_4",["辰溪縣","洪江市","懷化市","會同縣","靖州苗族侗族自治縣","麻陽苗族自治縣","通道侗族自治縣","新晃侗族自治縣","中方縣","芷江侗族自治縣","沅陵縣","漵浦縣"]);
dsy.add("0_12_5",["冷水江市","漣源市","婁底市","雙峰縣","新化縣"]);
dsy.add("0_12_6",["城步苗族自治縣","洞口縣","隆回縣","邵東縣","邵陽市","邵陽縣","綏寧縣","武岡市","新寧縣","新邵縣"]);
dsy.add("0_12_7",["韶山市","湘潭市","湘潭縣","湘鄉市"]);
dsy.add("0_12_8",["保靖縣","鳳凰縣","古丈縣","花垣縣","吉首市","龍山縣","永順縣","瀘溪縣"]);
dsy.add("0_12_9",["安化縣","南縣","桃江縣","益陽市","沅江市"]);
dsy.add("0_12_10",["道縣","東安縣","江華瑤族自治縣","江永縣","藍山縣","寧遠縣","祁陽縣","雙牌縣","新田縣","永州市"]);
dsy.add("0_12_11",["華容縣","臨湘市","平江縣","湘陰縣","岳陽市","岳陽縣","汨羅市"]);
dsy.add("0_12_12",["慈利縣","桑植縣","張家界市"]);
dsy.add("0_12_13",["茶陵縣","炎陵縣","株洲市","株洲縣","攸縣","醴陵市"]);
dsy.add("0_13",["白城","白山","長春","吉林","遼源","四平","松原","通化","延邊朝鮮族自治州"]);
dsy.add("0_13_0",["白城市","大安市","通榆縣","鎮賚縣","洮南市"]);
dsy.add("0_13_1",["白山市","長白朝鮮族自治縣","撫松縣","江源縣","靖宇縣","臨江市"]);
dsy.add("0_13_2",["長春市","德惠市","九台市","農安縣","榆樹市"]);
dsy.add("0_13_3",["吉林市","磐石市","舒蘭市","永吉縣","樺甸市","蛟河市"]);
dsy.add("0_13_4",["東豐縣","東遼縣","遼源市"]);
dsy.add("0_13_5",["公主嶺市","梨樹縣","雙遼市","四平市","伊通滿族自治縣"]);
dsy.add("0_13_6",["長嶺縣","扶余縣","乾安縣","前郭爾羅斯蒙古族自治縣","松原市"]);
dsy.add("0_13_7",["輝南縣","集安市","柳河縣","梅河口市","通化市","通化縣"]);
dsy.add("0_13_8",["安圖縣","敦化市","和龍市","龍井市","圖們市","汪清縣","延吉市","琿春市"]);
dsy.add("0_14",["常州","淮安","連雲港","南京","南通","蘇州","宿遷","泰州","無錫","徐州","鹽城","揚州","鎮江"]);
dsy.add("0_14_0",["常州市","金壇市","溧陽市"]);
dsy.add("0_14_1",["洪澤縣","淮安市","金湖縣","漣水縣","盱眙縣"]);
dsy.add("0_14_2",["東海縣","贛榆縣","灌南縣","灌雲縣","連雲港市"]);
dsy.add("0_14_3",["高淳縣","南京市","溧水縣"]);
dsy.add("0_14_4",["海安縣","海門市","南通市","啟東市","如東縣","如皋市","通州市"]);
dsy.add("0_14_5",["常熟市","崑山市","蘇州市","太倉市","吳江市","張家港市"]);
dsy.add("0_14_6",["宿遷市","宿豫縣","沭陽縣","泗洪縣","泗陽縣"]);
dsy.add("0_14_7",["姜堰市","靖江市","泰興市","泰州市","興化市"]);
dsy.add("0_14_8",["江陰市","無錫市","宜興市"]);
dsy.add("0_14_9",["豐縣","沛縣","銅山縣","新沂市","徐州市","邳州市","睢寧縣"]);
dsy.add("0_14_10",["濱海縣","大豐市","東台市","阜寧縣","建湖縣","射陽縣","響水縣","鹽城市","鹽都縣"]);
dsy.add("0_14_11",["寶應縣","高郵市","江都市","揚州市","儀征市"]);
dsy.add("0_14_12",["丹陽市","句容市","揚中市","鎮江市"]);
dsy.add("0_15",["撫州","贛州","吉安","景德鎮","九江","南昌","萍鄉","上饒","新余","宜春","鷹潭"]);
dsy.add("0_15_0",["崇仁縣","東鄉縣","撫州市","廣昌縣","金溪縣","樂安縣","黎川縣","南城縣","南豐縣","宜黃縣","資溪縣"]);
dsy.add("0_15_1",["安遠縣","崇義縣","大余縣","定南縣","贛縣","贛州市","會昌縣","龍南縣","南康市","寧都縣","全南縣","瑞金市","上猶縣","石城縣","信豐縣","興國縣","尋烏縣","於都縣"]);
dsy.add("0_15_2",["安福縣","吉安市","吉安縣","吉水縣","井岡山市","遂川縣","泰和縣","萬安縣","峽江縣","新干縣","永豐縣","永新縣"]);
dsy.add("0_15_3",["浮梁縣","景德鎮市","樂平市"]);
dsy.add("0_15_4",["德安縣","都昌縣","湖口縣","九江市","九江縣","彭澤縣","瑞昌市","武寧縣","星子縣","修水縣","永修縣"]);
dsy.add("0_15_5",["安義縣","進賢縣","南昌市","南昌縣","新建縣"]);
dsy.add("0_15_6",["蓮花縣","蘆溪縣","萍鄉市","上栗縣"]);
dsy.add("0_15_7",["波陽縣","德興市","廣豐縣","橫峰縣","鉛山縣","上饒市","上饒縣","萬年縣","余干縣","玉山縣","弋陽縣","婺源縣"]);
dsy.add("0_15_8",["分宜縣","新余市"]);
dsy.add("0_15_9",["豐城市","奉新縣","高安市","靖安縣","上高縣","銅鼓縣","萬載縣","宜春市","宜豐縣","樟樹市"]);
dsy.add("0_15_10",["貴溪市","鷹潭市","余江縣"]);
dsy.add("0_16",["鞍山","本溪","朝陽","大連","丹東","撫順","阜新","葫蘆島","錦州","遼陽","盤錦","沈陽","鐵嶺","營口"]);
dsy.add("0_16_0",["鞍山市","海城市","台安縣","岫岩滿族自治縣"]);
dsy.add("0_16_1",["本溪滿族自治縣","本溪市","桓仁滿族自治縣"]);
dsy.add("0_
④ 怎樣做access2003省市表
我知道在sql中,可以使用select查詢完成分類以省為分類條件:select * from 表名 order by 省名;以市為分類條件:select * from 表名 order by 市名;order by 是分組查詢的語句答案補充select * from 表名 order by 省市;因48個省市須執行48邊答案補充為方便期間,ACCESS可導入sql server 2000中更加方便
⑤ 求中國省份和城市的access資料庫
我盡力找了,但是沒找到,這東西不怎麼可能找到的
⑥ 如何用Access做資料庫錄入全國城市
三張表
表一：省
另外無論怎麼建表，市和省總會重復的，畢竟省市縣是包含關系
⑦ Access 窗體中如何實現"省市縣"關聯查詢
這個很好實現,就看你在資料庫里如何存儲了,一般情況在地區表裡加個 父ID欄位就可以了 這個地段記錄本條記錄所屬的地區ID
然後展現的時候就可以謝SQL語句了 ,比如你省選的是湖北省,這樣你就可以得到湖北省的ID,然後上地區表裡查詢父ID是湖北省的ID的地區就可以得到湖北省下屬地區,縣也是一個道理.
----------------------------------
你時說你選的時候只執行一次是吧，你要把方法寫到listedit的onchange事件里，只要你選一次他就會執行一次了。
⑧ Access是什麼資料庫管理系統
Access是一種傳統的桌面型關系資料庫，資料庫是有結構的數據集合,它與一般的數據文件不同，是一串文字或數字流。資料庫中的數據可以是文字、圖象、聲音等。 關系式資料庫由一系列表組成，表又由一系列行和列組成，每一行是一個記錄，每一列是一個欄位，每個欄位有一個欄位名，欄位名在一個表中不能重復。如圖1就是一張表。
圖1
表與表之間可以建立關系（或稱關聯，連接），以便查詢相關聯的信息。Access資料庫以文件形式保存，文件的擴展名是DB。Access 97資料庫由六種對象組成，它們是表、查詢、窗體、報表、宏和模塊。
表(Table) ——表是資料庫的基本對象，是創建其他5種對象的基礎。表由記錄組成，記錄由欄位組成，表用來存貯資料庫的數據，故又稱數據表。
查詢(Query)——查詢可以按索引快速查找到需要的記錄，按要求篩選記錄並能連接若干個表的欄位組成新表。
窗體(Form)——窗體提供了一種方便的瀏覽、輸入及更改數據的窗口。還可以創建子窗體顯示相關聯的表的內容。窗體也稱表單。
報表(Report)——報表的功能是將資料庫中的數據分類匯總，然後列印出來，以便分析。
宏(Macro)——宏相當於DOS中的批處理，用來自動執行一系列操作。Access列出了一些常用的操作供用戶選擇，使用起來十分方便。
模塊(Mole)——模塊的功能與宏類似，但它定義的操作比宏更精細和復雜，用戶可以根據自己的需要編寫程序。模塊使用Visual Basic編程。
⑨ access資料庫是什麼 具體點
Access
是微軟公司推出的基於Windows的桌面關系資料庫管理系統（RDBMS），是Office系列應用軟體之一。它提供了表、查詢、窗體、報表、頁、宏、模塊7種用來建立資料庫系統的對象；提供了多種向導、生成器、模板，把數據存儲、數據查詢、界面設計、報表生成等操作規范化；為建立功能完善的資料庫管理系統提供了方便，也使得普通用戶不必編寫代碼，就可以完成大部分數據管理的任務。
Access是一種關系型資料庫管理系統，其主要特點如下：
（1）存儲方式單一
Access管理的對象有表、查詢、窗體、報表、頁、宏和模塊，以上對象都存放在後綴為（.mdb）的資料庫文件種，便於用戶的操作和管理。
(2)面向對象
Access是一個面向對象的開發工具，利用面向對象的方式將資料庫系統中的各種功能對象化，將資料庫管理的各種功能封裝在各類對象中。它將一個應用系統當作是由一系列對象組成的，對每個對象它都定義一組方法和屬性，以定義該對象的行為和外國，用戶還可以按需要給對象擴展方法和屬性。通過對象的方法、屬性完成資料庫的操作和管理，極大地簡化了用戶的開發工作。同時，這種基於面向對象的開發方式，使得開發應用程序更為簡便。
（3）界面友好、易操作
Access是一個可視化工具，是風格與Windows完全一樣，用戶想要生成對象並應用，只要使用滑鼠進行拖放即可，非常直觀方便。系統還提供了表生成器、查詢生成器、報表設計器以及資料庫向導、表向導、查詢向導、窗體向導、報表向導等工具，使得操作簡便，容易使用和掌握。
（4）集成環境、處理多種數據信息
Access基於Windows操作系統下的集成開發環境，該環境集成了各種向導和生成器工具，極大地提高了開發人員的工作效率，使得建立資料庫、創建表、設計用戶界面、設計數據查詢、報表列印等可以方便有序地進行。
（5）Access支持ODBC（開發資料庫互連，Open
Data
Base
Connectivity），利用Access強大的DDE（動態數據交換）和OLE（對象的聯接和嵌入）特性，可以在一個數據表中嵌入點陣圖、聲音、Excel表格、Word文檔，還可以建立動態的資料庫報表和窗體等。Access還可以將程序應用於網路，並與網路上的動態數據相聯接。利用資料庫訪問頁對象生成HTML文件，輕松構建Internet/Intranet的應用。
用dreamweaver和visual
stdiou都可以建wap網站
⑩ access中查詢籍貫是山東和河北應該怎麼寫
access中查詢籍貫是山東和河北的SQL語句如下：
select * from 表 where 籍貫="貴州" or 籍貫="杭州"。
Access編寫SQL語句的方法：
首先打開Access，點擊頂部的創建，選擇查詢向導，如下圖所示
(10)省市區資料庫access擴展閱讀：
SQL的作用：
1、SQL 面向資料庫執行查詢
2、SQL 可從資料庫取回數據
3、SQL 可在資料庫中插入新的記錄
4、SQL 可更新資料庫中的數據
5、SQL 可從資料庫刪除記錄
6、SQL 可創建新資料庫
7、SQL 可在資料庫中創建新表
8、SQL 可在資料庫中創建存儲過程
9、SQL 可在資料庫中創建視圖
10、SQL 可以設置表、存儲過程和視圖的許可權