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.

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.