Course Outline:

Access 2016 Essentials:

Module One: Create and Manage a Database

•Create and Modify Databases

oCreate a blank desktop database

oCreate a database from a template

oCreate a database by using Import objects or data from other sources

oDelete database objects

•Manage Relationships and Keys

oCreate and modify relationships

oSet the primary key

oEnforce referential integrity

oSet foreign keys, view relationships

•Navigate through a Database

oNavigate specific records

oCreate and modify a navigation form

oSet a form as the startup option

oDisplay objects in the Navigation Pane

oChange views of objects

•Protect and Maintain Databases

oCompact a database

oRepair a database, back up a database

oSplit a database

oEncrypt a database with a password

oRecover data from backup

•Print and Export Data

oPrint reports

oPrint records

oSave a database as a template

oExport objects to alternative formats

Module Two: Build tables

•Create Tables

oCreate a table

oImport data into tables

oCreate linked tables from external sources

oImport tables from other databases

oCreate a table from a template with application parts

•Manage Tables

oHide fields in tables

oAdd total rows

oAdd table descriptions

oRename tables

•Manage Records in Tables

oUpdate records

oAdd records

oDelete records

oAppend records from external data

oFind and replace data

oSort records, filter records

•Create and Modify Fields

oAdd fields to tables

oAdd validation rules to fields

oChange field captions

oChange field sizes

oChange field data types

oConfigure fields to auto-increment

oSet default values

oUsing input masks

oDelete fields

Module Three: Create Queries

•Create a Query

oRun a query

oCreate a crosstab query

oCreate a parameter query

oCreate an action query

oCreate a multi-table query

oSave a query

•Modify a Query

oRename a query

oAdd fields, remove fields

oHide fields

oSort data within queries

oFormat fields within queries

•Create Calculated Fields and Grouping within Queries

oAdd calculated fields

oSet filtering criteria

oGroup and summarize data

oGroup data by using comparison operators

oGroup data by using arithmetic and logical operators

Module Four: Create Forms

•Create a Form

oCreate a form

oCreate a form from a template with application parts

oSave a form

•Configure Form Controls

oMove form controls

oAdd form controls

oModify data sources

oRemove form controls

oSet form control properties

oManage labels

oAdd sub-forms

•Format a Form

oModify tab order

oConfigure Print settings

oSort records by form field

oApply a theme

oControl form positioning

oInsert backgrounds, insert headers and footers, insert images

Module Five: Create Reports

•Create a Report

oCreate a report based on the query or table

oCreate a report in Design view

oCreate a report by using a wizard

•Configure Report Controls

oGroup and sort fields

oModify data sources

oAdd report controls

oAdd and modify labels

•Format a Report

oFormat a report into multiple columns

oAdd calculated fields

Control report positioning

oFormat report elements

oChange report orientation

oInsert header and footer information

oInsert images

oApply a theme