Unlock the secrets of Access 2013 and discover how to use your data in creative ways. With this book’s easy step-by-step instructions, you’ll learn how to build and maintain a full-featured database and even turn it into a web app. You also get tips and practices from the pros for good database design—ideal whether you’re using Access for business, school, or at home. The important stuff you need to know Build a database with ease. Organize and update lists, documents, catalogs, and other types of information. Create your own web app. Let your whole team work on a database in the cloud. Share your database on a network. Link your Access database to SQL Server or SharePoint. Customize the interface. Make data entry a breeze by building your own templates Find what you need fast. Search, sort, and summarize huge amounts of data in minutes. Put your info to use. Turn raw info into well-formatted printed reports. Dive into Access programming. Automate complex tasks and solve common challenges.
Unlock the secrets of this powerful database program and discover how to use your data in creative ways. With this book’s easy step-by-step process, you’ll quickly learn how to build and maintain a complete Access database, using Access 2013’s new, simpler user interface and templates. You also get practices and tips from the pros for good database design—ideal whether you’re using Access for school, business, or at home. The important stuff you need to know: Build a database with ease. Store information to track numbers, products, documents, and more. Customize the interface. Build your own forms to make data entry a snap. Find what you need fast. Search, sort, and summarize huge amounts of information. Put your data to use. Turn raw info into printed reports with attractive formatting. Share your data. Collaborate online with SharePoint and the Access web database. Dive into Access programming. Get tricks and techniques to automate common tasks. Create rich data connections. Build dynamic links with SQL Server, SharePoint, and other systems.
Microsoft Office is the most widely used productivity software in the world, but most people just know the basics. This helpful guide gets you started with the programs in Office 2013, and provides lots of power-user tips and tricks when you’re ready for more. You’ll learn about Office’s new templates and themes, touchscreen features, and other advances, including Excel’s Quick Analysis tool. The important stuff you need to know: Create professional-looking documents. Use Word to craft reports, newsletters, and brochures for the Web and desktop. Stay organized. Set up Outlook to track your email, contacts, appointments, and tasks. Work faster with Excel. Determine the best way to present your data with the new Quick Analysis tool. Make inspiring presentations. Build PowerPoint slideshows with video and audio clips, charts and graphs, and animations. Share your Access database. Design a custom database and let other people view it in their web browsers. Get to know the whole suite. Use other handy Office tools: Publisher, OneNote, and a full range of Office Web Apps. Create and share documents in the cloud. Upload and work with your Office files in Microsoft’s SkyDrive.
The world’s most popular spreadsheet program is now more powerful than ever, but it’s also more complex. That’s where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data. You’ll be using new features like PowerPivot and Flash Fill in no time. The important stuff you need to know: Go from novice to ace. Learn how to analyze your data, from writing your first formula to charting your results. Illustrate trends. Discover the clearest way to present your data using Excel’s new Quick Analysis feature. Broaden your analysis. Use pivot tables, slicers, and timelines to examine your data from different perspectives. Import data. Pull data from a variety of sources, including website data feeds and corporate databases. Work from the Web. Launch and manage your workbooks on the road, using the new Excel Web App. Share your worksheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn. Master the new data model. Use PowerPivot to work with millions of rows of data. Make calculations. Review financial data, use math and scientific formulas, and perform statistical analyses.
A guide to the project management tool covers such topics as estimating work time, setting up a project schedule, building a team, setting up a budget, tracking progress, evaluating performance, and reporting on projects.
A comprehensive reference to the updated and new features of Access 2013 As the world's most popular database management tool, Access enables you to organize, present, analyze, and share data as well as build powerful database solutions. However, databases can be complex. That's why you need the expert guidance in this comprehensive reference. Access 2013 Bible helps you gain a solid understanding of database purpose, construction, and application so that whether you're new to Access or looking to upgrade to the 2013 version, this well-rounded resource provides you with a thorough look at everything Access can do. Explains how to create tables, manipulate datasheets, and work with multiple tables Teaches you how to apply the seven-step design method to build databases that are tailored to your needs Covers building forms with wizards, creating bound and unbound forms, and adding data validation Shows you ways to automate query parameters, create functions and subroutines, and add programmed error routines Features a bonus website with content that contains all source code from the book as well as bonus shareware, freeware, trial, demo, and evaluation programs If you are looking for a comprehensive book on all things Access, look no further than Access 2013 Bible.
Introduce your students to the latest that Microsoft Office has to offer with the new generation of Shelly Cashman Series books! For the past three decades, the Shelly Cashman Series has effectively introduced computer skills to millions of students. With MICROSOFT ACCESS 2013, we’re continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today’s students. In this text you’ll find features that are specifically designed to engage students, improve retention, and prepare them for future success. Our trademark step-by-step, screen-by-screen approach now encourages students to expand their understanding of MICROSOFT ACCESS 2013 through experimentation, critical thought, and personalization. With these enhancements and more, the Shelly Cashman Series continues to deliver the most effective educational materials for you and your students. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
You're beyond the basics, so dive right into Access 2013 and use your skills to create sophisticated database apps! This organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2013 and challenge yourself to new levels of mastery.
Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include building an Access database from scratch or from templates; publishing your database to the Web; exchanging data with other databases and Microsoft Office documents; creating data-entry forms; using filters and queries; designing reports; using conditional formatting; preventing data corruption and unauthorized access; and other core topics.
Authoritative and comprehensive coverage for building Access 2013 Solutions Access, the most popular database system in the world, just opened a new frontier in the Cloud. Access 2013 provides significant new features for building robust line-of-business solutions for web, client and integrated environments. This book was written by a team of Microsoft Access MVPs, with consulting and editing by Access experts, MVPs and members of the Microsoft Access team. It gives you the information and examples to expand your areas of expertise and immediately start to develop and upgrade projects. Explores the new development environment for Access web apps Focuses on the tools and techniques for developing robust web applications Demonstrates how to monetize your apps with Office Store and create e-commerce solutions Explains how to use SQL Server effectively to support both web and client solutions Provides techniques to add professional polish and deploy desktop application Shows you how to automate other programs using Macros, VBA, API calls and more. Professional Access 2013 Programming is a complete guide on the latest tools and techniques for building Access 2013 applications for both the web and the desktop so that developers and businesses can move forward with confidence. Whether you want to add expand your expertise with Client/Server deployments or start developing web apps, you will want this book as a companion and reference.
Get up to speed on Microsoft Project 2013 and learn how to manage projects large and small. This crystal-clear book not only guides you step-by-step through Project 2013’s new features, it also gives you real-world guidance: how to prep a project before touching your PC, and which Project tools will keep you on target. With this Missing Manual, you’ll go from project manager to Project master. The important stuff you need to know Learn Project 2013 inside out. Get hands-on instructions for the Standard and Professional editions. Start with a project management primer. Discover what it takes to handle a project successfully. Build and refine your plan. Put together your team, schedule, and budget. Achieve the results you want. Build realistic schedules with Project, and learn how to keep costs under control. Track your progress. Measure your performance, make course corrections, and manage changes. Create attractive reports. Communicate clearly to stakeholders and team members using charts, tables, and dashboards. Use Project’s power tools. Customize Project’s features and views, and transfer info via the cloud, using Microsoft SkyDrive.
Whether you’re a budding blogger or seasoned Web designer, WordPress is a brilliant tool for creating websites, once you know how to tap its impressive features. The latest edition of this jargon-free Missing Manual shows you how to use WordPress 3.9’s themes, widgets, plug-ins, and souped-up editing and multimedia tools to build just about any kind of site. The important stuff you need to know: Create your site. Get hands-on, A-to-Z instructions for building all types of websites, from classy blogs to professional-looking ecommerce sites. Add features. Choose from thousands of widgets and plug-ins to enhance your site’s ease of use, looks, and performance. Mix in multimedia. Add picture galleries, slideshows, video clips, music players, and podcasts to your pages. Attract an audience. Create automatic content feeds, sign up site subscribers, and help readers share your posts on social media. Fine-tune your content. Analyze site statistics to improve your content and reach, and to optimize your site for search engines. Go Mobile. Choose a theme that automatically reconfigures your site for mobile devices. Build a truly unique site. Learn how to customize WordPress themes to create a site that looks exactly the way you want it to.
Windows 8.1 continues the evolution of the most radical redesign in Microsoft’s history. It combines the familiar Windows desktop with a new, touchscreen-friendly world of tiles and full-screen apps. Luckily, David Pogue is back to help you make sense of it—with humor, authority, and 500 illustrations. The important stuff you need to know: What’s new in 8.1. The update to 8.1 offers new apps, a universal Search, the return of the Start menu, and several zillion other nips and tucks. New features. Storage Spaces, Windows To Go, File Histories—if Microsoft wrote it, this book covers it. Security. Protect your PC from viruses, spyware, spam, sick hard drives, and out-of-control kids. The network. HomeGroups, connecting from the road, mail, Web, music streaming among PCs—this book has your network covered. The software. Media Center, Photo Gallery, Internet Explorer, speech recognition—this one authoritative, witty guide makes it all crystal clear. It’s the book that should have been in the box.
Photoshop CS5 is more amazing than ever, but it can be overwhelming if you're just getting started. This book makes learning Photoshop a breeze by explaining things in a conversational, friendly style -- with no technical jargon. After a thorough introduction to the program, you'll delve deep into Photoshop's secrets with expert tips and practical advice you can use every day. Learn your way around. Get a guided tour of Photoshop's efficient new workspace Unlock the power. Learn the best ways to use layers, channels, masks, paths, and more Bring images to life. Discover how to effectively retouch, resize, and recolor your photos Be artistic. Create beautiful illustrations and paintings, and use text effectively Share your work. Produce great-looking photos for print and the Web Work smarter and faster. Automate common chores and install plug-ins for complex tasks Get bonus online content. Find more great material on the Missing CD page Written with the clarity, humor, and objective scrutiny, Photoshop CS5: The Missing Manual is the friendly, thorough resource you need.
Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly. Navigate with ease. Master Excel's tabbed toolbar and its new backstage view Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more Organize your data. Search, sort, and filter huge amounts of information Illustrate trends. Bring your data to life with charts and graphics -- including miniature charts called Sparklines Examine your data. Summarize information and find hidden patterns with pivot tables and slicers Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save
Apple’s wildly popular iPad and new iPad Mini come jam-packed with features, like access to your media library from the Web, Siri voice control, and seamless Facebook and Twitter integration. But to tap your iPad’s potential, you need a trustworthy owner’s manual. This bestselling book shows you how to import, create, and play back media; sync and shop wirelessly; keep in touch over the Internet; and even take care of business. In addition, you'll find full coverage of iTunes 11, Apple's newly updated media manager. The important stuff you need to know: Take your media with you. Fill your iPad with music, photos, movies, TV shows, games, ebooks, and podcasts. Tap new features in email. Create VIP and Flagged mailboxes, and insert photos or videos into messages on the fly. Get online. Surf at warp speed with the streamlined Safari browser and the iPad’s new ultrafast WiFi connection or 4G LTE network. Post to Facebook and Twitter. Update your status right from the iPad’s Camera, Photos, Maps, and Game Center apps. Make photos public. Share selected photos over iCloud. Find your way with Maps. Get turn-by-turn directions, soar over cityscapes in 3D, and read embedded Yelp reviews. Dictate email. Speak email messages and notes and have your iPad type them up. Stream with Airplay. Take stunning photos and HD video, and wirelessly beam the results to your big-screen TV.
HTML5 is more than a markup language—it’s a collection of several independent web standards. Fortunately, this expanded guide covers everything you need in one convenient place. With step-by-step tutorials and real-world examples, HTML5: The Missing Manual shows you how to build web apps that include video tools, dynamic graphics, geolocation, offline features, and responsive layouts for mobile devices. The important stuff you need to know: Structure web pages more effectively. Learn how HTML5 helps web design tools and search engines work smarter. Add audio and video without plugins. Build playback pages that work in every browser. Create stunning visuals with Canvas. Draw shapes, pictures, and text; play animations; and run interactive games. Jazz up your pages with CSS3. Add fancy fonts and eye-catching effects with transitions and animation. Design better web forms. Collect information from visitors more efficiently with HTML5 form elements. Build it once, run it everywhere. Use responsive design to make your site look good on desktops, tablets, and smartphones. Include rich desktop features. Build self-sufficient web apps that work offline and store the data users need.
Guides readers with practical advice for getting -- and keeping -- their finances in order, covering all the money-management bases, from saving and spending to getting out of debt to investing, and planning for retirement.
Home ownership is a cornerstone of the American dream, but it's a complex process that, without the right guidance, can seem like a nightmare. This Missing Manual takes you through the process of buying a home, from start to finish. Along the way, you'll use the book's expert advice and fill-in forms to identify the house you want, figure out what kind of neighborhood you want to live in, determine what a target home is really worth, make an offer, and close the deal. Throughout the process, this book helps you: Realistically determine how much house you can afford Assemble a real estate team that's looking after your interests and not the seller's Understand the different ways to finance your house, and which is best for you Create an attractive offer with the best chance of acceptance Learn what lenders look for so you can get your mortgage approved Inspect your new home to uncover potential problems Prepare all the right paperwork for a smooth closing
The easy, visual way to learn this popular database program Part of the Office 2013 productivity suite, Access enables you to organize, present, analyze, and share data on a network or over the web. With this Visual guide to show you how, you'll master the fundamentals of this robust database application in no time. Clear, step-by-step instructions are illustrated with full-color screen shots that show exactly what you should see on your screen. Learn to enter new records; create, edit, and design tables and forms; develop queries that generate specific reports; add smart tags to your tables; and much more. While it is the most widely used database application, Access is not particularly intuitive; the Visual system's two-page lessons and full-color screen shots make this complex software easier to learn Concise, step-by-step instructions and clear illustrations show you exactly what to expect Covers scores of tasks, including entering and setting up new records, organizing and sharing data, designing tables and forms, and generating reports Shows how to perform more complex operations, such as finding dependencies between database objects and adding smart tags to tables Teach Yourself VISUALLY Access 2013 uses clear steps and high-resolution screen images to get you up and running with this popular database program.