【正文】 通過使用 Visual Basic 的 控件 報表是一個 ACCESS 對象設(shè)計來顯示數(shù)據(jù)其作用類似于窗體但主要是用于數(shù)據(jù)打印不能輸入數(shù)據(jù) 數(shù)據(jù)庫是一個包含各種 ACCESS 對象 表查詢窗體報表宏和模塊 的文件ACCESS 中所有工作都是建立在此基礎(chǔ)之上的 表是存放數(shù)據(jù)的容器被設(shè)計成行和列的格式就像電子表中的那樣每一列叫做一個字段包含特定類型的信息 如姓名或?qū)W歷每一行稱為一個記錄包含與單個實體有關(guān)的所有信息如某個員工的姓名性別所在部門學(xué)歷等對于像 ACCESS 這樣的關(guān)系數(shù)據(jù)庫管理程序一個數(shù)據(jù)庫通常包含幾個存放相關(guān)數(shù)據(jù)的不同表 頁是一種特殊類型的窗體它使用戶能夠利用 Web 瀏覽器查看和編輯ACCESS 的表 通過使用由 Visual Basic 提供的專用的直接與數(shù)據(jù)庫相連的接口聚簇功能許多關(guān)系型 DBMS 都提供了聚簇功能即為了提高某個屬性或?qū)傩越M 的查詢速度把在這個或這些屬性上有相同值的元組集中存放在一個物理塊中如果存放不下可以存放到預(yù)留的空白區(qū)或鏈接多個物理塊 第四章 系統(tǒng)實現(xiàn) 41 系統(tǒng)功能實現(xiàn) 用戶登陸實現(xiàn) 正確輸入用戶名和密碼才能成功登陸用戶管理系統(tǒng)主界面登陸成功將顯示登陸信息 在工程引用 ADO20 在命令按鈕單擊寫下連接數(shù)據(jù)庫 USER 表的判斷語句 Private Sub Command1_Click denlu_name Text1Text denlu_pass Text2Text Dim my As New ADODBConnection Dim myrs As New ADODBRecordset Set myrs New ADODBRecordset myOpen Provider MicroData Source rsglmdb myrsOpen SELECT FROM [user] where useruser denlu_name my adOpenKeyset adLockOptimistic If myrsBOF True And myrsEOF True Then MsgBox 查無此人 登陸信息 Else If myrs pass denlu_pass Then MsgBox ok 登陸信息 Form2Show Unload Me Else MsgBox 密碼不正確 登陸信息 End If 目的是 USER 表沒有該用戶將無法使用本程序 主界面的實現(xiàn) 用戶成功登陸隨即進入主界面 主界面包含方面的內(nèi)容以下 SELECT useruser userpass FROM [user]篩選出全部記錄 用 DATA GRID 控件將 它的數(shù)據(jù)源設(shè)為 ADO 控件將它的各列顯示出數(shù)據(jù)庫的各列屬性設(shè)為可寫 Private Sub Command1_Click On Error Resume Next Adew 添加記錄 End Sub Private Sub Command2_Click On Error Resume Next Adte 刪除記錄 End Sub[1] Bob Reselman Richard PeasleyWayne Pruchniak 編著《 Visual Basic 60 使用指南 Craig Eddy Timothy Buchanan 中文 ACCESS 2021 24 學(xué)時教程 機械工業(yè)出版社邱振昆 ACCESS 的應(yīng)用 ACCESS2021 疑難解析劉炳文 Visual Basic 60 中文版 Visual Basic 60 程序設(shè)計實用教程 清華大學(xué)出版社美 Rick DobsonVisual Basic 與 ACCESS 數(shù)據(jù)庫開發(fā) 清華大學(xué) 門 中國財政經(jīng)濟出版社夸克霍停車場車輛管理策劃 平 申莉莉數(shù)據(jù)庫系統(tǒng)與 ACCESS 教程 清華大學(xué)出版社 Visual Basic 60 使用指南這是一本詳細講解如何使用VisualBasic60 進行編程的英文原版教材該書使用面向?qū)ο笫录?qū)動的VisualBasic60 語言采用任務(wù)驅(qū)動的方式向?qū)W生講解編程的概念激發(fā)學(xué)生對于基于 Windows應(yīng)用程序的熱情讓學(xué)生理解如何充分利用 VisualBasic的強大功能學(xué)會編寫實際工作中會遇到的應(yīng)用程序書中強調(diào)了設(shè)計技巧如訪問數(shù)據(jù)庫中的信息創(chuàng)建與打印報表引用對象使用 OLE 等此外該書向?qū)W生簡介了面向?qū)ο缶幊碳夹g(shù)以及 VisualBasicNET 的最新功能作為教材書中提供了大量的練習(xí)題并提供有教輔材料另外在隨書光盤中提供有專為本教材定制的 VisualBasic60 軟件 中文 ACCESS 2021 24 學(xué)時教程 ACCESS2021 疑難解析 ACCESS2021 的必備書書中列舉了使用 ACCESS2021時所遇到的常見疑難問題及解答全書共分 16章每一章都包含了 ACCESS2021 一個特定方面的問題和解答本書按相應(yīng)的主題由淺入深地提出問題并解答可作為學(xué)習(xí)和使用 ACCESS2021 的入門指南 PDF 格式 e Calvin said Cirocco glanced at him got a glimpse of his brown eyes before he turned back to his work That was my thought A real big fusion ramscoop The machinery is in the hub electromagic field generators to funnel the interstellar hydrogen into the center where it gets burned Gaby shrugged Makes sense But what about docking Well leaving the thing would be easy enough just drop out a hole in the bottom and get escape velocity for free plus some to fool around with But there ought to he some sort of dingus that would telescope out to the center of rotation when the engine isnt running to pick up scout ships The main engine has to he there The only other way would be to space engines around the rim Id want three at least More would be better nd girls dorms but you saw everybody in the rec room and the dining hall and so on and she was in my psychodrama group Her hair had been black and shiny as the lacquered furniture in Dr Hongs rooms her skin white like motherofpearl her eyes long and narrow making him think of cats eyes and darkly blue She was fifteen or so Nicholas believedmaybe sixteen Im going home she told him It was psychodrama and he was her brother younger than she and she was already at home but when she said this the floating ring of light that gave them the necessary separation from the small doctorandpatient audience ceased by i And when I was there it rained There was a big trouble at one of the generating piles and they shut it _ down and it got colder and colder until everybody in the hospital wore their blankets just like Amerinds in books and they locked the switches off on the heaters in the bathrooms and the nurses and the screen told you all the time it wasnt dangerous they werejust rationing power to keep from blacking out the important stuff that was still running And then it rained just like on Earth They said it got so cold the water condensed in the air and it was like the whole hospital was right under a shower bath Everybody on the top floor had to e down because it rained right on their beds and for two nights I had a man in my room with me that had his arm cut off in a machine But we couldnt jump any higher and it got kind of dark It doesnt always get dark here Diane said Sometimes the rain sparkles I think Dr Island must do it to cheer everyone up No the waves explained or at least not in the way you mean Diane Nicholas was hungry and started to ask them for something to eat then turned his hunger in against itself spat on the sand and was still es I never met any one of his class who remembered him They did not even remember that he was middleweight boxing champion I mistrust all frank and simple people especially when their stories hold together and I always had a suspicion that perhaps Robert Cohn had never been middleweight boxing champion and that perhaps a horse had stepped on his face or that maybe his mother had been frightened or seen something or that he had maybe bumped into something as a young child but I finally had somebody verify the story from Spider Kelly Spider Kelly not only remembered Cohn He had often wondered what had bee of him Robert Cohn was a member through his father of one of the richest Jewish families in New York and through his mother of one of the oldest At the military school where he prepped