Maricopa Community Colleges  MST170   19996-20025 
Official Course Description: MCCCD Approval: 05/25/99
MST170 19996-20025 L+L 4 Credit(s) 5 Period(s)
Visual Basic Desktop Application Development
Use of Visual Basic programming language to create database applications using Visual Data Access tools, ActiveX Controls, Component Objects, and Structured Query Language (SQL) Server database. Prerequisites: CIS159 or permission of instructor.
 
Course Note:Under the terms and conditions specified in the legal agreement between Microsoft Corporation and each AATP campus in the Maricopa Community College District, Microsoft requires that "all instructors of Microsoft Official Curriculum and Microsoft Approved Study Guides pass the Microsoft Certified Professional exam in the product area of the courseware being delivered."
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
MST170   19996-20025 Visual Basic Desktop Application Development
1. Create, debug, and compile a simple application and an executable file for users. (I)
2. Access data and create database queries, forms, and reports using visual data access tools. (II)
3. Create a Component Object Model (COM) component within Visual Basic project using a class module. (III)
4. Create an ActiveX control that exposes properties, methods, and events. (IV)
5. Connect to a data source, retrieve data, manipulate data, and use an ADO record-set object to store non-database data using ActiveX Data Objects (ADO). (V)
6. Execute a statement on a database working with Structured Query Language (SQL) Server security and stored procedures. (VI)
7. Create a client application that uses a COM component, handles events from a COM component, and automates Internet Explorer. (VII)
8. Create an object model, debug, test, and compile a project with class modules into a COM component. (VIII)
9. Create a setup program and package an ActiveX control for use on a Web site. (IX)
10. Create applications that can enhance Web site by creating client-side and server-side code components. (X)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
MST170   19996-20025 Visual Basic Desktop Application Development
    I. Essentials of Microsoft Visual Basic
        A. Understanding Microsoft Visual Basic-based development
        B. Creating an application
        C. Debugging and error handling
        D. Compiling an executable (EXE) file
        E. Overview of the State University Bookstore application
      II. Visual Data Access Tools
          A. Universal data access
          B. Connecting to a data source
          C. Getting data from a connection
          D. Organizing data
          E. Presenting data
        III. Class Modules
            A. Designing an application
            B. Creating class modules for Component Object Model (COM) components
            C. Adding properties, methods, and events
            D. Using a class module
            E. Creating data-bound class modules
          IV. Building ActiveX Controls
              A. Creating an ActiveX control
              B. Exposing properties, methods, and events
              C. Testing a control
              D. Creating property pages
              E. Creating a data-bound control
              F. Creating a data source control
            V. Using ActiveX Data Objects
                A. Overview of ADO
                B. Handling data access errors
                C. Connecting to a data source
                D. Retrieving data from a data source
                E. Sorting and searching data
                F. Updating data
                G. Using disconnected data
                H. Creating dynamic record sets
                I. Understanding performance considerations
              VI. Advanced Data Access Issues
                  A. Overview of Microsoft Structured Query Language (SQL) ServerŠ security
                  B. Using cursors
                  C. Enforcing data integrity
                  D. Executing statements on a database
                VII. Using COM Components
                    A. Introduction to using COM components
                    B. Creating a client application
                    C. Using Microsoft Internet Explorer
                  VIII. Building COM Components
                      A. Introduction to COM components
                      B. Creating COM components
                      C. Creating an object model
                      D. Adding error handling
                    IX. Optimizing and Deploying an Application
                        A. Optimizing an application
                        B. Deploying an application with a setup program
                        C. Deploying an ActiveX control
                      X. Building Internet Applications
                          A. The Web Browser control
                          B. Creating Active Documents
                          C. Creating dynamic hypertext markup language (DHTML) applications
                          D. Creating Microsoft Internet Information Server applications
                      Go to Description    Go to top of Competencies    Go to top of Outline