|
Provided by: 123-CBT Computer Based Training Access 2002 Basic |
 |
Training
Provided by 123-CBT Computer Based Training
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 L
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 L
|
|
||||||||
Access 2002 Basic
--
About The Training Provider: 123-CBT Computer Based Training
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
-...
