Essentials : Access 2002 Level 1

By (author) 

List price: US$50.00

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


The Design is clean and the approach is simple; a list of steps to move users through Office XP tasks. Extensive end-of-project exercises reinforce what readers have learned. Easy to use, clear, concise instructions are accompanied by numbered screens, text is in black and white for flexible and inexpensive customization. The Essentials Series for Microsoft Office XP has be rewritten and redesigned -- hands-on tutorials with a project orientation are designed to give users a thorough knowledge of software applications. Extensive end-of-project exercises emphasize hands-on skill development. For anyone interested in updating their software applications more

Product details

  • Paperback | 258 pages
  • 220.5 x 287 x 12.4mm | 648.65g
  • Pearson Education (US)
  • Pearson
  • United States
  • English
  • 013100901X
  • 9780131009011

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 more