Always Learning

Access 2000 Essentials Basic
Robert L. FerrettEastern Michigan University
Sally Preston
John Preston

ISBN-10: 1580760945
ISBN-13:  9781580760942

Publisher:  Prentice Hall
Copyright:  2000
Format:  Paper; 238 pp
Published:  08/26/1999
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 Microsoft Office Professional for Windows and Access for Windows.

Essentials courseware is anchored in the practical and professional needs of all types of students. The series has been completely revamped as the result of extensive usability testing conducted by students with multiple levels of computer knowledge.

The Essentials series is conceived as a “learning system” that combines graphics, instructions, experience, reinforcement, and problem solving. It consists of modular lessons that are built around a series of numbered, step-by-step procedures that are clear, concise, and easy to review. Explanatory material is interwoven before each lesson and between the steps.

Additional features, tips, pitfalls, and other related information are provided at exactly the right place. They are easily recognizable elements that stand out from the main flow of the tutorial. Icons are designed to match the Microsoft Office theme.

The end-of-chapter exercises have been carefully graded from the routine Checking Concepts and Terms to tasks in the Discovery Zone that gently prod students into extending what they've learned into areas beyond the explicit scope of the lessons proper.


Features

Substantial Focus On Learning and How To Learn.
  • Guided use of onscreen Help within lessons and end-of-project exercises.
    • Helps students “learn to learn” on their own to keep up with the ever-expanding feature set of Microsoft Office. Shows them how to discover the right procedures or answers by exploiting the many resources that are already within the application. Ex.___

Hands-On Exercises: Expanded into Three Levels.
  • Skill Drill exercises—Reinforce project skills. Each skill that is reinforced is the same, or nearly the same, as a skill presented in the project. Detailed instructions are provided in a step-by-step format.
    • Enables students to check their comprehension, evaluate their progress, and practice what they've learned. Ex.___

  • Challenge exercises—Expand upon or are related to skills presented in the lessons. Each exercise provides a brief narrative introduction, followed by instructions in a numbered step format that are not as detailed as those in the Skill Drill section. Some contain references for students to apply tips discussed in Nice to Know, Need to Know, or Help.
    • Helps students learn to think on their own and fosters the “near transfer” of learning. Ex.___

  • Discovery Zone exercises—Require advanced knowledge of topics presented in Essentials lessons, the application of skills from multiple lessons, or self-directed learning of new skills. Some contain references for students to apply tips discussed in Nice to Know, Need to Know, or Help.
    • Emulates real-world experience by encouraging self-directed learning of new skills. Ex.___

Beginning of the Project.
  • Objectives—Specific topics covered in the lessons.
    • Gives students short-term, attainable goals for each project. Ex.___

  • Key Terms—New terminology defined and discussed in the project.
    • Helps students to become familiar with the terminology used. Ex.___

  • Why Would I Do This?—Introductory section telling students why a project is useful to them.
    • Shows students why a project is useful to them and what they can do with the knowledge they obtain. Ex.___

  • Visual Summary—Screen shots and sample documents to illustrate what students will learn in the project.
    • Illustrates the concepts and features students will learn in the project and helps to keep them motivated. Ex.___

Lessons.
  • Lessons—Projects broken down into lessons that correspond with objectives.
    • Gives students the project broken down into lessons that correspond with objectives. Ex.___

  • Step-by-Step Instructions—Instructions, along with explanation, to guide students as they learn new features.
    • Guides students as they learn new features, and lets them “learn-by-doing.” Ex.___

  • If You Have Problems— Trouble-shooting tips that anticipate common pitfalls.
    • Helps students anticipate or solve common problems quickly and effectively. Ex.___

  • Need to Know—Essential notes and information necessary to apply features.
    • Provides students with essential tips for performing the task and using the application more effectively. Ex.___

  • Nice to Know—Additional tips to become more proficient in using the software.
    • Provide students with extra tips, shortcuts, alternative ways to complete a process, and special hints about using the software. Ex.___

Checking Concepts and Terms.
  • True/False Questions —With reference to lesson where topic is covered.
  • Multiple Choice Questions—With reference to lesson where topic is covered.
  • Screen ID—Where students identify elements of the screen and within documents.
  • Discussion Questions—That make students apply critical-thinking skills to further understand concepts and features.
    • Helps students check their comprehension and assess their retention. Ex.___


Table of Contents



Project 1: Getting Started with Access.

Lesson 1. Copying and Renaming a Database File. Lesson 2. Opening and Closing a Database. Lesson 3. Opening and Closing a Database Table. Lesson 4. Identifying Access Window. Lesson 5. Getting Help. Lesson 6. Exiting Access and Windows.



Project 2: Creating a Database.

Lesson 1. Creating a New Database. Lesson 2. Creating a New Table. Lesson 3. Saving a Table Design and Creating a Primary Key. Lesson 4. Adding Fields. Lesson 5. Editing Fields. Lesson 6. Moving Fields. Lesson 7. Deleting Fields.



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 a Record. Lesson 7. Sorting Records.



Project 4: Querying Your Database.

Lesson 1. Creating a New Query. Lesson 2. Choosing Fields for a Query. Lesson 3. Saving the Query. Lesson 4. Editing the Query. Lesson 5. Changing the Field Order and Sorting the Query. Lesson 6. Matching Criteria. Lesson 7. Saving the Query with a New Name and Opening Multiple Queries.



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 from Scratch. 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 the Report Wizards. 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. Saving a Form as a Data Access Page. Lesson 6. Using a Browser to Interact with the Database.



Glossary.


Task Guide.


Index.



Back to top

Print this content

In this section:


Websites and Online Courses

Companion Website
Ferrett
©2000  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 013087017X  |  ISBN-13: 9780130870179
More Info

Back to top

Print this content

In this section:

Companion Website
Ferrett
©2000  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 013087017X  |  ISBN-13: 9780130870179
More Info

Back to top


Websites and online courses

Companion Website
Ferrett
©2000  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 013087017X  |  ISBN-13: 9780130870179
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
Ferrett
©2000  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 013087017X  |  ISBN-13: 9780130870179
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: 0131216015 | ISBN-13: 9780131216013
©2002 | Out of Stock
Suggested retail price: $105.67  Buy from myPearsonStore

This package contains:

Ferrett, Preston & Preston | ©2000 | Prentice Hall | Paper; 238 pp
Lauckner & Lintner | ©2001 | Prentice Hall | Paper; 489 pp
ETTER & KUNCICKY | ©2001 | Prentice Hall | Paper
Allen Interactions | ©2002 | Prentice Hall | Software


Back to top