When
Start Tuesday April 14, 2015 at 9:00 PM CDT-to-
Tuesday April 28, 2015 at 12:00 PM CDT
Add to Calendar
Where
Delta Center for Economic Development5501 Krueger Drive
Jonesboro, AR 72401
Driving Directions
Contact
Alan Decker
Delta Center for Economic Development
870-972-3000
dced@astate.edu
Payment Information
Payment options
Credit or Debit Card- You may pay with a Credit or Debit Card before the first class date by calling the ASU cashiers window at 870-972-3847 between the hours of 8 a.m. and 5 p.m., Monday-Friday
Pay By Check- Make checks out to: ASU Treasurer's Office - Delta Center. Include the name of the class, and student's name and the Delta Center in the memo line. Payment must be received prior to attending class. If you need to make other arrangements, please call (870) 680-4383.
Mail checks to:
ASU Treasurer's Office
P.O. Box 2640
State University, AR 72467
We can also invoice your company upon request. Please provide purchase order if required.
Cancellation policy
If you are unable to attend a course for which you have registered, please provide a two-day notice of cancellation. A 50% cancellation fee is charged unless a 2-day notice is provided. No shows are billed at 100%. Substitutions are encouraged.Access 2010 Advanced Spring 2015
Dates: 3 Tuesday Session - April 14, April 21 and April 28
Time: 5:30PM-9:00PM
Cost: 109.00 Call for information regarding ASU Faculty and Staff discounts 870-680-4383
Instructor: Sue Melton
Microsoft Office Access 2010 is the newest version of Microsoft's popular database program. This advanced level is intended to help those who are familiar with Access do more with their database by exploring form controls and data management.
Highlights of the course include using SQL queries, macros, and Visual Basic code. We’ll also discuss using PivotTables and PivotCharts.
Advanced Data Management
In this section, students will learn about data management through table relationships, normalization, and referential integrity. This section also covers basic SQL structure and keywords as well as the use of modal dialog boxes.
Advanced Form Tasks
This section will focus on more advanced things that can be done with forms. Topics will include the creation and use of subforms, as well as navigation forms. This section also explores form controls like the combo box and command button. We will also discuss exporting a form to various formats.
Pivoting Data
This section will focus entirely on PivotTables and PivotCharts. We’ll discuss how to create, modify, and enhance both PivotTables and PivotCharts. We’ll also show you how to import and export your data.
Advanced Topics
Most people have experienced a computer program crash at some point, so this section shows you what to do when that happens and how to protect your work before it happens. Students will also learn about splitting databases and preparing a database for multiple users. We will also cover how to use Access with Outlook 2010 and SharePoint Server 2010.
Macros and Visual Basic for Applications (VBA)
This final section will show students how to build and use macros and submacros. Finally, we will introduce VBA and demonstrate some of its features. We’ll also touch on error handling and enabling and disabling form controls.