Microsoft Access

Category
Duration Time
1 day
VERSIONS PROVIDED:
2010 / 2013 / 2016 / 2019

Microsoft Access is a program that allows users to create, manage and analyse large databases of information. Whether you're a small business owner managing your company's information or a researcher examining a large data set, Access can help you manage this task quickly and efficiently.

 

Database Design Essentials Overview

Duration: 2 days

This course is designed to provide you with a thorough understanding of database design. It will benefit you if you are new to databases and need to learn how to design tables, forms, queries and reports.

Download the full course outline
COURSE CONTENT
Introduction to Databases
Table Design Techniques
Table Relationships
Working with tables
Form Design
Performing Select Queries
Reports

Reporting and Analysing Data Overview

Duration: 1 day

This course is designed to provide you with an understanding of the data analysis and reporting functionality with Access. It will benefit you if you wish to create queries, build reports and export data to third party software. You will either have an established database that you want to build upon or have attended our Database Design Essentials training.

Download the full course outline
COURSE CONTENT
Assessment of existing database design
Advanced Queries
Advanced Reporting
Macros

Advanced Front End Design Overview

Duration: 1 day

This course will benefit you if you are an advanced Access user needing to design a front end for your database. This training day will show you how to design user-friendly switchboards, enabling your users to add, edit & display data and run reports without the need for detailed knowledge of Access

Download the full course outline
COURSE CONTENT
Assessment of existing database design
The concept of Front End Design
Front end start-up options
Front end navigation design
Front end data analysis
Macros

Find out more about our Office 365 Evergreen Newsletter   Learn more