Access 2003 all-in-one desk reference for dummies

Select an Action

Title:

Author:

Simpson, Alan, 1953-

ISBN:

9780764539886

Personal Author:

Simpson, Alan, 1953-

Publication Information:

Physical Description:

xxvi, 809 pages : illustrations ; 24 cm.

Series:

--For dummies

--For dummies.

General Note:

"9 books in 1"--Cover.

Includes index.

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 pivot tables -- 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.

Abstract:

This is a guide to building databases and managing information with Access 2003, while covering the basics like tables, queries, forms, and reports and more advanced functions such as using Visual Basic for Applications (VBA) and writing code. 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; and Letting Access do the math, whether it's calculating simple cost per unit or performing complex financial functions.

Title Subject:

Microsoft Access.

Subject Term:

Database management.

Added Author:

Young, Margaret Levine.

Barrows, Alison.

Electronic Access:

Table of contents http://catdir.loc.gov/catdir/toc/wiley041/2003105629.html
Contributor biographical information http://catdir.loc.gov/catdir/bios/wiley046/2003105629.html
Publisher description http://catdir.loc.gov/catdir/description/wiley039/2003105629.html

Copies:

Available:*

Library	Material Type	Item Barcode	Shelf Number	Copy	Status
Searching... 1:VCSD	1:GEN-BOOK	000051689	005.756 SIM	1	Searching... Unknown

Bound With These Titles

On Order

Summary

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.