Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 37 Minute(s)
Language
English
Taught by
Intellezy Trainers
Rating
1 views
Course Overview
Students will learn the advanced features and functionality of Access 2016
Access 2016 Advanced will further build upon the topics covered in the Access 2016 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database by using the table analyzer wizard and creating a junction table. They will explore how to maintain an Access database, including how to back up a database and how to use various tools such as the object dependencies tool. Student will also learn how to create and modify Switchboards, how to configure security and access for multi-user environments, how to automate processes with VBA (Visual Basic for Applications), and finally how to use Table Events.
Course Content
- 9 section(s)
- 26 lecture(s)
- Section 1 Introduction
- Section 2 Improving the Structure of a Database
- Section 3 Maintaining a Database
- Section 4 Working with Access Switchboards
- Section 5 Configuring Access for Multiple Users
- Section 6 Automating Processes with VBA
- Section 7 Using Table Events
- Section 8 Conclusion
- Section 9 Access 2016 Advanced Assessment
What You’ll Learn
- Improve the Structure of a Database
- Maintain a Database
- Work with Access Switchboards
- Configure Access for Multiple Users
- Automate Processed with VBA
- Use Table Events
Skills covered in this course
Reviews
-
DDirk Grotefendt
I've learned a lot about database design and Access functionality. This will help me in my daily work.
-
OOscar Andres Jimenez
Es interesante, espero obtener mas info en los videos subsiguientes
-
JJanusz Sęk
I have expected more tips and tricks presented in the Advanced Level Course. Typical description of Access Tools was given instead. Course too short.
-
JJohn Kessinger
More advanced than the intermediate video. I would have like to see more on VBA. My only complaint is I would have like to have tried some of the techniques that were displayed, but I didn't know which database was being used for each procedure.
