SitesPower Training Center - PO Box 13801 Dubai, UAE
SitesPower Training Institute | Dubai : +9714-335-5549 | Sharjah Institute : +9716-575-1315 | معهد تدريب سايتس باور

Enquire About Course

Training Programs | Course Schedule

Printing Instructions

Microsoft Access 2003 - Levels 1-3
1 day Instructor-Led Course per Level (8 hours per level)
 

Previous Software Versions: MS Office XP, 2002, 2000

Introduction to Microsoft Access 2003
What is Access?
Creating Files
Opening and Closing a Database File
Review Questions

Access 2003 Interface
Access 2003 Workspace
Review Questions

The Database Toolbar
Using the Database Toolbar
Review Questions

The Task Pane
Using the Open area of the Getting Started Task Pane
Using the New area of the New File Task Pane
Using the Template area of the New File Task Pane
Using the Clipboard Task Pane
Using the File Search Task Pane
Review Questions

The Database Window
The Database Menu Bar
The Database Window Toolbar
Review Questions

Tables
Create a Table
Working with Tables
Review Questions

Queries
Create a Query
Review Questions

Forms
Using and Creating Forms
Displaying and Linking Images
About inserting images
Review Questions

Reports
Creating and Using Reports
Saving, Maintaining, and Printing Reports
Review Questions
 

Level 2 Course Outline:

Working with the Northwind Sample Database
Installing the Northwind Database
Review Questions

Designing Tables in Access 2003
Normalising Data
Establishing Relationships
Working with Indexes
Working with Data Types
Review Questions

Designing Queries in Access 2003
Creating Action Queries
Creating Parameter Queries
Creating Calculated Columns in Queries
Joining Tables
Review Questions

Designing Forms in Access 2003
Creating Data Entry Forms
Working with Subforms
Creating Pop-up Forms
Working with Switchboards
Review Questions

Designing Reports in Access 2003
Working with Standard Reports
Working with Pop-up Reports
Working with Subreports
Working with Report Snapshots
Developing Data Access Pages
Review Questions

Working with PivotTables and PivotCharts
Creating PivotTables and PivotCharts
Creating PivotTable Forms
Creating PivotChart Forms
Review Questions

Importing and Exporting
Linking to External Data Sources
Importing Data into Access
Exporting Data from Access
Review Questions

Building Expressions
Using the Expression Builder
Using Common Built-in Functions
Review Questions

Level 3 Course Outline:

Working with the Northwind Sample Database
Installing the Northwind Database
Review Questions

Introducing Structured Query Language
Writing SQL Commands
Writing SQL Queries
Writing SQL Subqueries
Writing SQL Joins
Inserting Data
Updating Data
Deleting Data
Writing SQL Queries in Access 2003
Review Questions

Working with Macros
Automating Tasks
Introducing the Macro Design Toolbar
Creating Macros
Testing and Debugging Macros
Modifying Macros
Conditional Programming in Macros
Adding Macros to Forms
Adding Macros to Reports
Filtering Data
Documenting Macros
Review Questions

Programming Access Using Visual Basic
Using Macros versus Visual Basic
Understanding Visual Basic Concepts
Using the Visual Basic Editor Window
Getting Help with Visual Basic
Review Questions

Using Data Access Pages
Creating Data Access Pages
Modifying Data Access Pages
Sorting Data in Data Access Pages
Summarising Data in Data Access Pages
Editing Data in Data Access Pages
Protecting Data in Data Access Pages
Review Questions

Converting Access Databases
Converting Databases to Access 2003
Converting from Access 2003 to Access 97
Converting from Access 2003 to Access 2000
Review Questions

Customising Access 2003
Configuring Access 2003 Options
Configuring AutoCorrect Options
Customising Menus and Toolbars
Review Questions

Managing and Maintaining Access Databases
Optimising Databases with Table Analyzer
Optimising Databases with Performance Analyzer
Documenting Databases with Documenter Analyzer
Avoiding errors with the Object Dependencies task pane
Review Questions