MS ACCESS 2003 – ADVANCED

MS ACCESS 2003 – ADVANCED

BY: GLOBALKNOWLEDGE PHILIPPINES, INC.

Duration: 1 Day

Venue: In-house or Off-site

Schedule: Open for Enrollment (Aug 12/26/ Sept  12/26/ Oct  13/27/ NOv  19/ Dec 1/15)

Course Outline

Customizing Access
Customizing Menus And Toolbars
Customizing Menus
Creating Menus
Showing And Hiding Toolbars
Customizing Toolbars
Creating Toolbars
Setting Access Options, Part 1
Setting General And View Options
Setting Editing And Keyboard Options
Setting Datasheet, Form, And Report Options
Setting Page And Tables/Queries Options
Setting Error Checking Options
Setting Advanced Options
Setting Access Options, Part 2
Setting International Options
Setting Spelling Options
Setting Autocorrect Options
Setting Start-Up Options
Setting Macro Security Options
Creating Macros
Using The Macro Design Toolbar
Creating A Macro
Running A Macro
About Macro Groups
Advanced Macro Uses
Editing A Macro With The Visual Basic Editor
Assigning A Macro To A Keystroke
Assigning A Macro To A Toolbar
Viewing And Printing Macro Definitions


Advanced Data Tools
Switchboards
Using A Switchboard
Using The Switchboard Manager
Creating A Switchboard
Editing A Switchboard
Deleting A Switchboard
Creating Data Access Pages
Using The Data Access Page Wizard
Using Design View To Create A Data Access Page
Using An Existing Html Page
Modifying Data Access Pages
Adding A Theme
Adding Text And Controls
Formatting Text And Controls
Aligning And Sizing Content
Adding Images
Using Data Access Pages
Basics Of Using Data Access Pages
Viewing Data Entered Via A Data Access Page
Protecting Data


Advanced Queries
Table Relationships
Normalizing Your Data
Establishing Referential Integrity
Using Cascade Update And Cascade Delete
Setting Fields For Indexing
Using Indexing
Using Crosstab Queries
Understanding Crosstab Queries
Creating A Crosstab Query Using The Wizard
Creating A Crosstab Query Manually
Using Parameter Queries
Setting Up Parameter Queries
Using A Parameter Query
Advanced Reporting Features
Using Autoformat
Aligning And Formatting Controls
Adding Pictures And Lines


Pivot Tables And Pivot Charts
Creating A PivotTable
Creating A PivotTable Using The Wizard
Continuing Where The Wizard Left Off
More About Fields
Completing Your PivotTable
Using Autoform And Creating Pivot charts
Creating A PivotTable Using Autoform
Creating A PivotTable Using Autoform
About PivotTable PivotTable Fields
Completing A Pivot chart
Using PivotTables And Pivot charts
Using A PivotTable
Using A PivotTable
Editing A PivotTable Or Pivot chart
Common PivotTable Editing Features
Turning A PivotTable Into A Pivot chart And Vice-Versa

Enroll Now!

GLOBALKNOWLEDGE PHILIPPINES, INC.