Access 2002: The Complete Reference (Book/CD-ROM)


Master all the powerful features of Access 2002. This complete reference explains in full detail how to design and use Access tables, queries, forms, and reports and maximize all the program's capabilities. Chapters on VBA techniques pave your way to Access programming, and a special section on using Access on the Internet is also included. The CD-ROM contains database files from the book's examples so you can recreate the sample projects. You'll also get Test Yourself software to help you prepare for the MOUS ...
See more details below
Paperback (Older Edition)
$34.95 price
(Save 30%)$49.99 List Price
Other sellers (Paperback)
  • All (21) from $1.99   
  • New (1) from $28.65   
  • Used (20) from $1.99   
Sending request ...


Master all the powerful features of Access 2002. This complete reference explains in full detail how to design and use Access tables, queries, forms, and reports and maximize all the program's capabilities. Chapters on VBA techniques pave your way to Access programming, and a special section on using Access on the Internet is also included. The CD-ROM contains database files from the book's examples so you can recreate the sample projects. You'll also get Test Yourself software to help you prepare for the MOUS Certification Exams for Access 2002.
Read More Show Less

Product Details

  • ISBN-13: 9780072132410
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 4/19/2001
  • Series: Complete Reference Series
  • Edition description: Older Edition
  • Edition number: 1
  • Pages: 1220
  • Product dimensions: 7.30 (w) x 9.10 (h) x 2.53 (d)

Meet the Author

Virginia Andersen (San Diego, CA) is a freelance author and writer who has written or contributed to nearlyy 25 books about PC-based applications, including many student tutorials and accompanying instructor manuals with exercise disks. Virginia is certified as a Microsoft Access MOUS Expert.
Read More Show Less

Read an Excerpt

Excerpt from
Chapter 1

Quick Tour of Access 2002

In this, the Information Age, we're all surrounded by mountains of data. To use this data effectively, the information must be stored so it can be retrieved and interpreted with flexibility and efficiency. Microsoft Access 2002 is the ideal database management system that you can use for all your information management needs, from a simple address list to a complex inventory management system. It provides tools not only for storing and retrieving data but also for creating useful forms, reports, and interactive Web data pages. All you need is a basic acquaintance with Microsoft Windows and a sense of exploration to build the database you need. This chapter shows you how to start Access 2002 and gives you a tour of the Access workplace. If you're already an experienced user, you may want to scan the material in this chapter quickly and move on to Chapter 2 for insight into the power of the tool called a relational database.

Starting Access and Opening a Database

You can start most software built for the Windows 95/98 environment in the same way: by clicking the Start button and pointing to Programs in the Start menu. Depending on how you installed Access 2002, the name may appear as a separate item in the Programs list or as one of the programs in the Microsoft Office XP menu. If you don't see Microsoft Access in the Programs list, choose Microsoft Office XP and then click Microsoft Access. When first opened, the Access main window displays a floating New File side pane offering you a choice of creating a new database or opening one of the existing database files, as shown in Figure 1-1. The upper panel contains the names of databases that were recently opened (your list will be different). The Access opening window is where your session with Access begins. The side pane in Figure 1-1 appears only when Access first starts or when you choose File I New. For now, click the Close button (the x in the upper-right corner) to close the side pane and leave the Access window empty for a tour of the window.

Launch Access and Start a Database at the Same Time

If you usually work with the same database in Access, you can quickly launch Access and open the database with one mouse click. To start Access and open the database:
1. Click the Start button and point to Documents.
2. Choose your database file from the list (see Figure 1-2). The icon preceding the document name identifies the type of document. If your system displays file extensions, an Access database file shows the .mdb extension.
If your database doesn't appear in the list of recently opened documents, you must resort to the two-step method by first starting Access, and then opening the database. NOTE: If you have more than one version of Access installed on your computer, the database will open in the latest version.

Touring the Access Window

The Access window (see Figure 1-3) shows a title bar, a menu bar, and a toolbar common to Windows 95/98 programs. In addition to displaying the program name, Microsoft Access, the title bar contains buttons you can use to manipulate the window:
  • The Close button closes the program.
  • The Maximize button appears only when the window is less than maximum size and enlarges the window to fill the screen.
  • The Restore button replaces the Maximize button when the window is maximized and returns the window to its previous reduced size.
  • The Minimize button reduces the window to an icon on the Windows taskbar.
  • The Control Menu icon at the far-left end of the title bar opens a menu with the commands that accomplish the same things as the other buttons. Click the Control Menu icon to open the menu.
When the window is less than maximum size, you can move it to a new position on the desktop by dragging its title bar. You can also change its height and width by dragging its borders or the resize handle in the lower-right corner where you see the three diagonal lines.

Most of the menu commands are dimmed and unavailable in the empty Database window. The File menu offers options to create a new database or to open an existing one. Other options, such as the Toolbars option in the View menu, let you tailor the database workplace. All the Help menu options are available.

The buttons on the toolbar offer shortcuts to many of the commonly used menu commands. Most of the toolbar buttons are dimmed, which indicates they're also unavailable when no database is active. Even if a button is dimmed, you can still rest the mouse pointer on the button and see its name displayed below the button in a ScreenTip (called a ToolTip in earlier versions of Access). The toolbar, as well as the menu bar, presents different options, depending on the current activity.

The status bar, located at the bottom of the Access window, provides a running commentary about the ongoing task and the Access working environment. The right side of the status bar also shows boxes that indicate the presence of a filter and the status of various toggle keys such as INSERT, CAPS LOCK, SCROLL LOCK, and NUM LOCK.

If you're already familiar with Windows 95, you know the taskbar at the bottom of the screen shows a button for each program currently running. New with Windows 98, the taskbar shows a button for each open document, even if they are from the same program. These buttons make switching from one program or document to another quick and easy. Just click the name of the one you want to use and it becomes the active program or document. Notice the Microsoft Access button appears pressed in on the Windows taskbar, indicating it's the active application. If other programs are open, their buttons also appear in the taskbar, but only the currently active one appears pressed in.

Note: As more and more programs are started, the Windows taskbar buttons are narrowed so all can be seen in the taskbar. With many programs running at once, only the programs' icons and the first few letters of their names may be visible on the taskbar buttons.

Opening a Database

If the database you want to open is listed in the side pane that appears when Access starts, you can open it by simply double-clicking the filename or by selecting it and choosing OK. If the one you want isn't on the list, click More Files. The Open dialog box appears, as shown in Figure 1-4. (Your list of folders and files will be different.) The same dialog box appears if Access is already running when you choose File I Open or click the Open toolbar button.

The Groups bar at the left contains five buttons, which you can click to open other folders or to return to the Windows desktop.

  • The top button, History, opens the new Recent folder that contains the name, size, type, and date of the last modification for each recently accessed database. When you click the History button, the Recent folder name appears in the Look in box.
  • The second button, My Documents (or the name of your personal default folder) shows the contents of that folder. This is the default display in the Open dialog box.
  • The Desktop button displays a list of the desktop components on your computer you can move to, including such items as My Computer, My Documents, Network Neighborhood, and Online Services.
  • The Favorites button displays the names of any folders and objects you've added to the Favorites folder.
  • The Web Folders button displays the folders and objects you saved in Web folders.
The trick is to know where you stored your database. If you used other applications, such as Word or Excel, you know how to find the file you want with the Open dialog box. You use the Look in box to zero in on the folder that contains the database, double-click the folder name or icon to open it, and then select the one you want from the list that appears in the dialog box.

The Open dialog box contains several buttons that help you find the file you want to open. You can see the name of each button by resting the mouse pointer on the button in the command bar. Table 1-1 describes the purpose of each of the buttons in the Open dialog box....

Read More Show Less

Table of Contents

Part I: Getting Started.

Chapter 1: Quick Tour of Access 2002.

Chapter 2: The World of Relational Databases.

Chapter 3: Creating a Database.

Chapter 4: Creating and Modifying Tables.

Chapter 5: Relating Tables.

Chapter 6: Entering and Editing Data.
Part II: Retrieving and Presenting Information.

Chapter 7: Sorting, Filtering and Printing Records.

Chapter 8: Extracting Information with Queries.

Chapter 9: Creating Advanced Queries.

Chapter 10: Creating Form and Report Designs.

Chapter 11: Using the Form Wizard.

Chapter 12: Customizing Forms.

Chapter 13: Using the Report Wizard.

Chapter 14: Customizing Reports.

Chapter 15: Creating Charts, PivotTables, and PivotCharts.
Part III: Improving the Workplace.

Chapter 16: Customizing the Workplace.

Chapter 17: Improving Database Performance.

Chapter 18: Understanding Events and the Event Model.

Chapter 19: Automating with Macros.

Chapter 20: Customizing Menus and Toolbars.

Chapter 21: Creating Custom Switchboards and Dialog Boxes.
Part IV: Exchanging Data with Others.

Chapter 22: Exchanging Database Objects and Text.

Chapter 23: Exchanging Data with Outside Sources.

Chapter 24: Access 2002 on the Internet.
Part V: Application Development.

Chapter 25: Introducing Microsoft Visual Basic.

Chapter 26: Sharing with Multiple Users.

Chapter 27: Securing a Database.

Chapter 28: Developing an End-User Application.

Chapter 29: Converting to Access 2002.
Appendix A: MOUS Exam Objectives.
Appendix B: What's on the CD.
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)