Office 2000

Writing Excel Macros with VBA, 2nd Edition

Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. Writing Excel Macros with VBA, 2nd Edition is written in a terse, no-nonsense manner that is characteristic of Steven Roman's straightforward, practical approach. Instead of a slow-paced tutorial with a lot of handholding, Roman offers the essential information about Excel VBA that you must master to write macros effectively. This tutorial is reinforced by interesting and useful examples that solve common problems you're sure to have encountered. Writing Excel Macros with VBA, 2nd Edition is the book you need to delve into the basics of Excel VBA programming, enabling you to increase your power and productivity.

Access Cookbook, 2nd Edition

Access power users and programmers at all levels, from the relatively inexperienced to the most sophisticated, will rely on the Access Cookbook, Second Edition for quick solutions to gnarly problems. Each of the book's "recipes" examine a particular problem--problems that commonly occur when you push the upper limits of Access, or those that are likely to trip up a developer attempting to design a more elegant Access application --even some things you never knew Access could do. Fully updated for Access 2003, it's also one of the first books to thoroughly explore new support for .NET managed code and XML. All of the practical, real-world examples have been tested for compatibility with Access 2003, Windows XP, and Windows Server 2003. This updated new edition also covers Access and SharePoint, Access and SmartTags, Access and .NET; and Access and XML.

Access 2000 for Windows for Dummies

Being a normal human being, you probably have work to do. In fact, you may have lots of work piled precariously around your office or even stretching onto the Internet. Someone, possibly your boss, suggested that Access 2000 may help you get more done in less time, eliminate the piles, and generally make the safety inspector happy.

But if you’re confused instead of organized, befuddled instead of productive, or just completely lost on the whole database thing, Access 2000 For Windows For Dummies is the book for you.

You don't need to be a nerd to get the most out of Access 2000 For Windows For Dummies. If you know the basics of Windows 95, 98, or NT (whichever one you use) and have a desire to work with databases, you're ready to go. Everything you need to know is right here, just waiting for you to read it.

Each part of Access 2000 For Windows For Dummies covers a general topic of Access 2000. Right off the bat, this book answers the lyrical question “It’s a data-what?” By starting with an overview of both database concepts in general and Access 2000 in particular, this book provides the information you need to make sense of the whole database concept. You'll also gain insight into

• Solving problems with Access 2000
• Designing, building, using, changing, and generally coexisting in the same room with Access 2000 tables
• Using the Access 200 queries to unearth the answers you know are hiding somewhere in your data
• Committing your database to paper
• Doing stuff faster and seeking assistance from the wizards. You'll even venture into a bit of programming

Now nothing’s left to hold you back from the wonders of Access 2000. Cleave tightly to Access 2000 For Windows For Dummies, consign the Microsoft manuals to a suitable dark hole, and dive into Access 2000.

Bon Voyage!

Microsoft Access 2000 Bible

They say information wants to be free, and you can be its liberator by using the Microsoft Access 2000 Bible. Written to bring all levels of users up to the first steps of advanced use, it's as clear as a tutorial and as comprehensive as a reference can be. It even includes a 32-page "Quick Start" guide for newbies who want to get up and running quickly.

By combining screenshots with text in just the right proportions, it appeals to both visual and verbal learners and should pose no problems in training. It covers the basics of use and design, advanced features like action queries and subforms, and the use of macros and Visual Basic for Applications to fine-tune your data solutions. The Bible makes learning easy by using examples at every step to ensure hands-on learning.

The enclosed CD-ROM contains all the files you'll need for learning (just add Access!), as well as piles of free and demo software like business forms, Check Writer 2000, and WinZip. So whether you're a bright novice who wants to learn more or an advanced user who needs to learn how Access 2000 differs from previous and competing database applications, the Microsoft Access 2000 Bible will help you unlock the secrets and let your information run free. --Rob Lightner

Client lists. Figure sales. Web research. Take charge of your data before it takes over your business. With expert advice from Cary Prague and Michael Irwin, you'll quickly master Access 2000's top database management capabilities -- and its revolutionary Web features. Using step-by-step instructions and practical examples, the authors demonstrate everything you need to know to organize, present, analyze, and share data efficiently over a corporate network or the Internet.

Microsoft Excel 2000 Step by Step (Step By Step (Microsoft))

EXCEL 2000 STEP BY STEP

Spreadsheets aren't just for financial planners anymore. If you want to master the secrets of one of the most powerful spreadsheet applications on the market, take a peek inside Microsoft Excel 2000 Step by Step. You'll find 19 self-paced lessons on everything from navigating workbooks to automating your work; novices will quickly get up to speed, while more advanced users can jump right in to the new features offered by the 2000 version.

The numbered instructions are clear and linked to sharp illustrations, making the translation from book to machine a snap. While it's certainly not the most comprehensive book on Excel 2000 (there's little programming information, and you don't get every last detail on most features), it's not meant as a reference and it serves its educational purposes handily.

The enclosed CD-ROM provides all the sample files you'll need to work through the hands-on lessons. You'll also find multimedia walk-through files that demonstrate some of the more complex procedures. If Excel 2000 is or will be a part of your life, do yourself a favor and get Microsoft Excel 2000 Step by Step --Rob Lightner

Microsoft Access 2000 Comprehensive Concepts and Techniques (Shelly Cashman)

Part of the highly successful Shelly Cashman series, this comprehensive text offers a step-by-step, screen-by-screen approach that goes beyond the basics to teach introductory and advanced topics of Microsoft Access 2000. Covers Microsoft Access 2000 topics such as maintaining and querying a database, creating custom toolbars, menus, writing visual basic code, and more. This text includes nine complete projects that cover beginning and advanced Microsoft Access 2000 skills

Microsoft Office 2000: Introductory Concepts and Techniques, Enhanced (Shelly, Gary B. Shelly Cashman Series.)

Part of the highly successful Shelly Cashman Series, this text provides step-by-step instructions accompanied by full-color screen shots, helping students learn basic Office skills quickly and easily. Enhanced with new end-of-project exercises, new Web-based activities, an updated Introduction to Computers, coverage of Windows 2000, and more!

Quick Course in Microsoft Office 2000 (Quick Course)

OFFICE 2000 QUICK COURSE

Alison Balter's Mastering Microsoft Access 2000 Development (Other Sams)

Alison Balter's Mastering Access 2000 Development is a well-written, well-paced, and comprehensive tutorial on virtually every aspect of the new Access 2000, written for any beginning or intermediate developer. With its notable clarity, this book can put basic Access development within reach of many users.

As an introduction to or a review of Access and database basics, Mastering Access 2000 Development provides a really strong mix of clear explanations (for tables, queries, and reports) that will let you get up and running. One of the best features of this book is its patient introduction to the world of Visual Basic for Applications (VBA) programming. (If you've struggled to use VB/VBA before, these sections can make successful programming accessible to you.)

The decidedly low-end focus of this book doesn't mean that it skimps on more advanced features. Besides showing off the strengths of Access when used with SQL Server (including stored procedures), "black-belt" sections of the book look at Web support and the new Data Access Pages for delivering Web content. Sections on deployment and optimizing Access applications will be invaluable to any working Access developer.

Overall, it's the author's skill at explaining the fundamentals clearly that makes this a strong choice for readers seeking to get more out of the new Access 2000. Mastering Access 2000 Development is perfect for the Access user who wants to break through to successful database programming for the first time. --Richard Dragan

Topics covered: Access 2000, database basics, queries, reports, form design, VBA, scaling Access to SQL Server, ADO, DAO, client/server, deployment, Microsoft Office Developer (MOD) tools, Data Access Pages and Web support, and advanced features.

Alison's book takes a highly technical topic and presents it in a manner that is easy to comprehend. You'll want to read it from cover to cover, but it can also act as an excellent reference. Learn thorough knowledge of Access application development, real-world solutions to specific development and programming problems, and professional programming techniques backed by concise, no-nonsense explanations of the underlying theories. Debugging and troubleshooting methods are also included.

Teach Yourself® Microsoft® Access 2000

Teach Yourself Microsoft Access 2000 is the no-nonsense way to learn the basics of this popular database program. The short, clear steps, easy-reference format, and detailed visuals make it easier to hone those important Access skills in less time. Topics covered include: using wizards to create tables, queries, forms and reports, building relational databases to access and retrieve information, generating, analyzing and creating custom forms and reports, linking a database to a Word document or Excel spreadsheet, publishing Access documents on the Web, and more.