|
About This Book
|
xiii
|
|
Intended Audience
|
xiii
|
|
Prerequisites
|
xiii
|
|
Getting Started
|
xiv
|
|
Hardware Requirements
|
xiv
|
|
Software Requirements
|
xiv
|
|
About The CD-ROM
|
xv
|
|
Using the Exercises
|
xv
|
|
Using the Multimedia
Presentations
|
xv
|
|
Chapter Overview
|
xv
|
|
Other Features of This
Book
|
xviii
|
|
About The Online Book
|
xviii
|
|
Using this Book to Prepare for
Certification
|
xviii
|
|
Conventions Used in This Book
|
xviii
|
|
Notational Conventions
|
xix
|
|
Keyboard Conventions
|
xix
|
|
The Microsoft Certified Professional
Program
|
xx
|
|
Microsoft Certification
Benefits
|
xxi
|
|
Technical Support
|
xxi
|
|
E-mail:
|
xxi
|
|
Postal Mail:
|
xxi
|
|
Chapter 1 Windows Operating Systems
and Architecture
|
1
|
|
Before You Begin
|
1
|
|
Lesson 1: Windows Operating
Systems
|
2
|
|
Windows 3.1
|
2
|
|
Windows 95
|
2
|
|
Windows NT
|
4
|
|
Choosing a Windows
Platform
|
7
|
|
Lesson 2: Windows Architecture
|
10
|
|
How Windows Executes
Code
|
10
|
|
Multitasking
|
12
|
|
Memory Management
|
17
|
|
Running Applications
|
20
|
|
Windows Device Drivers
|
24
|
|
Win32 Application
Programming Interface
|
25
|
|
Using the Win32 API
|
28
|
|
The Windows Registry
|
29
|
|
Review
|
35
|
|
Chapter 2 Network Concepts
|
37
|
|
Before You Begin
|
37
|
|
Lesson 1: Networking
Architectures
|
38
|
|
Local Area Networks
(LANs)
|
38
|
|
Wide Area Networks
(WANs)
|
38
|
|
The Global Internet
|
38
|
|
Corporate Intranets
|
39
|
|
Lesson 2: TCP/IP Protocol
|
40
|
|
TCP/IP Layers
|
40
|
|
Using FTP
|
42
|
|
Choosing a Network
Application Protocol
|
43
|
|
Troubleshooting TCP/IP
|
45
|
|
Lesson 3: Network Limitations
|
49
|
|
Bandwidth
|
49
|
|
Latency
|
50
|
|
Lesson 4: Developing Network
Applications
|
52
|
|
Windows Sockets
|
52
|
|
WinInet API
|
52
|
|
Networking ActiveX
Controls
|
54
|
|
Creating a Web browser
application
|
54
|
|
Review
|
56
|
|
Chapter 3 Building Solutions Using
Microsoft BackOffice
|
57
|
|
Before you Begin
|
57
|
|
Lesson 1: Microsoft BackOffice
Overview
|
58
|
|
BackOffice Applications
|
58
|
|
Lesson 2: Internet Information
Server (IIS)
|
61
|
|
Features of IIS
|
62
|
|
Using FrontPage to
Manage a Web Site
|
64
|
|
Creating a new Web site
using FrontPage
|
65
|
|
Lesson 3: Microsoft Exchange
Server
|
67
|
|
Internet Standards
Supported
|
67
|
|
Replication
|
68
|
|
Lesson 4: Microsoft SQL Server
|
70
|
|
Features of SQL Server
|
70
|
|
Lesson 5: Microsoft Proxy Server
|
72
|
|
How Proxy Server Works
|
72
|
|
Benefits of Proxy Server
|
74
|
|
Lesson 6: Microsoft Systems
Management Server
|
77
|
|
Systems Management
Server Functions
|
78
|
|
Lesson 7: Systems Network
Architecture Server
|
81
|
|
PC-to-Host Connectivity
|
81
|
|
Host Integration
|
81
|
|
Benefits of SNA Server
|
82
|
|
Lesson 8: Microsoft Transaction
Server
|
83
|
|
Application Components
|
83
|
|
Transactions
|
84
|
|
Calling MTS Components
|
85
|
|
Lesson 9: Microsoft Site Server
|
87
|
|
Standard System
Components
|
87
|
|
Microsoft Site Server,
Enterprise Edition
|
89
|
|
Lesson 10: Choosing a BackOffice
Solution
|
90
|
|
Selecting a Microsoft
BackOffice Product
|
91
|
|
Review
|
93
|
|
Chapter 4 Application Development
|
95
|
|
Before You Begin
|
95
|
|
Lesson 1: Development Platforms
|
96
|
|
Microsoft Visual Studio
|
96
|
|
Creating a Web Page in
Visual InterDev
|
100
|
|
Choosing a Visual Studio
Development Tool
|
104
|
|
Microsoft Office
|
107
|
|
Using Visual Basic for
Applications
|
110
|
|
Lesson 2: Microsoft Windows Logo
Compliance
|
113
|
|
Logo Compliance
Requirements
|
114
|
|
Lesson 3: Application
Localization
|
117
|
|
Resource Files
|
117
|
|
Using A Resource File
|
118
|
|
Character Codes
|
119
|
|
Review
|
121
|
|
Chapter 5 Component Solutions
Architecture
|
123
|
|
Before you Begin
|
123
|
|
Lesson 1: COM Architecture
|
124
|
|
COM Features
|
124
|
|
COM Objects
|
126
|
|
COM Interfaces
|
126
|
|
The IUnknown Interface
|
127
|
|
Globally Unique
Identifiers
|
130
|
|
Distributed COM
|
131
|
|
Lesson 2: Implementing COM
|
135
|
|
COM Library
|
135
|
|
Component Versioning
|
136
|
|
Inter-object
Communication
|
137
|
|
Lesson 3: Object Linking and
Embedding
|
141
|
|
Compound Files
|
141
|
|
Using Compound Documents
|
143
|
|
OLE Structured Storage
|
144
|
|
Structured Storage Files
|
144
|
|
Storage and Streams
|
145
|
|
Structured Storage
|
146
|
|
OLE Automation
|
148
|
|
Review
|
150
|
|
Chapter 6 Implementing Database
Solutions
|
151
|
|
Before You Begin
|
151
|
|
Lesson 1: Relational Databases
|
152
|
|
Relational Database
Structure
|
152
|
|
Lesson 2: Client/Server Systems
|
159
|
|
Client/Server
Architecture
|
159
|
|
Designing a
Client/Server System
|
161
|
|
Client/Server Systems
|
163
|
|
Lesson 3: Open Database
Connectivity
|
170
|
|
Defining ODBC
|
170
|
|
The ODBC Driver Manager
|
171
|
|
Data Source Names
|
173
|
|
Creating a Data Source
Name
|
173
|
|
ODBC API Conformance
|
174
|
|
ODBC SQL Conformance
|
176
|
|
Lesson 4: Database Normalization
|
179
|
|
The Normalization
Process
|
179
|
|
Creating an Entity
Relationship
|
181
|
|
Denormalization
|
183
|
|
Lesson 5: Database Replication
|
186
|
|
Microsoft Access
Replication
|
186
|
|
Replicating a Database
using Microsoft Access
|
188
|
|
Replicating a database
using the Windows Briefcase
|
189
|
|
Microsoft SQL Server
Replication
|
191
|
|
Review
|
195
|
|
Chapter 7 Database Interfaces for
Developers
|
197
|
|
Before you Begin
|
197
|
|
Lesson 1: Basic Interface
Options
|
198
|
|
File-Based Databases and
ISAM Database Interfaces
|
198
|
|
ODBC
|
198
|
|
OLE DB
|
198
|
|
Lesson 2: Data Access Methods
|
200
|
|
Data Access Objects
|
201
|
|
Connecting to a Database
Using DAO
|
204
|
|
Implementing DAO and
Microsoft Excel
|
205
|
|
DAO and ODBC
|
207
|
|
Using ODBCDirect
|
209
|
|
DAO Summary
|
210
|
|
Using Data Access
Objects
|
211
|
|
Remote Data Objects
|
212
|
|
Connecting With RDO
|
214
|
|
Building Result Sets
with RDO
|
215
|
|
Connecting Using RDO
|
216
|
|
RDO Summary
|
217
|
|
ActiveX Data Objects
|
217
|
|
Using ActiveX Data
Objects
|
219
|
|
ADO Summary
|
220
|
|
SQL-DMO
|
220
|
|
Lesson 3: Choosing a Data Access
Method
|
222
|
|
Data Format
|
222
|
|
Combination of Formats
|
222
|
|
New Product or Revision
|
222
|
|
Application Lifetime
|
222
|
|
Administrative Use Only
|
223
|
|
Review
|
224
|
|
Chapter 8 ActiveX Technologies
|
225
|
|
Before You Begin
|
225
|
|
Lesson 1: ActiveX Controls
|
226
|
|
ActiveX Controls
Specifications
|
227
|
|
Advantages of ActiveX
Controls
|
227
|
|
ActiveX Controls and
Applications
|
227
|
|
Creating an ActiveX
Control
|
227
|
|
Testing the ActiveX
Control
|
229
|
|
ActiveX Controls and the
Internet
|
230
|
|
Lesson 2: ActiveX Controls and
Security
|
233
|
|
Internet Explorer
Security Zones
|
233
|
|
ActiveX Code Signing
|
235
|
|
ActiveX Code Marking
|
236
|
|
Security Technologies
|
238
|
|
Lesson 3: ActiveX Documents
|
240
|
|
ActiveX Document
Functionality
|
240
|
|
Using ActiveX Documents
in Internet Applications
|
240
|
|
Creating ActiveX
Documents
|
241
|
|
Lesson 4: ActiveX Code
Components
|
243
|
|
Automation with ActiveX
|
243
|
|
ActiveX DLLs
|
244
|
|
Using an ActiveX DLL
|
245
|
|
ActiveX Executables
|
247
|
|
Single-Use and Multi-Use
Components
|
247
|
|
Review
|
249
|
|
Chapter 9 Implementing Client-Side
Solutions
|
251
|
|
Before You Begin
|
251
|
|
Lesson 1: Introduction to
Scripting
|
252
|
|
Client-Side and
Server-Side Scripting
|
252
|
|
Implementing Client-Side
Scripting
|
254
|
|
Lesson 2: Using Microsoft
VBScript for Client-Side Scripting
|
258
|
|
VBScript Language Syntax
|
258
|
|
Handling Errors
|
268
|
|
Controlling Objects with
VBScript
|
269
|
|
Writing Event Procedures
|
273
|
|
Using Properties and
Methods of Controls
|
274
|
|
Lesson 3: Implementing ActiveX
Controls
|
277
|
|
Advantages of Using
ActiveX Controls
|
277
|
|
The <OBJECT> Tag
|
278
|
|
Preparing to Use ActiveX
Controls
|
280
|
|
Setting Initial
Properties
|
281
|
|
Review
|
283
|
|
Chapter 10 Implementing Server-Side
Solutions
|
285
|
|
Before You Begin
|
285
|
|
Lesson 1: Active Server Pages
|
286
|
|
Elements of an Active
Server Page
|
286
|
|
The Adventure Works Web
Site
|
287
|
|
Lesson 2: Authoring Active
Server Pages
|
289
|
|
Active Server Page
Architecture
|
289
|
|
Active Server Page
Syntax
|
290
|
|
Intrinsic Objects
|
292
|
|
Creating an Active
Server Page
|
293
|
|
Lesson 3: Reading an HTTP
Request
|
295
|
|
The Request Object
|
295
|
|
Using the QueryString
Collection
|
297
|
|
Using the Form
Collection
|
299
|
|
Lesson 4: Creating an HTTP
Response
|
301
|
|
The Response Object
|
301
|
|
The Write Method
|
302
|
|
The Redirect Method
|
303
|
|
Buffering the Response
Message
|
304
|
|
Lesson 5: Saving User
Information
|
306
|
|
Using Cookies
|
306
|
|
The Session Object
|
308
|
|
Reading Form Data
|
309
|
|
The Application Object
|
311
|
|
Using Events in the
Global.asa File
|
312
|
|
Lesson 6: Using ActiveX Server
Components
|
316
|
|
The Server Object
|
316
|
|
Base Components
|
317
|
|
Using ADO in an Active
Server Page
|
318
|
|
Lesson 7: ActiveX Design-Time
Controls
|
322
|
|
Using Design-time
Controls in Visual InterDev
|
322
|
|
Implementing a
Design-time Control in an ASP
|
324
|
|
Review
|
326
|
|
Chapter 11 Other Programming
Interfaces
|
327
|
|
Before You Begin
|
327
|
|
Lesson 1: Microsoft Messaging
API (MAPI)
|
328
|
|
MAPI Architecture
|
329
|
|
MAPI Messaging Subsystem
|
331
|
|
Using the MAPI OCX
Controls
|
333
|
|
Lesson 2: Microsoft SNA APIs
|
337
|
|
Microsoft SNA Server
|
337
|
|
Lesson 3: Microsoft Cryptography
API (CryptoAPI)
|
340
|
|
Application
Implementations
|
340
|
|
Privacy
|
341
|
|
Authentication
|
341
|
|
Lesson 4: Microsoft Windows
Telephony
|
343
|
|
Windows Telephony
Architecture
|
343
|
|
TAPI
|
344
|
|
TSPI
|
345
|
|
Using Telephony in
Applications
|
345
|
|
Lesson 5: License Service API
(LSAPI)
|
346
|
|
The Licensing Solution
|
346
|
|
Implementing LSAPI
|
348
|
|
Lesson 6: Microsoft Speech API
(SAPI)
|
349
|
|
Text-To-Speech
|
349
|
|
Speech Recognition
|
349
|
|
Speech Engine
Independence
|
349
|
|
Review
|
351
|
|
Chapter 12 User Interface
Considerations
|
353
|
|
Before You Begin
|
353
|
|
Lesson 1: Windows User Interface
Considerations
|
354
|
|
Add OLE Drag and Drop
Functionality
|
354
|
|
Implementing OLE Drag
and Drop
|
355
|
|
Test on All Windows
Platforms
|
356
|
|
Multiple Instances
|
356
|
|
Windows Interface
Consistency
|
358
|
|
Use the Windows Registry
|
359
|
|
Support System File
Naming Conventions
|
360
|
|
Provide a Smart Setup
Program/Uninstall Utility
|
360
|
|
Running the Setup Wizard
|
361
|
|
Creating a Setup
Application
|
362
|
|
Give Your Application a
Three-Dimensional Look
|
363
|
|
Lesson 2: Standard Windows
Controls and Dialogs
|
365
|
|
Windows Common Controls
|
365
|
|
General Purpose Controls
|
367
|
|
Organizational Controls
|
368
|
|
List Controls
|
369
|
|
Text Controls
|
371
|
|
Pen Controls
|
372
|
|
Using the Microsoft
Windows Common Controls
|
373
|
|
Windows Common Dialogs
|
374
|
|
Using the Common Dialog
Control
|
376
|
|
Lesson 3: Windows Interaction
within an Application
|
379
|
|
Console Applications
|
379
|
|
Windowing Applications
|
380
|
|
Building a Multiple
Document Interface
|
381
|
|
Lesson 4: The Windows Help
System
|
385
|
|
Designing a Help System
|
385
|
|
Implementing Help in an
Application
|
387
|
|
Add Context-Sensitive
Help to an Application
|
388
|
|
Features of the Help
System
|
390
|
|
Review
|
393
|
|
Chapter 13 Design Methodologies and
Management
|
395
|
|
Before You Begin
|
395
|
|
Lesson 1: The Microsoft
Solutions Framework
|
396
|
|
How MSF is Utilized
|
397
|
|
Microsoft Solutions
Framework Models
|
397
|
|
Lesson 2: Managing Source Code
with Visual SourceSafe
|
416
|
|
Visual SourceSafe
Management
|
416
|
|
Using Visual SourceSafe
|
418
|
|
Visual SourceSafe
Integration
|
419
|
|
Visual SourceSafe and
Visual Basic
|
419
|
|
Sharing Files in Visual
SourceSafe
|
420
|
|
Viewing Changes to files
in the VSS Explorer
|
422
|
|
Review
|
424
|
|
Questions and Answers
|
425
|
|
Glossary
|
441
|
|
Index
|
471
|