Mastering Microsoft Access: Advanced Practices Training Class

Course ID: 14153

Mastering Microsoft Access: Advanced Practices Training Seminar

Move your skills to an even higher level - this session covers the advanced techniques and tools that will put unbelievable power into your information management!

Move your skills to an even higher level - attend Mastering Microsoft Access:
Advanced Practices ! This session covers the advanced techniques and tools that will put unbelievable power into your information management.

This Advanced Practices course will move you beyond the basics, and teach you to use the tools that can turn your database into a powerful tool for business planning, marketing, research and more. You'll learn how to use your Basics skills in new ways, and discover how to master more complex information management tools.

Covers 2003 and all previous versions

Agenda

Seminar Overview

How to create multiple tables, and ensure they work in tandem

Changing table designs without compromising the integrity of the data

Refining tables with hyperlink controls, indexes, and properties

How to edit the properties of linked tables

Designing advanced links and table joins

How to handle time-dependent data

Queries in multiple tables: what you can and can't accomplish

How to update fields in queries and change a miniside join field

How to set up a cross-tab

Tips and tricks for writing advanced queries

How to filter records within a form

How to export reports to a variety of formats, including HTML

Tips for jazzing up reports with graphics, custom colors, and special effects

How to troubleshoot errors within macros

How to add actions, arguments, or conditional expressions to macros

How to control record locking and set defaults for multi-user databases

How to ensure security on multi-user systems