2033 – Microsoft Access 2013 Advanced EssentialsDownload Course Outline
Title: Microsoft Access 2013 Advanced Essentials 2033; 2 Days; Instructor-led
Description: This course builds upon basic Microsoft Access skills to help students become power users. In this advanced Microsoft Access 2013 course, students will delve deeper into the program by studying a dozen different topics. Modules in this course cover how to manage data and data entry; create forms, macros, and dialog boxes; create and use SQL queries; split databases; and much more.
At Course Completion:
Audience & Prerequisites:
Course Outline Details: Module 1: Managing Data Lessons View relationships View object dependencies Enforce referential integrity Enforce cascade updates and deletes Module 2: Advanced Table Tasks Lessons Insert application parts Use the table analyzer wizard Create validation rules Configure validation messages Module 3: Managing Data Entry in Tables Lessons Mark fields as required Create lookup fields Create input masks Module 4: Create Subforms Lessons Create sub-forms Link sub-forms Format a sub-form with a main-form Module 5: Creating Navigation Forms Lessons Create a navigation form and add tabs Create tab hierarchy Display a navigation form when databases opens Module 6: Advanced Query Tasks Lessons Create SQL Use the expression builder Module 7: Creating Modal Dialog Boxes Lessons Create a dialog box Format a dialog box Modify a dialog box Module 8: Splitting the Database Lessons Split the database Back up the database Module 9: Creating Macros Lessons Create macros Edit macros Create event procedures Module 10: Advanced Form Tasks Lessons Limiting user access to a form Creating checkboxes and command buttons Building command buttons events Creating event procedures Module 11: Advanced Form Tasks Lessons Creating a split form Splitting an existing form Using a split form
Start Date: 10/23/2019
End Date: 10/24/2019