Log On/Register  

855.838.5028

Access 2016

Duration: 4 days, 8 modules
Module Price: $130

Module 1: Introduction to Access & Creating Tables

Introduction to the Access 2016 Interface

Tell Me

Reliance On SharePoint For Certain Database Templates

Introduction To Database Design Concepts & Terminology

Open And Examine And Existing Access Database

Working With Tables And Data Records

Find, Sort And Filter Records In A Table

Introduction To Table Creation Options

Create Tables Using The Design View

Using The Data Type Gallery

Introduction To Table Field Properties

 

Module 2: Working with Relationships & Tables

Relational database design concepts

Create table relationships

Explore relationship types

Define referential integrity

Display object dependencies

How to “Normalize” databases

Additional table field properties

Create a lookup list

 

Module 3: Queries 

Create select queries

Use criteria to refine query results

Create multi-table queries

Create query joins

Implement query parameters

Performing calculations in a query

 

Module 4: Additional Queries, & Importing/Exporting Objects & Data

Create a Totals Queries

Create Crosstab Queries

Create Action Queries

Import/Export Data

Linking Tables from One Database to Another

Overview Of Importing Data From Microsoft Outlook

 

Module 5: Creating Forms

Creating an AutoForm

Using the Form Wizard to Design New Forms

Add and Modify Form Controls

Using Office Themes

Adding Images and Titles

Create Calculated Controls

Work with Control Properties

Create Forms in Design View

Creating Forms with Sub-Forms

Create Tabbed Forms

 

Module 6: Creating Reports

Using the Report Wizard to create new Reports

Modify report's page setup settings

Modify report design and layout

Work with report sections

Create summary functions

Create reports in design view

Use the Mailing Labels Wizard

 

Module 7: Automating Access Databases

Create Macros

Implement and Run Macros

Creating Table Macros

Event Driven Macros

Setting Database Startup Options

Introduction to VBA Concepts and Terminology

 

Module 8: DB Maintenance and Deployment

Create Custom Switchboards

Discuss Deploying Access Databases in a Multi-User Environment

Explore Microsoft Access Security Features

Compact and Repair Databases

Using Hyperlinks in an Access Database

Module 1: Introduction to Access & Creating Tables

Introduction to the Access 2016 Interface

Tell Me

Reliance On SharePoint For Certain Database Templates

Introduction To Database Design Concepts & Terminology

Open And Examine And Existing Access Database

Working With Tables And Data Records

Find, Sort And Filter Records In A Table

Introduction To Table Creation Options

Create Tables Using The Design View

Using The Data Type Gallery

Introduction To Table Field Properties

 

Module 2: Working with Relationships & Tables

Relational database design concepts

Create table relationships

Explore relationship types

Define referential integrity

Display object dependencies

How to “Normalize” databases

Additional table field properties

Create a lookup list

 

Module 3: Queries 

Create select queries

Use criteria to refine query results

Create multi-table queries

Create query joins

Implement query parameters

Performing calculations in a query

 

Module 4: Additional Queries, & Importing/Exporting Objects & Data

Create a Totals Queries

Create Crosstab Queries

Create Action Queries

Import/Export Data

Linking Tables from One Database to Another

Overview Of Importing Data From Microsoft Outlook

 

Module 5: Creating Forms

Creating an AutoForm

Using the Form Wizard to Design New Forms

Add and Modify Form Controls

Using Office Themes

Adding Images and Titles

Create Calculated Controls

Work with Control Properties

Create Forms in Design View

Creating Forms with Sub-Forms

Create Tabbed Forms

 

Module 6: Creating Reports

Using the Report Wizard to create new Reports

Modify report's page setup settings

Modify report design and layout

Work with report sections

Create summary functions

Create reports in design view

Use the Mailing Labels Wizard

 

Module 7: Automating Access Databases

Create Macros

Implement and Run Macros

Creating Table Macros

Event Driven Macros

Setting Database Startup Options

Introduction to VBA Concepts and Terminology

 

Module 8: DB Maintenance and Deployment

Create Custom Switchboards

Discuss Deploying Access Databases in a Multi-User Environment

Explore Microsoft Access Security Features

Compact and Repair Databases

Using Hyperlinks in an Access Database

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):