Computer Training Courses and Tutorials: MCSE Training, A+ Training, MS Office Training from www.cvision.co.uk Computer Training Courses and Tutorials: MCSE Training, A+ Training, MS Office Training from www.cvision.co.uk
* call us on 0121 248 2400
To receive updates and new
releases, subscribe today
*
* HOME * CONTACT US
* ABOUT US * HOW TO ORDER * PURCHASE ORDERS * RESELLERS * ARTICLE * VIEW BASKET
*
Featured Courses

IT CERTIFICATION & TECHNICAL
IT Helpdesk Career Track
IT Security Career Track
Network Engineer Career Track
MCSE 2003
MCSE 2008 Upgrade
MCSE 2003 Corp Training Suite
Microsoft .NET 2005 Power Suite
MCPD.NET 2.0 Web C# Bundle
MCPD.NET 2.0 Web VB Bundle
MCPD.NET 2.0 Windows C#
MCPD.NET Windows VB
MCITP: Database Administrator
MCITP: Database Developer
A+ Certification Bundle
Cisco CCNA
Cisco CCNP
CISSP 2007
Certified Ethical Hacker (CEH)

View Complete List...
*

DESKTOP & OFFICE
Office 2007 Training Bundle
Office 2003 Training Bundle
PRINCE2 Foundation
PRINCE2 Practioner Complete
IT Infrastructure Library ITIL

View Complete List...
*

GRAPHICS & LAYOUT
Creative Suite 3: Design Bundle
PhotoShop CS3 Essentials
Illustrator CS3 Essentials
InDesign CS3 Essentials
Photoshop Elements 5

View Complete List...
*

MULTIMEDIA & ANIMATION
After Effects CS3 Essentials
CS3: Production Bundle
Encore DVD Pro 2.0
Final Cut Studio
Premiere Pro CS3 Essentials

View Complete List...
*

CAD & 3D
AutoCAD 2008
AutoCAD Architecture 2008
AutoCAD LT 2008
3ds max 9 and VIZ
Civil 3D 2007

View Complete List...
*

SOFT SKILLS TRAINING
Assertiveness
Communication Series
Customer Service Series
Effective Presentation Skills
Telephone Courtesy and Customer Service

View Complete List...
*

WEB DESIGN & INTERNET
Creative Suite 3: Web Bundle
Dreamweaver CS3 Bundle
Flash CS3 Bundle
Expression Studio Bundle
E-Commerce Introduction

View Complete List...
*
* A-Z COURSE LIST * WHAT'S NEW * FREE DEMOS * SPECIAL OFFERS * ONLINE TRAINING *

Access 2002/XP
By LearnKey
MS Access 2002/XP Set of 3 Training CDs
Access 2002/XP
Single User CD Course £80.00 + VAT
Buy Now
Multi User CD Course £280.00 + VAT
Buy Now
 

More on Single User & Multi User Licences

View all Training Courses by LearnKey


COURSE INTRODUCTION

Access 2002 can strengthen your data organization capabilities for powerful results no matter what business you're in. Expert instructor, Casey McNeal, demonstrates the powerful features of Access 2002 from LearnKey. McNeal successfully integrates solid instruction with an easy-to-follow presentation that arms you with practical knowledge. At the conclusion of this training course, you'll understand how to use the basic and advanced capabilities of Access 2002 to build databases, query data, design forms and generate reports.

Benefits

  • Gain valuable skills and improve personal productivity.
  • Acquire knowledge that will add credibility for future career prospects.
  • Increase marketability by using the latest information technology.

    		•

    COURSE OUTLINE

    Session 1

    Section A: Introduction
    · Database Concepts
    · Relational Databases
    · Task Pane
    · Tables
    · Forms
    · Queries
    · Reports

    Section B: Database Wizard
    · Database Development
    · Build a Database

    Section C: Table Essentials
    · Table Wizard
    · Relationships
    · Field Names
    · Text & Number Data Types
    · Other Data Types
    · Primary Key

    Section D: Datasheet View
    · Add New Record
    · Delete Record
    · Office Clipboard

    Section E: Table Appearance
    · Column Width
    · Font & Cell Effects
    · Moving & Hiding Columns

    Section F: Filter Techniques
    · Sorting Records
    · Find a Record
    · Filter By Selection

    Section G: Query Essentials
    · Relationships
    · Query Wizard
    · Dynaset Concepts
    · Add Criteria
    · Comparison Operator
    · Wildcards

    Section H: Form Essentials
    · Form Wizard
    · AutoForm

    Section I: Report Essentials
    · Report Wizard
    · Calculated Control
    · Print Preview
    · Label Wizard

    Session 2

    Section A: Field Properties
    · Field Size
    · Data & Time
    · Context Sensitive Help
    · Yes & No Fields
    · Default Value
    · Validation Rule
    · Indexed Field

    Section B: Create a Lookup
    · Insert a field
    · Lookup Wizard
    · Limit to List

    Section C: Importing & Exporting Data
    · Export to Excel
    · Import from Access
    · Import from Excel
    · Link Data from Excel
    · Share a Database
    · Database Splitter

    Section D: Relationships
    · Relate Tables
    · Referential Integrity
    · Cascade Options
    · Print Relationships

    Section E: Advanced Query Techniques
    · Parameter Queries
    · Multiple Parameters
    · Calculated Fields
    · Expression Builder
    · Summary Queries

    Section F: Using Access & HTML
    · Properties of HTML
    · Creating a Hyperlink
    · Using Hyperlinks
    · Publish Database to HTML Format
    · Creating Data Access Pages
    · Accessing Access Pages in Browser

    Session 3

    Section A: Merging Access into Word
    · Mail Merge Wizard
    · Create Letter
    · Run Merge

    Section B: Action Queries
    · Make Table Query
    · Append Query
    · Delete Query
    · Run Delete Query
    · Update Query
    · Print Queries

    Section C: Compact & Backup
    · Compact & Repair Utility
    · Backup & Restore Tool

    Section D: Form Design
    · Print Records
    · Form Controls
    · Calculated Controls
    · Object Properties
    · Event Procedures
    · Working with Controls

    Section E: Advanced Form Design
    · Adding Fields
    · Saving & View Form
    · Adjust Tab Order
    · Add Combo Box
    · Add Command Button
    · Add Graphic
    · Add Header & Footer
    · Add ActiveX Control
    · Input Mask Wizard

    Section F: Report Design
    · Headers & Footers
    · Move & Resize Controls
    · Add Controls
    · Add Calculated Control
    · Add Group & Sorting Control
    · Pagebreak Control
    · Report Footer

    Section G: Macros
    · Creating, Saving & Running Macros
    · Perform Queries from Macros
    · Assigning a Macro to Event Procedures

    Section H: Switchboard
    · Creating Switchboard
    · Editing Switchboard
    · Switchboard in Action
    · Set a Startup Option
     
    Printer friendly version   
    Top of page
    *
    *
    A-Z COURSE LIST  PROVIDERS CONTACT US  SITEMAP 
    *

    Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

    CareerVision
    61 CarolineStreet, Birmingham, B3 1UF, UK
    Tel: 0121 248 2400, Fax: 0121248 2800,
    Email: sales@cvision.co.uk |Web: www.cvision.co.uk
    red arrow Website design by Aimpro UK red arrow Terms