|
|||||||||||||||||||||||||||||||||||||||||||
Databases
| Microsoft Access 1: Data Modeling In Access 2003 | |
|
Intended Audience:
|
Faculty, staff, graduate students |
|
Prerequisite Skills:
|
Proficiency with basic Windows operations, mouse usage, and other Microsoft software such as Excel |
|
Course Description:
|
Course includes: -- Understanding database concepts -- Learning database design steps -- Creating a data model -- Normalizing data -- Documenting the database |
|
Current Offerings:
|
There are no courses scheduled at this time. |
| Microsoft Access 2: Tables in Access 2003 | |
|
Intended Audience:
|
Faculty, staff, graduate students |
|
Prerequisite Skills:
|
Completion of Data Modeling in Access 2003. |
|
Course Description:
|
Course includes: -- Setting field properties -- Indexing a field and adding a primary key -- Editing properties and modifying tables -- Formatting data -- Creating relationships and enforcing integrity -- Courses will be offered again in April and June |
|
Current Offerings:
|
There are no courses scheduled at this time. |
| Microsoft Access 3: Queries in Access 2003 | |
|
Intended Audience:
|
Faculty, staff, graduate students |
|
Prerequisite Skills:
|
Completion of "Microsoft Access 2: Tables" |
|
Course Description:
|
This course is two parts: Level 1 and Level 2-- Course includes: -- Using simple queries in design view -- Modifying a query -- Sorting a query using multiple fields -- Developing AND and OR operations in queries -- Creating a calculated field -- Designing advance queries and creating action queries -- These Courses will be offered again in April and June. |
|
Current Offerings:
|
There are no courses scheduled at this time. |
| Microsoft Access 4: Forms in Access 2003 | |
|
Intended Audience:
|
Faculty, staff, graduate students |
|
Prerequisite Skills:
|
Completion of "Microsoft Access 3: Queries" |
|
Course Description:
|
Course includes: -- Creating basic forms using the form wizard -- Modifying a form -- Working with control properties, form properties, and multiple controls -- Changing a control's data source -- Creating a calculated control -- Creating and modifying a subform -- Course will offered again in April and June. |
|
Current Offerings:
|
There are no courses scheduled at this time. |
| Microsoft Access 5: Reports in Access 2003 | |
|
Intended Audience:
|
Faculty, staff, gratuate students |
|
Prerequisite Skills:
|
Completion of "Microsoft Access 4: Forms" |
|
Course Description:
|
Course includes: -- Creating mailing labels with the label wizard -- Creating a report with Autoreport -- Modyfing a report and adding or deleting fields -- Understanding report sections and grouping and sorting records -- Creating calculated controls -- Creating a chart with the Chart Wizard -- Course will be offered again in April/May and June/July. |
|
Current Offerings:
|
There are no courses scheduled at this time. |
| Microsoft Access 6: Advanced Features in Access 2003 | |
|
Intended Audience:
|
Faculty, staff, graduate students |
|
Prerequisite Skills:
|
Completion of "Microsoft Access 5: Reports" |
|
Course Description:
|
Course includes: -- Compacting and repairing a database -- Converting an Access database from an older Access version -- Working with macros and creating conditional expressions and importing -- Course will be offered again in April/May and June/July. |
|
Current Offerings:
|
There are no courses scheduled at this time. |