Microsoft Office 2000 Development

Overview

This Microsoft Mastering learning system provides practical, hands-on instruction for creating custom solutions with the integrated programming tools and services in Microsoft Office 2000, including the Visual Basic for Applications (VBA) development system. Students get the training they need — how and when they need it — through a combination of text-based and interactive lessons, narrated demonstrations, and hands-on labs. The instructional modules step learners through essential topics, such as using the ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (6) from $1.99   
  • New (1) from $19.99   
  • Used (5) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$19.99
Seller since 2007

Feedback rating:

(89)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
1999-01-01 Paperback New Beautiful New Paperback Book with Glossy Finish.

Ships from: Farmerville, LA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

This Microsoft Mastering learning system provides practical, hands-on instruction for creating custom solutions with the integrated programming tools and services in Microsoft Office 2000, including the Visual Basic for Applications (VBA) development system. Students get the training they need — how and when they need it — through a combination of text-based and interactive lessons, narrated demonstrations, and hands-on labs. The instructional modules step learners through essential topics, such as using the Visual Basic Editor, forms and controls, object models for individual applications, shared object models, data access, and web components. Lab exercises reinforce the concepts presented in each learning unit and provide hands-on experience with development tasks. By the end of the course, students have developed a custom solution that integrates components of the Office 2000 suite.

Read More Show Less

Product Details

  • ISBN-13: 9780735608993
  • Publisher: Microsoft Press
  • Publication date: 1/1/1999
  • Series: Microsoft Mastering Series
  • Pages: 580
  • Product dimensions: 7.38 (w) x 9.23 (h) x 1.60 (d)

Table of Contents


A
absolute reference, 213
Access. See Microsoft Access
access to code, disallowing, 359
ADO (ActiveX Data Objects), 144, 146
    retrieving data from a data source, 150
    understanding OLE DB, 147
    using the object model, 148
    working with recordsets, 149
application
    distributing, 367
    packaging, 369
Application object model, 404
areas
    retrieving, 288
    working with the Selection object, 292
arguments, 70-72
Assistant, 319
    creating balloons, 322, 321, 325
    displaying a balloon, 323
    modifying, 320
automation tools, 6
AutoText, creating and inserting, 297, 298

B
balloons. See Assistant
bookmarks, 293
break mode, entering to debug, 47
breakpoint, setting, 47
built-in dialog boxes, 111

C
Call Stack, using to debug, 53
categories, managing a Web site, 394
cells ranges, 210
chart sheets, 241
Chart Wizard, 241
charts, 240, 241
    ChartWizard method, 245
    creating in Excel, 240-244
    embedded, 240
    modifying, 245
    sheets, 241
code
    adding to a procedure, 41
    adding to control events, 104
    recording, 37
    running, 42, 36
    stepping through, 48
    storing, 26
    using objects in, 88
    viewing in a macro, 38
    writing, 36
code librarian, 348
    adding code to, 350
    using code in, 352
code samples, 348
Code window
    adding code, 35
    opening, 34
COM add-ins, 353
    adding, 354
    building, 357
    creating, 371
    debugging, 355
    deploying, 368, 371
    registering a DLL, 356
command
    adding to Tools menu, 133
command bar
    adding controls, 120
    building, 114
    creating new, 118
    customizing, 113
    storing custom bars, 115
    working with, 124
CommandBar object model, 116
constants, 66-69
control events, adding code, 104
control toolbox, 96
controls
    adding to a document, 107, 110
    adding to a form, 98
    adding to command bars, 120
    initializing, 103, 105
    setting properties, 121
    validating input, 105
CreateObject, 90
custom setup, developing, 368
customizing menus and toolbars, 114

D
data
    creating charts in Excel, 240
    external, importing, 145
    retrieving from a data source, 150
    retrieving in an Office solution, 141, 173
    storing, 142
    using ADO, 146
    working with, 144
data access, 7
    handling errors, 171
data source
    establishing a connection, 150
    retrieving data from, 150
databases
    Excel vs. relational, 143
    reformatting, 144
    working in Access, 326
Debug.print statement, 50
debugging, 45
    Call Stack, 53
    COM add-ins, 355
    entering break mode, 47
    Immediate window, 49
    Locals window, 51
    tools, 53
    Watch window, 51
debugging tools, 53
declaring variables, 67
deployment
    choosing a strategy, 366
    COM add-ins, 368
    distributing custom templates and documents, 367
design
    considerations for Excel, 186
    considerations for Word, 274
    referencing a range, 203
design mode, running code, 42
developer resources, 347
developer tools, 346
developing a Web site, 382
dialog boxes, 111
digital certificates
    understanding security, 359
    using digital signatures, 361, 362, 364
distributing an application, 369
documents
    adding controls, 107, 110
    building in Excel, 185
    building in Word, 273
    creating and opening, 283, 286
    deploying a solution, 367
    inserting and formatting text, 294, 297, 298
    inserting data, 301
    printing, 287
    relating to projects, 28
    retrieving areas, 288
    saving and closing, 285, 288
    storing code in, 274
    using styles, 296

E
embedded charts, 240
environment options, setting, 36
Err object, 77
error handling
    data access errors, 171
    understanding the process, 75
event procedures, 37
events
    in Outlook, 335
    in Word, 279
    using the Workbook object, 195
    working with forms, 102
    worksheet events, 200
Excel. See Microsoft Excel
external data, importing, 144

F
files, importing to a Web site, 389
forms, 93, 100
    adding code to control events, 104
    adding controls, 98
    adding controls to a document, 107, 110
    control group, creating, 97
    initializing controls, 103, 105
    setting properties, 95
    Toolbox, adding pages, 98
    using built-in dialog boxes, 111
    working with events, 102
    working with the control toolbox, 96
formulas
    entering in Excel, 215
    referencing in Excel, 212
FrontPage. See Microsoft FrontPage
function
    CreateObject, 90
    GetObject, 89
Function procedure, 71

G
general procedures, 37
GetObject, 89

H
HTML
    coding with scripts in Excel, 257
    creating pages, 4
    publishing workbooks, 255

I
Immediate window, 49
    Debug.print statement, 50
Internet
    data access pages, 7
    Office Web components, 7

K
keyword, using New with Set statement, 89

L
labs
    setting up, iv
    viewing the solutions, 19
Locals window, 50

M
macros, recording, 38
menus, customizing, 113
methods, calling, 82
Microsoft Access
    object model, 327
    publishing an Access report, 329
    publishing a Web report, 328
    using the Simple Query Wizard, 166, 169
    working with databases, 328
Microsoft Excel. See also charts; PivotTables
    analyzing data, 262
    Application object, 190
    building documents, 185
    choosing a format for your solution, 260
    coding with scripts, 257
    design considerations for solutions, 186
    formula referencing, 212
    navigating the Excel model, 189
    object model, 187
    presenting results, 253
    publishing as Office Web components, 258
    publishing workbooks as static HTML, 254
    saving workbook files, 253
    understanding formula referencing, 212
    using from other applications, 190
    using objects, 189
    workbooks, 186, 192, 193
    worksheets, 197
Microsoft FrontPage
    Application object model, 404
    creating a personal Web site, 387
    creating a Web page, 388
    managing a Web site, 392
    Page object model, 411
    planning and developing a Web site, 380
    programming, 402
    publishing a Web site, 396
    server extensions, 383
    summarizing advanced features, 385
    using categories to manage, 394, 395
    using reports and tasks to manage, 392, 395
    using the object model, 412
    Web object model, 406
Microsoft Outlook
    adding dialog to an e-mail message, 336
    creating items, 333
    object model, 331
    using events, 335
Microsoft PowerPoint
    navigating the object model, 314
    publishing a Web presentation, 318
    understanding the object model, 314
    working with presentations, 315
Microsoft Word
    bookmarks, 293
    creating a template, 275, 286
    creating and inserting AutoText, 297, 298
    creating and opening documents, 284-86
    defining a Range object, 289
    design considerations, 274
    events, 279
    inserting and formatting text, 294
    inserting data, 301
    navigating the Word model, 278
    object model, 276
    printing documents, 287
    publishing a Web document, 288
    retrieving areas, 288
    saving and closing documents, 285
    storing code, 274
    styles, 296
    tables, 299
    working with the Selection object, 292
modules
    adding to a project, 40
    creating procedures in, 40
Move, describing methods, 157

N
naming conventions, 66

O
object library, referencing, 85
object models
    and ADO, 148
    CommandBars, 116
    Excel model, 187, 189
    Word model, 276, 278
    using in Office, 84, 90
object variable, declaring, 87
objects, 81
    calling methods, 83
    declaring a variable, 87
    in code, 88
    creating a Recordset, 152
    in Excel, 189, 187
    referencing a library, 85
    setting properties, 82
    understanding Workbook, 192, 195
    within Word, 278
Office 2000 suites, 8
Office 2000, creating solutions, 2
Office object models, 80
    hierarchy, 84
    shared, 85
Office solutions
    deploying, 14
    designing, 12
    understanding, 10
Office Web components, 7
OLE DB components, 147
Options, setting the environment, 36
Outlook. See Microsoft Outlook

P
Package and Deployment Wizard, 368
packaging an application, 369
Page object model, 411
Personal Macro Workbook, 186
PivotTables, 248-50
    modifying, 251
    understanding basics, 247
planning a Web site, 380
PowerPoint. See Microsoft PowerPoint
PowerPoint presentations, 314, 318
printing a document, 287
procedures, 40, 44, 70
    adding code, 41
    declaring with arguments, 72
    describing types, 37
program execution, controlling, 72
Programmability features, 6
project, displaying elements, 30
projects, relating to documents, 28
properties
    for controls, 121
    at design time, 32
    for forms, 95
    for objects, 82

Q
query. See also SQL
    building, 162
    using the Simple Query Wizard, 166, 169

R
range. See also Range object
    changing, 205
    collapsing, 291
    direct referencing in Excel, 210
    selecting, 210
    redefining in Word, 291
    referencing at design time, 203
    returning, 203
    using Cells property, 203
Range object, 203
    defining in Word, 289
    defining named ranges in Excel, 219
    entering values and formulas in Excel, 215
    formatting in Excel, 211
    formula referencing in Excel, 212
    returning recordset data to a worksheet, 221
    working with, 218
records
    filtering in a recordset, 160
    navigating in a recordset, 156
recordsets
    creating, 152, 160
    filtering records, 160
    navigating records, 156
    opening using SQL, 167
    populating controls, 156
    referencing fields, 155
    working with, 149
reference
    relative, 213
    setting to ADO, 149
    styles, 213
    using the Cells property, 203
    working with cell ranges, 210
reference styles, 213
relational databases, storing data, 142
relative reference, 213
Reports, viewing, 392
Resume statement, 76
retrieving data in Office, 141
run mode, running code, 42
run-time errors, handling, 75

S
scope of variables, 68
security
    mechanisms, 360
    settings, 363
selecting, compared to direct referencing, 210
Selection object, working with, 292
server extensions, 383
setup, developing a custom program, 368
signing your project digitally, 362
Simple Query Wizard, 166, 169
solutions
    creating, 2
    deploying, 14
    designing, 12
    understanding, 10
SQL, 162
    opening a recordset, 167
    selecting records, 163
    using the Simple Query Wizard, 166, 169
storage location, custom command bars, 115
styles, using in documents, 296
Sub procedures, 70

T
tables, 299
Tasks list, 392
templates
    deploying a solution, 367
    using in Excel solutions, 186, 212
    creating in Word, 275, 286
    storing code in, 274
toolbox, 96
Tools menu, adding commands, 133

U
user interface, building, 128

V
values, entering, 215
variables, 66
Visual Basic Editor, 25, 29, 56
    creating general procedures, 40
    features, 29
    relating projects to documents, 28
    setting Options, 36
    storing code, 26
    understanding basic elements, 30
Visual Basic for Applications, 3
Visual Basic syntax, 78
    controlling program execution, 72
    handling run-time errors, 75
    procedures, 70
    variables, 66

W
Watch expression, adding, 52
Watch window, 51
Web components
    Office, 7
    publishing results, 258
Web document, publishing, 288
Web object model, 406
Web page, creating and importing, 388, 390
Web presentation, publishing, 318
Web report, publishing, 328
Web site
    creating, 384
    displaying the structure, 409
    importing files, 389
    managing with categories, 394, 395
    managing with folders and files, 408
    managing with reports and tasks, 392, 395
    navigating, 408
    planning and developing, 380
    publishing, 396
With statement, 83
Word. See Microsoft Word
workbook
    opening, 192
    publishing as static HTML, 254
    saving and closing, 193, 253
    using events, 195
    using templates, 212
worksheet events, writing code, 200
worksheets, 197, 201
    activating, 199
    adding, 197
    managing, 199
    changing a range, 205
    referencing a range, 203
    returning Range objects, 203, 208
    using events, 200

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)