雖然這篇Recordset VBA鄉民發文沒有被收入到精華區：在Recordset VBA這個話題中，我們另外找到其它相關的精選爆讚文章
[爆卦]Recordset VBA是什麼？優點缺點精華區懶人包
你可能也想看看
搜尋相關網站
-
#1(Access) 的Recordset 屬性 - Microsoft Docs
Office VBA reference topic. ... 語法; 註解; 範例. 會傳回或設定ADO recordset 或DAO recordset 物件，代表指定之物件的記錄來源。 讀/寫物件。
-
#2Excel VBA 的眉眉角角Day28: SQL運用 - iT 邦幫忙
Excel VBA 的眉眉角角系列第28 篇 ... Excel可以透過VBA與SQL語言來進行資料運算，但使用上不如MS Access來的方便，雖然如此，對於 ... Recordset") vADODBConnection.
-
#3【Access VBA】 多倉庫Recordset 循環讀取資料的用法
【Access VBA】 多倉庫Recordset 循環讀取資料的用法 ... SUB 循環讀取紀錄() Dim strSQL As String '定義資料集物件RecordSet的物件變數 Dim rst As ADODB.
-
#4How to work with recordset (Dao) in MS Access - Code VBA
Tutorial on how to use DAO recordsets in MS Access - create a recordset, add or edit records, etcetera.
-
#5RecordSet - VBA Databases - BetterSolutions.com
The Recordset object is used to hold a set of records from a database table. When you first open a recordset, the currrent record pointer will point to the ...
-
#6ADODB Recordset - VBA for smarties
An ADODB Recordset in VBA is a storage item: you can store all kinds of different things in it: numbers, texts, dates. An ADODB Recordset is a database that you ...
-
#7Query timeout expired Excel VBA ADODB Recordset - Stack ...
The Open -method of your recordset already triggers the execution of the SQL-command. Your TimeOut -commands must be set before the command ...
-
#8Access VBA Recordsets - Open, Count, Loop and More
Access VBA Recordsets – Open, Count, Loop and More. In this tutorial, we will learn how to open a Recordset, count the number of records in the Recordset, ...
-
#9ADO Recordset Object - W3Schools
The ADO Recordset object is used to hold a set of records from a database table. A Recordset object consist of records and columns (fields).
-
#10Delete a record in access vba - Nayenne Vedove
Re: Delete record in access database with excel VBA Hi MSP77079, ... 2015-07-10 · Delete Record, Access VBA Recordset Jul 10, 2015 by azurous in Access.
-
#11Ado中Recordset记录集最全的属性方法事件说明(含脑图)
ADO (ActiveX Data Objects，ActiveX数据对象）是微软提出的应用程序接口，用以实现访问关系数据库中的数据, 在Access 及Excel VBA高级编程中会经常用到，而在Access中则 ...
-
#12RecordSet判斷是否有資料的觀念| topcat 姍舞之間的極度凝聚
常看到許多網友，在使用Recordset的時候，會出現這樣的錯誤. ADODB.Recordset (0x800A0BCD) 可能是BOF 或EOF 的值為True，或目前的資料錄已被刪除。
-
#1310+ mistakes to avoid when using VBA Recordset objects
The Recordset object is an essential component in Access development, but it often trips up even experienced developers.
-
#14Create a Recordset Based on a Parameter Query from VBA ...
Create a Recordset Based on a Parameter Query from VBA Code Problem You have a parameter query that is linked to a form by three parameters.
-
#15How to use VBA to get the correct number of records in a ADO ...
This article explains why the RecordCount property of ADO Recordset object returns -1 and how to get the correct count from it.
-
#16Microsoft Access tips: VBA Traps: Working with Recordsets
This article highlights ten common traps with DAO recordsets in VBA code. Most of the traps yield no syntax error; they are bugs lying dormant in your code ...
-
#17Access vba code examples download
Microsoft Access Database Modules and VBA Coding: Here you will find ... MS Excel VBA How To (7) Other (21) Queries (9) Recordset (3) Reports (8) Set ...
-
#18Retrieve data from Recordset by table column name - Java2s ...
Retrieve data from Recordset by table column name : Recordset « Access « VBA / Excel / Access / Word.
-
#19將Datatable轉換成Vba可接受的RecordSet類別
將Datatable轉換成Vba可接受的RecordSet類別. 2016-04-02 · C#. 由於目前工作地方大部分程式還是建構在EXCEL中，使用VBA撈取資料庫資料並做資料運算。
-
#20Disconnected Recordsets - Excel 2007 VBA - Visual Basic for ...
The Retrieving Data from Microsoft Access Using a Plain Text Query section mentioned that getting in and out of the database as quickly as ...
-
#21Find a Record in a Table-Type DAO Recordset - GitHub
All content in this repository has been migrated to a new repository (https://github.com/MicrosoftDocs/VBA-Docs). Please do not open issues or pull requests ...
-
#22Excel VBA SQL ADO Recordset Returning Old Cached Results
Hi, If anyone can provide a solution to this, it will be massively appreciated. I have written a number of VBA macros at work that perform ...
-
#23Delete Record, Access VBA Recordset - Software Solutions ...
In this article I will explain how you can delete a record from an Access table using the Recordset object in VBA.
-
#24VBA宏: adodb.RecordSet的属性和方法_bigheadsheep的专栏
为了更精确地跟踪数据，要用RecordSet组件创建包含数据的游标，游标就是储存在内存中的数据： rs = Server.CreateObject("ADODB.RecordSet") rs.
-
#25VBA Tutorial => Retrieving records with a query
Queries can be performed in two ways, both of which return an ADO Recordset object which is a collection of returned rows. Note that both of the examples ...
-
#26VBA Excel Looping through recordset and storing the data to ...
It is much faster to iterate over an array then a recordset. You should also pass the recordset to a function to return the dictionary.
-
#27Looping Through a Recordset | Access All In One
In this blog post we will be demonstrating how to loop through a recordset. Recordsets act like a cursor or a ruler underneath a row of data.
-
#28Closing a recordset in VBA - Microsoft Access / VBA - Bytes ...
You do need to close recordsets. Setting the variable to Nothing is less important, but recordsets need to be closed. Another thing to avoid is ...
-
#29Create a blank (not disconnected) recordset in VBA/Access ...
Create a blank (not disconnected) recordset in VBA/Access (without RDS)?. 5 posts. Maxer. Ars Legatus Legionis. Tribus: Under the spreading ...
-
#30Открытие Recordset в ADO/VBA - AskIt.RU
9.5 Объект Recordset и коллекция Fields. 9.5.1 Открытие Recordset. Открытие Recordset, метод Open(), передача запроса при открытии Recordset.
-
#31How do I query a recordset object in VBA? - access ...
I am working solely in the VBA environment and would like to perform an automated process that returns a recordset based on the results of a ...
-
#32VBA與資料庫解決方案：Recordset記錄集合的動態查詢
VBA 與資料庫解決方案：Recordset記錄集合的動態查詢，並顯示結果. 2019-06-06 由 VBA專家 發表于程式開發. 大家好，今日繼續講解VBA與資料庫解決方案的第10講內容， ...
-
#33How to Use Recordset in MS Access - iAccessWorld.com
A recordset is a data structure that consists of a group of database records, and can either come from a table, query or SQL.
-
#34學習ADODB..1 - Excel VBA應用的部落格- 痞客邦
要和Access搭配在Excel VBA中需使用ADODB來連結Access資料庫中的資料到Excel ... 其中宣告Connection給變數myCon，Recordset給變數myRs，變數名稱可以 ...
-
#35Different ways of Reading RecordSet Object in Excel Macro
Excel VBA to Copy RecordSet in Excel. Read RecordSet through loop in Excel VBA. How to get Column names from your RecordSet in Excel VBA. VBA Code to Copy ...
-
#36Excel VBA+ADO+SQL入門教程025：將記錄集轉換為數組
我們使用Connection對象創建對數據庫的鏈接，然後使用SQL語句向數據庫提交查詢，此時ADO將查詢結果儲存在Recordset對象中，我們則可以使用Recordset對象的 ...
-
#37VBA CopyFromRecordset Range in Excel with Examples
CopyFromRecordset of Excel VBA Range method can be used if you want to copy the data from a record set. When we deal with data bases using ADO or DAO, ...
-
#38Recordset.AddNew方法@ Excel VBA Comics - 添加紀錄演示
除了用SQL INSERT敘述增加資料的紀錄外，我們亦可以直接使用Recordset的AddNew方法來添加紀錄，接著使用Update方法來寫入紀錄。 物件類別模組- clsADODBopen 請 ...
-
#39VBA Code to Export Access Recordset to Excel - ExcelSirJi
VBA Code to Export Access Recordset to Excel ... Creating a VBA tool in MS Access is always better as compare to MS Excel. MS Access provides better user ...
-
#40VBA Recordset: How to Handle Sets of Records Easily
A recordset is a structure which stores a group of records in a database. These records could be the result of a query or the contents of an individual table.
-
#41Where should I use “!” in VBA and why is it used with recordset?
In Excel VBA, you most commonly encounter ! when trying to write code to run a macro from another workbook, or when you are trying to build worksheet ...
-
#42VBA動態顯示Recordset對象記錄 - 多源焦點
這套教程共兩冊，八十四講，今後一段時間會給大家陸續推出修訂後的教程內容。今日的內容是第16講：VBA動態顯示Recordset對象記錄。
-
#43Recordset Builder for ADO and DAO - FMS, Inc.
Writing the VB6/VBA code to open a database and create a recordset on a table or query/view is very commonplace, yet complex and tedious.
-
#44How to output data from an ADO-Recordset-Column as ...
Access/VBA - How to output data from an ADO-Recordset-Column as comma separated string using local sorting and filtering.
-
#45通俗易懂的，Recordset.GetRows的用法讲解-Excel VBA程序开发
通俗易懂的，Recordset.GetRows的用法讲解Excel VBA程序开发,ExcelHome技术论坛.
-
#46Excel VBA tip 7: Create a recordset based on 2 different ...
... time when processing data in Excel VBA. In this post, you'll learn how to create a recordset based on data from 2 different worksheets.
-
#47VBA (Excel) Assign ADODB RecordSet to a Variable - Toolbox
I am fairly new to VBA and I've learned a lot throughout forums but I'm stuck at passing the ADODB Recordset to a Variable in VBA.
-
#48VBA Recordset Cursor type | Chandoo.org Excel Forums
Hi, I'm using excel 2010 - 32 bit version This is my first of encounters with VBA... supporting an existing application :) My VBA code thats ...
-
#49Excel VBA Part 56.2 - Get Data from SQL Server with ADO ...
You'll learn how to write a connection string to connect to a SQL Server databse and how to use a recordset to retrieve data. You'll learn how ...
-
#50Solved: VBA - Sending large recordset to text file - Experts ...
Find answers to VBA - Sending large recordset to text file from the expert community at Experts Exchange.
-
#51Search Code Snippets | vba create ADO recordset from table
Hmm, looks like we don't have any results for this search term. Try searching for a related term below. or. Browse Code Snippets. Related Searches.
-
#52Insert From Excel Recordset to SQL Server table
Can I insert the whole recordset at once like "Insert into Customer_info Select * from " & Rst in Excel VBA? Thanks. Replies continue below ...
-
#53如何在VBA程序中將窗体的Recordset 對象賦值給變量。如何綁 ...
上海,Access,編程,,有些朋友使用以下代碼總是出錯[CGCODE]Dim Rst As New ADODB.Recordset Rst = Me.Recordset Rst = Me.RecordsetClone[/CGCODE]現在 ...
-
#54How To Use For...Each On A Recordset - Wrox - Wiley
Welcome to the p2p.wrox.com Forums. You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a ...
-
#55MS Access Using DAO Recordsets
Programming in Excel and MS Access VBA, Crystal Reports, C#, ASP .NET, SSIS, T-SQL languages.
-
#56How To Write A Recordset To File With VBA | - Search ...
In this video you'll find out how to write a recordset to a file with VBA using the Microsoft Scripting Object. You'll find out how to take your table data, ...
-
#57Display every row in a table (recordset) - Access: VBA - LinkedIn
Database tables store the data you use to perform your analysis. In this video, learn how to display every row in a table (recordset).
-
#58Create In-Memory ADO Recordsets - Database Journal
Creating in-memory ADO recordsets may be a solution in search of a problem, but I find the process fascinating and there's been at least one ...
-
#59Recordsetオブジェクト（ADO）を使ってレコードを追加する
12/1 VBAセミナー情報、更新！ 12/1 12月の書籍プレゼント受付スタート · 11/1 VBAセミナー情報、更新！ 一覧 ...
-
#60Thread: VB/VBA - Null and ADO Recordset.Filter - VBForums
VB/VBA - Null and ADO Recordset.Filter. If you look at the documentation on the ADO Recordset's Filter property you won't find a way to ...
-
#61Recordsets - Macoratti.net
Trabalhando com Recordsets - Alterando e Retornando dados. O objeto Recordset esta presente tanto na DAO como na ADO. Lembre-se que um Recordset representa ...
-
#62AccessVBAの基本
Recordset オブジェクトを使うと、レコードセットの性質を指定してテーブルを開けます。レコードセットの性質をカーソルタイプといいます。ADOのRecordsetオブジェクトには ...
-
#63types de Recordset - Définition et manipulation de données ...
Depuis Access et VBA, il est possible d'utiliser plusieurs méthodes afin d'ouvrir un jeu d'enregistrements. 5-2-1. Depuis un objet Database△. L'objet Database ...
-
#64レコードセット(ADODB.Recordset)の使い方
Recordset )の使い方について簡単に記載します。 レコードセット？ VB6 のレコードセットは、データベースから SQL でデータを取得するときに使用したり ...
-
#65ADO(ActiveX Data Objects)の使い方の要点｜VBA技術解説
Recordset の取得方法. ADODB.ConnectionのExecuteメソッド. 最初のサンプルVBAで使っている方法です。 Set recordset ...
-
#66EXCEL VBA で、RecordSet を使いまわしする - 徒然草
今回も先日に続き EXCEL VBA についてです。 シートのデータを RecordSet に取り込んで利用されている方も多いかと思います。 Dim dbRes As ADODB.
-
#67Creating ADO Objects | iFIX 6.1 Documentation | GE Digital
Example: Creating an ADO Record set. 'General Declarations. Dim conODBC As ADODB.Connection. 'This stores the link to the database. Dim adoRS As ADODB.
-
#68[VBA] Parcourir les champs d'un RecordSet (mais pas ...
VBA Access : [VBA] Parcourir les champs d'un RecordSet (mais pas commencer au premier champ). dalmasma, le 25/07/2007 à 10h00#1. Bonjour,
-
#69Building a searchable Userform using a Recordset - XcelanZ
In my previous post How to create a disconnected recordset I showed how to create a disconnected ... Retrieving Access Data with VBA.
-
#70從ADODB.recordset設置表單的VBA記錄集時出錯- 優文庫
我已經使用MS Access 2010中的VBA創建了一個函數來執行SQL Server存儲過程並在ADODB.Recordset對象中返回值。但是，我無法使用從ADODB連接返回的記錄集來設置MS Access ...
-
#71Vba query sql database
vba query sql database I have an Excel file which have a data and a table in sql server 2000. After that i need to create tables/views from the recordset ...
-
#72Vba ldap query
Use VBA to get the correct number of records in a Recordset object: 15. Do Not Sell My Personal Information. Select the option to use Query Wizard to ...
-
#73Access 2003 VBA Programmer's Reference
Opening a recordset is easy, using either DAO or ADO (for more details about ... modify the SQL statement in VBA code, for example like this: Set rec = db.
-
#74Adodb connection timeout vba - Verofax
RE: Timeout Expired with ADO connection. recordset 等效 的 版本 ？ mysql excel vba macos Mysql thigvfpy 7个月前 预览 (151) 7个月前 VBA ADO Update Query VBA ...
-
#75Ms access vba update record in table Ms access vba update ...
MS Access VBA – List the Tables in a Database. ... Jul 13, 2016 · How to Update Data with RecordSet in MS Access You can update the existing ...
-
#76Ms access vba refresh form Ms access vba refresh form Ms ...
How would I do this with VBA in the Update form Close event? ... creates a unique bookmark for each record in a form's recordset when a form is opened, ...
-
#77Vba query sql database - crystal99
3 I have the below code, which queries a database and compares the recordset against my variable 'StockCode'. I have written a SQL VBA SQL Library ...
-
#78Retrieving Data into Excel | Absolute Beginners Guide to VBA
Retrieving One or More Entire Rows. To get full records, use the Recordset object's GetRows method: Recordset .GetRows Rows, Start, Fields ...
-
#79Recordsetに高速でデータを追加する方法 - Excelが大好きだ！
VBA から表のデータをまとめて操作する方法としては配列が挙げられる。 ところが最近空のRecordsetを使用する方法があることを知って勉強しようと思っ ...
-
#80Recordset | Akademia VBA
Od 2000 roku czyli już od kilkunastu lat Microsoft Office może bez problemu łączyć się w zasadzie z dowolnymi bazami danych, ...
-
#81Excel 2003 VBA Programmer's Reference - 第 213 頁 - Google 圖書結果
Prior to opening the Recordset object, you can use the ActiveConnection property to assign an existing Connection object to the Recordset or a connection ...
-
#82Beginning Access 2003 VBA - 第 137 頁 - Google 圖書結果
The Recordset object has various methods that allow you to navigate among the records, assuming of course that the recordset is set to a CursorType that can ...
-
#83ADO ¿Dónde y cómo visualizaremos los datos en nuestro ...
El objeto RecordSet será nuestro gran aliado en esta etapa. ... que entendamos que pasará cuando le pidamos al servidor datos mediante VBA.
-
#84Ms access save record button vba Ms access save record ...
Nov 09, 2012 · Force save record in VBA code I have a form that is bound to a table. yourfieldname) =" & me. create a macro to export the record set.
-
#85VBA and SQL Server – Excel kitchenette
After defining the string, we make a new connection and a recordset, and further we need to execute the desired SQL query using the Execute ...
-
#86Access vba apply filter to query Access vba apply filter to ...
VBA Code to AutoFilter Excel Table by Column Header Name. Use Recordset filter. ... Recordset Filter. field1 LIKE 'asdf*' AND myQuery. A filter in Excel, ...
-
#87Access macro to delete all records in a table
htmlThis tutorial teaches you how to Add, Edit, Access VBA Recordsets – Open, Count, Loop and More In this tutorial, we will learn how to open a Recordset, ...
-
#88Ms access vba refresh form - maagalim.biz
An alternate syntax for VBA only, is written like: Forms("frmMain"). ... the form by settings its Recordset property to a Recordset you created in VBA code.
-
#89Record delete
Click the zone for which you want to delete the resource record set. ... htmlThis tutorial teaches you how to Add, Edit, Access VBA Recordsets – Open, ...
-
#90Recordset.Edit oder Update sql vba Anweisung schnellste ...
Ich bin kürzlich auf vba-Aktualisierungsanweisungen gestoßen und habe Recordset.Edit und Recordset.Update verwendet, um meine vorhandenen Daten nicht nur zu ...
-
#91Vba queries object
Recordset rst. NET through DAO or ADO. Enter the Class Name, choose Visual C# or Visual Basic output, and click Generate. If the amount of data is large and ...
-
#92Access vba filter Access vba filter Access vba filter In VBA ...
This Excel VBA tutorial explains how to automate AutoFilter to filter value and then copy data to new ... Jun 11, 1999 · Help with Access VBA recordset.
-
#93Microsoft Office Access 2007 VBA - 第 279 頁 - Google 圖書結果
All Recordset objects have a cursor, which marks the current record. The functionality of the Recordset, as well as the visibility of record modifications, ...
-
#94Excel query access database with parameter
I am trying to use this VBA code to pass a SQL stored procedure multiple ... Recordset Set db = CurrentDb ( ) ' Open the form to collect the parameters.
-
#95Vba code library for access - Voomnet
Oct 06, 2013 · VBA code for running access queries Both macros below use the ... Jul 10, 2015 · VBA Access Recordset, Object Library; VBA Access ADOX.
-
#96Vba query sql database
vba query sql database XLTools SQL Queries add-in enhances Excel with the power of ... 2 - Get Data from SQL Server with ADO Recordsets; Excel VBA Part 56.
-
#97Vba getfilename
This Excel VBA Tutorial explains, how to get Filename from path and file ... Dim Recordset As Recordset Set Recordset = New Recordset Call Recordset. XLS!
recordset 在 吳老師教學部落格 Youtube 的精選貼文
TQC ASP 互動式網頁設計線上影音教學
課程名稱
00安裝IIS
00安裝ASP練習系統
00開啟練習檔與參考解答
00設定資料庫可讀寫的權限
00設定102流程
00其他相關設定
第一類 表單與Request 物件
101 星座個性
102 學生註冊系統 [完成]
103 教師授課日表查詢系統
104 電子賀卡選擇系統 [完成]
105 首頁產生器
106 電子郵件檢查 [完成]
107 會員資料查詢
108商品資料查詢
109 會員資料新增表單
110 線上益智測驗
第二類 Application、Session、、Server物件Cookies
201 網頁拜訪紀錄
202 寵物飼養
203 學習系統登錄
204 人氣手機票選
205 網路電子書問卷調查
206 聊天室
207 地理教學測驗系統
208 社群聊天室
209 學生作品評分系統
210 網路購物商店
第三類 資料庫應用與RecordSet物件
301 DVD影片新增系統
302 通訊錄資料刪除
303 房屋仲介資料更新
304 地震題庫測驗系統
305 學生基本資料分頁查詢系統
306 留言板製作
307 商店售價管理系統
308 股票行情表
309 世足賽票選活動
310 心情留言
第四類 結構化資料查詢語言
401產品資料查詢
402 通訊錄資料新增
403 書籍售價查詢系統
404 線上書籍查詢系統
405 親親旅遊管理系統
406 學生聯絡資料庫查詢系統
407 會員資料庫新增及刪除系統
408 教師資料庫新增及修改系統
409 薪資調整系統
410 線上購物系統
recordset 在 吳老師教學部落格 Youtube 的最讚貼文
TQC ASP 互動式網頁設計線上影音教學
課程名稱
00安裝IIS
00安裝ASP練習系統
00開啟練習檔與參考解答
00設定資料庫可讀寫的權限
00設定102流程
00其他相關設定
第一類 表單與Request 物件
101 星座個性
102 學生註冊系統 [完成]
103 教師授課日表查詢系統
104 電子賀卡選擇系統 [完成]
105 首頁產生器
106 電子郵件檢查 [完成]
107 會員資料查詢
108商品資料查詢
109 會員資料新增表單
110 線上益智測驗
第二類 Application、Session、、Server物件Cookies
201 網頁拜訪紀錄
202 寵物飼養
203 學習系統登錄
204 人氣手機票選
205 網路電子書問卷調查
206 聊天室
207 地理教學測驗系統
208 社群聊天室
209 學生作品評分系統
210 網路購物商店
第三類 資料庫應用與RecordSet物件
301 DVD影片新增系統
302 通訊錄資料刪除
303 房屋仲介資料更新
304 地震題庫測驗系統
305 學生基本資料分頁查詢系統
306 留言板製作
307 商店售價管理系統
308 股票行情表
309 世足賽票選活動
310 心情留言
第四類 結構化資料查詢語言
401產品資料查詢
402 通訊錄資料新增
403 書籍售價查詢系統
404 線上書籍查詢系統
405 親親旅遊管理系統
406 學生聯絡資料庫查詢系統
407 會員資料庫新增及刪除系統
408 教師資料庫新增及修改系統
409 薪資調整系統
410 線上購物系統
recordset 在 吳老師教學部落格 Youtube 的最佳解答
TQC ASP 互動式網頁設計線上影音教學
課程名稱
00安裝IIS
00安裝ASP練習系統
00開啟練習檔與參考解答
00設定資料庫可讀寫的權限
00設定102流程
00其他相關設定
第一類 表單與Request 物件
101 星座個性
102 學生註冊系統 [完成]
103 教師授課日表查詢系統
104 電子賀卡選擇系統 [完成]
105 首頁產生器
106 電子郵件檢查 [完成]
107 會員資料查詢
108商品資料查詢
109 會員資料新增表單
110 線上益智測驗
第二類 Application、Session、、Server物件Cookies
201 網頁拜訪紀錄
202 寵物飼養
203 學習系統登錄
204 人氣手機票選
205 網路電子書問卷調查
206 聊天室
207 地理教學測驗系統
208 社群聊天室
209 學生作品評分系統
210 網路購物商店
第三類 資料庫應用與RecordSet物件
301 DVD影片新增系統
302 通訊錄資料刪除
303 房屋仲介資料更新
304 地震題庫測驗系統
305 學生基本資料分頁查詢系統
306 留言板製作
307 商店售價管理系統
308 股票行情表
309 世足賽票選活動
310 心情留言
第四類 結構化資料查詢語言
401產品資料查詢
402 通訊錄資料新增
403 書籍售價查詢系統
404 線上書籍查詢系統
405 親親旅遊管理系統
406 學生聯絡資料庫查詢系統
407 會員資料庫新增及刪除系統
408 教師資料庫新增及修改系統
409 薪資調整系統
410 線上購物系統