|
Use the ConnectionString, specifically applying:
Open, Close,
ConnectionString, State
Universal Data Link
Use the Recordset Object, specifically applying:
Open, Close,
GetRows, ActiveConnection, BOF, EOF
CursorLocation,
CursorType, Fields, LockType, Source, State
Use the Command Object, specifically applying:
Execute, ActiveConnection,
CommandText, and State
Use the Fields Collection
Use ADO to build an n-tier database application, specifically applying:
Design patterns
Business Object
Data Transfer (BODT)
Array function,
variant array utilization
Handle user input error using 3-tier techniques
Use the Validate Event to communicate from the UI-tier to the
business-tier
Use Err.Raise to communicate errors from the business-tier to the UI-tier
Discuss definitions and terminology, purpose, and advantages of ActiveX
Components
Discover the differences between ActiveX DLL and ActiveX EXE components
Build an ActiveX DLL Component
Compile an ActiveX component
Compile an ActiveX component
Test an ActiveX component
Deploy an application on a client workstation:
Use the Package and
Deployment Wizard to create dependency files
Use the Package and
Deployment Wizard to create a setup program
Use the setup program
to install your application
Verify that files
are installed and registered
Discuss the advantages of Microsoft Transaction Server (MTS)
Use the Microsoft Management Console (MMC) and MTS Explorer to manage MTS
activities such as creating, deleting, and exporting packages, and
creating components
Observe components in action by watching the "spinning balls":
Create, delete, and export MTS packages
Create and successfully deploy MTS components
Discuss the evolution of Web-based development
Discuss Web-based architectures
Articulate ASP architecture
Articulate the difference between:
HTML
Client-side scripting
ASP (Server-side
scripting)
Establish/manage a Web site using IIS
Establish a physical
directory
Establish a virtual
directory
Create and run a basic ASP application
Apply objects within the Active Server Object model to Web development
Utilize the Request object
Utilize the Response object
Create a simple ASP application that receives information from a user and
responds based on the user input
Test a simple ASP application
Use the ASP Server object to create ActiveX objects
Use ASP to manage ActiveX objects
Create a simple ASP application that accesses data through MTS
business-tier components
|