Microsoft Access Introduction
|
Course Outline |
Enroll |
Cost: |
$499 |
Duration: |
2 Days |
Time: |
8:30 AM to 4:30 PM |
Continuing Ed Units |
1.4 |
|
|
This course is designed to provide a
practical application of relational database concepts. Topics
include database design, creating fields in tables, choosing data
type, setting properties, identifying a primary key, creating table
relationships, working in datasheet view, designing basic forms,
formatting form controls, combo boxes, sorting, setting criteria in
queries, using AND, OR, NOT, and NULL, multi-table queries,
parameter queries, designing list reports and grouped reports. |
 |
2020 |
|
Monday-Tuesday |
1/20-1/21 |
Wednesday-Thursday |
3/11-3/12 |
Monday-Tuesday |
4/6-4/7 |
Wednesday-Thursday |
5/6-5/7 |
Wednesday-Thursday |
6/10-6/11 |
Thursday-Friday |
8/6-8/7 |
Monday-Tuesday |
10/5-10/6 |
Wednesday-Thursday |
11/4-11/5 |
Tuesday-Wednesday |
12/8-12/9 |
|
Microsoft Access Intermediate
|
Course Outline |
Enroll |
Cost: |
$499 |
Duration: |
2 Days |
Time: |
8:30 AM to 4:30 PM |
Continuing Ed Units |
1.4 |
Prerequisite: |
Microsoft Access - Introduction |
|
|
Topics include database design,
filtering data, validating data integrity, input masks, table
lookups, value lists, forms with subforms, form properties, editing
subforms, creating text strings, action queries, sorting and
grouping in reports, using OLE object and attachment fields, creating
command buttons and creating switchboard forms. |
 |
2020 |
|
Thursday-Friday |
2/6-2/7 |
Monday-Tuesday |
4/13-4/14 |
Monday-Tuesday |
5/11-5/12 |
Tuesday-Wednesday |
6/16-6/17 |
Monday-Tuesday |
7/6-7/7 |
Tuesday-Wednesday |
8/11-8/12 |
Thursday-Friday |
10/8-10/9 |
Wednesday-Thursday |
11/18-11/19 |
|

Microsoft Access Advanced
|
Course Outline |
Enroll |
Cost: |
$499 |
Duration: |
2 Days |
Time: |
8:30 AM to 4:30 PM |
Continuing Ed Units |
1.4 |
Prerequisite: |
Microsoft Access - Intermediate |
|
|
Topics include joins, indexes, summary
queries, crosstab queries, calculating controls, calculating values
from subform controls, report controls, data integration, importing,
exporting, linking, hyperlink fields, hyperlinks in forms, dialog
boxes, automating with macros and conditional macros. |
 |
2020 |
|
Monday-Tuesday |
1/27-1/28 |
Monday-Tuesday |
3/16-3/17 |
Monday-Tuesday |
5/18-5/19 |
Monday-Tuesday |
6/22-6/23 |
Monday-Tuesday |
7/20-7/21 |
Monday-Tuesday |
9/21-9/22 |
Monday-Tuesday |
11/9-11/10 |
|
|
|
|
|
|