|
|
|
|
|
|
|
|
[to previous page]
[other products in "No Longer Available"]
|
| |
|
| Product: |
Access 2000 CBT Course
This course will help you create, manage and work in Access 2000. Learn tables, relationships, query, forms, reports, looping constructs and much more.
|
Price:
excl. VAT |
|
|
|
Beginner Introduction - Starting Access
- Opening an Existing Database
- The Access Desktop
- The Database Window
- A Preview of the Database Components
Working with an Existing Database - Viewing & Navigating Table Data
- Editing Table Data
- Adding Records to a Table
- Selecting & Deleting Records
- Find & Replace
- Modifying the Appearance of a Datasheet
- Spell-Check & Auto-correct
Form Basics - Moving from Record to Record
- Finding
- Sorting
- Filtering
- AutoForms
- Using a Form Wizard
- Conditional Formatting
Report Basics - Moving form Page to Page
- Zooming In & Out
- Viewing Multiple Pages
- Printing
- AutoReports & the Report Wizard
- Page Setup
Printing Database Objects - Printing Table Datasheets
- Printing Queries
- Printing Forms
- Printing Reports
Getting Help - The Office Assistant & Index Searching
- Context-Sensitive Help & Printing Help Topics
Database Maintenance & Shortcuts - Backing Up & Restoring a Database
- Compacting & Repairing a Database
- Converting a Database to a Previous Version
- Organizing Database Objects into Groups
Intermediate Planning & Designing a Database - Evaluating Inputs & Outputs
- Normalization
- Creating a Database Using a Wizard
- Creating a Database from Scratch
Building & Modifying Tables - Creating Tables Using a Wizard
- Creating Tables from Scratch & Data Types
- Setting Primary Keys
- Field Properties
- Input Masks
- The Lookup Wizard
- Indexes
Working with Relationships - Introduction to Relationships
- Benefits of Relationships
- Types of Relationships
- Referential Integrity
- Indexes & Relationships
- Printing Relationships
Designing Simple Queries - Selecting Fields & Ordering the Query Result
- Refining Queries with Criteria
- Updatability of Query Results
- Queries Based on Multiple Tables
Advanced Building & Modifying Forms - Adding Controls
- Selecting Controls
- Moving
- Aligning Controls
- Changing Control Properties
- Changing the Tab Order Controls
- Form Properties
- Working with Combo Boxes & List Boxes
Building & Modifying Reports - Understanding Report Bands
- Working with Controls
- Creating Groups & Totals Reports
- Working with Report Properties
- Modifying Selection Criteria
Database Startup Options - Setting the Application
- Designing other Startup Information
Importing - Exporting to another Database
- Exporting to an Excel Spreadsheet
- Exporting to ASCII
- Exporting to HTML
- Importing from another Access Database
- Importing Spreadsheet Data
- Importing ASCII Data
- Importing from HTML
- Linking to Another Access Database
- Linking to another types of Database
- The Linked Table Manager
|
|
|
 |
|
|
|
|
| Quick Links |
|
|
|
| RCS Newsletter |
|
|
|
| Our Customers |
excellent:
"The CBT product is easy to use and an excellent combination of reading material, video on CD and interactive labs. "
thank you :
"Thank you! i have received the complete order today.
thank you for your swift service and i hope to be in touch soon with regards further training.
Once again thank you very much"
glad:
"I am glad to report that the CBT packages arrived successfully.
I really appreciate all the help and assistance you gave me since my initial enquiry with yourselves"
More testimonials
IT Training
Settings/Tips/Tricks
Computer Articles
Biodiesel Energy
PPE Safety Equipment
Learn English Language |
|
|
| Copyright 2002-2011 RCS Limited. All rights reserved. More
... |
