Microsoft Access

Microsoft Access 2000 makes it easy to get the information you need and provides powerful tools that help you organize and share your database so you and your team make better decisions. With 3 levels of training available you can get the most out of access with the capability to design and build your own.

With Three levels of training to choose from we can accommodate the beginner to advanced users

Introduction
Intermediate
Advanced

«Top»

INTRODUCTION TO ACCESS

DURATION : Half day

TARGET AUDIENCE :

Those with an elementary knowledge of the operation of micro computers who wish to learn how to create and use Databases using Access for Windows.

This is a course with a high level of practical content, aimed at those people who have not used Access before. It caters for delegates with widely differing experience and skill levels.

TEACHING APPROACH :

The teaching approach contains a mix of lectures, practical and one to one work, varying according to the number of people attending. For the most part delegates are able to work at a pace which best suits them with emphasis being placed upon quality rather than quantity.

PRE REQUISITES :

Those with an elementary knowledge of the operation of micro computers. No previous experience with Access is necessary although some experience with Microsoft Windows is an advantage, though not essential.

COURSE OBJECTIVES :

By the end of the course, delegates should be able to :

1. Start the Access program& understand database theory.
2. Become familiar with the database window and objects.
3. Use the Access menu system and toolbar.
4. Create a new database table and database file.
5. Enter data into a table in datasheet view.
6. Find and replace data.
7. Use the Form Wizard.
8. Enter and edit data records in form view.
9. Filter, Sort and search through records.
10. Understand and use Dynsets or Subsets.
11. Create and apply Filters or Quick Queries.
12. Create, and apply Permanent Queries.
13. Modify existing Permanent Queries.
14. Include calculated fields into queries.
15. Use the Report Wizard.
16. Create a standard tabular report.
17. Create a grouped report.

«Top»

ACCESS DATABASE - INTERMEDIATE LEVEL

DURATION : Half day

TARGET AUDIENCE :

Those with an elementary knowledge of the operation of micro computers who wish to learn how to create and use more in-depth database features using Access for Windows.

This is a course with a high level of practical content, aimed at those people who have used Access before. It caters for delegates with widely differing experience and skill levels.

TEACHING APPROACH :

The teaching approach contains a mix of lectures, practical and one to one work, varying according to the number of people attending. For the most part delegates are able to work at a pace which best suits them with emphasis being placed upon quality rather than quantity.

PRE REQUISITES :

Ideally, course delegates will have attended introduction to Microsoft Access databases or have previous knowledge surrounding the concepts of Microsoft Access.

COURSE OBJECTIVES :

By the end of the course, delegates should be able to :

1. Modify a table structure in design view
2. Set up an Indexed Property of a field
3. Specify a default field value
4. Validate field information
5. Set the default value, validation rule & validation text of properties
6. Add a memo field to a table & work with multiple tables
7. Resize and reposition two datasheet windows
8. Relate tables, create a custom form
9. Create a relationship between two tables
10. Design a custom form
11. Design and use a form to enter and update data
12. Create a Graph Wizard
13. Specify multiple criteria in a query
14. Specify AND and OR conditions in a query
15. Generate summary information for records
16. Generate summary information in a table
17. Extract information from multiple tables
18. Create a query that extracts information from two tables

«Top»

ACCESS DATABASE - ADVANCED LEVEL

DURATION : Full Day

TARGET AUDIENCE :

Those with a well developed knowledge of the operation of micro computers who wish to learn more in-depth database features and techniques using Access for Windows.

This is a course with a high level of practical content, aimed at those people who have used Access before. It caters for delegates with widely differing experience and skill levels.

TEACHING APPROACH :

The teaching approach contains a mix of lectures, practical and one to one work, varying according to the number of people attending. For the most part delegates are able to work at a pace which best suits them with emphasis being placed upon quality rather than quantity.

PRE REQUISITES :

Ideally, course delegates will have attended introduction to Microsoft Access and Access Intermediate Database course(s) or have previous knowledge surrounding the concepts and operations of Microsoft Access.

COURSE OBJECTIVES :

By the end of the course, delegates should be able to :

1. Use Object Linking and Embedding in Access
2. Link an object in an unbound object frame
3. Link an object in a bound object frame
4. Create a Master-detail form
5. Create a form based on a Multiple-table query
6. Work with database macros
7. Create a database macro
8. Execute a database macro
9. Work with object macros
10. Create and execute a command button macro
11. Create a calculation macro
12. Create a data validation macro
13. Create a macro control window
14. Create dialogue boxes
15. Create a main menu
16. Create a custom macro menu
17. Assign a keyboard shortcut to a macro