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, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events.
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.
There’s nothing more exhilarating for a guitarist than taking center stage and fronting a power trio. Witness the likes of Stevie Ray Vaughan, Hendrix, Jimmy Page, Clapton and so many other masters of this genre. It’s also a lot more challenging than it looks and that’s the premise for Kelly Richey’s Power Trio course, which focuses on the key elements, creative approaches and techniques that define the genre.
Take the shortcut! Work faster and more efficiently in Lightroom with this collection of keyboard and mouse shortcuts from photographer and educator Chris Orwig. Switch screen modes and panels, import photos faster, delete unwanted images, rate and filter photos, crop smarter, develop more beautiful images, sync settings, reapply adjustments, and more—all with the touch of a button or key. Chris also points you toward resources for learning more, including a website where you can download all known Lightroom shortcuts for free.
Learn VBA concepts that you can apply to your job, and add functionality to your Access databases.