Access 2002 Basic

Lesson 1: The Access Interface & Database Objects
Introduction
Lesson Objectives
About Databases
Access Database Files
Opening Access
The Title Bar
The Menu Bar
The Ask A Question List Box
The Database Toolbar
The Task Pane
Navigating Between Task Panes
The Clipboard Task Pane
The Basic & Advanced Search Task Panes
Closing The Task Pane
The Status Bar
Database Objects
Opening A Sample Database
About The Northwind Database
The Main Switchboard
The Database Window
The Database Window Toolbar
The Objects Bar
Expanding & Minimizing The Objects Bar
Selecting An Object
Opening An Object
Tables
Fields & Records
Field & Record Selectors
Selecting A Record
Navigating Records
Creating A New Record
Sorting Records
Design View
Primary Keys
Data Types
Switching Views
Closing A Table
Viewing Relationships
Relational Databases
Relationship Lines
Queries
Forms
Navigating In Forms
Viewing Reports
Zooming In
Zooming Out
Displaying Multiple Pages
Form Design View
Data Access Pages
Macros
Modules
Closing The Database Window
Exiting Access

Lesson 2: Working With Tables
Introduction
Lesson Objectives
Opening Access
Creating A New Database
Using The Table Wizard
Selecting Fields
Removing A Field
Renaming A Field
Design View
Entering Data
Creating A New Record
Resizing A Field
Deleting A Field
Deleting A Record
Closing A Table
Deleting A Table
Manually Creating A Table
Entering Field Names
Assigning A Primary Key
Viewing Help
Applying An Input Mask
Required Fields
The Allow Zero Length Property
Inserting A Row
Setting A Validation Rule
Validation Text
The Date/Time Data Type
The Yes/No Data Type
Setting A Default Value
Switching To Datasheet View
Filtering By Selection
Removing A Filter
Sorting Records
Viewing Your Work
Saving Your Work

Lesson 3: Creating Forms & Importing Objects
Introduction
Lesson Objectives
Opening An Existing Database
Open Options
Customizing The Interface
Customizing The Interface
Displaying Shortcut Keys
The Options Dialog Box
The Recently Used File List
Removing Personal Information
Setting Click Options
The AutoForm Feature
Naming A Form
The Form Wizard
Form Layouts
Form Styles
Entering A Form Title
Deleting A Form
Closing A Database
About Importing
Viewing Relationships
Importing Existing Tables
Selecting Objects To Import
Import Options
Creating A Relationships
Adding A Subdatasheet
Child & Master Fields
Viewing Subdatasheets
Verifying Relationships

Lesson 4: Filters & Queries
Introduction
Lesson Objectives
The Recently Used Files List
The Selection Filter
Removing Filters
Filtering By Exclusion
The Filter For Feature
Filtering Tips
Using Queries
The Simple Query Wizard
Selecting Fields For A Query
Completing The Query
Viewing Multiple Objects
Tiling Windows
Query Design View
Hiding Fields In A Query
Specifying A Criteria
Calculated Fields
Removing Criteria
Running The Query
Modifying The Criteria
Adding A Field To A Query
Using A Numeric Expression
Specifying Sort Order
Adding Additional Criteria

Lesson 5: Reports, Printing & Help
Introduction
Lesson Objectives
Opening A Sample Database
About Reports
AutoReports
Viewing A Report
Modifying A Report
Removing A Field
Previewing A Repot
Displaying The Fields List
Adding A Label To A Report
Repositioning A Label
Adding A Text Box To A Report
Binding A Field To A Text Box
Verifying Changes
Grouping Records In A Report
Adding A Group Header
Repositioning A Header
Formatting A Group Header
Adding Multiple Groups
Printing A Report
Deleting A Report
The Report Wizard
Selecting Source Data
Adding Grouping Levels
Specifying Sort Order
Specifying Orientation
Grouping Database Objects
Deleting A Group
The Ask A Question List Box
Microsoft Access Help
The Contents Tab
The Index Tab
The What's This? Feature
The Office Assistant

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 -...