Cosensa - Microsoft Access 2016

> Home > Courses > Microsoft Access 2016 - Advanced

Course Overview

The Introduction to Microsoft Access 2016 training course covers how to use Access 2016 to manage data, including creating a new database; constructing tables; designing forms and reports and creating queries.

Content

Getting started with Microsoft Access

Identify the components of the Access 2016 interface
Understanding database terminology and relationships
Using the new “tell me what you want to do” help and search feature of 2016
Using the new insights smart lookup feature to access definitions or web content
Planning and designing a database
Learn about security warnings

Building a database

Constructing a new database
Naming conventions
Using Database Templates – New templates and themes Introduced in 2016
File formats

Tables

Creating a Table. Using the Table Wizard.
Field types and field properties
Table relationships
Formatting a table
Table views
Add, edit and delete records
Search, browse and print records
Format a table

Creating and formatting forms

Creating and modifying a morm
Changing the theme of a form
Understanding bound and unbound controls
Adding fields, controls, images and logos to a form
Using a form

Creating and using Queries

Understanding types of queries
Creating a simple query – using the wizard
Using wildcards and operators
Running a query
Viewing, sorting and filtering results
Create and use multiple table queries
Create and use a parameter query
Exporting results to excel

Reports

Creating a report – design view
Using the wizard
Modifying placement, colours, fonts, headers & footers
Create a report from an object
Preview results
Printing reports
Printing reports to PDF

Learning outcomes

Who should attend

Level

Course benefits

Pre-course work

Certificates

View Upcoming Dates Print this Page

Related Courses

I.T. Training

Microsoft Project 2016 - Introduction

Find Out More

I.T. Training

Microsoft Access 2016 - Introduction

Find Out More

I.T. Training

Microsoft Word 2016 - Introduction

Find Out More

I.T. Training

Microsoft Excel 2016 - Advanced

Find Out More

View Full Course List

Microsoft Access 2016 - Advanced

Course Overview