Provided by: Training Connection

Access Training - Chicago

Click here for more information or to take this course

home : Computer : Microsoft Office : Access

Get More Information

Search for Training

Find Your Genius!

Training Provided by Training Connection

Microsoft Access Training Chicago

ABCDEFGHI7.jpg" alt="Microsoft Access Training Class Course" align="left" />

http://www.trainingconnection.com

1. Access 2003/2007 Level 1 - $295 (1 day instructor-led)

2. Access 2003/2007 Level 2 - $295 (1 day instructor-led)

3. Access 2003/2007 Level 3 - $295 (1 day instructor-led)

4. Access 2003 VBA - $395 (1 day instructor-led)

Access Package

Book any two levels of Access training and save $100

Access 2003 Level 1

This course is ideal for people new to Access that need to manage, sort and view large amounts of data. No prior knowledge of Microsoft Access is required, however a general understanding of computers and Windows is beneficial.

What you will learn

Some elementary database theory
Build a relational database
Relationships between tables in database
Manage data in an Access database
Search data with filters and sorts
Write a simple database query
Create and customize forms
How to write reports using AutoReport

Outline

Unit 1: Understanding How Access Works

How To Start Access
How To Open A Database Using Task Pane
How To Close A Database
How To Exit Access

Unit 2: Getting Familiar with the Access Screen

How To Use Menu
How To Show Or Hide Toolbars
How To Move Toolbar And Menu Bar
How To Use Toolbar Button
How To Use Shortcut Menu Using Right Mouse Click
How To Use Shortcut Key

Unit 3: Working With Database Objects

How To Open A Table
How To Open A Query
How To Open A Form
How To Open A Report
How To Rename An Object

Unit 4: Managing Data

How To Navigate Through Records
How To Move To A Specific Record
How To Add Records
How To Edit Records
How To Delete A Record
How To Delete A Few Records

Unit 5: Controlling and Searching Records

How To Sort Records
How To Find Record
How To Filter Records By Selection
How To Filter Records By Criteria

Unit 6: Creating and Customizing Tables

How To Create A New Blank Database
How To Create A New Table
How To Set Primary Key
How To Rearrange Fields
How To Add Field
How To Delete Field
How To Change Data Type

Unit 7: Get External Information

How To Import Table
How To Link Tables

Unit 8: Managing Relationships

How To Delete Table Relationship
How To Create Table Relationships

Unit 9: Creating Select Queries

How To Create Queries Quickly

Unit 10: Controlling Queries Output

How To Open / Switch Query To Design View
How To Rearrange Fields
How To Delete A Field
How To Add A Field
How To Sort The Query Output
How To Filter The Query Output With Criteria
How To Set Multiple Criteria
How To Hide A Field

Unit 11: Creating Forms Effectively

How To Create A Form Quickly With AutoForm
How To Save And Rename Form
How To Create A Form Using Form Wizard

Unit 12: Customizing Forms

How To Open Form Design View
How to Show / Hide Field List
How to Show / Hide Toolbox
How To Resize Control
How To Move Both Control And Label
How To Move Control And Label Separately
How To Delete A Field Control
How To Add A Field Control

Unit 13: Creating Reports

How To Create A Report Using AutoReport
How To Create Mailing Labels
How To Set Page Margin
How To Change Page Orientation
How To Number Pages

Access Training Chicago - http://www.trainingconnection.com/access-training.php

Training Avaliability and Delivery

This is primarily ilt training
	Computer Lab Work
	Contact Training Connection for more information

Course Level:	introductory
Schedule:	1 days
Training Presented in:	English

Training Program Details

About Training Connection - Training Provider

Training Connection - Training Connection Training Connection provides training in the world's most popular desktop applications and in business skills. All our hands on training sessions are delivered by a qualified industry leading professionals. We keep our class sizes small so that each student is well looked after. www.trainingconnection.com Computer Courses include Photoshop Training, Dreamweaver...

More Training from Training Connection

Click here for more information or to take this course

Custom Search

Training Directory \| New Training Seminars \| New Training Providers \| Search \| Site Map \| Promote Training \| Login \| Links

	Training-Classes.com by Skillbox® 07/20/08 Copyright 1998-2008 skillbox, inc. All rights reserved

Are you an Access course training provider?

You could be on this page today - for FREE!