Access
2003, Introduction
(12
hours) Total Cost $195 (includes all books and materials)
This course
is for the new user of Access and assumes no experience with relational
databases. The topics cover the critical skills you need to get started
creating databases in Access and working with the data by using tables,
queries, forms, and reports.
CMP
E94 541
August 19 & 21, Tuesday & Thursday
9:00 a.m. - 4:00 p.m.
SSC Room 3236
CMP
E94 543
August 26 - September 4, Tuesdays & Thursdays
6:00 - 9:00 p.m.
SSC Room 3236
Access
2003, Intermediate
(12
hours) Total Cost $195 (includes all books and materials)
Prerequisite: Introduction to Access or equivalent knowledge
Share
data with other applications and enforce referential integrity; modify
the design of a table to streamline data entry and maintain data integrity.
Use a filter to show records that match criteria and generate different
query results by creating different types of joins between tables.
Create select queries that display special records and design other
types of queries, including parameter and action queries; create forms
and change their designs to enhance the appearance and usability of
a form, and to make your form more professional.
CMP
E87 041
Novenber 11 & 13, Tuesday & Thursday
9:00 a.m. - 4:00 p.m.
SSC Room 3236
CMP
E87 042
October 21 - 30, Tuesdays & Thursdays
6:00 p.m. - 9:00 p.m.
SSC Room 3236
Access 2003, Advanced
(12 hours) Total Cost $195 (includes all books and materials)
Prerequisite: Introduction to Access or equivalent knowledge
Put existing data into correctly designed tables and compact your database; use a variety of techniques to summarize data. Create and revise basic Access macros; create macros that require data entry in certain fields and automate data entry in others. Use advanced features to enhance forms, reports and distribute a report to non-Access users. Use Office Links to use Access data in other Office programs.
CMP E87 540
December 8 & 10, Monday & Wednesday
9:00 a.m. - 4:00 p.m.
SSC Room 3236
CMP E87 542
December 9 & 11, Tuesday & Thursday
9:00 a.m. - 4:00 p.m.
UCC Room 5180
Access 2007, Introduction
(12 hours) Total Cost $195 (includes all books and materials)
Prerequisite: Introduction to Windows or prior knowledge
This course is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills you need to get started creating databases in Access and working with the data by using tables, queries, forms, and reports.
CMP E94 641
September 16 & 18, Tuesday & Thursday
9:00 a.m. - 4:00 p.m.
SSC Room 3228
CMP E94 643
August 18 - 27, Mondays & Wednesdays
6:00 p.m. - 9:00 p.m.
SSC Room 3228
Access 2007, Intermediate
(12 hours) Total Cost $195 (includes all books and materials)
Prerequisite: Access Introduction or equivalent knowledge
Share data with other applications and enforce referential integrity; modify the design of a table to streamline data entry and maintain data integrity. Use a filter to show records that match criteria and generate different query results by creating different types of joins between tables. Create select queries that display special records and design other types of queries, including parameter and action queries; create forms and change their designs to enhance the appearance and usability of a form, and to make your form more professional.
CMP E87 141
November 3 & 5, Monday & Wednesday
9:00 a.m. - 4:00 p.m.
UCC Room 5180
CMP E87 143
November 25 - December 9, Tuesdays & Thursdays
6:00 - 9:00 p.m.
UCC Room 5180
