Microsoft Access 2016 - Introduction
Course Objectives
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. At the end of this course delegates will have a good working knowledge of Microsoft Access 2016 basics and will feel more confident creating and designing databases.
Contents
The course covers: how to set up database tables; how to build queries to select information based on criteria; how to create forms and use them to enter information into the database tables; how to create reports to extract and display information from them.
Module One:
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
Module two:
Building a database
- Constructing a new database
- Naming conventions
- Using Database Templates – New Templates and themes Introduced in 2016
- File formats
Module Three:
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
Module Four:
Creating and formatting forms
- Creating and Modifying a Form
- Changing the Theme of a Form
- Understanding Bound and Unbound Controls
- Adding Fields, Controls, Images and Logos to a Form
- Using a Form
Module Five:
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
Module Six:
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
Who should attend
This course is designed for new Microsoft Access users who want to learn the fundamental skills of working with Microsoft Access 2016.
Course benefits
Additional information
Certificates
Trainers background