 |
| View our
class calendar |
|
Turn data
into information with Microsoft Access
|
|
|
Access
is the world's most widely-used database. Why? It's because
when it comes to managing your data, nothing is easier, more flexible
or more affordable than Access. Learn about this powerful database
management tool at our PC Potential Access classes.
See our complete listing of Access
topics below.
|
|
|
Introduction
to Microsoft Access
GETTING STARTED
Understanding How Access Work
How To Start Access 2000
How To Open A Database
How To Close A Database
How To Exit Microsoft Access
Getting Familiar With The Access 2000 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
Getting Help
How To Use Office Assistant Help
How To Use Contents Help
How To Use Answer Wizard Help
How To Use Index Help
How To Use What's This Help
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
WORKING WITH DATA
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
Controlling And Searching Records
How To Sort Records
How To Find Record
How To Filter Records By Selection
How To Filter Records By Criteria
WORKING WITH TABLES AND RELATIONSHIPS
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
Integrate With Other External Database
How To Import Table
How To Link Tables
Managing Relationships
How To Delete Table Relationship
How To Create Table Relationships
|
Microsoft
Access Intermediate
CREATING AND CUSTOMIZING QUERIES
Creating Select Queries
How To Create Queries Quickly
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
CREATING AND CUSTOMIZING FORMS
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
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
CREATING USEFUL REPORTS
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
MANAGING AND MAINTAINING DATABASE
Compacting and Repairing Database
How To Compact and Repair Database
How Compact Database Automatically
Converting Access Database
How To Convert Database To Access 2000 Version
|
|
Microsoft
Access Advanced
EXPLORING ADVANCED TABLE FEATURES
Understanding And Setting Table Fields Properties
How To Create A New Blank Database
How To Create A New Table From Scratch
How To Set Primary Key
Setting Table Fields Properties
How To Control Field Size
How To Control Text Display Format
How To Control Number or Currency Display Format
How To Control Date/Time Display Format
How To Limit Pattern Of Input Using Input Mask
How To Use Caption
How To Set Default Value
How To Set Validation Rule
How To Create Error Messages
How To Make A Field Compulsory
How To Index Field
How To Create Lookup Fields
How To Edit Lookup List
EXPLORING ADVANCED RELATIONSHIPS
Using Relationships Effectively
How To Create Referential Integrity Relationships
How To Cascade Updates Related Fields
How To Cascade Delete Related Records
Solving Complex Relationships
How To Create One-To-One Relationships
How To Solve Many-To-Many Relationships Problems
Exploring Relationship Join Types
How To Create Multiple Tables Query
How To Use Inner Join
How To Use Left Outer Join
How To Use Right Outer Join
CREATING ADVANCED AND ACTION QUERIES
Creating Advanced Queries
How To Create Multiple Related Tables Query
How To Add Calculated Fields
How To Change Field Title Display
How To Change Field Display Format
How To Combine Text Fields In A Single Column
How To Solve Duplicated Field Names Problem
How To Group And Summaries Records
How To Create Parameter Query
How To Create Crosstab Queries
Exploring Action Queries
How To Create New Table Using Make-Table Queries
How To Add Records Using Append Queries
How To Delete Records Using Delete Queries
How To Edit Records Using Update Queries
EXERCISES
Exercise - Exploring Advanced Table Features
Exercise - Exploring Advanced Relationships
Exercise - Creating Advanced And Action Queries
|
Register
for a PC Potential class today!
Click here to register! |
|
|
|
|
Start
using the power of Access (almost) right away!
Open Access.
Access presents you with the option to Access database wizards,
pages and projects. Select this option and click OK.
You will be presented with more than 10 ready-to-use databases to
manage Contact Management, Event Management, Inventory Control and
more. Just answer a few basic questions and click Next until
you are prompted to Finish.
Even if the
database is not exactly what you need, with the techniques you will
learn in our classes, you can easily customize these databases to
your exact requirements.
|
 |
PC
Potential offers group discounts for company-wide training. Group
rates start for as few as 5 persons from the same company.
Give a call for rates for your company. |
|
