Provided by: Training Connection

Access Training - Chicago

Access

Microsoft Access Training Chicago



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
This is primarily ilt training
computer labComputer Lab Work
Course Level:introductory
Duration:1 days
Training Presented in:English
Training Provided by Training Connection
  • F asked: I'm interested in setting up a Microst Access training course for attendees. Do you fer a two day course and if so do you give out special group rate pricing for government organizations? Please contact me via email or direct at --. Regards,
  • D asked: Hello, A member of my organization would like to schedule a session for people to learn Microsoft Access. Could you let me know if you would be able to travel to our location to teach this course and provide me with a cost and time estimate? We are located downtown Chicago off Michigan and Erie Avenues. DAINA GJEMRE Training Associate DRAFTFCB E. Erie St. Chicago, IL T+ F+ (login required)
Access Training - Chicago
--
About The Training Provider: Training Connection
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...
tcw11-v473M-08/23/11-04:04:21-()[A]-[B]-[B] -02:21:05