Contact:
Sue MeltonASU Continuing Education and Community Outreach
kmelton@astate.edu
870-972-3052
When
Wednesday May 15, 2013 at 5:30 PM CDT
-to-
Wednesday April 29, 2013 at 8:30 PM CDT
This class meets on Wednesday nights only for 3 weeks.
Where
ASU Jonesboro- CECO
106 N. Caraway
Jonesboro, AR 72467
Driving Directions
Instructors
Cindy Bode
Cindy Bode provides the computer support for the College of Education at Arkansas State University. Originally from the Kansas City area, she received a BA in Economics from Kansas State University in 1983. She is a Microsoft Certified Master Instructor and was an instructor at the New Horizons Computer Learning Center in Overland Park and adjunct faculty at Longview Community College in Lee’s Summit, Missouri. She enjoys reading, helping her husband (and their four-year-old) work on their racecar and trying to not kill her plants.
Intermediate Access Description
| Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts. This course will help students prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2010. Table Of Contents: Unit 1: Relational databases Topic A: Database normalization Topic B: Table relationships Topic C: Referential integrity Unit 2: Related tables Topic A: Creating lookup fields Topic B: Modifying lookup fields Topic C: Subdatasheets Unit 3: Complex queries Topic A: Joining tables in queries Topic B: Using calculated fields Topic C: Summarizing and grouping values Unit 4: Advanced form design Topic A: Adding unbound controls Topic B: Graphics Topic C: Adding calculated values Topic D: Adding combo boxes Topic E: Advanced form types Unit 5: Reports and printing Topic A: Customized headers and footers Topic B: Calculated values Topic C: Printing Topic D: Labels Unit 6: Charts Topic A: Charts in forms Topic B: Charts in reports Unit 7: PivotTables and PivotCharts Topic A: PivotTables Topic B: Modifying PivotTables Topic C: PivotCharts Topic D: PivotTable forms | ||
ASU Continuing Education Computer Classes
You must be registered by Wednesday before the week classes start.
Check out our schedule for Evening Computer Classes now offered at ASU Jonesboro and ASU Paragould.
Need a class not listed or one offered at a different time?
If you are interested in a class that is not listed, please let us know. Our schedule changes so please call to inquire if one has been recently added to the schedule or will be offered later in the year. We look forward to hearing from you.
Phone: (870) 972-3052
Contact:
Jessica Scott Sue Melton
jkscott@astate.edu kmelton@astate.edu
Cost: $109 per class.
Payment Options:
Mail:
ASU Treasurer's Office
P.O. Box 2640
State University, AR 72467
Phone:
Credit/Debit Card
(870) 972-3847 (Monday - Friday 8:00 a.m. - 5:00 p.m.)
In Person:
ASU Treasurer's Office Cashier's Window
Student Union Building, 2nd Floor
North Hall adjoining the Parking Deck, ASU Jonesboro
(Monday - Friday 8:00 a.m. - 4:30 p.m
***Checks should be made out to: ASU CECO/Computer Classes. The name of the class, student's name, and Account # 133101-212910-511416-0000 should be included on checks.
Note: If registering for multiple classes, a registration form is required for each class.
Classes may be added upon request, providing there are enough participants to make a class.
Computer Lab Location
Arkansas State University
ASU Jonesboro- CECO- Room 410
106 N. Caraway Road
State University, AR 72467
Phone: (870) 972-3052
Fax: (870) 972-3849