Microsoft Access 2016 Introduction - One Day
Course Objectives
The Introduction to Microsoft Access 2016 training course is an entry level course for this application. Delegates will be introduced to managing data, how to create a new database; constructing tables; designing forms and reports and creating queries.
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 insights smart lookup feature to access definitions or web content
- Planning and designing a database
Module two: Building a database
- Constructing a new database
- Using Database Templates
Module Three: Tables
- Creating a Table
- 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
- 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 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
- Modifying Placement, Colours, Fonts, Headers & Footers
- Create a Report from an Object
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
At the end of this course delegates will have a good working knowledge of Microsoft Access training basics. They will feel more confident using Access and be able to create a database from scratch.
Additional information
Certificates
All delegates will receive a certificate of attendance
Trainers background