Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Microsoft Visual Basic 6.0 Desktop: Introduction to Data Access |
| Course Status: | Released |
| Course Language: | English |
| Course Duration: | 4 Hours |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
| Audience |
| Visual Basic 6.0 developers and web applications developers |
| Prerequisites |
| A good knowledge of Visual Basic programming principles; a knowledge of relational database design principles; some knowledge of SQL would be an advantage |
| Course Aim |
| To show how to use the ActiveX Data Object (ADO) model and the ADO Data control to access and manipulate a data source |
| Learning Objectives |
| Use the new Visual Data Access tools in Visual Basic 6.0. Connect to a data source. Retrieve data from a data source. Display and manipulate data with the ADO Data control. Use ADO to sort, search, update, and delete data. Use disconnected data. Create dynamic Recordsets. Identify relevant performance considerations. |
| Topics Covered |
| Visual data access tools - The Data Environment designer - The Data View window - Using Query Designer - Creating data-bound forms - Using the Data Report designer Introduction to ActiveX Data Objects - The ADO object model - Using ADO for database access - Displaying and manipulating data - The ADO Data control Programming with ADO - Working with Recordset data - Editing and updating records - Disconnected and dynamic Recordsets - ADO performance considerations Hands-on: Using the ADO Data control - Live application tutorial - Connecting to a database - Viewing and editing data |