|
LEARN
ACCESS 2000
© 2000 Prentice Hall
ISBN: 1-58076-258-1
Lesson 1: Explore an Existing Database
Task 1: Copying, Renaming, and Opening
a Database File
Task 2: Examining a Database Table
Task 3: Using a Form to Enter Data
Task 4: Previewing and Printing a Report
Task 5: Using the "What’s This?"
Help Tool to Learn About the Design of a Form and a Report
Task 6: Getting Help Using the Office
Assistant
Task 7: Closing the Database and Exiting
Access
Lesson 2: Create a Customized Database
Task 1: Creating a New Database Using
the Blank Database Option
Task 2: Creating a Table and Defining
its Fields
Task 3: Entering Records into a Table
Task 4: Adding and Deleting Fields
Task 5: Creating a Form Using the Form
Wizard
Task 6: Arranging Text and Label Fields
in a Form and Adding a Label
Task 7: Setting the Tab Order in a Form
Task 8: Creating a Report Using the Report
Wizard
Task 9: Modifying and Printing a Report
Lesson 3: Modify the Structure of an
Existing Database
Task 1: Changing the Data Type of a Field
Task 2: Adding Input Masks to Aid Data
Input
Task 3: Setting Default Values
Task 4: Assigning a Primary Key Field
Task 5: Adjusting Table Column Widths
Task 6: Adding a List Box to a Form
Task 7: Adding a Combo Box to a Form
Task 8: Adding Headers, Footers, and Page
Breaks to a Form
Lesson 4: Extract Useful Data from
Large Databases
Task 1: Moving Between Records and Columns
of a Table
Task 2: Finding Records
Task 3: Sorting and Indexing Records
Task 4: Using a Form to Define a Filter
Task 5: Using Select Queries to Display
Data
Task 6: Calculating Values in a Query
Task 7: Creating Queries that Enable the
User to Change Criteria Each Time the Query is Used
Lesson 5: Use Two or More Tables In
Combination
Task 1: Importing or Linking to a Table
Task 2: Creating a Relationship Between
Tables
Task 3: Creating a Query that Uses Fields
from More Than One Table
Task 4: Using a Parameter Query with Two
or More Tables
Task 5: Creating a Form that Displays
Data from Two or More Tables
Task 6: Creating a Report Based on a Query
Lesson 6: Use Queries and Reports to
Calculate and Analyze Data
Task 1: Creating a Simple Crosstab Query
Task 2: Creating a Multilevel Crosstab
Query
Task 3: Editing a Query
Task 4: Adding the Totals Function to
a Query
Task 5: Creating a Report that Groups
Data and Displays Subtotals and Totals
Lesson 7: Connect and Interact
Task 1: Converting a Database from a Previous
version of Access
Task 2: Linking an Access Table to a Form
Letter in Word
Task 3: Merging an Access Table with a
Form Letter
Task 4: Importing a Table from Excel
Task 5: Saving a Form as a Data Access
Page
Task 6: Using a Browser to Interact with
the Database
|