Career Vision Training
call us on 0121 248 2400
 
To receive updates and new releases, subscribe today


Lowest Prices
Guaranteed
Save 10% - 30%
Off Publishers Retail Prices
courses / products

IT CERTIFICATION
MCPD: ASP.NET 3.5 C#
MCPD: Ent. App. Dev. 3.5 C#
MCPD: Windows 3.5 C#
A+ 2009 with Network+ 2009
MCSE 2003
MCSE with A+/N+ 2009
MCSE with CCNA
MCITP 2008 Server Admin
MCITP 2008 Enterprise Admin
Cisco CCNA (640-802)
MCTS: Windows 7 Configuration
MCITP Business Intelligence Dev SQL 2008

View Complete List...

DESKTOP & OFFICE
Office 2010: New Features
Office 2007 Training Bundle
Office 2003 Training Bundle
Access 2007
Excel 2007

View Complete List...

SECURITY & NETWORKING
EC-Council Network Security Administrator (ENSA)
EC Council - Security5
EC Council - CEH v6
EC Council - CHFI v4
EC Council - ESCA/LPT
CISSP Training Suite

View Complete List...

PROJECT MANAGEMENT
PMP 2008 Exam Prep
Project 2007
Project Management Intro
Managing Project Teams
ITIL v3 Foundation

View Complete List...

CAD & 3D
AutoCAD 2011
AutoCAD Architecture 2011
Inventor 2011
AutoCAD LT 2010
Civil 3D 2010
Revit Structure 2010
AutoCAD Map 3D 2010
AutoCAD Mechanical 2010

View Complete List...

GRAPHICS & LAYOUT
Creative Suite 5 Design Essentials Bundle
Photoshop CS5 Extended: Essentials
InDesign CS5: Essentials
Illustrator CS5: Essentials
Photoshop Elements 8

View Complete List...

WEB DESIGN & INTERNET
Dreamweaver CS5: Essentials
Creative Suite 5 Web Essentials Bundle
Flash CS5 Professional: Essentials
Creative Suite 5 Design Essentials Bundle
Expression Studio 2 Bundle

View Complete List...

CAREER PROGRAMS
Executive Office Admin Track
Helpdesk Support Track
Information Security Track
Network Engineer 2008 Track
Web & Graphic Designer Track

MULTIMEDIA & ANIMATION
Adobe CS4 Production Bundle
After Effects CS4 Essentials
Premiere Pro CS4 Essentials
MOTU Digital Performer 6
Encore DVD Pro 2.0

View Complete List...

SOFT SKILLS TRAINING
Better Business Writing
Excellence in Supervision
How to Get Things Done
Team Leadership
Assertiveness

View Complete List...

PROGRAMMING
ASP.Net 3.5
C Programming 2007
C# for Developers
VB.Net 3.5
Visual Studio 2008: Essentials

View Complete List...

DATABASES
Oracle 11g OCA
Visual Basic for Excel
SQL Server 2008 Database Development (70-433)
Data Modeling
MCTS: SQL Server 2005 (Exam 70-431)

View Complete List...

OPERATING SYSTEMS
Windows XP End User
Windows Vista for End Users
Windows 7 by VTC
Mac OSX 10.4 Tiger

View Complete List...

COURSES BY EXAM NUMBER
A+ Essentials 2009 Training

View Complete List...

BOOKS
A+ 2009 Review Guide

View Complete List...

Windows 7: New Features

100% Satisfaction Guaranteed

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....



FAST UK DELIVERY
Order Today, Learn Tomorrow!


SECURE PAYMENT
PROCESSING

We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted
PayPal Accepted



Follow us on Facebook
* A-Z COURSE LIST * WHAT'S NEW * FREE DEMOS * SPECIAL OFFERS * ONLINE TRAINING *

Access 2000

 
Bookmark and Share
MS Access 2000 Set of 3 Training CDs
Access 2000
 

More on Single User & Multi User Licences

COURSE INTRODUCTION

Relational databases are a critical component of the infrastructure that allows modern society to easily store, index and share information. LearnKey's comprehensive training course teaches you step-by-step the powerful facets of database management and usage with Access 2000. The straightforward approach of Reed Jacobson will help you become comfortable using tables, queries, forms, and reports. With this increased understanding, you'll be confident in the Access environment.

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
    ? Uses for a Database
    ? Access & Other Office Applications
    ? Understanding & Comparing Tables
    ? Creating a New Database

    Section B: Creating an Attribute Table
    ? Datasheet View
    ? Design View
    ? Entering Values
    ? Datasheet Features
    ? Print Preview
    ? Access vs. Excel
    ? Saving Design Changes

    Section C: Creating a Lookup Table
    ? Creating a New Table
    ? Creating a Primary Key
    ? Creating a Relationship Between Tables
    ? Cascade Update & Deletes
    ? Entering Data in a Sub-form
    ? Creating a Lookup to a Text Key

    Section D: Creating Queries
    ? Sorting & Filtering
    ? Save as a Query
    ? Editing a Query in Design View
    ? Using the Query Wizard to Join Tables
    ? Changing Values in a Query

    Section E: Creating Forms
    ? Create an AutoForm
    ? Columnar, Datasheet & Tabular Forms
    ? Printing Form

    Section F: Creating a Measures Table
    ? Designing a Measures Table
    ? Using Automatic & Primary Keys
    ? Specifying Column Data Types
    ? Creating a Lookup
    ? Preventing Duplicate Keys
    ? Relating Tables

    Section G: Creating Summary Queries
    ? Creating Summary Queries
    ? Crosstab Queries

    Section H: Creating Reports
    ? Create a Tabular Report
    ? Using the Report Wizard
    ? Editing the Report

    Section I: Discovering More
    ? Customize Access
    ? Using the Office Assistant & Help Window

    Session 2

    Section A: Designing a Database
    ? Introduction
    ? Field Names
    ? Keys

    Section B: Importing & Exporting Tables
    ? Importing from Access
    ? Exporting
    ? Copying To & From Excel

    Section C: Customizing Field Definitions
    ? Field Features
    ? Order Detail Table

    Section D: Extending Queries
    ? Making a New Query
    ? Filters & Criteria
    ? Add a Field

    Section E: Creating Action Queries
    ? Create New Query
    ? Modify Query
    ? Update Action Query
    ? Delete Query

    Section F: Managing a Database
    ? Suggestions
    ? Database Security
    ? Synchronization
    ? Linking Databases

    Section G: Improving Database Design
    ? Table Indexes
    ? Relationships
    ? Splitting Tables

    Session 3

    Section A: Creating Report Details
    ? Creating Forms & Reports
    ? Queries in Design View
    ? Creating Reports in Design View
    ? Linking Reports to Queries
    ? Altering Labels
    ? Adding Files
    ? Converting Text Boxes to Labels
    ? Refining Label Location

    Section B: Creating Report Groupings
    ? Sorting & Grouping
    ? Creating Extended Price
    ? Adding Text Boxes
    ? Forcing New Pages
    ? Formatting Reports

    Section C: Enhancing the Layout of a Report
    ? Creating a Page Header
    ? Adding Logos & Images
    ? Header & Cover Page Options

    Section D: Creating Form Details
    ? Form & Report Differences
    ? Copying Controls & Labels
    ? Headers & Footers
    ? Linking Data
    ? Changing Unit Price
    ? Altering Form List
    ? Locking & Enabling Form Changes
    ? Changing Product Name
    ? Adding a Calculated Field

    Section E: Creating Form Grouping
    ? Renaming & Creating Forms
    ? Adding & Arranging Controls
    ? Adding Subforms

    Section F: Enhancing the Layout of a Form
    ? Controlling the Form & Subform Display

    Section G: Displaying Data in a Chart
    ? Creating a Chart

    Section H: Automating Access
    ? Adding Form Controls
    ? Adding a Graphic Image
    ? Using the Macro Builder
    ? Creating a Switchboard
    ? Splitting the Database

    Section I: Integrating with the Internet
    ? Creating a Hyperlink
    ? Exporting Queries to HTML Documents
    ? Creating a Data-access Page

    Section J: Tips for the Certification Test
    ? Key Exam Points
     
     
    Print Image Printer friendly version   
    Top of page
    A-Z COURSE LIST   PROVIDERS   CBT TRAINING  CVISION NEWS  CONTACT US   SITEMAP  

    MCITP Training Courses   MCPD Training Courses   MCTS Training Courses
    MCITP Database Developer Training Courses   MCITP Database Administrator Training Courses
    Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

    CareerVision
    61 Caroline Street, 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