Of related interest: Database
Management Using Access 7.0 or Access for Office 97
and also: Computer Literacy Certificate
Microsoft Access for Office 97 will be used for this 12-hour course in which beginning concepts of database development and use are taught. The student will learn to design a table, add and edit records. Locating, sorting and deleting records will be covered. Designing and applying queries, reports, and forms will equip a beginner to accomplish everyday database tasks. The text used is Microsoft Office User Specialist approved courseware. Prerequisite: Beginning Windows 95 (5305/5805).
CEU Hours Awarded: 1.2
| AA Sep 15, 17, 22 TTh 8:00a-12:00p |
AB Sep 29, Oct 1, 6 TTh 1:00p-5:00p |
BA Sep 28, 30, Oct 5, 7 MW 6:00p-9:00p |
| BB Oct 8, 13, 15 ThT 8:00a-12:00p |
DA Sep 19, 26 Sat 9:00a-4:00p |
DC Nov 23, 24, 25 MTW 1:00p-5:00p |
Access Version 7.0 for Windows 95 will be used for this 12-hour course. Beginning concepts of database development and use are taught. The student will learn to design a table, and to add and edit records. Locating and sorting records will be covered. Designing and applying queries, reports, and forms will equip a beginner to accomplish everyday database tasks. Prerequisite: Beginning Windows 95 (5305).
CEU Hours Awarded: 0.8
| CA Sep 21, 23, 26 MW 6:00p-9:00p Sat 9:00a-4:00p |
CB Sep 28, 30, Oct 2 MWF 8:00a-12:00p |
| CC Oct 19, 21, 23 MWF 1:00p-5:00p |
In this 12-hour intermediate Access course you will learn how to share and manage data, define data rules, use advanced queries to answer specific questions, and create summary queries. Additionally, comprehensive exercises will allow you to create and enhance custom forms, create a main form with sub forms to view data in two tables, create and enhance custom reports and create hyperlinks to jump to other files or to locations within a file. The text used is Microsoft Office User Specialist approved courseware.Prerequisite: Beginning MS Access for Office 97 (5744/5844).
CEU Hours Awarded: 1.2
| AA Nov 9, 11, 13 MWF 8:00a-12:00p |
DA Nov 2, 4, 6 MWF 1:00p-5:00p |
DB Oct 26, 28, 30 MWF 1:00p-5:00p |
| DC Nov 30, Dec 2, 4 MWF 8:00a-12:00p |
DD Dec 7, 9, 14, 16 MW 6:00p-9:00p |
This 12-hour course introduces students to advanced query concepts, including calculations, grouping and parameters. Action queries are applied. Forms for combining information from related tables are explored, including the application of a combo box, a list box, and option group and form tab order. The advanced concepts of identifying and creating table relationships are applied. Prerequisite: Beginning MS Access (7.0) for Windows 95 (5344).
REQUIRED TEXT: Running Microsoft Access 7.0 (ISBN: 1-55615-886-6)
CEU Hours Awarded: 1.2
| CA Oct 26, 28, 30 MWF 8:00a-12:00p |
CB Nov 3, 5, 10 TTh 1:00p-5:00p |
In this 12-hour class the experienced user will learn advanced features which will allow masterful utilization of Microsoft Access for Office 97. After completing the class, training participants will be able to apply and use Cascade Update and Cascade Delete properties. They will apply selection criteria and parameters in queries, then design advanced queries with the SQL system. Additionally, they will learn to work with advanced forms and reports functions and expressions. You will learn how to create database automation features by building various macros to include an Autoexec macro. The text used is Microsoft Office User Specialist approved courseware. Prerequisite: Intermediate Access (7.0) for Office 97(5745).
REQUIRED TEXT: Running Microsoft Access 7.0 (ISBN: 1-55615-886-6)
CEU Hours Awarded: 1.2
| DA Nov 17, 19, 24 TTh 8:00a-12:00p |
DB Dec 14, 16, 18 MWF 1:00p-5:00p |
In this 12-hour class the experienced user will learn techniques to build forms for specific user needs and data entry screens. More complex reports, using calculations and graphs, are investigated. The students will utilize macros and be introduced to Access Basic. Prerequisite: Intermediate Access (7.0) for Windows 95(5345).
REQUIRED TEXT: Running Microsoft Access 7.0 (ISBN: 1-55615-886-6)
CEU Hours Awarded: 1.2
| CA Nov 30, Dec 2, 4 MWF 8:00a-12:00p |