Course OutlineModule 1: Essentials of Microsoft Visual BasicLessons - Understanding Microsoft Visual Basic-based development
- Creating an application
- Debugging and error handling
- Compiling an EXE file
- Overview of the State University Bookstore application
Lab : Lab:After completing this chapter, students will be able to: Use Visual Basic to create a simple application and an executable file for users. List the files that comprise a Visual Basic-based application. Use the Visual Basic debugging tools. Add run-time error handling to a procedure.
Module 2: Using Visual Data Access ToolsLessons - Universal data access
- Connecting to a data source
- Getting data from a connection
- Organizing data
- Presenting data
Lab : Lab:- Using visual data access tools
After completing this chapter, students will be able to: Describe the visual data access tools that come with Visual Basic. Use the visual data access tools to create a connection to a data source and access data from the connection in an application. View the structure of a database using the Data Environment designer and the Data View window. Create database queries using Query Builder. Create data-bound forms using the Data Environment designer, Data Form Wizard, and the ADO Data control. Create a report using the Data Report designer.
Module 3: Using Class ModulesLessons - Designing an application
- Creating class modules
- Adding properties, methods, and events
- Using a class module
- Creating data-bound class modules
Lab : Lab:After completing this chapter, students will be able to: Explain the benefits of using class modules in an application. Use a class module to create a COM component within a Visual Basic project. Create a COM component that exposes properties, methods, and events. Create and use data-bound class modules.
Module 4: Building ActiveX ControlsLessons - Creating an ActiveX control
- Exposing properties, methods, and events
- Testing a control
- Creating property pages
- Creating a data-bound control
- Creating a data source control
Lab : Building an ActiveX controlLab : Data-binding an ActiveX controlAfter completing this chapter, students will be able to: Describe the benefits of using ActiveX controls. Create an ActiveX control that exposes properties, methods, and events. Use control events to save and load persistent properties. Test and debug an ActiveX control. Create and enable property pages for an ActiveX control. Enable the data-binding capabilities of an ActiveX control. Create an ActiveX control that is a data source.
Module 5: Using ActiveX Data ObjectsLessons - Overview of ActiveX Data Objects (ADO)
- Handling data access errors
- Connecting to a data source
- Retrieving data from a data source
- Sorting and searching data
- Updating data
- Using disconnected data
- Creating dynamic record sets
- Understanding performance considerations
Lab : Lab:After completing this chapter, students will be able to: List the major components of the ADO object model. Explain how to handle errors using ADO. Connect to a data source using ADO. Use an ADO record-set object to retrieve and manipulate data. Describe and use a disconnected record set. Use an ADO record-set object to store nondatabase data.
Module 6: Advanced Data Access IssuesLessons - Overview of Microsoft SQL Server security
- Using cursors
- Enforcing data integrity
- Executing statements on a database
Lab : Lab:- Advanced data access issues
After completing this chapter, students will be able to: Discuss SQL Server security implementations. Describe different cursor locations and when to use a specific cursor type. Use a stored procedure to execute a statement on a database. Handle referential integrity errors. Describe ways to enforce data integrity.
Module 7: Using COM ComponentsLessons - Introduction to using COM components
- Creating a client application
- Using Microsoft Internet Explorer
Lab : Lab:After completing this chapter, students will be able to: List the main steps required to use an external COM component in a Visual Basic-based application. Create a Visual Basic-based client application that uses a COM component. Create a Visual Basic-based application that handles events from a COM component. Create a Visual Basic-based applica-tion that automates Internet Explorer.
Module 8: Building COM ComponentsLessons - Introduction to COM components
- Creating COM components
- Creating an object model
- Adding error handling
Lab : Lab:After completing this chapter, students will be able to: Compile a project with class modules into a COM component. Create an object model in a COM component. Debug and test a COM component.
Module 9: Optimizing and Deploying an ApplicationLessons - Optimizing an application
- Deploying an application
- Deploying an ActiveX control
Lab : Lab:- Deploying the StateUBookstore solution
After completing this chapter, students will be able to: Describe a variety of techniques for optimizing the performance of an application. Use the GetSetting and SaveSetting statements to save application-specific information to the registry. Use resource files. Create a Setup program using Package and Deployment Wizard. Package an ActiveX control for use on a Web site.
Module 10: Building Internet ApplicationsLessons - Using the WebBrowser control
- Creating Active Documents
- Creating dynamic hypertext markup language (DHTML) applications
- Creating Microsoft Internet Information Server applications
After completing this chapter, students will be able to: List the ways Visual Basic can enhance a Web site. Create applications that use the WebBrowser control. Explain what Active Documents are. Create an Active Document. Use the DHTML Page designer to create client-side code components. Use the Webclass designer to create server-side code components.
|
| |
