Ramp It Up: Excel, Access, & VBA (Completed)
Date: Tuesday, June 7, 2011
Instructor: L. Keith Jordan
| Begin Time: |
12:00pm Pacific Time
1:00pm Mountain Time
2:00pm Central Time
3:00pm Eastern Time |
| CPE Credit: |
2 hours for CPAs |
|
This 2-hour webcast will present students with specific situations requiring form-driven data collection techniques, and illustrates how to integrate and manipulate this data for more effective analysis and reporting. MS-Access and MS Excel will be used for illustration.
Who Should Attend
Practitioners wanting a more powerful approach to data analysis and reporting through leveraging the features of MS-Access and MS-Excel.
Topics Covered
- Using MS-Access forms, queries, and tables for form-driven data collection
- MS-Access functions and features such as form views, combo boxes, and conditional formatting
- Visual Basic for Applications (VBA), event triggers and error trapping
- Relational database design considerations
- Getting MS-Access data into MS-Excel
Learning Objectives
- Design and create a MS-Access database
- Design and create an interactive MS-Access application
Level
Intermediate
Instructional Method
Group: Internet-based
NASBA Field of Study
Specialized Knowledge and Applications (2 hours)
Program Prerequisites
A basic knowledge of MS-Access and an intermediate knowledge of MS-Excel is recommended. Completing the Leveraging the Power of Excel and Access webcast is required. Completing the Building Interactive Excel Spreadsheets for Data Capture and Using Excel with External Data webcasts is strongly recommended.
Advance Preparation
None
