Access Level 2 Home / Courses / Access Level 2 Location: PST, Application Classroom Length: 1 day Times: 9:00 AM – 4:30 PM Price: $200 View Course Outline Lesson 1: Designing a Relational Database Topic A: Relational Database Design Topic B: Create a Table Topic C: Create Table Relationships Lesson 2: Joining Tables Topic A: Create Query Joins Topic B: Relate Data Within a Table Topic C: Work with Subdatasheets Lesson 3: Using Data Validation Topic A: Use Field Validation Topic B: Use Form and Record Validation Lesson 4: Creating Advanced Queries Topic A: Create Parameter Queries Topic B: Summarize Data Topic C: Create Subqueries Topic D: Create Action Queries Topic E: Create Unmatched and Duplicate Queries Lesson 5: Organizing a Database for Efficiency Topic A: Data Normalization Topic B: Create a Junction Table Topic C: Improve Table Structure Lesson 6: Using Advanced Reporting Techniques Topic A: Include Control Formatting in a Report Topic B: Add a Calculated Field to a Report Topic C: Add a Subreport to an Existing Report Appendix A: Microsoft Office Access 2016 Exam 77-730 Appendix B: Microsoft Access 2016 Common Keyboard Shortcuts COURSE DESCRIPTION: This course builds upon basic Microsoft Access skills acquired in Access Level 1 to help students become power users. In this Microsoft Access course, students will delve deeper into the program by studying topics such as how to manage data and data entry, create forms and dialog boxes, split databases, and much more. You will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, and insert background images and charts. Upon completion, you will be able to create specialized objects such as looking up fields, subforms, subreports, navigation forms, and calculated fields. IDEAL CANDIDATES: This course is aimed at intermediate users of Microsoft Access or those who have already taken Access Level 1. Students taking this course are database administrators or prospective database administrators who have experience working with Access and need to learn advanced skills. This course helps participants prepare for certification when followed by Access Level 3. RELATED COURSES: Access Level 1, Access Level 3 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