Font size:

Interactive Instructor-Based Access 2003 Essentials 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.

Levels included: • Beginner • Intermediate • Advanced

Trainer Information: Dr. Tom Murray is a business professor and director of technical education and training at Lynchburg College located in Lynchburg, Virginia. Working closely with Microsoft on the development of Microsoft Office tutorials for over 10 years. Dr. Murray has been featured in many industry publications, including the Microsoft Innovatice Teachers' website. Recently recognized as a 2003 Microsoft Model Professional Development Site, the KeyStone Learning Systems-sponsored "OfficeTutorials.com" website is recommended by more than 300 websites and accessed by thousands of learners each day. Dr. Murray's Microsoft Office training is known for its superior quality and ease of use. 1.0 Introduction 1.1 Starting Access 1.2 The Access Window, Menu Bar, Tool Bars and Task Pane 1.3 Help in Access 1.4 Creating a Database – Fields, Properties, and Datasheet View 1.5 Copying Databases 2.0 Working with an Existing Database 2.1 Viewing & Navigating Table Data 2.2 Widening Datasheet Columns and Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting & Deleting Records 2.5 Find & Replace 2.6 Modifying the Appearance of a Datasheet 2.7 Spell-Check & Auto-correct 3.0 Form Basics 3.1 Using a Form Wizard and Moving from Record to Record 3.2 Finding Data 3.3 Sorting Data 3.4 Filtering Data 3.5 AutoForms 4.0 Report Basics 4.1 AutoReports & the Report Wizard 4.2 Zooming In & Out 4.3 Moving from Page to Page 4.4 Viewing Multiple Pages 4.5 Printing Access 2003: Intermediate Level 1.0 Planning & Designing a Database 1.1 Copy Database for Intermediate Lessons 1.2 Creating a Database Using a Wizard 2.0 Building & Modifying Tables 2.1 Evaluating Inputs and Outputs 2.2 Creating Tables Using a Wizard 2.3 Creating Tables without the Use of a Wizard, Field Properties, Input Masks 2.4 The Lookup Wizard 2.5 Format, Default Value, Validation Rules and Validation Text 3.0 Working with Relationships 3.1 Introduction to Relationships 3.2 Setting Primary Keys 3.3 Indexes, Relationships and Normalization 3.4 Printing Relationships Access 2003: Advanced Level 1.0 Designing Simple Queries 1.1 Selecting Fields in Single and Multiple Tables 1.2 Ordering the Query Result & Refining Queries with Criteria 1.3 Updatability of Query Results 2.0 Building and Modifying Forms 2.1 Adding Controls 2.2 Selecting, Moving, Sizing, Deleting and Aligning Controls 2.3 Changing Control Properties 2.4 Changing the Tab Order Controls and Form Properties 2.5 Working with Combo Boxes & List Boxes 3.0 Building & Modifying Reports 3.1 Creating Groups and Total Reports 3.2 Understanding Report Bands 3.3 Working with Controls 3.4 Working with Report Properties 3.5 Modifying Selection Criteria 4.0 Managing Databases 4.1 Identify Object Dependencies 4.2 Import Data to Access 4.3 Export data from Access 4.4 Create and Modify Calculated Fields and Aggregate Functions 4.5 Create a Data Access Page 4.6 Back up a database 4.7 Compact and repair databases
Register Now
Microsoft Access 2003 Essentials - Beginner/Intermediate/Advanced Instructor-based Video Training Online course
  • Course ID:
    194681
  • Duration:
    n/a
  • Price:
    $171