|
Provided by: 123-CBT Computer Based Training Access 2000 User Set of 5 |
 |
Training
Provided by 123-CBT Computer Based Training
1.1 Starting Access
1.2 Opening an Existing Database
1.3 The Access Desktop
1.4 The Database Window
1.5 A Preview of the Database Components
2.0 Working with an Existing Database (33 Minutes)
2.1 Viewing and Navigating Table Data
2.2 Editing Table Data
2.3 Adding Records to a Table
2.4 Selecting and Deleting Records
2.5 Find and Replace
2.6 Modifying the Appearance of a Datasheet
2.7 Spell-Check and Auto-correct
3.0 Form Basics (25 Minutes)
3.1 Moving from Record to Record
3.2 Finding
3.3 Sorting
3.4 Filtering
3.5 AutoForms
3.6 Using a Form Wizard
3.7 Conditional Formatting
4.0 Report Basics (15 Minutes)
4.1 Moving form Page to Page
4.2 Zooming In and Out
4.3 Viewing Multiple Pages
4.4 Printing
4.5 AutoReports & the Report Wizard
4.6 Page Setup
5.0 Printing Database Objects (5 Minutes)
5.1 Printing Table Datasheets
5.2 Printing Queries
5.3 Printing Forms
5.4 Printing Reports
6.0 Getting Help (8 Minutes)
6.1 The Office Assistant & Index Searching
6.2 Context-Sensitive Help & Printing Help Topics
7.0 Database Maintenance & Shortcuts (12 Minutes)
7.1 Backing Up and Restoring a Database
7.2 Compacting and Repairing a Database
7.3 Converting a Database to a Previous Version
7.4 Organizing Database Objects into Groups
1.1 Evaluating Inputs and Outputs
1.2 Normalization
1.3 Creating a Database Using a Wizard
1.4 Creating a Database from Scratch
2.0 Building and Modifying Tables (49 Minutes)
2.1 Creating Tables Using a Wizard
2.2 Creating Tables from Scratch & Data Types
2.3 Setting Primary Keys
2.4 Field Properties
2.5 Input Masks
2.6 The Lookup Wizard
2.7 Indexes
3.0 Working with Relationships (27 Minutes)
3.1 Introduction to Relationships
3.2 Benefits of Relationships
3.3 Types of Relationships
3.4 Referential Integrity
3.5 Indexes and Relationships
3.6 Printing Relationships
4.0 Designing Simple Queries (27 Minutes)
4.1 Selecting Fields & Ordering the Query Result
4.2 Refining Queries with Criteria
4.3 Updatability of Query Results
4.4 Queries Based on Multiple Tables
1.1 Adding Controls
1.2 Selecting Controls
1.3 Moving, Sizing and Deleting Controls
1.4 Aligning Controls
1.5 Changing Control Properties
1.6 Changing the Tab Order Controls
1.7 Form Properties
1.8 Working with Combo Boxes and List Boxes
2.0 Building and Modifying Reports (26 Minutes)
2.1 Understanding Report Bands
2.2 Working with Controls
2.3 Creating Groups and Totals Reports
2.4 Working with Report Properties
2.5 Modifying Selection Criteria
3.0 Database Startup Options (5 Minutes)
3.1 Setting the Application, Icon, and Startup Form
3.2 Designing other Startup Information
4.0 Importing, Exporting and Linking (39 Minutes)
4.1 Exporting to another Database
4.2 Exporting to an Excel Spreadsheet
4.3 Exporting to ASCII
4.4 Exporting to HTML
4.5 Importing from anther Access Database
4.6 Importing Spreadsheet Data
Access 2000 Beginning (2 Hours 6 Minutes)
1.0 Introduction (26 Minutes)1.1 Starting Access
1.2 Opening an Existing Database
1.3 The Access Desktop
1.4 The Database Window
1.5 A Preview of the Database Components
2.0 Working with an Existing Database (33 Minutes)
2.1 Viewing and Navigating Table Data
2.2 Editing Table Data
2.3 Adding Records to a Table
2.4 Selecting and Deleting Records
2.5 Find and Replace
2.6 Modifying the Appearance of a Datasheet
2.7 Spell-Check and Auto-correct
3.0 Form Basics (25 Minutes)
3.1 Moving from Record to Record
3.2 Finding
3.3 Sorting
3.4 Filtering
3.5 AutoForms
3.6 Using a Form Wizard
3.7 Conditional Formatting
4.0 Report Basics (15 Minutes)
4.1 Moving form Page to Page
4.2 Zooming In and Out
4.3 Viewing Multiple Pages
4.4 Printing
4.5 AutoReports & the Report Wizard
4.6 Page Setup
5.0 Printing Database Objects (5 Minutes)
5.1 Printing Table Datasheets
5.2 Printing Queries
5.3 Printing Forms
5.4 Printing Reports
6.0 Getting Help (8 Minutes)
6.1 The Office Assistant & Index Searching
6.2 Context-Sensitive Help & Printing Help Topics
7.0 Database Maintenance & Shortcuts (12 Minutes)
7.1 Backing Up and Restoring a Database
7.2 Compacting and Repairing a Database
7.3 Converting a Database to a Previous Version
7.4 Organizing Database Objects into Groups
Access 2000 Intermediate (2 Hours 4 Minutes)
1.0 Planning and Designing a Database (20 Minutes)1.1 Evaluating Inputs and Outputs
1.2 Normalization
1.3 Creating a Database Using a Wizard
1.4 Creating a Database from Scratch
2.0 Building and Modifying Tables (49 Minutes)
2.1 Creating Tables Using a Wizard
2.2 Creating Tables from Scratch & Data Types
2.3 Setting Primary Keys
2.4 Field Properties
2.5 Input Masks
2.6 The Lookup Wizard
2.7 Indexes
3.0 Working with Relationships (27 Minutes)
3.1 Introduction to Relationships
3.2 Benefits of Relationships
3.3 Types of Relationships
3.4 Referential Integrity
3.5 Indexes and Relationships
3.6 Printing Relationships
4.0 Designing Simple Queries (27 Minutes)
4.1 Selecting Fields & Ordering the Query Result
4.2 Refining Queries with Criteria
4.3 Updatability of Query Results
4.4 Queries Based on Multiple Tables
Access 2000 Advanced (2 Hours 3 Minutes)
1.0 Building and Modifying Forms (51 Minutes)1.1 Adding Controls
1.2 Selecting Controls
1.3 Moving, Sizing and Deleting Controls
1.4 Aligning Controls
1.5 Changing Control Properties
1.6 Changing the Tab Order Controls
1.7 Form Properties
1.8 Working with Combo Boxes and List Boxes
2.0 Building and Modifying Reports (26 Minutes)
2.1 Understanding Report Bands
2.2 Working with Controls
2.3 Creating Groups and Totals Reports
2.4 Working with Report Properties
2.5 Modifying Selection Criteria
3.0 Database Startup Options (5 Minutes)
3.1 Setting the Application, Icon, and Startup Form
3.2 Designing other Startup Information
4.0 Importing, Exporting and Linking (39 Minutes)
4.1 Exporting to another Database
4.2 Exporting to an Excel Spreadsheet
4.3 Exporting to ASCII
4.4 Exporting to HTML
4.5 Importing from anther Access Database
4.6 Importing Spreadsheet Data
|
|
||||||||
Access 2000 User Set of 5
--
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
-...
