Describe the components of a relational database. Explain how data is accessed and manipulated in a relational database. Explain the role that SQL plays in a Visual Basic client tool that is used to access databases. Using the proper syntax and structure, write SQL script to retrieve, modify, and delete data in a database. Connect to a data source and create data-bound forms using the Data Environment Designer. Create data-bound forms using the Data Form Wizard or the ADO Data Control
Unit 1: Introduction to Databases
- Database Concepts
- Accessing and Manipulating Data
- Database Interoperability
Unit 2: Introduction to SQL
- SQL Programming Essentials
- Retrieving Database Data
- Modifying Database Data
Unit 3: Using Data Controls in Visual Basic
- Understanding Data Controls
- Connecting to a Database
- Creating Commands
- Displaying Recordsets in Forms