Access Training - Intermediate Plus Access training for those already experienced at developing Access databases for personal use, who now want to develop databases for others to use. This course builds on the skills introduced on our intermediate Access course. During the course the participant will develop a multi-user relational database sufficiently refined for third party use. At the end of the course the participant will have sufficient knowledge to be able to develop complex relational database suitable for business use. Course content: - Advanced user interfaces
- Security
- Developing Multi-user databases
- Replication
- Macros
- Conditional statements
- An introduction to Visual Basic for Applications (VBA)
- An introduction to external links
- An introduction to front end/back end designs
- Database repair and compacting
- Error trapping
- An introduction to ActiveX components
Course duration 1 day. Course prerequisites. This course covers a great deal of ground in a short space of time. It is essential therefore that participants have either attended the Microsoft® Access intermediate course or have an equivalent level of knowledge. |