Home > Store

Absolute Beginner's Guide to Microsoft Access 2002

Register your product to gain access to bonus material or receive a coupon.

Absolute Beginner's Guide to Microsoft Access 2002


  • Your Price: $19.99
  • List Price: $24.99
  • We're temporarily out of stock, but order now and we'll send it to you later.


  • Copyright 2003
  • Dimensions: 7-3/8" x 9-1/8"
  • Pages: 336
  • Edition: 1st
  • Book
  • ISBN-10: 0-7897-2919-9
  • ISBN-13: 978-0-7897-2919-4

Microsoft Access 2002 is a powerful, relational database software package that makes it easy to create and manage complex databases. With Access, users can create a database quickly from scratch or by using an Access database Wizard. Once the database is created, Access provides all the tools needed to enter and manipulate data. With the help of the Absolute Beginner's Guide, readers are able to quickly start a new database by using the Database Wizard, create tables from scratch or by using a Wizard, add and edit database information by using both tables and forms and manipulate data in a number of tables by using queries and reports. The book assumes absolutely no prior knowledge of the topic, and learning is easy because of the book's lighthearted but no-nonsense style. It serves as an excellent resource for users who are completely new to Access 2002 or who are upgrading from a previous version of the software.



All the Access databases developed for the book in one convenient Zip file for download - 20,161 kb -- Acc2002ABGSamples.zip

The Access database file for Chapter 4 in a Zip file - 35 kb -- Chapter04.zip

The Access database file for Chapter 5 in a Zip file - 16 kb -- Chapter05.zip

The Access database file for Chapter 6 in a Zip file - 15 kb -- Chapter06.zip

The Access database file for Chapter 7 in a Zip file - 23 kb -- Chapter07.zip

The Access database file for Chapter 8 in a Zip file - 3,378 kb -- Chapter08.zip

The Access database file for Chapter 9 in a Zip file - 1,692 kb -- Chapter09.zip

The Access database file for Chapter 10 in a Zip file - 1,693 kb -- Chapter10.zip

The Access database file for Chapter 11 in a Zip file - 1,695 kb -- Chapter11.zip

The Access database file for Chapter 12 in a Zip file - 2,863 kb -- Chapter12.zip

The Access database file for Chapter 13 in a Zip file - 2,813 kb -- Chapter13.zip

The Access database file for Chapter 14 in a Zip file - 2,856 kb -- Chapter14.zip

The Access database file for Chapter 15 in a Zip file - 3,088 kb -- Chapter15.zip

Sample Content

Online Sample Chapters

Exploring the Database Window

Exploring the Database Window in Microsoft Access

Table of Contents


1. Welcome to Databases.

What Can You Do with a Database? Why Not Just Use Excel? A Sample Database: Northwind Traders.

2. Take a Quick Tour of Access.

Launching Access. Opening a Database. Opening an Existing File. Converting. Exploring the Access User Interface. Making a Grand Exit.

3. Exploring the Database Window.

Whats in the Database Window? Organizing Database Objects.


4. Planning a Database.

The Goal. etermining the Databases Purpose. The Discovery Process—Finding the Data. Identifying Possible Forms. Planning Possible Reports.

5. Building Your First Tables.

Whats in a Table? How to Create a Simple Table. Working with Data in Your Tables. How to Find Information.

6. Tapping the Power of Relationships.

Using the Lookup Wizard. Using the Table Analyzer to Create Relationships. Using the Relationships Window. Subdatasheets—A Product of Relationships.

7. Retrieving Data with Queries.

How to Create Simple Queries. Using Query Design View.


8. Creating and Using Data Entry Forms.

Creating Simple Forms. Entering Data Through Forms. Finding Information with Forms.

9. Printing Information with Reports.

Building Reports. Using Reports.

10. Take Your Data to the Web with Pages.

A Quick Overview of the Page Object. Creating Simple Pages. Using Pages. How Youll Use Pages.


11. Customizing Your Tables.

Using Data Types Wisely. Setting Field Properties. Working with Indexes.

12. Getting Down to Business with Queries.

Running the Query Wizards. Working in Query Design View.

13. Customizing Forms.

Setting Form Properties. Using the Field List. Using the Toolbox. Working with Sections and Subforms.

14. Dressing Up Your Reports.

Formatting Reports. Specialized Wizards.


15. Automating Your Database.

Using the Switchboard Wizard. Setting Startup Options. Writing Macros.

16. Sharing Data.

Exporting Data to Excel. Using Excel Data in Access. Exporting Access Data to a Text File. Importing Text Files into Access. Publishing to Word. Merging Access Data with Word Documents. Sending Access Objects in Email. Using AutoCorrect. More Compatible Formats.




The errata for the book is available here in Adobe Portable Document Format (PDF) format. You will need Adobe's Acrobat Reader to view these files. If you do not have the Acrobat Reader installed, you may go to Adobe Systems' web site to download this free reader.

Click on the links below to display the PDF file in a new window. Right-click on the link and select Save As if you want to download it to your hard drive.

Errata for the book - 20 kb -- 0789729199errata.pdf

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership