Access Training - Chicago
Access
Training
Provided by Training Connection
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 $100Access 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
|
|
||||||||||||
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...
