Profile

e-Catalog

Contact

Search

Cart

Microsoft Visual C++ 5.0: Developing MFC Applications - Database Applications

Audience

Application developers, system analysts, database and system administrators, and information managers who are responsible for implementing sophisticated C++ applications using MFC, ATL, and COM technologies

Prerequisites

Completion of all preceding content in the Microsoft Visual C++ 5.0: Developing MFC Applications curriculum; basic C++ programming skills or completion of the C++ Programming curriculum; familiarity with object-oriented programming concepts or completion of the courses on object-oriented techniques; a sound knowledge of the Windows Operating System Architecture; familiarity with the Microsoft Internet Explorer interface an advantage

Course Aim

To familiarize the student with the MFC ODBC and DAO database classes, and to demonstrate how to use these classes to access and query database applications

Learning Objectives

Provide an overview of the ODBC and DAO APIs. Discuss MFC database classes. Describe recordsets and discuss how transactions are used to update them. Create an ODBC application using AppWizard. Explain how to connect a recordset to dialog box controls. Explain how to join and build a recordset from several different data sources. Outline how to build and customize a query. Discuss querydefs and stored queries. Outline how to search for records within a recordset. Explain how to implement advanced database techniques using DAO classes.

Topics Covered

Data access with MFC - Introduction to data access - MFC database classes - Recordsets and transactions Developing database applications - Creating an ODBC application - Hands-on: Creating a database application - Structure of a database application - Connecting the recordset to controls - Creating a joined recordset Querying the database - Customizing a query - Querydefs and parameterized queries - Seek and Find functions - Hands-on: Locating records using Seek Advanced database techniques with DAO - Moving through the recordset - Data manipulation - Creating a database - Accessing external databases