Visual QuickStart Guide or Engineering with Excel

Visual QuickStart Guide: SQL

Author: Chris Fehily

As dynamic, database-driven Web sites become the standard, more and more nonprogrammers just like yourself are being forced to work with database information and create and edit database objects. With SQL and this task-based guide to it, you can do it too--no programming experience required!

After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily launches into the tasks that will get you comfortable with SQL fast. In addition to explaining SQL basics, this updated reference covers the ANSI SQL:2003 standard and contains a wealth of brand-new information, including a new chapter on set operations and common tasks, well-placed optimization tips to make your queries run fast, sidebars on advanced topics, and added IBM DB2 coverage.

Best of all, the book's examples were tested on the latest versions of Microsoft Access, Microsoft SQL Server, Oracle, IBM DB2, MySQL, and PostgreSQL. On the companion Web site, you can download the SQL scripts and sample database for all these systems and put your knowledge to work immediately on a real database..

Interesting book: Perfect Phrases for Performance Reviews or The 17 Indisputable Laws Of Teamwork

Engineering with Excel

Author: Ronald W Larsen

Based on Excel 2007 , Engineering with Excel, 3e  takes a comprehensive look at using Excel in engineering.  This book focuses on applications and is intended to serve as both a textbook and a reference for students.

Booknews

This textbook for a first-year engineering course explains how to apply the Excel spreadsheet program to perform common engineering calculations. Topics include graphing, matrix operations, linear regression, macros, Visual Basic for applications, financial calculations, statistics functions, and numerical integration techniques for differential equations. Annotation c. Book News, Inc., Portland, OR (booknews.com)

Table of Contents:

1	Introduction to Excel	1
2	Graphing with Excel	46
3	Excel Functions	84
4	Matrix Operations in Excel	126
5	Linear Regression in Excel	153
6	Iterative Solutions Using Excel	187
7	Using Macros in Excel	225
8	Programming in Excel with VBA	268
9	Sharing Excel Information with Other Programs	296
10	Time Value of Money with Excel	335
11	Financial Calculations with Excel	363
12	Excel's Statistics Functions	387
13	Numerical Differentiation Using Excel	409
14	Numerical Integration Using Excel	433
15	Numerical Integration Techniques for Differential Equations Using Excel	459
	Index	490

Beginning Lua Programming or Creating Cool Web Sites with HTML XHTML and CSS

Beginning Lua Programming

Author: Aaron Brown

Lua offers a wide range of features that you can use to support and enhance your applications. With this book as your guide, you’ll gain a thorough understanding of all aspects of programming with this powerful language. The authors present the fundamentals of programming, explain standard Lua functions, and explain how to take advantage of free Lua community resources. Complete code samples are integrated throughout the chapters to clearly demonstrate how to apply the information so that you can quickly write your own programs.

See also: Raving Fans or Shift

Creating Cool Web Sites with HTML, XHTML, and CSS

Author: Dave Taylor

• Walks readers through the process of creating a basic Web site from scratch using HMTL, the basis for billions of Web pages, and then jazzing it up with advanced techniques from the author's award-winning sites

• This updated edition features new material that shows readers how to attract visitors to a site and keep them there, including new JavaScript examples and coverage of cascading style sheets and XHTML, technologies that make building successful Web sites even easier

• Also features exciting new tips and tricks for beginning and advanced users, as well as more expanded examples and samples for users to incorporate in their own sites

• The book moves from basic design and deployment to advanced page layout strategies, showing how to spice up new or existing sites with sound, video, and animation

Table of Contents:

	Preface
	Acknowledgments
Pt. I	Building a wicked cool web page	1
Ch. 1	So what's all this web jazz?	3
Ch. 2	Building your first web page : HTML basic	21
Ch. 3	Presenting text attractively	43
Ch. 4	Moving into the 21st century with cascading style sheets	57
Ch. 5	Lists and special characters	81
Ch. 6	Putting the web in world wide web : adding pointers and links	103
Ch. 7	From dull to cool by adding graphics	121
Pt. II	Rockin' page design strategies	157
Ch. 8	Tables and frames	159
Ch. 9	Forms, user input, and the common gateway interface	195
Ch. 10	Advanced form design	219
Ch. 11	Activating your pages with JavaScript	235
Ch. 12	Advanced cascading style sheets	261
Ch. 13	Site development with weblogs	293
Pt. III	Expanding your page into a web site	307
Ch. 14	Web sites versus web pages	309
Ch. 15	Thinking about your visitors and your site's usability	323
Ch. 16	Validating your pages and style sheets	335
Ch. 17	Building traffic and being found	351
	App. A: Step-by-step web site planning guide	373
	App. B: Finding a home for your web site	379
	Index	385

Visual Basic 6 for Windows for Dummies or Ruby on Rails For Dummies

Visual Basic 6 for Windows for Dummies

Author: Wallace Wang

Create your own custom Visual Basic programs fast for Windows 95, Windows 98, and Windows NT with the power and friendly object-oriented interface of Microsoft's Visual Basic 6 with Visual Basic 6 For Dummies.

Here's a great resource to help you

• Understand the art of object-oriented programming in Visual Basic
• Build attractive user interfaces with buttons, boxes, and scroll bars
• Master menus and submenus -- plus expanding, pull-down, and pop-up menus -- quickly and easily
• Discover how to write subprograms that everyone can share
• Save and retrieve information in databases like Microsoft Access
• Integrate your own special ActiveX controls into applications

From the fundamentals of writing BASIC code to the thrill of distributing your very own custom applications, programming expert Wallace Wang brings a fresh and humorous perspective to the world of Visual Basic in terms everyone can understand. Plus, the bonus CD-ROM that comes with Visual Basic 6 For Dummies includes all the source code and examples from the book, along with demo or trial versions of some cool VB and ActiveX programs.

Table of Contents:

	Introduction	1
Pt. I	Creating a Visual Basic 6 Program	7
Ch. 1	How Visual Basic Works	9
Ch. 2	Using the Visual Basic User Interface	15
Ch. 3	Designing Your First User Interface	23
Ch. 4	Writing BASIC Code	41
Pt. II	Creating User Interfaces	53
Ch. 5	User Interface Design 101	55
Ch. 6	Forms and Buttons	81
Ch. 7	Boxes and Buttons for Making Choices	103
Ch. 8	Text Boxes for Typing and Showing Words	123
Ch. 9	Scroll Bars and Labels	135
Ch. 10	Pretty Pictures and Objects from Geometry	145
Pt. III	Making Menus	161
Ch. 11	Creating and Editing Pull-Down Menus	163
Ch. 12	Submenus, Growing Menus, and Pop-Up Menus	181
Ch. 13	Dialog Boxes	191
Pt. IV	The Basics of Writing Code	207
Ch. 14	Event Procedures	209
Ch. 15	Using Variables	223
Ch. 16	Responding to the User	247
Ch. 17	Math 101: Arithmetic, Logical, and Comparison Operators	259
Ch. 18	Strings and Things	275
Ch. 19	Defining Constants and Using Comments	287
Ch. 20	Killing Bugs	299
Pt. V	Making Decisions (Something You Stop Doing When You Get Married)	309
Ch. 21	The If-Then and If-Then-Else Statements	311
Ch. 22	The Select Case Statement	321
Pt. VI	Getting Loopy	327
Ch. 23	The Do While and Do-Loop While Loops	329
Ch. 24	The Do Until and Do-Loop Until Loops	335
Ch. 25	For Next Loops That Can Count	341
Ch. 26	Nested Loops and Quick Exits	349
Pt. VII	Writing Subprograms (So You Don't Go Crazy All at Once)	353
Ch. 27	General Procedures (Subprograms Tha Everyone Can Share)	355
Ch. 28	Passing Arguments	363
Ch. 29	Functions, a Unique Type of Subprogram	373
Ch. 30	Getting Some Class with Object-Oriented Programming	385
Ch. 31	Managing Files	403
Pt. VIII	Database Files and Printing	409
Ch. 32	Creating Database Files	411
Ch. 33	Using Files from Database Programs You d Rather Not Use	417
Ch. 34	Making Your Program Print Stuff	433
Pt. IX	The Part of Tens	441
Ch. 35	The Ten Visual Basic Topics That Didn't Fit Anywhere Else	443
	App. A: About the CD	451
	Index	459
	IDG Books Worldwide End-User License Agreement	476
	Installation Instructions	478
	Book Registration Information

Books about: Global and the Local or Erp Tools Techniques and Applications for Integrating the Supply Chain

Ruby on Rails For Dummies

Author: Barry Burd

Quickly create Web sites with this poweful tool

Use this free and easy programming language for e-commerce sites and blogs

If you need to build Web and database applications quickly but you don't dream in computer code, take heart! Ruby on Rails was created for you, and this book will have you up and running in no time. The Ruby scripting language and the Rails framework let you create full-featured Web applications fast. It's even fun!

Discover how to

• Install and run Ruby and Rails

• Use the RadRails IDE

• Create a blog with Ruby

• Connect your Web site to a database

• Build a shopping cart

• Explore Ruby's syntax

The Hidden Pattern or Black White Photography Techniques with Adobe Photoshop

The Hidden Pattern: A Patternist Philosophy of Mind

Author: Ben Goertzel

The Hidden Pattern presents a novel philosophy of mind, intended to form a coherent conceptual framework within which it is possible to understand the diverse aspects of mind and intelligence in a unified way. The central concept of the philosophy presented is the concept of "pattern": minds and the world they live in and co-create are viewed as patterned systems of patterns, evolving over time, and various aspects of subjective experience and individual and social intelligence are analyzed in detail in this light.

Many of the ideas presented are motivated by recent research in artificial intelligence and cognitive science, and the author's own AI research is discussed in moderate detail in one chapter. However, the scope of the book is broader than this, incorporating insights from sources as diverse as Vedantic philosophy, psychedelic psychotherapy, Nietzschean and Peircean metaphysics and quantum theory. One of the unique aspects of the patternist approach is the way it seamlessly fuses the mechanistic, engineering-oriented approach to intelligence and the introspective, experiential approach to intelligence..

Go to: Umbertos Kitchen or Pearls of Kitchen Wisdom

Black & White Photography Techniques with Adobe Photoshop

Author: Maurice Hamilton

Fine art quality, black-and-white prints are within every photographer's reach with the techniques illustrated in this digital image editing guide. Taking advantage of the control and reproducibility that the digital darkroom offers, this handbook teaches photographers how to fine-tune images with contrast and exposure levels, crop and rotate images for dynamic results, and remove flaws such as dust and scratches long after the photograph has been taken. Instruction on techniques that simulate traditional hand coloring and tinting and add special effects such as frames, infrared, and lighting and lens effects helps photographers realize their artistic vision. Screen shots and images guide readers through the presented techniques, allowing photographers to gauge their own results and anticipate the effects of the outlined corrections and enhancements on their own images. A gallery of the author's work provides inspiration for simulating—and improving upon—the chemical-based darkroom experience.

Art Book News Annual

"Describes and illustrates classic concepts and Adobe Photoshop editing techniques for digital photographers seeking to create fine art prints.

Successful Affiliate Marketing for Merchants or Office XP for Dummies

Successful Affiliate Marketing for Merchants

Author: Shawn Collins

If you¿re an online business, instead of paying for an ad, like a banner, you pay for the result <196> the sale. This is called affiliate marketing. Pay for Performance will show anyone conducting business online, how to plan, implement, and manage a successful affiliate marketing program. The reader will find valuable Web resources such as tracking software and contract templates with the guidance of this book. There will also be direction for the reader to focus the content and develop the right affiliate model for the type of business. It will also provide case studies of successful programs as well as failures and scams to demonstrate and teach the lessons of building a successful program.

Interesting textbook: Corporations and Other Business Associations or Human Value Management

Office XP for Dummies: Quick Reference

Author: Doug Low

You certainly get your money’s worth with Office XP. In one convenient bundle, you get a world-class word processor (Word 2002), a spreadsheet program (Excel 2002), a presentation program (PowerPoint 2002), an e-mail program (Outlook 2002), and a database program (Access 2002). Plus, you get a grab-bag of other useful programs. What a bargain!

With its plethora of features and commands, you may not know where or how to start using Office XP effectively. With Office XP For Dummies Quick Reference in hand, you'll find yourself zipping around in Office XP in no time. This handy guide is right for you if

• You've just upgraded to Office XP
• You currently use one of these versions of Microsoft Office XP: Standard Edition, Small Business Edition, Professional Edition
• You already use Office XP and want to know more about its advanced features
• You want quick, accessible answers to questions about Office XP

Office XP has tried to make your experience among the various Office programs as consistent as possible – from using dialog boxes and toolbars to starting or navigating a program. But you'll still need help getting around in any Office program. Here's a sampling of the quick, "get-in, get-out" information that you'll find in Office XP For Dummies Quick Reference:

• Getting a handle on the basics: Spell checking, searching, using the Task Pane
• Word 2002: Creating envelopes and labels, tables and columns, keyboard shortcuts
• Excel 2002: Using Autoformat and Autosum, charts, formatting cells, Pivot Table
• Powerpoint 2002: Working with Animation and colorschemes, Photo Album, Slide Show, templates
• Access 2002: Entering data, working in fields, using queries and reports
• Outlook 2002: Managing a calendar, adding and deleting contacts, using e-mail, creating tasks
• The Drawing Toolbar: Using clip art, Autoshapes, diagrams, text boxes

Author Doug Lowe has written more than 50 computer books, including PowerPoint 2002 For Windows For Dummies, Networking For Dummies (5th Edition), and Internet Explorer 5.5 For Dummies, and he knows how to present boring technostuff in a style that is both entertaining and enlightening.

Table of Contents:

	The Big Picture: Office XP
Pt. I	Doing Common Chores	1
Pt. II	Word 2002	15
Pt. III	Excel 2002	59
Pt. IV	PowerPoint 2002	93
Pt. V	Access 2002	123
Pt. VI	Outlook 2002	145
Pt. VII	Working with the Drawing Toolbar	163
Pt. VIII	Completing Complex Tasks	185
	Index	199