major projects for IT training crown software and compter consultancy

Microsoft Access Advanced Plus Course Outline

Course Aims

This one-day intensive course is designed to give existing users an insight into some of the more advanced features in Access. This entirely 'hands on' course will give participants a further understanding of database design principles, advanced forms, reports and query design, including using calculations.

Course Outline

Designing Advanced Queries
Writing SQL Queries
Writing Advanced Joins
Developing Advanced Queries

Working with Macros
Automating Tasks
Debugging Macros
Conditional Programming in Macros
Adding Macros to Forms
Adding Macros to Reports
Filtering Data
Documenting Macros

Programming Access Using Visual Basic
Using Macros Verses Visual Basic
Understanding Visual Basic Concepts
Using the Visual Basic Editor Window
Getting Help with Visual basic

Using Data Access Pages
Creating Data Access Pages
Modifying Data Access Pages
Sorting and Summarizing
Editing Data in Data Access Pages
Protecting Data in Data Access Pages

Analysing Access Databases
Optimizing Databases with Table Analyzer
Optimizing Databases with performance Analyzer
Documenting Databases with Document Analyser

Target Audience

Existing users of Microsoft Access for windows who want to customise forms, queries and reports.

Assumed Knowledge

A basic knowledge of Microsoft Access gained through use of the product or by attending an "MS Access Intermediate" course.

Related Courses

Access Introduction and Intermediate; Windows; other MS Office Applications.

IT training microsoft office lotus smartsuite

For further information e-mail:info@major-projects.co.uk
All site content is © Major Projects Limited | Website design is © Ambrow Limited