Managing Financial Information Using Microsoft Office Access 2003

New Horizons Learning Centres of Australia
Brisbane, Melbourne, Newcastle, Perth, Sydney, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' In this course, students learn techniques that will enhance skills for gathering, organizing, and reporting vital business information and demonstrate the power of Access as a financial data management and analysis tool.

Pre-requisites:


Outline:

Lesson 1: Starting with a Firm Relational Foundation
- Export Video: Importance of using Relationships and Referential Integrity
- Data Coming from Excel into Access
- Exercise: Importing Excel Data into Existing Tables
- Best Practices for Creating Tables and Utilizing Outside Data

Lesson 2: Using Queries to Work with Financial Information
- Looking at Queries Available for Working with Financial Data
- Exercise 1: Creating Select and Totals Queries
- Exercise 2: Working with Crosstab Queries
- Retrieving Only the Information You Want
- Exercise 3: Adding Criteria to Queries
- Best Practices for Using Queries to Their Full Potentials

Lesson 3: Generating Flexible Reports for Management Use
- Creating Financial Reports Using Access
- Exercise 1: Creating and Enhancing an Access Report
- Using Access PivotTables and PivotCharts
- Exercise 2: Displaying Data Using a PivotTable View
- Exercise 3: Displaying Data Using a PivotChart View
- Best Practices for Reporting Financial Information

Lesson 4: Introduction to Microsoft Visual Basic for Applications
- Getting Started with Visual Basic for Applications by Using the Command Button Wizard
- Exercise 1: Gaining Experience with Visual Basic for Applications Procedures
- Exercise 2: Creating Event Routines Without Using Command Button Wizard
- Best Practices for Using Visual Basic for Applications Code in Databases

Lesson 5: Automating Excel from Access Using VBA
- Automating Microsoft Excel from Access
- Exercise 1: Analyzing Information with Excel Using a Menu Command
- Exercise 2: Creating Visual Basic for Applications Code that Creates an Excel Worksheet
- Exercise 3: Loading a Recordset into Excel from Access
- Best Practices for Avoiding the Pitfalls of Automation

...''

Phone:1300 794 006

School Address:

Level 6, St. Martins Tower
31 Market Street
Sydney NSW 2000 Australia

Level 4, 200 Creek Street,
Brisbane, QLD 4000

Level 2, 31 Queen Street,
Melbourne, VIC 3000

9 Denison Street,
Newcastle West NSW 2302


Jobs & Resumes: Brisbane, Melbourne, Newcastle, Perth, Sydney
Houses & Roommates: Brisbane, Melbourne, Newcastle, Perth, Sydney
Travel Agencies: Brisbane, Melbourne, Perth, Sydney

Search other schools for Managing Financial Information Using Microsoft Office Access 2003 training resources.

Microsoft Office 2007
MS Word 2007
Windows Vista
Microsoft Expression Web 2007
Team Collaboration Using Microsoft Windows SharePoint Services
Forecasting and Trend Analysis using Microsoft Office Excel 2003
Access 2007
Lotus Notes 7
Managing Critical Business Information Using Microsoft Office Access 2003
VBA ACCESS 2003
Web Design with XHTML, HTML, and CSS
Time and Task Management Using Microsoft Office Outlook 2003
XML
FileMaker Pro 7.0
Presentations Using Microsoft Office PowerPoint 2003
Online Merchandising Using Microsoft Office FrontPage 2003
Adobe Photoshop CS3
CorelDRAW 12
Adobe PageMaker 7

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.