Margaret Levine Young has co-authored several dozen computer books about the Internet, UNIX, WordPerfect, Access, and (stab from the past) PC-File and Javelin, including The Internet For Dummies (Wiley) and Windows XP Home Edition: The Complete Reference (Osborne/McGraw-Hill). She met her future husband Jordan in the R.E.S.I.S.T.O.R.S., a high-school computer club before there were high-school computer clubs. Her other passions are her children, music, Unitarian Universalism (www.uua.org), reading, and anything to do with cooking or eating.
Alison Barrows has authored or co-authored books on Windows, the Internet, Microsoft Access, WordPerfect, Lotus 1-2-3, and other topics. In addition to writing books, Alison writes and edits technical documentation and training material. In real life she hangs out with her “guys” — Parker, 6, and Mason, 4, and Evan 2 — and tries to carve out some time to practice yoga. Alison lives with her family in central Massachusetts.
April Wells is a graduate of the University of Pittsburgh and holds an MBA from West Texas A&M. She is a database administrator with expertise in a wide variety of enterprise database software programs, including Oracle, DB2, MySQL, and Access. She is the author of several books and white papers on database software and is a frequent public speaker, trainer, and consultant.
If you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference are exactly what you need. Read the book cover to cover, or jump into any of the minibooks for the instruction and topics you need most. Learn how to connect Access to SQL Server, manipulate your data locally, use nifty new features from Office 2010 such as the enhanced Ribbon, create queries and macros like a champ, and much more. From the basics to advanced functions, it’s what you need to make Access more accesssible.Shows you how to store, organize, view, analyze, and share data using Microsoft Access 2010, the database application included with Microsoft Office 2010 Includes nine minibooks that cover such topics as database design, tables, queries, forms, reports, macros, database administration, securing data, programming with Visual Basic for Applications (VBA), and using Access with the Web Helps you build database solutions that integrate with the Web and other enterprise data sources Offers plenty of techniques, tips, and tricks to help you get the most out of Access
This all-in-one guide contains everything you need to start power-using Access 2010!
- Covers Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL, and Microsoft Access.
- Learn the core language for standard SQL, and variations for the most widely used database systems.
- Organize your database in terms of the relational model.
- Master tables, columns, rows, and keys.
- Retrieve, sort, and format data.
- Filter the data that you don't want to see.
- Convert and manipulate data with SQL's built-in functions and operators.
- Use aggregate functions to summarize data.
- Create complex SQL statements by using joins, subqueries, constraints, conditional logic, and metadata.
- Create, alter, and drop tables, indexes, and views.
- Insert, update, delete, and merge data.
- Execute transactions to maintain the integrity of your data.
- Avoid common pitfalls involving nulls.
- Troubleshoot and optimize queries.
- Plenty of tips, tricks, and timesavers.
- Fully cross-referenced, linked, and searchable.
2. Database Basics
3. SQL Basics
4. Retrieving Data from a Table
5. Sorting Rows
6. Filtering Rows
7. Combining and Negating Conditions
8. Pattern Matching
9. More Ways to Filter Rows
10. Operators and Functions
11. Working with Functions
12. Evaluating Conditional Values
13. Summarizing Data
14. Grouping Data
15. Joining Tables
16. Working with Joins
18. Combining Queries
19. Inserting Rows
20. Updating and Deleting Rows
21. Creating and Changing Tables
A. The Sample Database
B. Running SQL Programs
C. Data Types
Being a skilled welder is a hot commodity in today's job market, as well as a handy talent for industrious do-it-yourself repairpersons and hobbyists. Welding For Dummies gives you all the information you need to perform this commonly used, yet complex, task.
This friendly, practical guide takes you from evaluating the material to be welded all the way through the step-by-step welding process, and everything in between. Plus, you'll get easy-to-follow guidance on how to apply finishing techniques and advice on how to adhere to safety procedures.Explains each type of welding, including stick, tig, mig, and fluxcore welding, as well as oxyfuel cutting, which receives sparse coverage in other books on welding Tips on the best welding technique to choose for a specific project Required training and certification information
Whether you have no prior experience in welding or are looking for a thorough reference to supplement traditional welding instruction, the easy-to-understand information in Welding For Dummies is the ultimate resource for mastering this intricate skill.
Several sources for Maven have appeared online for some time, but nothing served as an introduction and comprehensive reference guide to this tool -- until now. Maven: The Definitive Guide is the ideal book to help you manage development projects for software, web applications, and enterprise applications. And it comes straight from the source.
If you're an Internet newcomer and want to get up to speed without all the intimidating technical jargon, The Internet For Dummies has you covered. With over 5,000,000 copies sold*, The Internet For Dummies is the #1 choice for Internet newcomers.
Inside, you'll discover how to make the most of the Internet, get accustomed to popular sites, find the information and items you need fast, and stay away from the bad stuff floating around online.Catches you up on the latest online trends, from social networking sites to blogs and more Includes the latest on Google Chrome, getting good search results, and sharing files Covers choosing and connecting to an Internet provider, establishing an e-mail account, getting on the web, and finding the sites that matter most
Now in its 14th edition, The Internet For Dummies covers the latest social networking tools, browser features, connection options, safety features, and so much more. Starting out with the basics, it walks you through getting online, picking an Internet provider, getting to know the different web browsers, dealing with e-mail and connecting with friends, finding the hottest sites to share photos and videos—and everything in between.
*Includes all formats and all editions
Want to know how to set up, navigate, use, and maintain Windows XP? It’s all in Book I. Book II covers the care and feeding of PCs in general and takes you on a complete tour of peripherals—those add-ons that make computing cool. Want to explore the world via the World Wide Web? Check Book III. And if you finally have to do some work, check into Book IV, where you’ll get the complete story on Office 2003 and Money 2004. You’ll discover how to:Customize Windows XP, set up user accounts, and share files Work with digital photos, Windows Media Player, and Windows Movie Maker Choose a printer, scanner, game hardware, and additional storage Set up a wireless home network Get online safely, protect your kids, create your own Web pages, and cruise for bargains on eBay Use Word, Outlook, Excel, and PowerPoint Manage your finances with Microsoft Money
Windows XP Gigabook For Dummies is packed with information that’s easy to find and even easier to understand. Keep it handy for reference—you’ll be gigapleased with how useful it is!
Take full advantage of the high-performance features available in Microsoft Windows Vista and experience the power of this integrated, next-generation operating system. Windows Vista: The Complete Reference shows you how to install and configure Windows Vista for optimal performance, customize the streamlined new desktop, display sidebars and gadgets, and enjoy all the entertainment capabilities, including music, movies, and games.
Find out how to manage your files, install software and hardware, and use the latest Internet technologies. You'll also learn to secure your system, back up and restore your files, and set up a Local Area Network (LAN) so you can share resources. Filled with clear screenshots and detailed explanations, this is your one-stop guide to mastering Windows Vista.Customize your desktop with new UI components Use the new User Account Control (UAC) to prevent unauthorized changes to your computer Manage files and folders using Windows Flip 3D and Windows Live Taskbar thumbnails Protect your files using the Backup and Restore Center Manage and edit your photos with the new Windows Photo Gallery Keep track of your appointments with the new Windows Calendar Use Windows Media Center to record live TV and radio, view digital photos, play music, and burn CDs and DVDs Connect to the Internet and use Windows Mail, Internet Explorer 7, and Windows Live Messenger Secure your PC and use Windows Update Troubleshoot and tune Windows Vista for maximum performance