MS ACCESS 2003 – FOUNDATION

MS ACCESS 2003 – FOUNDATION

BY: GLOBALKNOWLEDGE PHILIPPINES, INC.

Duration: 1 Day

Venue: In-house or Off-site

Schedule: Open for Enrollment(Aug 10-24/ Sept 10-24/ Oct 8-22/ Nov 17/ Dec 4-18)

Course Outline

Access Basics
Database Terminology
What Is A Table?
What Is A Record?
What Is A Form?
What Is A Report?
What Is A Query?
Meeting Access
Starting Access
The Microsoft Access Environment
Working With Toolbars
Working With The Task Pane
Creating A Database
Plan Your Database
Creating A New Database Using The Wizard
The Database Window
The Relationships Window
Understanding Join Lines
Creating Tables
About Referential Integrity
Viewing Tables And Entering Data
Viewing Table Properties
Creating Forms
Previewing A Form’s Design
Previewing Reports
Viewing A Report’s Design

Tables
Table Basics
Table Structure
Primary Key Field
Changing Field Properties
Creating A Table
Creating A Table Using The Wizard
Creating A Table Using Newobject:Table
Creating A Table In Design View
About Table And Field Names
Working With A Table
Editing A Table
Changing Table And Field Names
Deleting Fields
Finishing A Table
Saving A Table
Editing A Table In Design View
Changing A Table Structure
Entering Table Data
Importing Data From Excel

Forms
Creating A Form
Creating A Form Using Newobject
Creating A Form Using The Wizard
Creating A Form In Design View
Modifying A Form
Designate The Record Source
Place The Fields
Move And Place Controls
Delete Controls
Using Controls
Use The Toolbox
Format Controls
Changing Formatting Using The Format Painter
Using The Navigation Bar To Move Through Your Form
Viewing Your Work

Reports And Queries
Creating A Report
Create A Report Using Newobject:Report
Create A Report Using The Wizard
Create A Report In Design View
Grouping And Sorting
Using Report Controls
Bound Controls
Unbound Controls
Option Buttons
Toolbox
Control Properties
Finishing A Report
Report Sections
Add A Report Header Or Footer
Sort And Group
Previewing Your Report
Queries
Working With Queries
Manipulate Tables In The Query Window
Arrange The Query Design Window
About The Design Grid
Multi-Table Queries
About Calculated Fields

Enroll Now!

GLOBALKNOWLEDGE PHILIPPINES, INC.
Unit107 Beacon Plaza,cor.Ideal St.Shaw blvd,.Mandaluyong City
Tel: 712-4380
Fax: 724-1891