Microsoft Access Fundamentals (Live Online)

This class is suitable for trainees new to Microsoft Access. After this class you will have a very good working knowledge of Microsoft Access, including how to design and build an efficient relational database, construct data fields and tables, run queries, design forms and build reports.Training is hands-on and all classes are taught by experienced database developers.Suitable for Access 2016, 2019 & 365 users.Course OutlineDatabase FundamentalsUnderstanding general database termsDatabase management systemsTable OverviewData typesTable metadataQueries and SQLSQL StatementsRelational databasesFlat file databasesNoSQL databasesAdvantages of relational databasesAccess interface and objectsNew databasesExisting databasesThe navigation PaneAccess objects: Tables, Queries, Forms and ReportsDatabase DesignFundamentals of efficient designModelingThe logical modelThe physical modelNormal formsCreating and Modifying databasesChoosing data types: Numeric, String, OtherConstraintsChanging table structureChanging data typesAdding and deleting fieldsRelationships and KeysTablesCreating a simple tableCreating tables in Design ViewCreating fieldsCreating fields in Datasheet viewCreating fields in Table Design viewSetting a Primary FieldData Validation using Field PropertiesSetting validation rulesSetting table-level validationRelationships and keysThe importance of primary keys and indexesDeciding whether you need unique indexesCreating relationshipsQueriesCreating basic queriesSelect queriesAction queriesAdding data sources to a querySelecting query fieldsQuery criteriaAdding multiple criteria conditionsParameter queriesTotal queriesCross tab queriesAppend queriesUpdate queriesDelete queriesModifying queriesSorting query resultsQuery field formattingUsing calculated fieldsCreating calculated Yes/No fieldsCalculated text fieldsFormsCreating simple formsBasic form design optionsBound and unbound form controlsUsing the Form WizardForm DesignDisplaying form propertiesForm sectionsForm controlsAdding bound controls to a formAdding controls form the field listTypes of controlsTest box and label controlsList controlsAdding a command buttonChanging the layout of controlsReportsCreating ReportsReport basicsSetting up data sourcesFiltering and ordering reportsAutomatic report generatorsUsing the Report WizardReport ControlsCalculated fieldsGrouping and summarizingFormatting ReportsReport Page Setup optionsImages and other objectsThemesOur 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.