|
What
Microsoft Access 2000 Intermediate Covers...
|
| |
|
| Lesson
1: Working With Tables |
- Installing The Northwind Database
- Opening Microsoft Access 2000
- The Single-Click Option
- The Find Feature
- The Find In Field Dialog Box
- Search Options
|
- Using Replace
- Filtering By Form
- Creating Advanced Filters
- Sorting In Form View
- Printing Your Data In Form Style
- The Compact On Close Option
|
| Lesson
2: Manipulating Table Structure |
|
- Opening A Table In Design View
- The Table Design Window
- Switching Between Design And Datasheet
Views
- Design View Controls
- Modifying Field Properties
- Modifying Field Layout
- The General Sheet
|
- The Lookup Tab
- Text
- List And Combo Boxes
- Creating A New Field
- Naming Your New Field
- Selecting A Data Type Field Indexing
- Setting A Validation Rule
|
| Lesson
3: Multi-Table Relationships |
- Viewing Multiple Tables
- The Window Menu
- Tiling Vertically
- Tiling Horizontally
- Resizing A Field
- The Database Button
- The Relationships Window
- The Show Table Button
|
- Creating Multi-Table Relationships
- The Edit Relationships Dialog Box
- Editing Relationships
- Criteria For Data And Referential
Integrity
- Cascade Update Related Fields
- Cascade Delete Related Records
- Join Types
|
| Lesson
4: Forms And Charts |
|
- The Form Wizard
- Combining Tables In Forms
- Using Subforms
- Hierarchical And Synchronized Forms
- Showing Related Records
- Conditional Formatting
- Adding Records In Form View
- Adding Records With Subforms
- Modifying A Form's Design
|
- Form Design View
- Creating Controls On A Form
- Expressions In Calculated Controls
- Modifying Controls
- Grouping Controls
- Text Formatting
- Inserting An Image
- Printing The Form
- Using The Chart Wizard
|
| Lesson
5: Working With Queries And Data Access Pages
|
- Creating A Select Query
- Adding Fields To A Select Query
- Running A Query From The Design Window
- Sorting With A Query
- Showing And Hiding Fields
- Using Criteria In A Query
- Querying Multiple Tables
- Specifying Another Table In A Query
|
- Using Comparison Operators
- Multiple Criteria Conditions
- Closing
- Saving
- Naming and Printing The Query
- Building Summary Queries
- The Data Access Page
- The Page Wizard
|
| Lesson
6: Creating Reports |
|
- Using The Report Wizard
- Viewing Your Report
- Modifying A Report Title
- Adding Custom Pages
- Customize Headers And Footers
- Making Calculations On A Report
|
- Formatting Report Text
- Lines
- Borders And Special Effects
- Inserting An Image
- Printing Your Report
- Using The Label Wizard
|