In this advanced course, students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, and how to use Access as a development tool. Various maintenance and security features are covered in the course, teaching students ways to better manage multi-user databases.
Training Avaliability and Delivery
This is primarily online training
This is an online eLearning or CBT training program
This course may be available for home-study
Courseware may be available for purchase
Self Directed
Contact Online Training Directory for more information
PIN code provided for this course allows unlimited on-line access for 90 days. This advanced course strives to broaden and develop the intermediate database design skills that students already possess. Students will gain a more complete understanding of how to effectively create and use the primary database objects in Access, including tables, queries, forms, reports, and data access pages. In addition, students will be introduced to advanced features that allow Access to be used as a development tool. The course also teaches strategies for protecting data by enacting various security measures and by controlling how data is entered into a database. Finally, various maintenance features are covered in the course, teaching students ways to better manage multi-user databases. The material is presented through explanatory text, real-world scenarios, interactive steps, and questions to test and reinforce the material covered.
Outcomes:
Upon completion of this course, students will be able to: --Create lookup fields --Define relationships --Modify form properties and use the subform control --Create and run macros --Use Access tools while integrating Access with other applications
Assessment:
Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery.
Contact Hours: 24
About Online Training Directory - Training Provider
Online Training Directory - Workforce and Continuing Ed online courses are offered at basic, intermediate and advanced levels. Going beyond basic training provides a deeper and more educationally rewarding learning experience, especially for students who wish to advance careers or initiate new ones. For the general lifelong learner we continue to offer "fun to learn" single, stand-alone courses.
We look forward to...
More Access Training from Online Training Directory