Компьютеры - скачать книги или читать онлайн. Страница 89

This friendly, easy-to-use guide shows experienced Access users how to use VBA (Visual Basic for Applications) to build Access databases and applications, but also covers programming fundamentals for nonprogrammers Includes practical, ready-to-use VBA code examples that readers can type or copy and paste from the Web into their own database projects Explains basic VBA skills and concepts for nonprogrammers, such as procedures, variables, and loops Covers more advanced topics, such as record sets and other programming activities that are unique to Access programming Author has written more than ninety computer books and has been working with databases since the early 1980s

Having Excel and just using it for standard spreadsheets is a little like getting the ultimate cable system and a 50” flat panel plasma HDTV and using it exclusively to watch Lawrence Welk reruns. With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and much more. This guide is not for rank Excel amateurs. It’s for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you’re an intermediate or advanced Excel user, Excel VBA For Dummies helps you take your skills (and your spreadsheets) to the next level. It includes: An introduction to the VBA language A hands-on, guided, step-by-step walk through developing a useful VBA macro, including recording, testing, and changing it, and testing it The essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions, and the Excel macro recorder The essential VBA language elements, including comments, variables and constants, and labels Working with Range objects and discovering useful Range objective properties and methods Using VBA and worksheet functions, including a list and examples Programming constructions, including the GoTo statement, the If-Then structure, Select Case, For-Next loop, Do-While loop, and Do-Until loop Automatic procedures and Workbook events, including a table and event-handler procedures Error-handling and bug extermination techniques, and using the Excel debugging tools Creating custom dialog boxes, also known as UserForms, with a table of the toolbox controls and their capabilities, how-to for the dialog box controls, and UserForm techniques and tricks Customizing the Excel toolbars Using VBA code to modify the Excel menu system Creating worksheet functions and working with various types of arguments Creating Excel add-ins such as new worksheet functions you can use in formulas or new commands or utilities Author John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including Excel 2003 Bible and Excel 2003 Power Programming with VBA. While this guide includes tons of examples and screenshots, Walkenbach knows there’s no substitute for hands-on learning. The book is complete with: A dedicated companion Web site that includes bonus chapters plus all sample programs to save you a lot of typing and let you play around and experiment with various changes Information to help you make the most of Excel’s built-in Help system so you can find out other stuff you may need to know What are you waiting for? Sure, learning to do VBA programming

Formerly known as Red Hat Linux, the Fedora Core distribution is an excellent, no-cost alternative to Windows, Solaris, and other expensive operating systems Red Hat currently controls an estimated seventy percent of the Linux market in the U.S. This book gives experienced and first-time Fedora users sixty concise, step-by-step, timesaving techniques to help them perform tasks with Fedora more efficiently Organized by topic, the techniques are presented in the friendly, easy-to-understand For Dummies style, with a minimum of technical jargon The techniques run the gamut of end-user, system administration, and development tasks, ranging from desktop, file system, RPM, and database tips to Internet server, e-mail server, networking, system monitoring, security, and Linux kernel tricks Covers the latest release of Red Hat's Fedora Core distribution

Twenty-seven million Americans have been victims of identity theft in the last five years and the total cost of identity theft approaches $48 billion per year (total costs to businesses are $43 billion and the direct cost to consumers is $5 billion) These staggering statistics have prompted security consultant Michael Arata to provide readers with the resources they need to guard themselves against identity theft In this valuable book, Arata offers easy-to-follow, straightforward advice on understanding identity theft, minimizing risk, maintaining vigilance, choosing who to share personal information with, selecting hard-to-guess PINs, determining victimization, reviewing a credit report, charting a course of action, resolving credit problems, reclaiming good credit, and much more Explains how to recover successfully if identity theft does occur Author Michael Arata, CISSP, CPP, CFE, ACLM, is a veteran of the security industry with more than fifteen years of experience

Would you read information presented like this? No. It’s just not natural. Sometimes presentation is almost as important as content. When you create a report, the goal is to provide information for readers in a format they can readily understand. Crystal Reports 10 For Dummies, the latest version of the most popular report writer in the world, shows you how to create simple or sophisticated reports, turning data into interactive, actionable reports that convey what’s happening in your business. You can progress cover-to-cover or use the index to find out how to: Give your reports more pizzazz by using the correct fonts, color, drop shadows, graphic elements, and more Integrate elements from multiple, non-database sources Group sort, total result sets, cross-tab reports, and add formulas, charts, or maps Print reports Use customized Business Views gleaned from the same information to provide each reader with information he or she needs to know without spilling all the beans, sales figures, marketing information, or whatever Present multi-dimensional data in OLAP (Online Analytical Processing) cubes Get ideas from sample reports on the companion Web site Written by Allen G. Taylor, nationally known lecturer, teacher, and author of over 20 books, including Database Development for Dummies, Crystal Reports 10 For Dummies makes it crystal clear how to: Store your information securely in Crystal Repository Use Crystal Analysis 10 to display OLAP data so you and your report’s readers can analyze the information in an online environment Use Crystal Enterprise to put Crystal Reports online for viewing by hundreds or thousands of people in your organization Whether you want to dazzle your company’s CEO and shareholders, motivate the sales force, or simply share database information cogently, with Crystal Reports 10 For Dummies you not only make your point, you an impression. When your reports look professional, you look professional.

Updated and revised with eighty percent new material, this book is 100 percent of what readers need to upgrade, fix, or troubleshoot PCs Sixty-five percent of U.S. households own a PC; this book caters to the do-it-yourselfers in these households, both novices and tech hobbyists alike, who are looking for an approachable reference A one-stop reference for topics such as video, CD, and DVD; multimedia; storage; communications (network and Internet); peripherals; and integrating with laptops and handhelds Concludes with a step-by-step tutorial on building an «extreme» machine that can handle the most demanding multimedia or gaming applications Written by Marcia and Barry Press, authors of PC Toys (076454229X)

Chances are you have friends who have been thrilled with deals they got on eBay. Maybe you’d like to get in on the eBay action, but don’t know where to start. Or maybe you’ve bought on eBay before, but want to get the inside scoop on scooping up the very best deals. This book is for you. It helps you differentiate between the junk and the jewels and get the best buys on everything from clothing, household goods, and electronics to business equipment, new or used cars, and real estate! Written by Marsha Collier, self-professed bargain shopper and best selling author of eBay For Dummies, eBay Bargain Shopping For Dummies is packed with advice and anecdotes from other experts, some of whom make a living buying and selling on eBay. It helps you begin shopping on eBay quickly, safely, and successfully, with information on: Using the My eBay Page to keep up with your potential deals Using feedback about sellers and shopping safely Bidding, buying, and winning Things to look for and things to look out for Ways to pay, including PayPal Taking advantage of eBay’s search functions and refining your searches to zero in on sought-after items Shopping eBay’s Bargain Basement Even successful eBay veterans will discover tips and tricks they didn’t know and bargain shopping secrets. Whether you want to use eBay to seek out and snap up hard-to-find collectibles, or simply to save on everyday purchases, eBay Bargain Shopping For Dummies takes you step-by-step through the process. And to get you started right, the book is a real bargain!

Find out how to * Understand XML specification and schemas * Set up and complete InfoPath?TM forms * Design new forms from XML data files * Debug InfoPath scripts * Tackle real-world problems with the help of case studies * Work with data in each of the XML-supported Office applications You don't need to be a programmer to enhance Office with XML XML support for Microsoft?? Office 2003 has taken interoperability to a new level. Now you can share data among Office applications, across platforms, and over the Internet using built-in XML tools. In this clearly organized volume, Peter Aitken helps you define and standardize document data structure within your organization using XML. He explains XML technology, walks you through designing templates with InfoPath, and shows you how to use the XML tools built into Word, Excel, Access, and FrontPage?? to facilitate data exchange throughout your enterprise. «…the real-world case studies are practical, offering detailed solutions to the scenarios outlined. I would recommend this book to anyone who plans to leverage the features found in the Office System 2003 for their business.» –Dave Beauchemin, Microsoft MVP CD-ROM Includes * Trial versions of John Walkenbach's Power Utility Pak, HotDog Professional, WinRAR?TM, and many others * Demo versions of BBEdit??, XML Pro, and more * Exclusive Office 2003 Super Bible eBook, with more than 500 pages of information about how Microsoft Office components work together * Valuable author files and examples

Install SUSE Linux and take advantage of cool new tools Use OpenOffice.org, go online with Firefox?, set up a wireless LAN, and more SUSE Linux is gaining popularity everywhere, and you'll soon see why. This friendly guide will help you install and configure the newest version, then help you work with digital media, build a network, get acquainted with Firefox (the super-secure browser that has everybody excited),explore Skype and Linphone Internet phone services, and much more! Discover how to * Set up an Ethernet LAN with wireless access * Use the OpenOffice.org productivity suite * Read newsgroups and use instant messaging * Play music and burn CDs * Secure your SUSE system

Use these great ideas to help you make your point Create PowerPoint presentations with Flash(r) movies, Excel(r) charts, and more Okay, you've PowerPointed before, right? And you knew there must be more cool things you could do? Here they are! This handy guide gives you pointers on what makes a powerful presentation, tips on using the right formats and templates, and directions for dressing up text, wowing 'em with color, adding action, and much more. Discover how to * Tweak and streamline PowerPoint * Get the most from color * Avoid amateur mistakes * Use shapes, fills, and 3D effects * Add photos, soundtracks, and DVD video * Deliver your presentation with punch

Keep your laptop on top of its game! Find out how to care for your laptop, what can go wrong, and what you can fix A laptop is much more than a PC that shrank. It has unique needs, and this book shows you how to meet them. You'll discover how to diagnose and fix common problems, replace parts, add external upgrades, and develop workarounds. You'll even get the lowdown on networks, and find out when to repair and when to replace your laptop. Discover how to * Treat your laptop properly * Identify common problems * Know when repair may not make economic sense * Install a new operating system * Troubleshoot CD and DVD drives * Add cool peripherals

Shows tech hobbyists how to build the perfect PC, whether they want to create the ultimate gaming machine or combine new and recycled parts to construct an inexpensive computer for a child The do-it-yourself craze is sweeping through the tech community, and this guide is now significantly revised and updated to cover the wide array of new hardware and accessories available Step-by-step instructions and dozens of photos walk first-time computer builders through the entire process, from building the foundation, and adding a processor and RAM, to installing a video card, configuring a hard drive, hooking up CD and DVD drives, adding a modem, and troubleshooting problems