Access Intermediate (Live Online)

Learn how to use action queries, use calculated fields, adjust data types, set field properties, and perform database maintenance. You will also use input masks, use controls in forms, learn the lookup feature, and work further with queries and reports.Class OutlineUnit 1: Designing a Relational databasesTopic A: Relational database designTopic B: Create a tableTopic C: Create table relationshipsUnit 2: Joining tablesTopic A: Create Query joinsTopic B: Relate data within a tableTopic C: Work with SubdatasheetsUnit 3: Using data validationTopic A: Use field validationTopic B: Use form and record validationUnit 4: Creating Advanced QueriesTopic A: Create parameter queriesTopic B: Summarize dataTopic C: Create subqueriesTopic D: Create Action queriesTopic E: Create unmatched and duplicate queriesUnit 5: Organizing a database for efficiencyTopic A: Data normalizationTopic B: Create a junction tableTopic C: Improve table structureUnit 6: Using Advanced Reporting TechniquesTopic A: Including control formatting in a reportTopic B: Add a calculated field to a reportTopic C: Add a subreport to an existing report