Access 2000 Essentials Basic / Edition 1 available in Multimedia Set
- Pub. Date:
- Prentice Hall
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.
For anyone interested in learning Microsoft Office 2000.
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.