* The most comprehensive reference on this popular database management tool, fully updated with the new features of Access "X" including increased use of XML and Web services * Explores the new, tighter integration with SharePoint and BizTalk in Office "X" that enables greater flexibility for gathering and manipulating data * Written by an international bestselling author team with several books to their credit, including previous editions of Access Bible * Gets Access beginners started with hundreds of examples, tips, and techniques for getting the most from Access * Offers advanced programming information for serious professionals * CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach’s Power Utility Pak

Written by two of the industry’s top Flash experts, this new edition of the best-selling classic has been revised and enhanced to cover the very latest release of Macromedia Flash.Показать полностьюWritten by two of the industry’s top Flash experts, this new edition of the best-selling classic has been revised and enhanced to cover the very latest release of Macromedia Flash. User-friendly, yet in-depth this is the book that serves as an indispensable reference for anyone — from the web novice to the accomplished web worker — and functions as the perfect, real-world guide to the workings and capabilities of this powerful program. The accompanying CD-ROM includes trial software, custom components and finished examples. * Totally enhanced and revised edition of the all-time Flash classic reference! * Everything you need to know to learn and master the Macromedia Flash 8 — the most comprehensive Flash reference available * Includes a CD-ROM packed with files from the book and valuable tryouts. * Co-author Robert Reinhardt is one of the two or three top stars in the Flash developer community, speaking regularly at FlashForward, the Macromedia User’s Conference, WebTEK, Macromedia’s traveling user seminars, and major universities. No other title matches this one in both comprehensiveness and author reputation. * Includes expert tutorials from the world’s leading Flash gurus * Includes tips for integrating Flash with other programs * Includes unpublished tricks, techniques and time-savers

In just 24 lessons of one hour or less, you will be able to churn out worksheets, charts, drawings, and databases,with all the help you need. Using a straightforward, step-by-step approach, each lesson builds on the previous ones, enabling you to learn the essentials of Microsoft Office Excel 2003 from the ground up.

Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place.Показать полностьюWhy program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it’s about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions. The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes. VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO). This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects. With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages. With this single-source reference and how-to guide, you'll learn to use the complete range of Excel programming tasks to solve problems, no matter what you're experience level.

Millions of people use Microsoft Access, but only a small fraction of them are really comfortable with it. If you're ready to go "beyond the wizards"and become a confident, highly effective Access userHands-On Microsoft Access was written for you. In plain English, Bob Schneider helps you master crucial principles for building flexible, powerful databases.Показать полностьюMillions of people use Microsoft Access, but only a small fraction of them are really comfortable with it. If you're ready to go "beyond the wizards"and become a confident, highly effective Access userHands-On Microsoft Access was written for you. In plain English, Bob Schneider helps you master crucial principles for building flexible, powerful databases. Discover how to enter data more easily, retrieve it more freely, manipulate it more successfully, analyze it with greater sophistication, and share it more effectively. Schneider’s dozens of hands-on examples thoroughly demystify Access, and his friendly, conversational style makes it more approachable than ever before. Hands-On Microsoft Access presents solutions for the challenges you're most likely to encounter, including How do Access objects and interfaces fit together, and when should I use each one? What’s the best way for me to organize my fields into tables? How can I modify the tables, forms, and reports an Access wizard created for me? How can I design forms and reports for people to use more effectively? How do primary keys and relationships work, and why are they so important? How do I make sure my data stays consistent and accurate? How do I build queries that give me the right informationquickly, efficiently, and reliably? How do I use data from other sources, or deliver Access data to other people or programs? What are PivotTables and PivotCharts, what can I do with them, and how do I use them? Written for Access 2003, this book also contains special instructions for Access 2002 users and extensive coverage of issues relevant to Access 95, 97, and 2000.

Make Excel work harder and faster for you. This unique book presents sample code for more than twenty practical, high-powered Excel VBA macro applications. You’ll get all the essentials of VBA, and then explore ways to power Excel with VBA. Automate tasks, convert numbers to labels, transpose cells, add formula details, globally changes values, and much, much more.

This book/CD-ROM package uses simple examples to teach readers how to create Excel programs. It walks through the basics of using the Visual Basic Editor that comes with Microsoft Office, covers the Excel Object Model, and illustrates how to use the various objects, properties, and methods to create macros.Показать полностьюThis book/CD-ROM package uses simple examples to teach readers how to create Excel programs. It walks through the basics of using the Visual Basic Editor that comes with Microsoft Office, covers the Excel Object Model, and illustrates how to use the various objects, properties, and methods to create macros. Although the book requires no experience with programming, familiarity with the Windows operating system is helpful. The CD-ROM contains trial and demo software, sample code and spreadsheets from the book, and a searchable version of the book. Simon is the author of several computer books. The book shows Hungry Minds as the publisher, but that company is now part of Wiley.

* Updated to cover all the latest features and capabilities of Access 2007, this resource provides new and inexperienced Access users with nine task-oriented minibooks that cover beginning to advanced-level material * Each minibook covers a specific aspect of Access, such as database design, tables, queries, forms, reports, and macros * Shows how to accomplish specific tasks such as database housekeeping, security data, and using Access with the Web * Access is the world’s leading desktop database solution and is used by millions of people to store, organize, view, analyze, and share data, as well as to build powerful, custom database solutions that integrate with the Web and enterprise data sources

This book is for the Access user who already has a basic knowledge of databases, and the basic objects of an Access database, and now wishes to expand on their existing knowledge of Access by learning to program in VBA.

Now you can do the things you do every day with FrontPage 2003—design and publish Web pages, create rich content, add dynamic features—but do them faster, smarter, and better.Показать полностьюNow you can do the things you do every day with FrontPage 2003—design and publish Web pages, create rich content, add dynamic features—but do them faster, smarter, and better. Dive in! This friendly, focused guide shows the best ways to get a great-looking Web site up and running, so you spend more time doing and less time learning. Use the quick lists, numbered steps, and helpful examples to accelerate your productivity—and do the cool things you want to do! Get expert tips to design and organize your Web pages Make templates, wizards, and themes work harder for you Take control of your site’s look—and add polish—with style sheets, tables, and layers Create amazing still images, video clips, animations, soundtracks, and more Generate and clean up your HTML and XML code—faster Produce easy-to-use forms, real-time feeds, and other database-driven features Extend the power of your Web to connect people and information in new ways

MICROSOFT EXCEL Version 2002 INSIDE OUT is the foremost reference to Excel version 2002 for PC “super users”. Complete in one volume, this book provides a thorough overview of the most-used features and functions of Microsoft’s popular spreadsheet program.Показать полностьюMICROSOFT EXCEL Version 2002 INSIDE OUT is the foremost reference to Excel version 2002 for PC “super users”. Complete in one volume, this book provides a thorough overview of the most-used features and functions of Microsoft’s popular spreadsheet program. The book provides the information advanced users really need. It delivers comprehensive information about each major Excel tool and task, including using worksheets, analyzing data, interfacing with other applications, using charts, creating databases and managing lists, and more. The book also shows how to create macros, use custom functions, and master Excel by using the Microsoft Visual Basic development system. Throughout the book you'll find a wealth of timesaving Excel tips and tricks, troubleshooting techniques, and indexes, plus a CD-ROM that holds an electronic version of the book’s text, handy Web links, sample macros and code, tutorials, utilities and additional third party software. This is the authoritative handbook you'll keep by your computer and use whenever you're stuck or stumped!

Dig into Project 2003—and discover how you can really put your project management skills to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds in concise, fast-answer format.Показать полностьюDig into Project 2003—and discover how you can really put your project management skills to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds in concise, fast-answer format. It’s all muscle and no fluff. Find the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Project mastery! •Master powerful tools for orchestrating project scope, resources, and time •Learn expert ways to monitor progress and costs, make corrections, and stay on course •Enable Web-based project collaboration, tracking, and reporting for project stakeholders •Skillfully coordinate multiple projects and resource pools •Simplify work by exchanging information between other projects and Microsoft Office programs •Employ advanced solutions to improve enterprise-wide project and resource management •Customize Project to work your way with macros and Microsoft Visual Basic for Applications (VBA)

Fast-paced and easy to read, this new book teaches you the basics of PowerPoint 2007 so you can start using the program right away. This concise guide shows readers how to work with PowerPoint’s most useful features and its completely redesigned interface.Показать полностьюFast-paced and easy to read, this new book teaches you the basics of PowerPoint 2007 so you can start using the program right away. This concise guide shows readers how to work with PowerPoint’s most useful features and its completely redesigned interface. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of timesaving advice, PowerPoint 2007 for Starters: The Missing Manual will quickly teach you to: Create, save, set up, run, and print a basic bullets-and-background slideshow Learn how to add pictures, sound, video, animated effects, and controls (buttons and links) to your slides Discover how to incorporate text, spreadsheets, and animations created in other programs The new PowerPoint is radically different from previous versions. Over the past decade, PowerPoint has grown in complexity, but its once-simple toolbar has been packed with so many features that not even the pros could find them all. For PowerPoint 2007, Microsoft redesigned the user interface completely, adding a tabbed toolbar that makes every feature easy to locate. Unfortunately, Microsoft’s documentation is as scant as ever, so even if you find the features you need, you still may not know what to do with them. But with this book, you can breeze through the new user interface and its timesaving features in no time. PowerPoint 2007 for Starters: The Missing Manual is the perfect primer for anyone who needs to create effective presentations.

Hey, you know your way around a database—so now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer format.Показать полностьюHey, you know your way around a database—so now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer format. It’s all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Access mastery! •Build on what you already know about Access and quickly dive into what’s new •Design your database the way the experts do—and sidestep common mistakes •Import data from spreadsheets, text files, databases, and other sources •Write simple to sophisticated queries to manipulate data •Learn advanced techniques for building forms and reports •Develop PivotTable and PivotChart dynamic views •Tap the power of Microsoft SQL Server with Access projects and views, functions, and stored procedures •Implement database security features •Deliver dynamic data on the Web with data access pages and XML •Use Microsoft Visual Basic for Applications (VBA) and script to automate your applications and Web pages

* The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features * Written by the leading Excel guru known as "Mr.Показать полностью* The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features * Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss * The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more * Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information * Explores Excel programming for those who want advanced information * CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office XP related Bibles and useful third party software, including John Walkenbach’s Power Utility Pak

Master the programming features in Excel 2002 and unleash the power of VBA with expert guidance from "Mr. Spreadsheet" - expert author John Walkenbach! This is the ideal guide for Excel developers who want to get the most out of Excel with VBA, more than they ever thought was possible.Показать полностьюMaster the programming features in Excel 2002 and unleash the power of VBA with expert guidance from "Mr. Spreadsheet" - expert author John Walkenbach! This is the ideal guide for Excel developers who want to get the most out of Excel with VBA, more than they ever thought was possible. It’s also perfect for beginning developers who want to quickly learn how to tap the full potential of Excel programming using VBA. Includes: * Explanation of effective techniques of Excel Application Development * Thoroughly explains how to use Visual Basic for Applications to add power to Excel Applications * Gives tricks and tips for interacting with other applications * Presents info on how to develop Excel utilities with VBA * Explores the Data Access Object, the powerful feature that makes it easier to work with external database files in VBA * Shows how to create custom menus, toolbars, help applications, and more * Gives complete instructions on how to use VBA to design and create 3D charts * Teaches VBA by presenting extensive code examples in the text * Provides hundreds of useful examples that demonstrate the most effective methods for implementing VBA

The book contains everything that you need to know to learn the basics of Excel and then move on to more advanced topics at your own pace. You’ll find many useful examples and lots of tips and tricks that I’ve accumulated over the years.

* This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere * Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else * John Walkenbach, aka "Mr.Показать полностью* This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere * Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else * John Walkenbach, aka "Mr. Spreadsheet," is one of the liworld’s leading authorities on Excel * Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features * Includes a valuable CD-ROM with templates and worksheets from the book

Dig into Microsoft Visio 2003—and discover how you can really put your business diagrams and technical drawings to work! This supremely organized reference packs all the information you need to master every major tool, task, and enhancement in Visio 2003—without the fluff.Показать полностьюDig into Microsoft Visio 2003—and discover how you can really put your business diagrams and technical drawings to work! This supremely organized reference packs all the information you need to master every major tool, task, and enhancement in Visio 2003—without the fluff. Learn how to create exactly the diagram you need—from basic flowcharts to organization charts, computer networks, and office layouts. Work smarter with core functions for diagramming assets; planning projects and presentations; using templates; and customizing and saving shapes. Quickly advance your expertise with new Visio features and capabilities; use advanced Microsoft ShapeSheet® techniques; extend Visio with code written with Microsoft Visual Basic®; take advantage of Visio integration with Microsoft .NET technology; and more. You’ll gain hundreds of timesaving solutions, troubleshooting tips, and handy workarounds in concise, fast-answer format. On the companion CD you get an eBook of Microsoft Office Visio 2003 Inside Out. You also get a collection of Microsoft resources for learning about Visio, a catalog of 3rd-party Visio resources, and two additional e-books—the Microsoft Computer Dictionary, Fifth Edition and the Insider’s Guide to Microsoft Office OneNote 2003. With INSIDE OUT, you’ll discover the best and fastest ways to perform everyday tasks—and challenge yourself to new levels of Visio mastery!

Find and use the features you need right away Create great documents, Excel charts, and slide shows, and organize your e-mail What’s new at the Office? A lot, and this book takes you through all the cool changes and enhancements so you can rev up and go.Показать полностьюFind and use the features you need right away Create great documents, Excel charts, and slide shows, and organize your e-mail What’s new at the Office? A lot, and this book takes you through all the cool changes and enhancements so you can rev up and go. Find your way around the new interface, dress up your documents, create spreadsheets that actually make sense, give presentations that wow your audience, and organize your life. Discover how to * Locate commands on the Ribbon * Use Live Preview * Stop spam with Outlook(r) * Format and enhance Word documents * Work with Excel(r) formulas * Store and find data in Access