Microsoft Access & Microsoft Excel

Course Overview

This course is designed for the Microsoft Excel user that collects data and needs to manipulate and/or relate the data before analyzing the results. In this course you will learn when and how to use Microsoft Excel and Microsoft Access to store and modify data. You will generate information using Access queries and learn to share & present your results in both Excel and Access. A working knowledge of Microsoft Excel at the intermediate level is a prerequisite for this course.


Course InformationRelated Training

Duration: One-Day Course
Platform: Windows Only
Fee: Call for information

We recommend one to eight people for this course.

Course Content Download PDF (57kb)

Transfering Data (Excel and Access)

Manipulating Data (Excel and Access)

Creating Information (Access)

Sharing Results (Excel and Access)

Presenting Results (Excel and Access)

Application Overview: Microsoft Access

Microsoft Access is a relational database management system which combines the relational Microsoft Jet Database Engine with a graphical user interface. Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container.

Microsoft Excel
is a powerful tool to create and format spreadsheets and to analyze, evaluate, and calculate data. You can use advanced features to manage, track, and chart critical business data to create rich data visualization, PivotTable views, and professional-looking charts.

Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create robust databases that can be searched, sorted, analysed, reported, updated and shared with other users.