PAGE 10
DRIVER'S ED FOR THE INFORMATION SUPERHIGHWAY • SPRING 99
Access Access: Introduction
Access,included in Microsoft Office,is database software that allows users to organize and manipulate data and create forms and reports for customized input and output.
Office and statistical software
CLASSES
Class Locations Key
CC Auditorium Computer Center Auditorium CC PC Lab 202A Computer Center CC Mac Lab 202B Computer Center Budig PC Lab 10 Budig Hall,PC Lab
Registration
Office and statistical software classes are free to the KU community, $75 non-KU. Most require registration as indicated in the class description. Register by e-mail acsworkshop@ukans.edu or call 785 864-0494.
Excel
Excel, included in Microsoft Office, is spreadsheet software that does complex calculations performs numerical and database analyses,and creates charts.
In this workshop, the Access modules are defined. You create a table, then use commands and menu features to create, save, index, sort, and edit a database table. Participants also filter fields and records from a table.Prerequisite: Experience in the Windows environment.Requires registration for all and a $75 fee for non-University. www.cc.ukans.edu/~acs/docs/wkshop/Access-introhandout.pdf
January 21,2-5 p.m.,CC PC Lab February 25,3-6 p.m.,CC PC Lab
Access: Intermediate
This workshop centers on the query module of Access. You learn to QBE (query by example) to get a custom display of data from one or more tables. We design special queries to extract and sort information, as well as Action Queries to create, delete, and append tables of data. Learn about table relations: how to link tables with related information and how to use queries to display related information from multiple tables. You are introduced to advanced criteria development with the Expression Builder.Prerequisite: Access: Introduction or equivalent skills. Requires registration for all and a $75 fee for non-University. www.cr.ukans.edu/~acs/docs/wkshon/Access-queries-handout
www.cc.ukans.edu/~acs/docs/wkshop/Access-queries-handout.pdf
January 29,9 a.m.-noon, CC PC Lab March 5,9 a.m.-noon,CC PC Lab
Access: Forms
In this workshop, you learn to create forms using the Form Wizard and the Design View.You use single tables, queries and multiple tables through queries to create forms. You create simple data entry forms and add additional features such as check boxes and pull-down menus from the Toolbox. You build a special kind of form called a switchboard that allows quick access to the tables, queries, reports, and forms of your database through buttons linked to macros.Prerequisite: Access: Intermediate or equivalent skills. Requires registration for all and a $75 fee for non-University www.cc.ukans.edu/~acs/docs/wkshop/Access-forms-handout.pdf
February 17,9 a.m.-noon,CC PC Lab
April 15,3-6 p.m.,CC PC Lab
Access: Reports
In this workshop, you learn to create reports using the Report Wizard and the Design View. You use single tables, queries and multiple tables through queries to create reports. You create simple reports such as mailing labels; as well as complex reports with summary information and groupings, group totals and running totals. You add selection and graphic features from the Toolbox and special functions from the Expression Builder. Prerequisite: Access: Intermediate or equivalent skills. Requires registration for all and a $75 fee for non-University. www.cc.ukans.edu/~acs/docs/wkshop/Access-reports-handout.pdf
February 3,9 a.m.-noon,CC PC Lab
March 30, 3-6 p.m., CC PC Lab
Excel: Introduction
Learn about Excel's menu selection, cursor movement, various data types, cell addressing and Help as you build a simple worksheet. Edit data, set ranges, format information, and use AutoFormat to create finished tables. Prerequisite: Experience in a Windows or Mac OS environment. Requires registration for all and a $75 fee for non-University. www.cs.ukans.edu/acs/dore/uuk schon/excel5 0 intru edf
www.cc.ukans.edu/acs/docs/wkshop/excel5.0-intro.pdf
January 26,1-4 p.m., CC PC Lab March 4,1-4 p.m.,CC PC Lab
Excel: Intermediate
Create an Excel chart and use the worksheet as a database.Learn to set criteria for ranges, and extract and sort data.The class also covers various chart types and how to edit chart objects.Also learn to link data between spreadsheets and workbooks so when data is changed in one location, information automatically updates in the linked spreadsheet.Prequisite:Excel:Introduction.or equivalent skills.Requires registration for all and a $75 fee for