Software

Upgrade Version, Platform(s): PC; CD-ROM, DVD-ROM

How to Use •        Office: Organize information and add impact with clip art, SmartArt diagrams, tables, and charts with a new results-oriented interface •        Word: Create great-looking documents faster using themes, styles, and templates •        Excel: Use organizing, processing, and presenting tools to create data in Excel •        PowerPoint: Create powerful presentations faster using ready-made design templates and themes •        Outlook: Use tools for creating and managing your e-mail, calendar, contacts, and tasks •        Publisher: Use task panes to quickly create a brochure or a newsletter without being a designer •        SharePoint: Collaborate and share documents and information •        Prepare for the Microsoft Certified Application Specialist exam •        Practice your new skills with the useful workshops inside   On the Web This book uses real-world examples to give you a context in which to use a task. This book also includes  workshops to help you put together individual tasks into projects. The Office example files that you need for project tasks are available at www.perspection.com   Perspection has written and produced books on a variety of computer software—including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks—and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more than 5 million copies.   Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.   Chapter 1    Getting Started with Office         1 Chapter 2    Using Shared Office Tools 33 Chapter 3    Adding Art to Office Documents 57 Chapter 4    Adding Shapes to Office Documents    93 Chapter 5    Formatting Office Documents    115 Chapter 6    Creating a Document with Word          131 Chapter 7    Formatting a Document with Word      153 Chapter 8    Enhancing a Document with Word       173 Chapter 9    Creating a Worksheet with Excel         211 Chapter 10  Building a Worksheet with Excel 239 Chapter 11  Designing a Worksheet with Excel        281 Chapter 12  Creating a Presentation with PowerPoint       305 Chapter 13  Delivering a Presentation with PowerPoint      343 Chapter 14  Creating a Database with Access         375 Chapter 15  Locating and Managing Data with Access       405 Chapter 16  Presenting Data with Access      423 Chapter 17  Communication with Outlook     447 Chapter 18  Managing Information with Outlook     489 Chapter 19  Creating a Publication with Publisher     519 Chapter 20  Designing a Publication with Publisher   537 Chapter 21  Publishing Office Documents on the Web       557 Chapter 22  Protecting and Securing Office Documents     575 Chapter 23  Reviewing and Sharing Office Documents       605 Chapter 24  Expanding Office Functionality    647 New Features        673 Microsoft Certified Applications Specialist       683

Full Version, Platform(s): PC; Package Type: Retail, CD-ROM

Full Version, Platform(s): PC; CD-ROM

Full Version, Platform(s): PC; CD-ROM

Microsoft Office Access 2007   For those who would rather be shown how than told how     See How To Create databases more efficiently using a new results-oriented interface Use tools for building a database that makes information easier to find and use Import data from other programs, HTML, XML files, and other databases Use forms, filters, queries, and reports to capture and analyze data Discover ways to prevent data corruption and unauthorized access Share your data with others through interactive web pages Put your newly acquired skills to work using the online workshops Organize information and add impact with clip art, SmartArt diagrams, tables, and charts Use Groove and SharePoint Team Services to collaborate and share documents and information Prepare for the Microsoft Certified Application Specialist (MCAS) exam     On the Web This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Access example files that you need for project tasks are available at www.perspection.com   Author Bio Perspection has written and produced books on a variety of computer software–including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks–and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more   Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.   Category Database Covers    Microsoft Office Access 2007 User Level    Beginning–Intermediate     1 Getting Started with Access 2 Touring Access Databases 3 Planning and Creating a Custom Database 4 Working with Fields 5 Working with Tables 6 Locating Specific Information Using a Query 7 Simplifying Data Entry with Forms 8 Creating Reports to Convey Information 9 Improving the Appearance of Forms and Reports 10 Working on the Web 11 Importing and Exporting Information 12 Managing a Database 13 Protecting and Securing a Database 14 Customizing Access 15 Enhancing a Database with Programming 16 Working Together on Office Documents New Features Microsoft Certified Applications Specialist Index

Quickly teach yourself how to use Microsoft Office Access 2007, Excel 2007, Outlook 2007, PowerPoint 2007, and Word 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them! Take control of your day—organize your e-mail, calendar, and meetings Learn the essentials for creating effective documents Build spreadsheets and perform calculations on your data Design database applications to help manage information Produce and deliver compelling slide show presentations Organize and format text to craft professional-quality documents Your all-in-one learning experience includes: Files for building skills and practicing the book’s lessons Fully searchable eBook Bonus quick reference to the Ribbon, the new Microsoft Office interface Windows Vista Product Guide eBook—plus other resources on CD A Note Regarding the CD or DVDThe print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Upgrade Version, Platform(s): PC; Standard License, Package Type: Retail, For 1 Computer/s, CD-ROM, MPN: 8030ZC8

Experience learning made easy—and quickly teach yourself how to manage your projects with Project 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!Build a project plan and fine-tune the details Schedule tasks, assign resources, and manage dependencies Monitor progress and costs—and keep your project on track Format Gantt charts and other views to communicate project data Begin exploring enterprise project management systems Your all-in-one learning experience includes:Files for building skills and practicing the book’s lessons Fully searchable eBook Bonus guide to the Ribbon, the new Microsoft Office interface Quick course on project management in the Appendix Windows Vista® Product Guide eReference—plus other resources on CD A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Full Version, Platform(s): PC; Non-commercial License, Package Type: Retail, For 3 Computer/s, CD-ROM, DVD-ROM, MPN: 79G-00871

See How To   •    Create documents more efficiently using a new results-oriented interface •    Use formatting, editing, reviewing, and publishing tools to create documents in print and online •    Create great-looking documents faster using themes, styles, and templates •    Organize information and add impact with clip art, SmartArt diagrams, tables, and charts •    Create customized letters, labels, and envelopes •    Use the Full Reading view to comfortably read documents on screen •    Use the Outline and Draft views to develop your documents •    Use Groove and SharePoint Team Services to collaborate and share documents and information •    Prepare for the Microsoft Certified Applications Specialists exam   This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Word example files that you need for project tasks are available at www.perspection.com   Perspection has written and produced books on a variety of computer software–including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks–and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more than 5 million copies.   This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.   Introduction     xvii Chapter 1        Getting Started with Word      Chapter 2        Working with Simple Documents       Chapter 3        Formatting Documents           Chapter 4        Using Templates, Styles, and Themes          Chapter 5        Adding Graphics and Multimedia to Documents        Chapter 6        Adding Tables and Charts to Documents      Chapter 7        Creating Desktop Publishing Documents      Chapter 8        Working with Long Documents          Chapter 9        Working with Technical Documents  Chapter 10      Creating Mail Merge Documents        Chapter 11      Proofing and Printing Documents      Chapter 12      Publishing Documents on the Web    Chapter 13      Protecting and Securing Documents Chapter 14      Reviewing and Sharing Documents   Chapter 15      Sharing Information Between Programs        Chapter 16     Customizing Word    Chapter 17     Expanding Word Functionality         Chapter 18     Working Together on Office Documents    W        Workshops: Putting It All Together     New Features Microsoft Certified Applications Specialist      Index   

Dive into the essential features in Microsoft Office Access® 2007, Excel® 2007, Outlook® 2007, PowerPoint® 2007, and Word 2007. This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle what’s new in your favorite Microsoft Office programs—and challenge yourself to new levels of mastery! Expertly manage your inbox, contacts, and business information Master sophisticated document-layout and formatting techniques Build spreadsheets to help you perform complex calculations and data analysis Design databases, build data-collection forms, and manipulate data Learn advanced techniques for creating charts and reports Create dynamic slides using themes, custom slide layouts, and special effects Explore Office Groove® 2007 and Windows® SharePoint® Services for powerful collaboration Configure security and privacy settings to help thwart worms, viruses, and malware Write macros using Microsoft Visual Basic® for Applications and work with Office Open XML CD includes: Fully searchable eBook—plus bonus chapters! 30+ sample files—spreadsheets, databases, code, and XML Resources for customizing, configuring, and troubleshooting programs Links to demos, webcasts, training courses, and blogs Visual references for finding commands in the Microsoft Office Fluent user interface Online resources for InfoPath® 2007, OneNote® 2007, Project 2007, and Visio® 2007 Windows Vista® Product Guide eReference and other eBooks A Note Regarding the CD or DVDThe print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Platform(s): PC

<>This book offers you comprehensive, information on using the new version of Access. Not only updated for the latest version, new chapters have been added on application automation with Access macros and collaboration with Microsoft SharePoint Team Server, both of which are hot topics.  All chapters are updated for the transition from Jet to the new Access database engine. Detailed, step-by-step instructions with icons guide you through Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports.   FM Introduction I Getting Acquainted with Access 2007 1 Access 2007 for Access 200x Users: What’s New 2 Building Simple Tracking Applications 3 Navigating the New Access User Interface II Learning the Fundamentals of Access Databases 4 Exploring Relational Database Theory and Practice 5 Working with Access Databases and Tables 6 Entering, Editing, and Validating Access Table Data 7 Sorting, Finding, and Filtering Data 8 Linking, Importing, and Exporting Data III Transforming Data with Queries and PivotTables 9 Designing Queries for Access Databases 10 Understanding Access Operators and Expressions 11 Creating Multitable and Crosstab Queries 12 Working with PivotTable and PivotChart Views 13 Creating and Updating Access Tables with Action Queries IV Designing Forms and Reports 14 Creating and Using Basic Access Forms 15 Designing Custom Multitable Forms 16 Working with Simple Reports and Mailing Labels 17 Preparing Advanced Reports 18 Adding Graphs, PivotCharts, and PivotTables V Moving to Networked Multiuser Applications 19 Linking Access Front Ends to Access and Client/Server Tables 20 Exploring Access Data Projects and SQL Server 2005 21 Moving from Access Queries to Transact-SQL 22 Upsizing Access Applications to Access Data Projects VI Collaborating with Access Data 23 Importing and Exporting Web Pages 24 Integrating with XML and InfoPath 2007 25 Collaborating with Windows SharePoint Services VII Programming and Converting Access Applications 26 Automating Access Applications with Macros 2007 27 Learning Visual Basic for Applications 28 Handling Events with VBA and Macros 29 Programming Combo and List Boxes 30 Understanding Data Access Objects, OLE DB, and ADO 31 Upgrading 200X Applications to Access 2007 VIII Appendix A Glossary Index

The Ultimate Microsoft Office Access 2007 ResourceBuild a highly responsive a database so you can track, report, and share information and make more informed decisions. This comprehensive resource shows you how to design and develop custom Access 2007 databases--even if you have little or no programming experience. You'll learn to collect data from a variety of sources, share it securely with others, and integrate it with other Office applications. Filled with detailed, easy-to-follow instructions, Microsoft Office Access 2007: The Complete Reference shows you how to take full advantage of all the new features, including the new ribbon user interface and navigation pane, new field types, and more. Create a reliable and versatile information management solution with help from this all-inclusive guide. As a bonus, you can gain hands-on experience by following along with the book's sample databases on the CD-ROM.Customize the user interface to suit your preferences Use the built-in database templates or design your ownCreate, modify, and relate tablesEnter and edit dataWrite advanced queries to extract and manipulate informationCreate customized forms and reportsImprove performance and back up your databaseDevelop macros to carry out automated responses to user actionsImport, link, and export dataEnable a multiple-user environmentSecure your database

Full Version, Platform(s): PC; Package Type: OEM (License Only), CD-ROM, MPN: 269-11618

Completely redesigned to help users finish tasks more quickly and manage information more effectively, Microsoft Office 2007 will offer users a new look and smarter ways of getting things done. From the expanded depth and power of Excel 2007 to the new graphics capabilities and formatting tools of PowerPoint, Microsoft has rethought and reworked the entire suite. And in this new edition of our Office Visual QuickStart Guide, author Steve Schwartz has rewritten from the ground up the entire book to better aid readers as they get up to speed with the new Office tools. The book is essential reference tool for the home and small business user, covering everything in the Office Basic, Home & Student, Standard, and Small Business suites. Software covered includes: Word, Excel, OneNote, Outlook, PowerPoint, and Publisher. Easy visual approach uses pictures to guide you through Microsoft Office and show you what to do. Concise steps and explanations let you get up and running in no time. Page for page, the best content and value around. Table of Contents: Part I:    Introducing Microsoft Office 2007 Chapter 1:    What's New in Office 2007? Chapter 2:    Office Basics Part II:    Microsoft Word Chapter 3:    Getting Started with Word 2007 Chapter 4:    Formatting Documents Chapter 5:    Creating Outlines Chapter 6:    Tables, Charts, and Art Chapter 7:    Sharing Word Documents Part III:    Microsoft Excel Chapter 8:    Getting Started with Excel 2007 Chapter 9:    Formatting Worksheets and Data Chapter 10:   Formulas and Functions Chapter 11:   Working with Tables Chapter 12:   Creating Charts Part IV:    Microsoft PowerPoint Chapter 13:    Getting Started with PowerPoint 2007 Chapter 14:    Creating a Presentation Chapter 15:    Completing a Presentation Part V:    Microsoft Outlook Chapter 16:    Getting Started with Outlook 2007 Chapter 17:    Using the Address Book Chapter 18:    Composing and Sending Mail Chapter 19:    Receiving Mail Chapter 20:    Managing the Mail Chapter 21:    Tasks and Appointments Part VI:    Microsoft OneNote Chapter 22:    Getting Started with OneNote 2007 Chapter 23:    Creating Notes Chapter 24:    Embellishing and Editing Notes Chapter 25:    Managing Notes Part VII:    Microsoft Publisher Chapter 26:    Getting Started with Publisher 2007 Chapter 27:    Distributing and Printing Index

Special Edition Using Microsoft Office Home and Student 2007 THE ONLY OFFICE BOOK YOU NEED We crafted this book to grow with you, providing the reference material you need as you move toward Office 2007 proficiency and use of more advanced features. If you buy only one book on Office Home and Student 2007, Special Edition Using Microsoft Office Home and Student 2007 is the book you need. Office Home and Student 2007 is available to ANYONE, regardless of whether you are a student, a teacher, or neither. The only condition Microsoft attaches is the requirement that the software not be used for commercial purposes. For use in the home or classroom, Office Home and Student 2007 is an exceptional deal at a fraction of the cost of the business versions!    •     No other authoring team in the business is as well recognized and respected as the Office Dream Team; when they speak, even the Office development team at Microsoft listens!    •     This book is a category killer–one that sets the pace for others to follow!    •     Tired of Office books that read as though Microsoft employees wrote them? Tired of learning the Microsoft way? Tired of books containing little more than you can pull from the Help system? If you answered yes to any of these questions, then you owe it to yourself to get a copy of this book!    •     If you own a copy of Office Home and Student 2007, you deserve a copy of this book! Here, you’ll find a bevy of previously undocumented tips and tricks that will show you how to harness the power of Office 2007!    •     Written in clear, plain English, readers will feel as though they are learning from real humans and not Microsoft clones. Sprinkled with a wry sense of humor and an amazing depth of field, this book most certainly isn’t your run-of-the-mill computer book “Another Special Edition Winner! Clear, concise and right on-target. Everything a student or a home user will need to know in order to master Office 2007.” –Alan & Sandra Ashendorf, Hosts of Let’s Talk Computers Radio Talk Show   Ed Bott is a best-selling author of more than 25 computer books and an award-winning computer journalist with two decades of experience in the personal computer industry. He is a three-time winner of the Computer Press Award, and he and Woody Leonhard won the prestigious Jesse H. Neal Award, sometimes referred to as “the Pulitzer Prize of the business press, ” in back-to-back years for their work on PC Computing’s “Windows SuperGuide.” You can read more of Ed’s writing at http://www.edbott.com/weblog. Curmudgeon, critic, and perennial “Office Victim, ” Woody Leonhard runs a fiercely independent website with up-to-the-nanosecond news, observations, tips, and help for both Office and Windows. AskWoody.com has become the premier source of unbiased information for people who need to really use Windows and Office, and for people concerned about juggling the neverending stream of Microsoft patches. In the past 15 years, Woody has written more than three dozen books, drawing an unprecedented six Computer Press Association awards and two American Business Press awards. Woody was one of the first Microsoft Consulting Partners and is a charter member of the Microsoft Solutions Provider organization. Category: Integrated Suites Covers: Microsoft Office Home and Student 2007 User Level: Beginner–Intermediate  

Experience learning made easy quickly learn how to use Office Groove 2007 to dynamically and effectively collaborate with team members. Work at your own pace through the easy numbered steps, practice files on CD, helpful hints, and troubleshooting tips and learn how to work better together. You ll learn the basics for getting started, including how to manage your Groove 2007 accounts and contacts and how to create new workspaces. After you re up and running, you'll discover the communication features of Groove 2007, and see the benefits of tight integration with Office Communicator and Windows LiveTM Messenger. You ll learn how to manage your messages and chat in real time, and how to manage your appointments and notes. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction, building and practicing the skills you need, just when you need them! Includes an easy-search companion CD with hands-on practice files, a complete eBook, a bonus quick reference to the new user interface, and more! Key Book BenefitsLearn how to use Office Groove 2007 by taking just the lessons you need or by working from cover to cover you set the paceIncludes coverage of the fundamentals, including setting up workspaces, managing your communications, and managing meetings and notesFeatures easy-to-follow lessons and hands-on, skill-building exercisesIncludes a companion CD with practice files and other resources

The smart way to learn Microsoft Office Excel® 2007, Office OneNote® 2007, Office PowerPoint® 2007, and Office Word 2007 one step at a time! Work at your own pace through the easy, numbered steps, practice files on CD, helpful hints, and troubleshooting help to master the fundamentals of working with the Microsoft Office programs in Office Home and Student 2007, including how to navigate the new user interface. You will discover how to create, edit, and proofread documents and create polished presentations that you can really be proud of. You ll also learn how to create spreadsheets and quickly calculate data. Plus learn how to digitally manage all of your notes so that you can easily find them and take action! With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction building and practicing the skills you need, just when you need them! Includes a companion CD with hands-on practice files.Key Book Benefits:Learn how to use Office Home and Student 2007 by taking just the lessons you need or by working from cover to cover you set the pace.Includes coverage of the fundamentals for working with Excel 2007, OneNote 2007, PowerPoint 2007, and Word 20007 including creating attractive documents and presentations, organizing data and performing calculations, and digitally managing your notes.Features easy-to-follow lessons and hands-on skill-building exercises.Includes a companion CD with practice files and other resources.

Experience learning made easy quickly learn how to use Office Groove 2007 to dynamically and effectively collaborate with team members. Work at your own pace through the easy numbered steps, practice files on CD, helpful hints, and troubleshooting tips and learn how to work better together. You ll learn the basics for getting started, including how to manage your Groove 2007 accounts and contacts and how to create new workspaces. After you re up and running, you'll discover the communication features of Groove 2007, and see the benefits of tight integration with Office Communicator and Windows LiveTM Messenger. You ll learn how to manage your messages and chat in real time, and how to manage your appointments and notes. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction, building and practicing the skills you need, just when you need them! Includes an easy-search companion CD with hands-on practice files, a complete eBook, a bonus quick reference to the new user interface, and more! Key Book BenefitsLearn how to use Office Groove 2007 by taking just the lessons you need or by working from cover to cover you set the paceIncludes coverage of the fundamentals, including setting up workspaces, managing your communications, and managing meetings and notesFeatures easy-to-follow lessons and hands-on, skill-building exercisesIncludes a companion CD with practice files and other resources

Experience learning made easy—and quickly teach yourself how to build database solutions with Access 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!Build databases from scratch or from templates Exchange data with other databases and Office documents Create forms to simplify data entry Use filters and queries to find and analyze information Design rich reports that help make your data meaningful Help prevent data corruption and unauthorized access Your all-in-one learning experience includes:Files for building skills and practicing the book’s lessons Fully searchable eBook Bonus quick reference to the Ribbon, the new Microsoft Office interface Windows Vista® Product Guide eReference—plus other resources on CD A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

The smart way to learn Microsoft Office Accounting Professional 2007 one step at a time! Work at your own pace through the easy numbered steps, practice files on CD, helpful hints, and troubleshooting tips to master the fundamentals of communicating your message effectively with the latest version of Office Accounting Professional. Updated from Microsoft Office Small Business Accounting 2006 Step by Step, you will discover the latest features in the accounting solution aimed at small business owners. You will learn how to manage your business financials, get a complete view of your business, and help your business flourish no accounting experience required. You will even learn how to sell products online and get paid faster. Plus, discover how to integrate your work with other Microsoft Office programs, including Microsoft Office Excel® 2007 and Microsoft Office Word 2007. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction, building and practicing the skills you need, just when you need them! This guide also includes coverage of Office Accounting Express 2007. Includes an easy-search companion CD with hands-on practice files, a complete eBook, and more!

Platform(s): PC; DVD-ROM, MPN: TMSO 2007 BUNDLE

Experience learning made easy—and quickly teach yourself how to create impressive documents with Word 2007. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!Apply styles and themes to your document for a polished look Add graphics and text effects—and see a live preview Organize information with new SmartArt® diagrams and charts Insert references, footnotes, indexes, a table of contents Send documents for review and manage revisions Turn your ideas into blogs, Web pages, and more Your all-in-one learning experience includes:Files for building skills and practicing the book’s lessons Fully searchable eBook Bonus quick reference to the Ribbon, the new Microsoft Office interface Windows Vista® Product Guide eBook—plus more resources and extras on CD A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Learn everything you need to know for working with Microsoft Office Project 2007. This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds for using Office Project 2007. Whether youre a project manager or just working to meet your deadlines, youll be able to dig in to the work-ready resources that help you plan, manage, and communicate project information more effectively. Youll learn how to develop a project plan; orchestrate project scope, resources, and time; track your progress; collaborate with others; and report and analyze all your project information. You'll also learn how to manage and participate in projects with Office Project 2007's enterprise project management capabilities. You'll even learn how to administer users and enterprise resource pools in Project Server 2007.

“Everything you need to master Access 2007 forms, reports, and queries.” –Charles Carr, Reviews Editor, ComputorEdge Magazine   Create Forms for Business Ensure Data Entry Accuracy Build Elegant Form Interfaces Collect Data Via Email Design Effective Business Reports Make an Invoice Report Create Mailing Labels Extract Data Work with Multiple Tables Calculate Discounts Analyze Data   Develop your Microsoft Access expertise instantly with proven techniques   Let’s face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database.  Without a more sophisticated knowledge of how to extract and present that data, you’re forced to rely on office gurus and overworked IT people to provide canned reports or one-size-fits-all solutions.   This book changes all that by giving you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power. ·        Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries. ·        Avoids database theory in favor of practical know-how that you can put to use right away. ·        Packed full of real-world examples and techniques to help you learn and understand the importance of each section. ·        Covers what’s new and changed in Microsoft Access 2007.   Introduction Part I: Creating Forms Chapter 1         Creating and Using a Form Chapter 2         Working with Form Controls Chapter 3         Designing Forms for Efficient and Accurate Data Entry Chapter 4         Designing Forms for Business Use Chapter 5         Creating Specialized Forms Part II: Designing and Customizing Reports Chapter 6         Creating and Publishing a Report Chapter 7         Designing Effective Business Reports Chapter 8         Designing Advanced Reports Chapter 9         Creating Specialized Reports Part III: Creating Powerful Queries Chapter 10       Creating a Basic Query Chapter 11       Building Criteria Expressions Chapter 12       Working with Multiple-Table Queries Chapter 13       Creating Advanced Queries Chapter 14       Creating PivotTable Queries Chapter 15       Querying with SQL Statements Index

The In Business system is the only series that prepares you expressly for your core business classes such as Accounting, Economics, Marketing, Finance and Business Statistics by doing the following:  exposing you to real business files that meet professional standards; providing a useful reference to be used in your business classes;  instructing how to use the software as a tool to accomplish business goals; coverage of the core Office skills that you will need in your business courses. In Business includes tools that will benefit any style of learning. Whether you need to reference specific skills for another course or understand how to utilize Microsoft Office to complete your business objectives, In Business will allow you to apply these skills directly to your own education and career aspirations. Microsoft Office Access 2007 In Business, Core, 1/e covers the following topics: introduction to Access; database tables; selecting and summarizing data from tables; applying calculations to data; reports; and applying core competencies.  Ideal for business students and professionals.

“VBA for the 2007 Microsoft Office System is jam-packed with code samples that you’ll be able to reuse right away in your VBA projects.” —Guy Barrette, Microsoft MVP & Regional Director, .NET Expertise   Develop your VBA expertise instantly with proven techniques VBA for the 2007 Microsoft® Office System shows you how to take full advantage of the 2007 Microsoft Office suite by automating routine Office tasks. No matter which Office application you’re using, there are some tasks you perform dozens of times, such as typing a section of text, running a series of menu commands, or formatting a document in a particular way.This book shows you how to accomplish the same tasks by incorporating them into a macro that you can run with just a few mouse clicks or keystrokes. This book shows you the basics of VBA programming from the ground up. Even if you’ve never programmed before, VBA for the 2007 Microsoft® Office System will have you up to speed with VBA in no time.You’ll learn how to write programs that control Word, Excel, PowerPoint, Access databases, and even Outlook email.You get dozens of example macros that not only illustrate the concepts in the book but also provide you with practical, business-oriented tools that you can use right away to improve your productivity.   Practical, real-world examples for anyone who uses Office applications—not just power users. Automate or streamline all your repetitive Word, Excel, and PowerPoint chores. Create custom dialog boxes and custom Ribbon tabs, groups, and buttons to make Office look and work the way you want it to—no program experience required! Easy-to-understand instructions that make learning VBA fast and fun. All code examples and documents are available online so you can get started with VBA with a minimum of fuss.   Automate Routine Tasks Control Word, Excel, and PowerPoint Program Access Databases Automate Document Backups Create Advanced Email Rules Build Custom Dialog Boxes Customize the Office 2007 Ribbon Access the Registry Troubleshoot Macro Problems Control Macro Security   Introduction  I Getting Started with VBA 1 Creating and Running Recorded Macros  2 Writing Your Own Macros  3 Understanding Program Variables  4 Building VBA Expressions  5 Working with Objects  6 Controlling Your VBA Code  II Putting VBA to Work 7 Programming Word  8 Programming Excel  9 Programming PowerPoint  10 Programming Access Databases  11 Programming Outlook Email  III Getting the Most Out of VBA 12 Creating Custom VBA Dialog Boxes  13 Customizing the Office 2007 Ribbon  14 VBA Tips and Techniques  15 Trapping Program Errors  16 Debugging VBA Procedures  IV Appendixes A VBA Statements  B VBA Functions  Index  

One Book…All the Answers   In just a short time you will be up and running with Microsoft Office 2007, including Word, Excel, PowerPoint, Outlook, and OneNote.   Using a straightforward, step-by-step approach, each lesson builds upon a real-world foundation, allowing you to learn the essentials of Office 2007 from the ground up.   Thorough instructions walk you through the most common tasks and show you extra features that make your Office 2007 documents stand apart from the crowd.   Notes present interesting pieces of information, extra features you can use, and warnings to protect your data.   Tips offer extra advice or teach an easier way to do something.   Learn how to… Leverage New Features to Do More Work in Less Time Master Office 2007’s New Ribbon Use Live Preview to See How Changes Will Affect Your Documents Create Online Web Pages from Your Office Documents, Worksheets, and Presentations Apply a Consistent Theme to All Your Documents, Worksheets, and Presentations Format Word Documents to Grab Attention Without Taking Away from the Message You Want to Convey Perform Mail Merging with Ease Set Up Powerful Worksheet Page Formats Drop Audio and Video into Your PowerPoint Presentations Organize Your Email to Work Smarter Locate Outlook Contacts on a Global Map Maximize Note Taking with OneNote Part I: Introducing Microsoft Office 2007 1 Chapter 1: Start Here      3   PART II: Writing with Word   29 Chapter 2: Learning Word’s Basics      31 Chapter 3: Making Your Words Look Good    69 Chapter 4: Adding Lists, Tables, and Graphics          107 Chapter 5: Using Word’s Advanced Features 147   PART III: Working with Excel Worksheets        201 Chapter 6: Getting to Know Excel       203 Chapter 7: Working with Excel Data    243 Chapter 8: Formatting Worksheets with Excel         273 Chapter 9: Creating Advanced Worksheets   303 Chapter 10: Using Excel as a Simple Database        329   PART IV: Impressing Audiences with PowerPoint      347 Chapter 11: Learning About PowerPoint        349 Chapter 12: Adding Flair to Your Presentations        371 Chapter 13: Making More Impressive Presentations          393   PART V: Organizing with Outlook    429 Chapter 14: Introducing Outlook         431 Chapter 15: Making Contact      475 Chapter 16: Living with Outlook 497   PART VI: Enhancing Your Work with Other Office Features 517 Chapter 17: Making Notes with OneNote      519 Chapter 18: Automatic Office    541 Chapter 19: Sharing Data Among Office Applications         563 Chapter 20: Combining Office and the Internet        581