Essentials: Access 2002 Level 1 / Edition 1

Essentials: Access 2002 Level 1 / Edition 1

by Dawn Parrish Wood
     
 

  • 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.
See more details below

Overview

  • 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 )

    Prentice Hall TRAIN Generation It. Prentice Hall's Train Generation IT is a computer-based training software 'a student can use to preview, learn, and review Microsoft® Office application skills. Delivered via intranet, network, CD-ROM, or the Web, Train IT offers interactive, multimedia, computer-based training to augment classroom learning. Built-in prescriptive testing suggests a study path based on not only student test results, but also the specific textbook chosen for the course.

    Prentice Hall ASSESS Generation It. Prentice Hall's Assess Generation IT is separate computer-based testing software used to evaluate a student's knowledge about specific topics on Word, Excel, Access, and PowerPoint®. More extensive than the testing in Train IT, Assess IT offers more features for the instructor and many more questions for the student.

Read More

Product Details

ISBN-13:
9780130927613
Publisher:
Prentice Hall
Publication date:
08/07/2001
Series:
Essentials 2002 Series
Edition description:
New Edition
Pages:
232
Product dimensions:
8.87(w) x 11.00(h) x 0.62(d)

Table of Contents

PROJECT 1. GETTING STARTED WITH ACCESS.

Lesson 1. Creating a New Database/Dbase 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/Table Wizard.
Lesson 3. Adding Fields.
Lesson 4. Editing Fields.
Lesson 5. Moving Fields.
Lesson 6. Deleting Fields.
Lesson 7. Saving a Table.

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. Using Filter by Selection.
Lesson 8. Using Filter by Form.
Lesson 9. Sorting Records.

PROJECT 4. QUERYING YOUR DATABASE.

Lesson 1. Creating a New Query/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 NewName and Opening Multiple Queries.
Lesson 6. Creating a Calculated Field in a Query .

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/Form Wizard.
Lesson 5. Adding Fields to an Existing Form.
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/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 a Previous Version.
Lesson 2. Linking an Access Table to a Form Letter.
Lesson 3. Merging an Access Table with a Form Ltr.
Lesson 4. Importing a Table from Excel.
Lesson 5. Creating a Data Access Page/Page Wizard.
Lesson 6. Using a Browser to Interact with the Db.

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >