Microsoft Access & Microsoft Excel
Integration

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)

Determining which program to use
Importing text files into Excel
Import text and Excel files into Access
Linking between file types (Excel to Access , Access to Access, Access to ODBC)
Appending data to existing tables
Troubleshooting

Manipulating Data (Excel and Access)

Creating Excel Text and Date functions
Using Access queries to delete records and modify data
Creating calculated fields
Finding unmatched records and deleting duplicates

Creating Information (Access)

Using criteria and wild cards
Understanding different Join types
Using IF statements
Summarizing data using summary queries and aggregate functions

Sharing Results (Excel and Access)

Exporting, sharing or connecting to Excel
Saving specifications
Troubleshooting

Presenting Results (Excel and Access)

Creating charts in Excel
Creating reports in Access
Sending results by e-mail
Saving reports as PDF or XPS files

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.

Microsoft Access & Microsoft Excel Integration