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.Register
Duration: One-Day Course
Platform: Windows Only
Fee: Call for information
We recommend one to eight people for this course.
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.