|
|
|
Module 1: Essentials of Microsoft Visual Basic
- Understanding the Visual Basic development
- Creating, testing, debugging and compiling an application
- Overview the State University Bookstore application
Skills
- Use Visual Basic to create and compile a simple application
- List the files that comprise a Visual Basic-based application
- Use Visual Basic debugging tools
- Write run-time error handlers
Top |
|
Module 2: Using Visual Data Access Tools
- Understand Universal Data Access
- Connecting to a data source
- Getting data from a Connection
- Organizing and presenting data
Skills
- Create a report using the Data Report Designer
Top |
|
|
Module 3: Using Class Modules
- Designing an application
- Creating class modules
- Adding Properties, Methods, and Events
- Creating data-bound class modules
Skills
- Understand the benefits of using class modules in an application
- Use a class module to create a COM object within Visual Basic
- Create COM objects exposing properties, methods, and events
- Create/use data-bound classes
Top |
|
Module 4: Building ActiveX Controls
- Creating and testing an ActiveX control
- Exposing properties, methods, and events
- Creating property pages
- Creating a data-bound control
- Creating a data source control
Skills
- Describe the benefits of using ActiveX controls
- Create ActiveX controls exposing Properties, Methods, and Events
- Use control events to save and load persistent properties
- Test and debug ActiveX controls
- Create and enable Property Pages for an ActiveX control
- Enable data-binding capabilities of an ActiveX control
- Create an ActiveX control as a data source
Top |
|
|
Module 5: Using ActiveX Data Objects
- 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
- Creating/using Disconnected Recordsets
- Creating dynamic Recordsets
- Understanding performance considerations
Skills
- Connect to a data source using ADO
- Explain how to handle errors using ADO
Top |
|
Module 6: Advanced Data Access Issues
- Overview of Microsoft SQL Server security
- Using cursors
- Enforcing data integrity
- Executing statements on a database
Skills
- 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
Top |
|
|
Module 7: Using COM Components
- Introduction to using COM components
- Creating a client application
- Using Microsoft Internet Explorer
Skills
- List the main steps required to use an external COM component in a Visual Basic application
- Create a Visual Basic client application that uses a COM component
- Create a Visual Basic application that handles events from a COM component.
- Create a Visual Basic application that automates Internet Explorer.
Top |
|
Module 8: Building COM Components
- Introduction to COM components
- Creating COM components
- Creating an object model
- Adding error handling
Skills
- Compile a project with class modules into a COM component
- Create an object model in a COM component
- Debug and test a COM component
Top |
|
|
Module 9: Application
- Optimising an application
- Deploying an application
- Deploying an ActiveX control
Skills
- Describe a variety of techniques for optimising 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
- Use the WebClass Designer to create server-side code components
Top |
|
Module 10: Building Internet Applications
- Using the WebBrowser control
- Creating Active Documents
- Creating DHTML applications
- Creating Microsoft Internet Information Server applications using WebClasses
Skills
- List the ways Visual Basic can enhance a Web site
- Create applications that use the Web Browser control
- Explain the uses for Active Documents
- Create an Active Document.
- Use the DHTML Page designer to create client-side code components
Top |
|
|
|
Exams:
-
There are no exams directly associated with this course
|
|
Price Options ex VAT:
Classroom Training
? |
Distance Learning
? |
eLearning Options
? |
Book Learning
? |
£
1750 (€2486)
|
£
995.00 (€1413)
|
£495.00
(€703)
|
No Books Supported for Course at present
|
|
|
Call Free on 0800 169 1890
Print 2 Page Flyer Last Modified 01 May 2008
|
|