Analysing Data with Access

Analysing Data with Access

Duration:
1 Day
Aims:

This course is designed to provide delegates with the knowledge of how Access can be used as a powerful tool to analyse and report on data, imported from Excel. This course mainly focuses on queries and data manipulation with only a brief introduction to forms and reporting.

Objectives:

On completion of this course attendees will be able to: Import data from Excel, Work with Tables, Create relationships between Tables, Create Select Queries, Create Action Queries, Create basic Reports and Forms.

Pre-Requistites

Attendees do not need any previous experience of Access but must have a good working knowledge of Excel.

Versions

Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
Database Introduction
  • - Relational database concepts and terminology
  • - Getting started in Access
Importing Data
  • - Importing data from Excel
Working with Tables
  • - Table properties
  • - Setting a primary key
  • - Sorting and filtering records
Table Relationships
  • - Creating relationships between Tables
Select Queries
  • - Select queries
  • - Parameter queries
  • - Calculated queries
  • - Multi table queries
Action Queries
  • - Make table queries
  • - Delete queries
  • - Append queries
  • - Update queries
Introduction to Forms and Reports
  • - Creating basic Forms and Reports
Related courses
Run this
course at
your offices
Request a quote
Speak to a friendly advisor

call

0333 344 6630

or visit our

Online Chat
Trustpilot