Microsoft Office Access 2007 On Demand

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

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 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.

How to use • Create workbooks more efficiently using a new results-oriented interface • Use data-analysis tools and techniques for better decision making • Use organizing, processing, and presenting tools to create data in Excel • Integrate data from external sources and add hyperlinks • Use conditional formatting to visualize results • Add impact to your data with PivotTable and PivotChart reports • Create organizational data reporting and publishing solutions • 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 • 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 the task. This book also includes workshops to help you put together individual tasks into projects. The Excel example files that you need for project tasks are available at www.perspection.com. 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.

Look beyond the hype–new and noteworthy and what Vista really means for tomorrow’s desktop. Covers the Beta 2 release of Windows® Vista An unbiased, unvarnished sneak peek at everything that’s new, noteworthy, and ready for prime time in Windows Vista. Microsoft Windows Vista Unveiled is an in-depth exploration of the public release Beta 2 version of Windows Vista, Microsoft’s next major operating system and the successor to Windows XP. Whether you’re just planning ahead for a future upgrade or running Beta 2 already, Microsoft Windows Vista Unveiled takes you on a detailed tour of all the new and improved technologies, features, tools, and programs that Microsoft programmers have stitched into the Vista fabric. You will learn not only what features are new in Vista, but also why they’re important (or not), who they were designed for, and how they will affect your computing life. The goal of this book is to give you an exhaustive sneak preview of Vista’s innovations and changes so that by the end of the book you should know whether Vista is for you and what you can expect when you sit down in front of this new operating system. Here’s what you’ll find inside… In-depth coverage of all the new and improved Windows Vista tools and technologies A tour of the new Windows Vista interface, including Aero Glass What hardware you need to get the most out of Windows Vista Vista’s file system improvements, including tags, Quick Search, and virtual folders A review of Vista’s new performance and stability features A critical look at the beefed-up security features, including Windows Defender, the new Firewall, and User Account Control A complete look at Vista’s totally redesigned networking tools In-depth coverage of Vista’s new and improved tools for notebooks and Tablet PCs, digital media, and gaming Paul McFedries is the president of Logophilia Limited, a technical writing company. He has been working with computers for more than 30 years, has been using Microsoft Windows since version 1, and is widely viewed as an expert in explaining Windows and Windows technology. Paul has written more than 40 books that have sold nearly three million copies worldwide, including Microsoft Windows Vista Unleashed, available January 2007.

Provides coverage of how to get the most out of Access, from using the Quick Launch Toolbar and Office Button to building a database from scratch.

The ultimate full-colour, task-oriented guide for those who want to become Office 2007 power users.

Master the tools that help you keep track of information, like Access 2007. Whether you're an office professional or entrepreneur, you can take charge of Access with this start-to-finish guide. Gain solid skills as you go from station to station in a series of clear-cut tutorials on designing databases, using forms, automating with macros, and more.

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 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.