Access 2002 Intermediate

Lesson 1: The Access Interface
Introduction
Lesson Objectives
Opening Access
Opening The Northwind Database
Customizing The Interface
Creating A New Folder
Other Options
Changing The Default Database Folder
Specifying Keyboard Behavior
Setting Default Field Types & Sizes
Creating A New Database
Opening A Table
Using Find
Search Options
Using Replace
Filtering By Form
Removing A Filter
Creating An Advanced Filter
Applying More Than One Filter
Sorting In Form View
Applying The Last Known Filter
Printing Data In Form Style
Compacting Databases & Projects

Lesson 2: Fields & Field Properties
Introduction
Opening Access
Opening A Sample Database
Opening A Table In Design View
The Table Design Window
Switching Between Views
Design View Controls
Opening A Form
Adding A Record
Inputting Data In A Form
Deleting A Record
Modifying Field Properties
Setting A Default Value
Creating A Validation Rule
Entering Validation Text
Getting Help On Field Properties
Verifying Changes
Modifying Field Layout
The Field Size Property
The Format Property
The Decimal Places Property
The Input Mask Property
The Caption Property
The Default Value Property
The Indexed Property
The Lookup Tab
Creating A New Field
Selecting A Data Type
Indexing A Field
Creating A Memo Field
Creating A Caption

Lesson 3: Relationships & Forms
Introduction
Lesson Objectives
Opening A Sample Database
Viewing Relationships
The Relationships Window
Showing & Hiding Tables
Creating A Multi-Table Relationship
The Edit Relationships Dialog Box
Editing Relationships
Cascade Update Related Fields
Cascade Delete Related Records
Join Types
Combining Tables In Forms
Hierarchical & Synchronized Forms
Showing Related Records
Naming Forms
Conditional Formatting
Adding Multiple Conditions
Adding Records In Form View
Adding Records With Subforms
Modifying Form Design
Adding Controls To A Form
Creating A Label
Expressions In Calculated Controls
Modifying Controls
Special Effects
Grouping Controls
Text Formatting
Formatting A Group
Applying A Border Color
Inserting An Image In A Form
Setting Image Properties
Printing A Form

Lesson 4: Charts, Queries & Data Access Pages
Introduction
Lesson Objectives
The Chart Wizard
Selecting A Source
Specifying Fields
Selecting A Chart Type
Laying Out Chart Data
Finishing A Chart
Modifying A Chart
Creating A Select Query
Adding Fields To A Select Query
Running A Query
Sorting With A Query
Showing & Hiding Fields
Using Criteria In A Query
Querying Multiple Tables
Using Comparison Operators
Setting Multiple Criteria
Saving & Naming A Query
Printing A Query
Building Summary Queries
Data Access Pages
The Page Wizard
Adding Grouping Levels
Sorting Records
Viewing The Finished Page
Modifying A Data Access Page
Demoting A Group
Adding A Fill/Back Color
Adding A Title
Viewing Changes
Saving The Page

Lesson 5: Reports & Labels
Introduction
Lesson Objectives
Opening A Database
About Reports
The Report Wizard
Selecting Fields For A Report
Specifying How Data Is Displayed
Getting Help
Grouping Levels
Specifying Sort Order
Selecting A Layout
Selecting A Style
Viewing Your Report
Modifying A Report Header
Modifying A Report Title
Resizing A Text Box Control
Repositioning An Object
Displaying Report Properties
Modifying Page Footers
Creating Group Footers
Adding A Text Box
Creating A Calculated Field In A Report
More Calculations
Formatting Report Text
Modifying Line/Border Width
Special Effects
Inserting An Image
Printing A Report
Using The Label Wizard
Printing Labels
Conclusion

CD

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...