Access Advanced (Live Online)

Learn the principles of table relationships; advanced query techniques; an introduction to functions, macro actions, advanced form techniques including using macros in forms; database security, and advanced report techniques.Class OutlineUnit 1: Implementing Advanced Form DesignTopic A: Add Controls to FormsTopic B: Enhance navigation and organization of formsTopic C: Apply conditional formattingUnit 2: Sharing data across applicationsTopic A: Import data into accessTopic B: Export Access dataTopic C: Link Tables to external data sourcesTopic D: Create a mail mergeUnit 3: Using macros to improve user interface designTopic A: Create a macroTopic B: Restrict records by using a conditionTopic C: Validate data by using a macroTopic D: Automate data entry by using a macroTopic E: Converting a macro to VBAUnit 4: Using Advanced database managementTopic A: Manage a databaseTopic B: Determine object dependencyTopic C: Document a databaseUnit 5: Distributing and Securing a databaseTopic A: Splitting a database for multiple-user accessTopic B: Implement securityTopic C: Convert an Access database to an ACCDE fileTopic D: Package a database with a digital signatureUnit 6: Creating a Start-up Display FormTopic A: Create a display formTopic B: Set start-up options