Intermediate Access Course

INTRODUCTION

More advances functions of Access. You will learn how to plan your database, normalise the data, use built-in wizards and define relationships. This course focuses on more advanced field properties, table relationships and queries. By the end of the day you will be able to enhance your database with advanced forms and reports and import and export to Word and Excel.

DURATION OF THE INTEREDIATE ACCESS COURSE

One full day.

WHO SHOULD ATTEND THIS COURSE?

This course is aimed at anyone who wishes to perfect their Microsoft Access skills.

The following people will find this course helpful:
 Anyone who wish to create more advanced database
 Anyone who has basic knowledge of Access and wish to improve their skills on the program
 Sales staff, marketing managers
 Data captures
 Business Analysts

COURSE DATES

We do not have workshops currently, but only provide on site training customized to your needs.

PRICING

The cost for on-site training is R10,000 per day. Maximum 15 delegates for computer training and 30 delegates for soft skills training. You can also find this course on our elearning platform.

OUTLINE

Unit 1: Plan the Database

Topic A: Plan a database

Topic B: Normalization

Unit 2: Wizards, Templates and Relationships

Topic A: Database templates and wizards

Topic B: Table wizard

Unit 3: Table relationships (1-1 and 1- many)

Topic A: Referential integrity

Unit 4: Advanced Field Properties

Topic A: Advanced Field properties

Topic B: Input masks

Topic C: Lookup fields

Unit 5: Advanced Table Relationships

Topic A: Table Filters

Topic B: Query joins (inner and outer joins)

Topic C: Unrelated tables self joins

Unit 6: Advanced Queries

Topic A: Query properties

Topic B: Parameters

Topic C: Action queries

Unit 7: Advance Form Development

Topic A: Combo box controls

Topic B: List box controls

Topic C: Option groups

Topic D: Command buttons

Topic E: Sub forms

Unit 8: Advanced Report Features

Topic A: Pagination

Topic B: Summarize information

Topic C: Subreports

Topic D: Mailing Labels

Unit 9: MS Office Integration

Topic A: Export to Word

Topic B: Export to Excel

Topic C: Import from Excel

 

Empower Yourself - BOOK NOW!

intermediate access course

Address:

Unit 11, Block 2
Falcon Crest Office Park
142 South Street
Die Hoewes
Centurion
South Africa

Contact Details:



*


Everyone can rise above their circumstances and achieve success
if they are dedicated to and passionate about what they do
Nelson Mandela