Examine and learn how to use a number of features essential to Access DB admins. This includes investigating how to import and restructure Excel data automatically, employ security, compact and repair data files, and split databases into front and back ends for multi-user access.

Administering Access Databases is a must for anyone who builds and maintains database files for other database users.

Explore a collection of high profile tips and tricks used by the pros to develop more sophisticated, efficient and powerful tables, forms, queries and reports.

Designing Complex Database Objects is the perfect course for individuals who are comfortable with the fundamental Access Database development features but want to incorporate additional time saving whistles and bells.

Find out what this underutilized program is all about and how it can be used to store data far more efficiently than Excel.

Then get to the heart of what it takes to build databases in Access by learning how to create tables, forms, queries and reports.

Students learn the Visual Basic for Applications language as well as the Access classes and objects needed to create VBA scripts to automate Access. Participants create procedures and functions using the VBA language and Access objects. As well, debugging and error handling techniques are reviewed.