Access Level 3 Home / Courses / Access Level 3 Location: PST, Application Classroom Length: 1 day Times: 9:00 AM – 4:30 PM Price: $200 View Course Outline Lesson 1: Implementing Advanced Form Design Topic A: Add Controls to Forms Topic B: Enhance Navigation and Organization of Forms Topic C: Apply Conditional Formatting Lesson 2: Sharing Data Across Applications Topic A: Import Data into Access Topic B: Export Access Data Topic C: Link Tables to External Data Sources Topic D: Create a Mail Merge Lesson 3: Using Macros to Improve User Interface Design Topic A: Create a Macro Topic B: Restrict Records by Using a Condition Topic C: Validate Data by Using a Macro Topic D: Automate Data Entry by Using a Macro Lesson 4: Using VBA Topic A: Getting Started with VBA Topic B: Enhance Access by Using VBA Lesson 5: Using Advanced Database Management Topic A: Manage a Database Topic B: Determine Object Dependency Topic C: Document a Database Lesson 6: Distributing and Securing a Database Topic A: Splitting a Database for Multiple-User Access Topic B: Implement Security Topic C: Convert an Access Database to an ACCDE File Topic D: Package a Database with a Digital Signature Lesson 7: Managing Switchboards Topic A: Create a Database Switchboard Topic B: Modify a Database Switchboard Topic C: Set Start-up Options Appendix A: Microsoft Office Access 2016 Exam 77-730 Appendix B: Microsoft Access 2016 Common Keyboard Shortcuts COURSE DESCRIPTION: Access Level 3 participants will learn about importing and exporting data from Access, advanced queries, forms and reporting, creating Macros, and important database management tasks such as compressing and restoring a database, data encryption, and more. This course will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users. IDEAL CANDIDATES: This advanced course is suitable for those who have taken Access Level 2 or Microsoft Access intermediate users who have an understanding of table relationships, how to set field controls, create multi-table queries, build expressions in the query design grid, and customize reports and forms. RELATED COURSES: Access Level 1, Access Level 2 Excel Level 1, Excel Level 2, Excel Level 3, Excel Pivot Tables, Excel Power Pivot, Excel VBA, Office 365, Outlook Level 1, Outlook Level 2, PowerPoint Level 1, PowerPoint Level 2, Project Level 1, Project Level 2, Publisher, SharePoint Site Administrator, SharePoint Site Owner, SharePoint Site User, Visio Level 1, Visio Level 2, Word Level 1, Word Level 2, Word Level 3