* Describe the differences between relational
and non-relational databases and create new databases using the
VisData manager.
* Write SQL statements and use them to manage
your data.
* Define the Universal Data Access (UDA)
paradigm, and explain how the ActiveX Data Objects (ADO) data access
model and OLE DB embody UDA.
* Use the ADO Data Control with data aware
controls to create Recordsets and to display and manipulate data,
and use the Data Form Wizard to build data access forms.
* Use the tools of the Data Environment
designer and the Data Project template to create ADO Command objects
and Recordsets and to manipulate data.
* Write ADO code that permits you to create
Connection, Command and Recordset objects, and to create a simple
data application that allows the user to manipulate data.
* Access the Data Report Designer in the Data
Environment, create a data report, display it in a browser, and
print it in hard copy form.
* Design a simple data hierarchy, describe the
Data Access Objects (DAO) data access model, and compare the ADO and
DAO models.
* Write the DAO code to create a database,
design a data access application and use the application to manage
data.
* Determine the right time to upgrade or
migrate legacy applications and begin to write the ADO code to
manage these changes.
