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.
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.