Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 28 Minute(s)
Language
English
Taught by
Intellezy Trainers
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn to improve and maintain a database, create Switchboards, and secure and automate an Access database
Access 2013 Advanced will further build upon the topics covered in the Access 2013 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, using the Table Analyzer Wizard, Normalize tables, and creating Junction Tables, and how to maintain an Access database by creating backups, compacting and repairing, and using the Performance Analyzer Tool. Students will create and modify Switchboards for easier user navigation, configure security and multi-user environments by splitting a database and password protecting a database. In addition, students will automate processes with VBA (Visual Basic for Applications), and learn to use Table Events.
Course Content
- 9 section(s)
- 28 lecture(s)
- Section 1 Introduction
- Section 2 Improving the Structure of an Access Database
- Section 3 Maintaining an Access Database
- Section 4 Creating and Modifying Switchboards
- Section 5 Configuring Security and Multi-User Environments
- Section 6 Automating Processes with VBA
- Section 7 Using Table Events
- Section 8 Conclusion
- Section 9 Access 2013 Advanced Assessment
What You’ll Learn
- Improve the Structure of an Access Database
- Maintain an Access Database
- Create and Modify Switchboards
- Configure Security and Multi-User Environments
- Automate Processes with VBA
- Use Table Events
Skills covered in this course
Reviews
-
MMark Parsons
Brilliant
-
AAnonymized User
The tools and education around VBA was great, would have loved a little more of an in depth discussion on VBA, though that may be more pertinent in a different course.
-
LLinda Cleary
This course provided exposure to advanced features of Access and tools for managing the database. While it was a little beyond my experience level at this point, it was very helpful to gain insight and understanding of issues that can arise with databases and how to fix them. I liked the format of the instructor standing in front of the large screen demonstrating how to navigate and use the database, however, I found I needed to enlarge the screen to see the details more easily at times. It is similar to what happens in meetings when a person already familiar with a computer screen displays it for others. If it isn't quite large enough it is difficult to follow along.
-
TThomas R Myler
Enjoyed this course. Contents were applicable to real world issues. Instructor was slow-paced, as I prefer, and provided thorough explanations.
