Font size:

Interactive Instructor-Based Access 2000 Complete Video Training Course on DVD-ROM. Computer Based Training (CBT) and Video Based Training (VBT) have emerged as the premier training tools in recent years. KeyStone Self-Paced CBT/VBT courses are known for their high quality in-depth content. Compared to traditional training methods, KeyStone courses cost less and users can learn faster while taking advantage of some of the best trainers in the industry. They are easy to use, comfortable to follow, perfect for training at the office, on the road, or at home.

Sections included in level: • Introduction • Working with an Existing Database • Form Basics • Report Basics • Printing Database Objects • Getting Help • Database Maintenance & Shortcuts

Course Outline: 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 anther Access Database Importing Spreadsheet Data Importing ASCII Data Importing from HTML Linking to Anther Access Database Linking to anther types of Database The Linked Table Manager Expert Topics Advanced Query Design Techniques Calculated Fields Summarizing Data Excluding Fields Parameter Queries Make Table The Find Duplicates Wizard The Find Unmatched Wizard Inner & Outer Joins Self & Union Advanced Form Design Techniques Working with Built-in Tab Control Working with Headers Creating Multi-Table Forms & Subforms Adding OLE Objects to Forms Using a Bitmap as a Form Background Adding Calculated Controls to a Form Other Important Form Control Properties Creating a Switchboard Saving a Form as HTML Advanced Report Design Techniques Building Reports with Sub-Reports Setting Section Properties Adding Graphics to a Report Adding / Modifying Calculations Web/Security Access & the Web Creating Data Access Pages Modifying Data Access Page Properties Modifying Record Navigating Control Properties Grouping & Sorting Data within Data Access Pages Charting Table Data Using the Chart Wizard Linking a Chart to a Record Security Basics Establishing a Database Password Modifying a Database Password Encrypting & Decrypting a Database Replication Basics Introduction to Replication Converting a Database to a Design Master Creating Additional Replicas Synchronizing Changes Managing Conflicts Developing Apps with Macros Creating a Macro Running a Macro Adding Macro Names Modifying an Existing Macro Adding Conditions to a Macro Special Topics Optimizing Data Types Usage Establishing One-to-One Relationships Using Add-ins Report & Form Section Properties
Register Now
Microsoft Access 2000 Complete Instructor-based Video Training Online course
  • Course ID:
  • Duration:
  • Price: