VBA 6 complete reference.pdf

Introduction

MCSD Training Guide: Visual Basic 6 Exams is designed

for developers with the goal of certiﬁcation as a

Microsoft Certiﬁed Solutions Developer (MCSD).

It covers both the Designing and Implementing

Distributed Applications with Microsoft Visual Basic

6.0 exam (70-175) and the Designing and

Implementing Desktop Applications with Microsoft

Visual Basic 6.0 exam (70-176). These exams measure

your ability to design and implement distributed and

desktop application solutions by using Microsoft Visual

Basic version 6.0.

This book is your one-stop shop. Everything you need

to know to pass the exams is in here, and Microsoft has

approved it as study material. You do not have to take a

class in addition to buying this book to pass the exam.

However, depending on your personal study habits or

learning style, you may beneﬁt from buying this book

and taking a class.

This book also can help advanced users and administra-

tors who are not studying for the exam but are looking

for a single-volume reference on Microsoft’s TCP/IP

implementation.

Organization. This book is organized by individual

exam objectives. Every objective you need to know

for the VB6 Distributed Applications exam and the

VB6 Desktop Applications exam is covered in this

book. The objectives are not covered in exactly the

same order as they are listed by Microsoft, but we

have attempted to organize the topics in the most

logical and accessible fashion to make it as easy as

possible for you to learn the information. We have

also attempted to make the information accessible

in the following ways:

• The full list of exam topics and objectives is

included in this introduction.

• Each chapter begins with a list of the objectives

to be covered. Each objective is also identiﬁed as

one that applies to the Distributed Applications

exam, the Desktop Applications exam, or both.

• Each chapter also begins with an outline that pro-

vides you with an overview of the material and

the page numbers where particular topics can be

found.

• We also repeat objectives before where the mater-

ial most directly relevant to it is covered (unless

the whole chapter addresses a single

objective).

• Information on where the objectives are covered

is also conveniently condensed on the tear card

at the front of this book.

H OW T HIS B OOK H ELPS Y OU

This book conducts you on a self-guided tour of all the

areas covered by the VB6 Distributed Applications

exam and the VB6 Desktop Applications exam and

teaches you the speciﬁc skills you need to achieve your

MCSD certiﬁcation. You’ll also ﬁnd helpful hints, tips,

real-world examples, exercises, and references to addi-

tional study materials. Speciﬁcally, this book is set up to

help you in the following ways:

Instructional Features. This book has been designed

to provide you with multiple ways to learn and rein-

force the exam material. Following are some of the

helpful methods:

MCSD TRAINING GUIDE: VISUAL BASIC 6 EXAMS

• Objective Explanations . As mentioned previ-

ously, each chapter begins with a list of the

objectives covered in the chapter. In addition,

immediately following each objective is an

explanation in a context that deﬁnes it more

meaningfully.

• Study Strategies . The beginning of the chapter

also includes strategies for approaching the

studying and retaining of the material in

the chapter, particularly as it is addressed

on the exam.

• Exam Tips . Exam tips appear in the margin to

provide speciﬁc exam-related advice. Such tips

may address what material is covered (or not

covered) on the exam, how it is covered,

mnemonic devices, or particular quirks of

that exam.

• Review Breaks and Summaries . Crucial infor-

mation is summarized at various points in the

book in lists or tables. Each chapter ends with

a summary as well.

• Key Terms . A list of key terms appears at the

end of each chapter.

• Notes . These appear in the margin and contain

various kinds of useful information such as

tips on technology or administrative practices,

historical background on terms and technolo-

gies, or side commentary on industry issues.

• Warnings . When using sophisticated informa-

tion technology, there is always the potential

for mistakes or even catastrophes that occur

because of improper application of the tech-

nology. Warnings appear in the margin to

alert you to such potential problems.

• In-depths . These more extensive discussions

cover material that may not be directly relevant

to the exam but which is useful as reference

material or in everyday practice. In-depths may

also provide useful background or contextual

information necessary for understanding the

larger topic under consideration.

• Step by Steps . These are hands-on, tutorial

instructions that lead you through a particular

task or function relevant to the exam

objectives.

• Exercises . Found at the end of the chapters in

the “Apply Your Knowledge” section, exercises

may include additional tutorial material as

well as other types of problems and questions.

• Case Studies . Presented throughout the book,

case studies provide you with a more concep-

tual opportunity to apply and reinforce the

knowledge you are developing. They include a

description of a scenario, the essence of the

case, and an extended analysis section. They

also reﬂect the real-world experiences of the

authors in ways that prepare you not only for

the exam but for actual network administra-

tion as well.

Extensive practice test options. The book pro-

vides numerous opportunities for you to assess

your knowledge and practice for the exam. The

practice options include the following:

• Review Questions . These open-ended questions

appear in the “Apply Your Knowledge” section

at the end of each chapter. They allow you to

quickly assess your comprehension of what

you just read in the chapter. Answers to the

questions are provided later in the section.

INTRODUCTION

• Exam Questions . These questions also appear

in the “Apply your Knowledge” section. They

reﬂect the kinds of multiple-choice questions

that appear on the Microsoft exams. Use

them to practice for the exam and to help

you determine what you know and what you

need to review or study further. Answers and

explanations for them are provided.

• Practice Exam . A Practice Exam is included in

the “Final Review” section. The Final Review

section and the Practice Exam are discussed

below.

• Top Score . The Top Score software included

on the CD-ROM provides further practice

questions.

It also provides you with valuable exam-day

tips and information on new exam/question

formats such as adaptive tests and simulation-

based questions.

• Practice Exam . A full practice test for each of

the exams is included. Questions are written

in the styles used on the actual exams. Use it

to assess your readiness for the real thing.

The book includes several valuable appendices as well,

including a glossary (Appendix A), an overview of the

Microsoft certiﬁcation program (Appendix B), and a

description of what is on the CD-ROM (Appendix C).

The Microsoft VB exams assume an elementary knowl-

edge of VB but do not specify this knowledge in the

exam objectives. For that reason, this book includes

Appendix E, “Visual Basic Basics” that provides you

with an overview of the elementary VB knowledge and

skills that are not speciﬁed as objectives but that you

will need to know in order to pass the exam.

Finally, Appendix F provides you with a list of

“Suggested Readings and Resources” that provides you

with useful information on Visual Basic 6.

These and all the other book features mentioned previ-

ously will provide you with thorough preparation for

the exam.

For more information about the exam or the certiﬁca-

tion process, contact Microsoft:

Microsoft Education: 800-636-7544

Internet: ftp://ftp.microsoft.com/Services/MSEdCert

World Wide Web: http://www.microsoft.com/train_cert

CompuServe Forum: GO MSEDCERT

For a complete description of the New

Riders Top Score test engine, please

see Appendix D, “Using the Top Score

Software.”

Final Review. This part of the book provides

you with three valuable tools for preparing for

the exam.

• Fast Facts . This condensed version of the

information contained in the book will prove

extremely useful for last-minute review.

• Study and Exam Tips . Read this section

early on to help you develop study strategies.

MCSD TRAINING GUIDE: VISUAL BASIC 6 EXAMS

Design the properties, methods, and events of

components.

W HAT THE D ESIGNING AND

I MPLEMENTING D ISTRIBUTED

A PPLICATIONS WITH

M ICROSOFT V ISUAL B ASIC 6.0

E XAM (70-175) C OVERS

Establishing the Development

Environment

Establish the environment for source-code version

control.

Install and conﬁgure Visual Basic for developing

distributed applications.

Conﬁgure a server computer to run Microsoft

Transaction Server (MTS).

Install MTS.

Set up security on a system package.

Conﬁgure a client computer to use an MTS

component.

Create packages that install or update MTS

components on a client computer.

The Designing and Implementing Distributed

Applications with Microsoft Visual Basic 6.0 Exam

(70-175) covers the nine main topic areas represented

by the conceptual groupings of the test objectives:

Developing the Conceptual and Logical Design,

Deriving the Physical Design, Establishing the

Development Environment, Creating User Services,

Creating and Managing COM Components, Creating

Data Services, Testing the Solution, Deploying the

Application, and Maintaining and Supporting an

Application. Each of these main topic areas is covered

in one or more chapters. The exam objectives are listed

by topic area in the following sections.

Developing the Conceptual and

Logical Design

Given a conceptual design, apply the principles of

modular design to derive the components and services

of the logical design.

Creating User Services

Implement navigational design.

Dynamically modify the appearance of a menu.

Add a pop-up menu to an application.

Create an application that adds and deletes

menus at runtime.

Add controls to forms.

Set properties for controls.

Deriving the Physical Design

Assess the potential impact of the logical design on per-

formance, maintainability, extensibility, scalability,

availability, and security.

Design Visual Basic components to access data from a

database in a multitier application.

Assign code to a control to respond to an event.

INTRODUCTION

Create data input forms and dialog boxes.

Display and manipulate data by using custom

controls. Controls include TreeView , ListView ,

ImageList , Toolbar , and StatusBar .

Create an application that adds and deletes

controls at runtime.

Create a Visual Basic application that handles

events from a COM component.

Create callback procedures to enable asynchronous pro-

cessing between COM components and Visual Basic

client applications.

Implement online user assistance in a distributed appli-

cation.

Set appropriate properties to enable user assis-

tance. Help properties include HelpFile ,

HelpContextID , and WhatsThisHelp .

Create HTML Help for an application.

Implement messages from a server component to

a user interface.

Use the Controls collection to manipulate

controls at runtime.

Use the Forms collection to manipulate forms at

runtime.

Write code that validates user input.

Create an application that veriﬁes data entered at

the ﬁeld level and the form level by a user.

Create an application that enables or disables

controls based on input in ﬁelds.

Implement error handling for the user interface in dis-

tributed applications.

Identify and trap runtime errors.

Handle inline errors.

Determine how to send error information from a

COM component to a client computer.

Write code that processes data entered on a form.

Given a scenario, add code to the appropriate

form event. Events include Initialize ,

Terminate , Load , Unload , QueryUnload , Activate ,

and DeActivate .

Use an active document to present information within

a Web browser.

Add an ActiveX control to the toolbox.

Create dynamic Web pages by using Active Server

Pages (ASP) and Web classes.

Create a Web page by using the DHTML Page

Designer to dynamically change attributes of elements,

change content, change styles, and position elements.

Use data binding to display and manipulate data from

a data source.

Instantiate and invoke a COM component.

Create a Visual Basic client application that uses

a COM component.

Creating and Managing COM

Components

Create a COM component that implements business

rules or logic. Components include DLLs, ActiveX

controls, and active documents.

Create ActiveX controls.

Create an ActiveX control that exposes properties.

Use control events to save and load persistent

properties.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: