Access 2000 Essentials Advanced / Edition 1
by Robert L. Ferrett, John Preston, Sally Preston
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
… See more details belowOverview
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.
Product Details
- ISBN-13:
- 9781580763028
- Publisher:
- Prentice Hall
- Publication date:
- 11/24/1999
- Series:
- Essentials Series for Office 2000 Series
- Edition description:
- New Edition
- Pages:
- 232
- Product dimensions:
- 8.75(w) x 10.99(h) x 0.48(d)
Table of Contents
Project 1: 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 2: Making the Input Form 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 Form View. Lesson 6: Adding Customized ControlTips to Controls. Lesson 7: Creating a Custom Toolbar.
Project 3: 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 Using a Calculated Expression. Lesson 4: Updating a Table Based on Values in Another Table. Lesson 5: Updating Linked Tables Automatically.
Project 4: Using Access Tools.
Lesson 1: Correcting Spelling with the Spell Checker. Lesson 2: Customizing Data Entry using AutoCorrect. Lesson 3: Analyzing a Table. Lesson 4: Analyzing Database Performance. Lesson 5: Using the Database Documenter. Lesson 6: Using OfficeLinks with Word and Excel.
Project 5: Analyzing and Reporting Data.
Lesson 1: Correcting Spelling with the Spelling Checker. Lesson 2: Customizing Data Entry Using AutoCorrect. Lesson 3: Analyzing a Table. Lesson 4: Analyzing Database Performance. Lesson 5: Updating the Database Using Name AutoCorrect. Lesson 6: Using Office Links to Analyze Data with Excel.
Project 6: Filtering Data in a Linked Table Using Parameters and Form Filters.
Lesson 1: Linking to a Large Table in Another Database. Lesson 2: Selecting Records Using Filter by Selection. Lesson 3: Selecting Records Using Filter by Form. Lesson 4: Using Parameters as Matching Criteria in a Query. Lesson 5: Using Parameters with Comparison Operators in a Query. Lesson 6: Using Parameters with Wildcards as Criteria in a Query.
Project 7: 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: Creating a Switchboard. Lesson 5: Setting Startup Parameters. Lesson 6: Setting Access Defaults.
Task Guide.
Glossary.
Index.
Customer Reviews
Average Review: