Welcome to Onsite Training - Have a look round!

Feedback Nottingham Home

Access

 

Up PC Concepts Windows Word Word VBA Excel Excel Macros Excel VBA Access Office Outlook Visual Basic PowerPoint Publisher Pagemaker Photoshop QuarkXPress Project

Introduction Course

Duration: 2 Days

Objectives:

By the end of the course the student will know the advantages of computerised databases in the commercial environment and will have used Microsoft Access software to solve information requirements.

Designed for:

This course is particularly suited to students who have some familiarity with personal computing and who now need to make effective use of Microsoft Access. The course assumes no previous knowledge of database software.

Description:

The early part of the course introduces the student to the concept of database' and the inherent advantages. The course then covers database creation, management, updating and reporting. The course has a significant practical content.

Course Topics

Introduction to Databases
Introduction to Microsoft Access Environment
Access Objects & how they Relate
The Case Study
Database Creation
Adding and Editing Data
Form Design
Find & Replace
Filters
Queries and Dynasets
Parameter Queries
Action Queries
Report Design

 

Advanced Course

Duration: 1 Day

Objectives:

This course extends the basic concepts of Microsoft Access to enable the delegate to make effective use of the many facilities available in the product. The material covered in this course provides a foundation for the Access Development course.

Designed For:

This course is suitable for delegates with a basic understanding of Microsoft Access, and the ability to create and modify Tables, Queries, Forms and Reports. It also assumes knowledge of table joins and parameter queries.

Description:

This course focuses on the importance of good design and the use of more advanced techniques to produce database applications that are largely automated. It shows how various components can be integrated, both within Access and with other software, to create an application with relatively little effort. The use of macros is covered, both to automate forms and reports and to control the overall application, as are the principles of database management.

Course Topics

Relational Database Design
Action Queries
Form Design Techniques
Report Design Techniques
Internet
Working with Macros
Event Macros
External Data
Access and other Applications
Database Management

 

Access Application Development

Duration: 2 or 3 days

Objectives:

This course will provide developers with a foundation in application development using Microsoft Access. After completing this course, students will be able to design, build and distribute database applications developed in Access.

Designed For:

The course is suitable for delegates with a good understanding of Microsoft Access, including relational database design and creation and use of Tables, Queries, Forms, Reports and Macros. Ability to use a modern programming language, including an understanding of variables, arrays, loops and decision structures, will be an advantage, though not essential.

Description:

Creating a database application that can readily be used by people who are unfamiliar with Microsoft Access requires knowledge of design skills and packaging techniques as well as a sound knowledge of the capabilities of Microsoft Access. This course focuses on design issues and on the features of Access that enable consistent, reliable designs to be implemented.

Course Topics

Application Design Concepts

Integrating Office Applications *

Visual Basic for Applications

Security *

Working with Record Sets

Accessing External Data *

Object programming

Debugging and Error Handling

ActiveX Controls

Customising Access

Documenting the Application

*   These topics will all be covered in the three-day version of the course;
     the two-day course will just cover those in the first column

 

 

Send mail to admin@onsite.demon.co.uk with questions or comments about this web site.
Copyright © 1999 - 2003  Onsite Training (East Midlands) Ltd