Analysing Data with Access
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.
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.
Attendees do not need any previous experience of Access but must have a good working knowledge of Excel.
Courses are delivered in 2007, 2010, 2013, 2016.
- - Relational database concepts and terminology
- - Getting started in Access
- - Importing data from Excel
- - Table properties
- - Setting a primary key
- - Sorting and filtering records
- - Creating relationships between Tables
- - Select queries
- - Parameter queries
- - Calculated queries
- - Multi table queries
- - Make table queries
- - Delete queries
- - Append queries
- - Update queries
- - Creating basic Forms and Reports