Always Learning

Essentials: Access 2002 Level 1
Dawn Parrish Wood

ISBN-10: 0130927619
ISBN-13:  9780130927613

Publisher:  Prentice Hall
Copyright:  2002
Format:  Paper; 232 pp
Published:  08/07/2001
Status: Out of Stock


We're sorry, this product is no longer available.
Please contact your Pearson rep if you are using this product and need instructor resources.


Print this content

In this section:


Description

For courses in Office Applications.

The Essentials Series for Microsoft Office XP has be rewritten and redesigned to meet the needs of today's classroom. These hands-on tutorials with a project orientation are designed to give students a thorough knowledge of software applications. Extensive end-of-project exercises emphasize hands-on skill development.


Features

  • New Custom PHIT Program—See www.prenhall.com/customphit for details.

    • This completely flexible program allows instructors to customize the text to their students' needs. Ex.___

  • Extensive end-of-project exercises—Reinforces what students have learned.
  • Easy to use, clear, concise instructions accompanied by numbered screens.
  • Text is in black and white for flexible and inexpensive customization.


Table of Contents

PROJECT 1. GETTING STARTED WITH ACCESS.

Lesson 1. Creating a New Database Using the Database Wizard.

Lesson 2. Copying and Renaming a Database File.

Lesson 3. Opening and Closing a Database.

Lesson 4. Opening and Closing a Database Table.

Lesson 5. Learning about the Access Window.

Lesson 6. Getting Help.

Lesson 7. Exiting Access and Windows.

PROJECT 2. CREATING A DATABASE.

Lesson 1. Creating a New Database.

Lesson 2. Creating a New Table Using the Table Design Wizard.

Lesson 3. Adding Fields.

Lesson 4. Editing Fields.

Lesson 5. Moving Fields.

Lesson 6. Deleting Fields.

Lesson 7. Creating a New Primary Key.

PROJECT 3. ENTERING AND EDITING DATA.

Lesson 1. Adding Records.

Lesson 2. Moving Among Records.

Lesson 3. Editing Records.

Lesson 4. Inserting and Deleting Records.

Lesson 5. Adjusting Column Widths and Hiding Columns.

Lesson 6. Finding Records.

Lesson 7. Selecting Records Using Filter by Selection.

Lesson 8. Selecting Records Using Filter by Form.

Lesson 9. Sorting Records.

PROJECT 4. QUERYING YOUR DATABASE.

Lesson 1. Creating a New Query Using the Simple Query Wizard.

Lesson 2. Editing the Query.

Lesson 3. Changing Field Order and Sorting Query.

Lesson 4. Matching Criteria.

Lesson 5. Saving the Query with a New Name and Opening Multiple Queries.

Lesson 6. Creating a Calculated Field.

Lesson 7. Formatting the Results of a Calculated Field.

PROJECT 5. CREATING AND USING FORMS.

Lesson 1. Creating an AutoForm.

Lesson 2. Entering and Editing Data Using a Form.

Lesson 3. Saving, Closing, and Opening a Form.

Lesson 4. Creating a New Form Using the Form Wizard.

Lesson 5. Adding Fields to Forms.

Lesson 6. Moving and Resizing Fields in Forms.

Lesson 7. Adding a Form Header and Label.

PROJECT 6. CREATING AND PRINTING REPORTS.

Lesson 1. Printing the Table Data.

Lesson 2. Creating a Report Using a Report Wizard.

Lesson 3. Printing and Renaming a Report.

Lesson 4. Modifying a Report Design.

Lesson 5. Saving the Report with a New Name.

Lesson 6. Adding Labels to Reports.

PROJECT 7. CUSTOMIZING FIELDS AND TABLES.

Lesson 1. Modifying a Table Design.

Lesson 2. Entering a Default Value.

Lesson 3. Changing a Field Type and Selecting a Format.

Lesson 4. Changing a Field Size.

Lesson 5. Working with More Than One Table.

Lesson 6. Creating Table Relationships.

Lesson 7. Creating a Multiple-Table Query.

PROJECT 8. INTEGRATING ACCESS WITH OTHER SOURCES OF DATA AND THE INTERNET.

Lesson 1. Converting a Database from a Previous Version of Access.

Lesson 2. Linking an Access Table to a Form Letter in Word.

Lesson 3. Merging an Access Table with a Form Letter.

Lesson 4. Importing a Table from Excel.

Lesson 5. Creating a Data Access Page Using the Page Wizard.

Lesson 6. Using a Browser to Interact with the Database.



Back to top

Print this content

In this section:


Author Bios

Marianne Fox—Series editor and coauthor of essentials Excel 2002 Level 1, Level 2, and Level 3. Marianne Fox is an Indiana CPA with B.S. and M.B.A. degrees in Accounting from Indiana University. For more than 20 years, she has enjoyed teaching full-time—initially in Indiana University's School of Business; since 1988 in the College of Business Administration at Butler University. As the co-owner of an Indiana-based consulting firm, Marianne has extensive experience consulting and training in the corporate and continuing education environments. Since 1984, she has coauthored more than 35 computer-related books; and has given presentations on accounting, computer applications, and instructional development topics at a variety of seminars and conferences.

Lawrence C. Metzelaar—Series editor and coauthor of essentials Excel 2002 Level 1, Level 2, and Level 3. Lawrence C. Metzelaar earned a B.S. in Business Administration and Computer Science from the University of Maryland, and an Ed.M. and C.A.G.S. in Human Problem Solving from Boston University. Lawrence has more than 30 years of experience with military and corporate mainframe and microcomputer systems. He has taught computer science and Management Information Systems (MIS) courses at the University of Hawaii, Control Data Institute, Indiana University, and Purdue University; currently, he is a full-time faculty member in the College of Business Administration at Butler University. As the co-owner of an Indiana-based consulting firm, he has extensive experience consulting and training in the corporate and continuing education environments. Since 1984, he has co-authored more than 35 computer-related books; and has given presentations on computer applications and instructional development topics at a variety of seminars and conferences.

Linda Bird—Author of essentials PowerPoint® and Level 2. Linda Bird specializes in corporate training and support through her company, Software Solutions. She has successfully trained users representing more than 75 businesses, including several Fortune 500 companies. She custom designs many of her training materials. Her clients include Appalachian Electric Power Co., Goodyear, Pillsbury, Rockwell, and Shell Chemical. Her background also includes teaching at Averett College and overseeing computer training for a business training organization.

Using her training experience as a springboard, Linda has written numerous books on PowerPoint, Word, Excel, Access, and Windows. Additionally, she has written more than 20 instructor's manuals and contributed to books on a variety of desktop application programs. She has also penned more than 150 magazine articles, as well as monthly how-to columns on PowerPoint and Excel for Smart Computing magazine.

Linda, a graduate of the University of Wisconsin, lives near the Great Smoky Mountains in Tennessee with her husband, Lonnie, and daughters, Rebecca and Sarah. Besides authoring books, Linda home-educates her daughters. If she's not writing, you can probably find her trekking around the mountains (or horseback riding) with her family.

Keith Mulbery—Author of essentials Word 2002 Level 1, Level 2, and Level 3. Keith Mulbery is an associate professor in the Information Systems Department at Utah Valley State College, where he teaches computer applications courses and assists with curriculum development. Keith received his B.S. and M.Ed. (majoring in Business Education) from Southwestern Oklahoma State University. Keith has written several Word and WordPerfect textbooks. His previous book, MOUS essentials Word 2000, received the Utah Valley State College Board of Trustees Award of Excellence in January 2001. In addition, he was the developmental editor of essentials Word 2000 intermediate and essentials Word 2000 advanced. Keith also conducts hands-on computer application workshops at the local, state, and national levels, including at the National Business Education Association convention.

Dawn Parrish Wood—Author of essentials Access 2002 Level 1, Level 2, and Level 3. Dawn Parrish Wood is an independent contractor, and provides software training through her own business, Software Support. She teaches customized courses to local businesses and individuals in order to upgrade employee skills and knowledge of computers. Dawn has written materials for these specialized courses for her own use. She also provides software consultation to local businesses. Previously, she was the computer coordinator/lead instructor for the Business & Industry Services division at Valdosta Technical Institute in Valdosta, Georgia. The majority of the coursework she taught was in continuing education. Prior to teaching, she worked as a technical support representative and technical writer for a software firm. She lives in Valdosta, Georgia, with her husband, Kenneth, and their two daughters, Micaela (4 1/2 years) and Kendra (2 1/2 years). Both girls have been her superlative students, learning more on the computer every day.


Backcover Copy

  • Just right for your level!
    Skills that are right for your needs. Instruction that is right for your level. The essentials series is your no-nonsense approach to learning Office XP applications at the basic, intermediate and advanced levels.
  • Reinforce what you learn! Practice and reinforce skills with extensive end-of-project exercises.
    Checkout the extensive end-of-project exercises that emphasize hands-on-learning and reinforce skills while checking your comprehension.
  • Fully customizable!
    Mix and match any project at any level on-line to target the skill sets you need to achieve your goals.
  • Be sure to visit www.prenhall.com/essentials

Back to top

Print this content

In this section:


Websites and Online Courses

Companion Website - Essentials
Metzelaar
©2002  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 0130927872  |  ISBN-13: 9780130927873
More Info

Back to top

Print this content

In this section:

Companion Website - Essentials
Metzelaar
©2002  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 0130927872  |  ISBN-13: 9780130927873
More Info

Back to top


Websites and online courses

Companion Website - Essentials
Metzelaar
©2002  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 0130927872  |  ISBN-13: 9780130927873
More Info


For the CIS: Office Applications Discipline

PHIT TIPS Microsoft Access 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0131588346  |  ISBN-13: 9780131588349
More Info

PHIT Tips: File Management
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 2 pp  |  Instock
ISBN-10: 0131588354  |  ISBN-13: 9780131588356
More Info

Phit TIPS: Microsoft Excel 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0136128017  |  ISBN-13: 9780136128014
More Info

PHIT Tips: Microsoft Office 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0132332221  |  ISBN-13: 9780132332224
More Info

PHIT Tips: Microsoft Outlook 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0132050625  |  ISBN-13: 9780132050623
More Info

PHIT Tips: Microsoft PowerPoint 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0132332558  |  ISBN-13: 9780132332552
More Info

PHIT Tips: Microsoft Word 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0132050617  |  ISBN-13: 9780132050616
More Info

PHIT Tips: WinZip for Microsoft Office 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card  |  Instock
ISBN-10: 0131588311  |  ISBN-13: 9780131588318
More Info

Shortcut Key Card: Microsoft Office 2007
PrenticeHall
©2008  |  Prentice Hall  |  Study Card; 2 pp  |  Instock
ISBN-10: 0131588400  |  ISBN-13: 9780131588400
More Info

Windows Vista PHIT Tip
Prentice Hall
©2008  |  Prentice Hall  |  Study Card; 4 pp  |  Instock
ISBN-10: 0136128025  |  ISBN-13: 9780136128021
More Info


Back to top


Websites and Online Courses

Companion Website - Essentials
Metzelaar
©2002  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 0130927872  |  ISBN-13: 9780130927873
More Info

Log in to the Instructor Resource Center

Login name: 

  Password: 

Forgot login/password?  |  Need to redeem an access code?

        

Instructor Resource Center File Download

This work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. Dissemination or sale of any part of this work (including on the World Wide Web) will destroy the integrity of the work and is not permitted. The work and materials from this site should never be made available to students except by instructors using the accompanying text in their classes. All recipients of this work are expected to abide by these restrictions and to honor the intended pedagogical purposes and the needs of other instructors who rely on these materials.

Cancel     I accept, proceed with download

Print this content

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.

Package ISBN-10: 0131679880 | ISBN-13: 9780131679887
©2002 | Not Yet Published
Suggested retail price: $48.00  

This package contains:

Wood | ©2002 | Prentice Hall | Paper; 232 pp
Wood | ©2002 | Prentice Hall | Paper; 232 pp
Wood | ©2002 | Prentice Hall | Paper; 232 pp
Pearson | ©2004 | Prentice Hall | Paper; 1 pp


Back to top