Microsoft Access Advanced (Live Online)

This course is aimed at Intermediate users of Access and covers topics such as building advanced forms, writing advanced queries, creating advanced reports and automating operations using Macros.Training is hands-on and all classes are taught by experienced database developers.Suitable for Access 2016, 2019 & 365 users.Course OutlineAdvanced queriesGrouping and summarizingAbout groupingBuilding totals queriesTotals query designWhere totalsExpression totalsCommon aggregate functionsUpdating, deleting, and relationshipsReferential integrityCascading practicesAbout cascading deletesAllowing deletes in key fieldsAllowing updates in key fieldsIndexing for performanceAbout indexesHow an index worksIndex planningCreating indexes in tablesSetting index propertiesMaximizing performanceSpecialized query typesPass-Through QueriesData Definition QueryAdvanced formsAbout subformsCreating the main form and subform using the Form WizardCreating a subform using the SubForm WizardUsing an existing form as a subformNested subformsLinking formsMain form–subform data relationshipsThe hyperlink controlAdding a hyperlink to a formThe Web Browser controlThe attachment controlManaging attachments in a formThe chart controlSpecialized form typesAbout navigation formsCreating a navigation formModal dialog formsCreating a database start-up formAdvanced reportsAbout subreportsSubreport record sourcesMain and subreport with the same record sourceMain and subreport with related record sourcesUsing an unbound main report as a containerAdvanced groupingDate rangesRunning sumsAdvanced formattingBanded reportsFormatting and design optionsShowing Username nameUsing a logoShowing and hiding for printingMacrosCreating a macroPlanning macrosUsing the Macro BuilderUsing Macro Builder featuresEmbedded macrosAssigning macros to eventsData macrosUsing variablesVariable scopeChoosing variable sourcesWhen to use variablesCreating macros with variablesTroubleshooting macrosError handling basicsStepping through macrosDisplaying variable valuesUsing the OnError actionUsing the MacroError ObjectDesigning robust macrosLogging Debug infoImporting and exporting dataData exchange basicsChoosing which parts of Access to useOther database applicationsOCDB databasesSaving import and export proceduresImport optionsExport basicsExchanging data with other Access databasesLinking to Access tablesImporting data in AccessExporting Access objectsExchanging data with ExcelImporting from ExcelLinking to Excel dataAppending Excel dataExporting data to ExcelUsing Text and XML data filesExporting to text filesExporting to XMLImporting from text filesImporting from XML filesDatabase managementPreparing and running Compact & RepairRunning Compact & Repair automaticallyRestoring a databaseOther maintenance tasksEncrypting a databaseCreating an executable fileDocumenting the database structureOur outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.