The Fictioning Horror Sale
 
 

Recently Viewed clear list


Interviews | September 2, 2014

Jill Owens: IMG David Mitchell: The Powells.com Interview



David MitchellDavid Mitchell's newest mind-bending, time-skipping novel may be his most accomplished work yet. Written in six sections, one per decade, The Bone... Continue »
  1. $21.00 Sale Hardcover add to wish list

    The Bone Clocks

    David Mitchell 9781400065677

spacer

Access 2003 All-In-One Desk Reference for Dummies. (For Dummies)

by

Access 2003 All-In-One Desk Reference for Dummies. (For Dummies) Cover

 

Synopses & Reviews

Publisher Comments:

Many people call our current era "The Age of Information." True, the body of information is increasing at an unprecedented pace, and information is more accessible than ever. But information doesn’t mean diddly-squat if you don’t know how to use it. Access 2003 All-In-One Desk Reference for Dummies is your one-stop guide to building databases and managing information with Access 2003, covering the basics like tables, queries, forms, and reports and more advanced functions such as using Visual Basic for Applications (VBA) and writing code. If you want, you can go all the way to geekdom, or you can simply find out how to make the most of your data to better manage your business by:
  • Creating and modifying tables and entering and editing data
  • Sorting, finding, and filtering data
  • Creating queries, including update queries, action queries, and the Query Wizards
  • Building forms with AutoForm and Wizards
  • Creating charts and graphs from your data
  • Maintaining, sharing, and securing your Access database
  • Letting Access do the math, whether it’s calculating simple cost per unit or performing complex financial functions

Microsoft Office Access 2003 All-In-One Desk Reference For Dummies was written by three computer gurus: Alan Simpson, author of over 80 computer books; Margaret Levine Young, co-author of several dozen computer books, including The Internet for Dummies; and Alison Barrows, book author and writer and editor of technical documentation and training material. To give you hands-on experience and demonstrate practical applications of database management, there is a Web site that complements the book and features a fully functioning mail order management database used in examples throughout the book. You can download it and follow along as you explore:

  • Working with external data sources such as Microsoft SQL Server
  • Writing and debugging code
  • Using HTML, JavaScript, Jscript, VB Script, and Java to facilitate the exchange of information on the Internet among different programs on disparate platforms
  • Using data access pages (DAP) to share information on your intranet

With Access 2003 All-In-One Desk Reference For Dummies, you’ll discover how to put information to work for you.

Synopsis:

Access allows database novices and experienced programmers to store, organize, view, analyze, and share data, and build powerful, custom database solutions that integrate with the Web and enterprise data sources. This book contains nine task-oriented minibooks that cover all aspects of Access.

Synopsis:

Access allows database novices and experienced programmers to store, organize, view, analyse and share data, and build powerful, custom database solutions that integrate with the Web and enterprise data sources. This book contains nine task-oriented minibooks that cover all aspects of Access.

Synopsis:

9 books in 1– one great price for nine handy guides

Your one-stop guide to building databases and managing information with Access 2003

Think of this book as the ultimate user-friendly Access companion, loaded with information that’s simple to find. It will have you creating and using a database in no time, and the self-contained minibooks include information that works for Access 2000, 2002, and 2003. From storing, organizing, and sharing data to customizing databases with VBA, it gives you easy Access.

The Dummies Way

  • Coverage of the essentials and beyond
  • Explanations in plain English
  • "Get in, get out" information
  • Thumbtabs and other navigation aids
  • Tear-out cheat sheet
  • A dash of humor and fun

Synopsis:

Provides new and experienced Access users and beginning programmers with nine task-oriented minibooks covering all aspects of AccessPart of Microsoft Office, Access is the most widely used database in the world and, along with the rest of the Office suite, will undergo a major revision in version " X" Covers beginning- to advanced-level material in an easy-to-use format, with minibooks on Access and database design, tables, queries, forms, reports, macros, database administration, programming with Visual Basic for Applications (VBA), and using Access with the WebShows the reader how to store, organize, view, analyze, and share data, as well as how to build powerful, custom database solutions that integrate with the Web and enterprise data sources

About the Author

Alan Simpson is the author of over 80 computer books on all sorts of topics: Windows, databases, Web site design and development, programming, and network administration. His books are published throughout the world in over a dozen languages and have millions of copies. When not building computers or writing books about them, Alan eats or sleeps. He doesn’t have a fancy job title, because he’s never had a real job, and still doesn’t know how to tie a tie.

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 (published by Wiley Publishing, Inc.) and Windows XP Home Edition: The Complete Reference (published by 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. She holds a B.A. in International Relations from Wellesley College and an M.P.P. from Harvard University. In real life she hangs out with her “guys” — Parker, 3, and Mason, 1, and tries to carve out some time to practice yoga. Alison lives with her family in central Massachusetts.

Table of Contents

Introduction.

Book I: Essential Concepts.

Chapter 1: Introducing Access 2003.

Chapter 2: Getting Started, Getting Around.

Chapter 3: Designing Your Database the Relational Way.

Book II: Tables.

Chapter 1: Creating and Modifying Tables.

Chapter 2: Entering and Editing Data in Datasheets.

Chapter 3: Sorting, Finding, and Filtering Data.

Chapter 4: Importing and Exporting Data.

Chapter 5: Avoiding “Garbage In, Garbage Out”.

Chapter 6: Protecting Your Data with Referential Integrity.

Book III: Queries.

Chapter 1: Creating Select Queries.

Chapter 2: Letting Queries Do the Math.

Chapter 3: Doing Neat Things with Action Queries and Query Wizards.

Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables.

Book IV: Forms.

Chapter 1: Designing and Using Forms (And Reports).

Chapter 2: Jazzing Up Your Forms (And Reports).

Chapter 3: Creating Smarter Forms.

Chapter 4: Doing Calculations in Forms (And Reports).

Book V: Reports.

Chapter 1: Creating and Spiffing Up Reports.

Chapter 2: Printing Beautiful Reports.

Chapter 3: Creating Charts and Graphs from Your Data.

Book VI: Macros: Automating Stuff in Access.

Chapter 1: Making Macros Do the Work.

Chapter 2: Making Macros Smarter.

Book VII: Database Administration.

Chapter 1: Database Housekeeping.

Chapter 2: Sharing the Fun — and the Database: Managing Multi-User Access.

Chapter 3: Securing Your Access Database.

Book VIII: Programming in VBA.

Chapter 1: What the Heck Is VBA?

Chapter 2: Writing Code.

Chapter 3: Writing Smarter Code.

Chapter 4: Controlling Forms with VBA.

Chapter 5: Using SQL and Recordsets.

Chapter 6: Debugging Your Code.

Chapter 7: Integrating Office Applications.

Book IX: Access on the Web.

Chapter 1: Creating Data Access Pages.

Chapter 2: Creating Access Projects.

Chapter 3: Introducing XML.

Appendix: Installing Microsoft Access.

Index.

Product Details

ISBN:
9780764539886
Author:
Simpson, Alan
Publisher:
For Dummies
Author:
Young, Margaret Levine
Author:
Barrows, Alison
Location:
Hoboken, New Jersey
Subject:
Database Management - General
Subject:
Database Management - MSAccess
Subject:
Database management
Subject:
Microsoft Access
Subject:
Desktop Applications - MS Access
Subject:
Database design
Subject:
Personal Computers-Desktop Applications-Databases
Copyright:
Edition Description:
WebSite Associated w/Book
Series:
For Dummies
Series Volume:
4222
Publication Date:
20031010
Binding:
TRADE PAPER
Language:
English
Illustrations:
Yes
Pages:
840
Dimensions:
9.36x7.32x1.81 in. 2.68 lbs.

Other books you might like

  1. Access 2003 for Dummies(r) (For Dummies) New Trade Paper $21.99
  2. Excel 2003 for Dummies Used Trade Paper $3.95
  3. Pivot Table Data Crunching for... New Trade Paper $34.99
  4. Excel Data Analysis for Dummies New Trade Paper $29.99
  5. Excel 2003 for Dummies Quick... New Trade Paper $18.99
  6. Quicken 2005 for Dummies (For Dummies) Used Trade Paper $1.00

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Personal Computers » Desktop Applications » Databases
Computers and Internet » Software Engineering » Software Management

Access 2003 All-In-One Desk Reference for Dummies. (For Dummies) Used Trade Paper
0 stars - 0 reviews
$2.95 In Stock
Product details 840 pages For Dummies - English 9780764539886 Reviews:
"Synopsis" by , Access allows database novices and experienced programmers to store, organize, view, analyze, and share data, and build powerful, custom database solutions that integrate with the Web and enterprise data sources. This book contains nine task-oriented minibooks that cover all aspects of Access.
"Synopsis" by , Access allows database novices and experienced programmers to store, organize, view, analyse and share data, and build powerful, custom database solutions that integrate with the Web and enterprise data sources. This book contains nine task-oriented minibooks that cover all aspects of Access.
"Synopsis" by , 9 books in 1– one great price for nine handy guides

Your one-stop guide to building databases and managing information with Access 2003

Think of this book as the ultimate user-friendly Access companion, loaded with information that’s simple to find. It will have you creating and using a database in no time, and the self-contained minibooks include information that works for Access 2000, 2002, and 2003. From storing, organizing, and sharing data to customizing databases with VBA, it gives you easy Access.

The Dummies Way

  • Coverage of the essentials and beyond
  • Explanations in plain English
  • "Get in, get out" information
  • Thumbtabs and other navigation aids
  • Tear-out cheat sheet
  • A dash of humor and fun
"Synopsis" by , Provides new and experienced Access users and beginning programmers with nine task-oriented minibooks covering all aspects of AccessPart of Microsoft Office, Access is the most widely used database in the world and, along with the rest of the Office suite, will undergo a major revision in version " X" Covers beginning- to advanced-level material in an easy-to-use format, with minibooks on Access and database design, tables, queries, forms, reports, macros, database administration, programming with Visual Basic for Applications (VBA), and using Access with the WebShows the reader how to store, organize, view, analyze, and share data, as well as how to build powerful, custom database solutions that integrate with the Web and enterprise data sources
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.