MOUS Essentials Access 2000 - Table of Contents
© Prentice Hall Inc.
A Pearson Education Company
Upper Saddle River, New Jersey 07458
Legal Statement
|
|
|
MOUS Essentials Access 2000 - Table of Contents | |
| Project 1 | Working with Access |
| Lesson 1 | Copying and Renaming a Database File |
| Lesson 2 | Opening a Database and Using the Objects Bar |
| Lesson 3 | Opening and Closing Database Objects |
| Lesson 4 | Identifying Access Window Elements |
| Lesson 5 | Using the Office Assistant and the What's This? Feature |
| Lesson 6 | Closing a Database and Exiting Access
|
| Project 2 | Creating a Database |
| Lesson 1 | Creating a New Database |
| Lesson 2 | Creating a Table Using Design View |
| Lesson 3 | Saving a Table Design and Creating a Primary Key |
| Lesson 4 | Adding Fields to a Table |
| Lesson 5 | Editing Fields |
| Lesson 6 | Moving Fields |
| Lesson 7 | Deleting Fields |
| Challenge 2 | Adding a Table to an Existing Database Using a Wizard |
| Discovery 1 | Creating a Database Using a Database Wizard
|
| Project 3 | Entering and Editing Data |
| Lesson 1 | Adding Records |
| Lesson 2 | Moving among Records |
| Lesson 3 | Editing Records |
| Lesson 4 | Copying, Pasting, 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 Query |
| Lesson 2 | Modifying and Sorting a Query |
| Lesson 3 | Matching Criteria and Using Multiple Criteria |
| Lesson 4 | Using Comparison Operators in a Query |
| Lesson 5 | Using Wildcards in a Query |
| Lesson 6 | Creating a Calculated Field in a Query |
| Lesson 7 | Summarizing Data Using the Total Function |
| Lesson 8 | Changing Query Properties to Show Top Values |
| Lesson 9 | Save a Query with a New Name
|
| 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 in Design View |
| 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 Data in a Table |
| Lesson 2 | Creating a Report Using the 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 | 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
|
| Project 8 | Making Data Entry Easier and More Accurate |
| Lesson 1 | Creating Consistent Data Formats |
| Lesson 2 | Creating Conditional Formats for Positive, Negative, and Null Values |
| Lesson 3 | Changing the Data Input Structure Using Input Masks |
| Lesson 4 | Restricting Entry Using Validation Criteria |
| Lesson 5 | Requiring Entry of Necessary Information |
| Lesson 6 | Preventing Duplicate Entries Using Indexed Fields |
| Lesson 7 | Creating a Lookup Column to Allow Selection from a List |
| Lesson 8 | Entering a Default Value |
| Lesson 9 | Optimize data type usage
|
| Project 9 | Managing Data Using Smaller, Related Tables |
| Lesson 1 | Designing Related Tables to Hold Repetitive Date |
| Lesson 2 | Defining the Relationship between the Tables |
| Lesson 3 | Printing Table Relationships and Displaying: Using Subdatasheets in Tables |
| Lesson 4 | Creating Queries That Draw Data from Both Tables |
| Lesson 5 | Automatically Filling in Data from One of the Joined Tables |
| Lesson 6 | Updating Tables by Entering or Deleting Data in the Query |
| Lesson 7 | Finding Duplicate Records in an Existing Table
|
| Project 10 | Adding Useful Features to Your Forms |
| Lesson 1 | Adding Formats in the Form Design View |
| Lesson 2 | Selecting Entries from a List |
| Lesson 3 | Looking Up Valid Entries from a Table or Query |
| Lesson 4 | Using Information from a Query to Fill in Fields Automatically |
| Lesson 5 | Entering the Current Date in a Field Automatically |
| Lesson 6 | Adding the Current Date and Time to a Form Automatically |
| Lesson 7 | Changing the Tab Order |
| Lesson 8 | Creating Subforms |
| Lesson 9 | Printing the Form for Filing Purposes
|
| Project 11 | Special Purpose Reports and Advanced Report Features |
| Lesson 1 | Creating Labels for Mailings |
| Lesson 2 | Creating Calculated Fields in a Report |
| Lesson 3 | Grouping and Sorting Data in a Report |
| Lesson 4 | Keeping Grouped Data Together in Reports |
| Lesson 5 | Adding Calculated Fields to Group Headers and Footers |
| Lesson 6 | Inserting a Graphic Background by Modifying Report Properties |
| Lesson 7 | Adding a Graphic to a Report
|
| Project 12 | Using Access Macros |
| Lesson 1 | Creating a Macro to Open Close a Form |
| Lesson 2 | Creating a Macro to Print a Report |
| Lesson 3 | Using the Macro Builder to Open a Form in Read Only Mode |
| Lesson 4 | Running a Macro from a Button on a Form |
| Lesson 5 | Creating a Macro to Close a Form |
| Lesson 6 | Running a Macro from a Button on a Form |
| Lesson 7 | Creating a Switchboard Using the Switchboard Manager |
| Lesson 8 | Creating a Macro to Automatically Launch the Main Switchboard
|
| Project 13 | Managing Your Databases |
| Lesson 1 | Making Backup Copies of Your Database |
| Lesson 2 | Saving Converting an Access 2000 Database as into an Access 97 Database |
| Lesson 3 | Compacting and Repairing Files for Efficient Storage |
| Lesson 5 | Using Detect and Repair to Fix Access Problems |
| Lesson 6 | Creating a Query that Creates an Archive Table |
| Lesson 7 | Modifying the Archive Setup Query to Delete Records from a Table |
| Lesson 8 | Creating a Query to Append Records to an Archive Table |
| Lesson 9 | Creating a Macro to Run Two Queries |
| Lesson 8 | Transferring Access Data to Excel
|
| Project 14 | Using Access on the Web and Linking to Other Documents |
| Lesson 1 | Add Hyperlinks from Forms to Word Documents |
| Lesson 2 | Adding Hyperlinks from Forms to Excel Spreadsheets |
| Lesson 3 | Saving Database Objects as Static HTML Pages |
| Lesson 4 | Viewing HTML Pages on a Local Drive Using a Browser
|
| Project 15 | Designing a Complex Database |
| Lesson 1 | Defining Desired Output |
| Lesson 2 | Organizing the Fields into Several Tables |
| Lesson 3 | Relating Tables using One-to-one, and One-to-many Relationships |
| Lesson 4 | Relating Two Tables Using a Third Table |
| Lesson 5 | Refining the Design to Eliminate Redundant Fields |
| Lesson 6 | Creating Queries and Testing the Design |
| Lesson 7 | Documenting the Design
|
| Project 16 | Making the Input Form More User-Friendly |
| Lesson 1 | Changing the Color of Text, Backgrounds, and Borders using Buttons |
| Lesson 2 | Using the Format Painter to Copy Formats Between Controls |
| Lesson 3 | Formatting More Than One Control at a Time |
| Lesson 4 | Changing Colors Using Properties |
| Lesson 5 | Adding Status Bar Instructions in the Form View |
| Lesson 6 | Adding Customized Control Tips to Controls |
| Lesson 7 | Use a Calculated Control on a Form |
| Lesson 8 | Creating a Custom Toolbar |
| Lesson 9 | Using the Macro Builder to Add Attach a Macro to a Form
|
| Project 17 | Managing Changing Data |
| Lesson 1 | Replacing Data in a Table using an Update Query |
| Lesson 2 | Replacing Portions of Fields using an Update Query |
| Lesson 3 | Updating Tables with a Calculated Expression |
| Lesson 4 | Updating a Table based on Values in Another Table |
| Lesson 5 | Updating Linked Tables Automatically
|
| Project 18 | Using Access Tools |
| Lesson 1 | Customizing Data Entry Using AutoCorrect |
| Lesson 2 | Analyzing a Table |
| Lesson 3 | Analyzing Database Performance |
| Lesson 4 | Updating the Database using Name AutoCorrect |
| Lesson 5 | Using Office Links to Analyze Data with Excel
|
| Project 19 | Analyzing and Reporting Data |
| Lesson 1 | Using the Totals Tool in a Query |
| Lesson 2 | Create Crosstab Queries and Reports |
| Lesson 3 | Adding a Subform to an Existing Form |
| Lesson 4 | Inserting Subreports into Reports Using the Subform/Report Wizard |
| Lesson 5 | Creating Forms Using the Chart Wizard
|
| Project 20 | Filtering Data in a Linked Table Using Parameters and Form Filters |
| Lesson 1 | Link to a Large Table in Another Database |
| Lesson 2 | Select Records using Filter by Selection |
| Lesson 3 | Select Records using Filter by Form |
| Lesson 4 | Use Parameters as Matching Criteria in a Query |
| Lesson 5 | Use Parameters with Comparison Operators in a Query |
| Lesson 6 | Use Parameters with Wildcards as Criteria in a Query
|
| Project 21 | Sharing a Database with Others |
| Lesson 1 | Assigning a Password to Your Database |
| Lesson 2 | Changing or Removing a Database Password |
| Lesson 3 | Encrypting a Database |
| Lesson 4 | Setting Startup Parameters |
| Lesson 5 | Setting Access Defaults |
|
© Prentice Hall Inc. A Pearson Education Company Upper Saddle River, New Jersey 07458 Legal Statement |
|