CHARLESTON, W.Va. -- Kanawha Valley Community and Technical College will offer a series of Microsoft Access workshops designed for participants with little or no experience with computers or who want to increase their computer proficiency. Instruction will be provided by a Microsoft Office master instructor.In Microsoft Access 2010 -- Basic, Participants will learn the basics needed to design a database. Participants will learn to create and edit tables, set field properties, use queries, and use basic forms and reports. Learn to store information and retrieve facts as needed. This workshop will be held Friday, March 8.In Microsoft Access 2010 -- Intermediate, students will learn the skills needed to build real world Microsoft Access databases with the features and capabilities needed in today's business climate. Participants will learn about designing tables, joining tables, and working with multiple tables through queries; how to create advanced, professional-quality forms and dialog boxes; create advanced reports with totals, subtotals, business charts, and more; use macros to automate business processes; and how to pull all the pieces of your database together into an easy-to-use, fully functional database application. This workshop will be held April 5.In Microsoft Access 2010 -- Advanced, students will learn the differences between Access 2007 and 2010, how to query with SQL; create crosstab, parameter, and action queries; create and work with macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook to update data. This workshop will be held May 3.
Workshops will be held at the Kanawha Valley Community & Technical College Workforce and Economic Development site located in the Schoenbaum Family Enrichment Center at 1701 Fifth Avenue, Suite 142. Each workshop begins at 9 a.m. and ends at 4 p.m. Pre-registration is required. The registration fee is $95 for each six-hour, hands-on workshop and includes a student textbook and CD with practice activities.Register online at http://apps.wvsto.com/wvsctccms/default.aspx
, by phone 304-205-6603 or e-mail firstname.lastname@example.org
. Members of Charleston Area Alliance, South Charleston Chamber of Commerce and Putnam County Chamber of Commerce receive a 5 percent discount.For information on other training programs and workshops offered by KVCTC's Workforce and Economic Development Division, visit our website at www.kvctc.edu/workforce