Contact Us

Database Classes - January through June 2008
click here for full schedule

D1- Access Level 1

Learn the basics of designing and building databases. Many useful tips and tricks, even if you are already using Access. Create a table, enter data, produce forms and reports. Learn how to formulate simple filters and queries for retrieving data. Produce and print mailing labels. All the techniques you need for the development of a data base are in this class.

D2- Access Level 2

Take your database skills to the next level. Learn how to relate several tables together and understand more about primary keys, foreign keys and referential integrity. Master, detail and lookup, table concepts are covered as well as more extensive GIGO (Garbage in Garbage out data checking).

D3- Access Queries & Calculations

An in-depth look at Queries and Calculations for linked relational tables. Learn how to create select, sort, compare, calculate and summarize data. Work with subtotals and parameter inputs and explore the use of Cross Tab Queries (similar to Pivot Tables in Excel).

D4- Introduction to SQL

Introduces the basic concepts and ideas of Structured Query Language using the Access Database SQL processor.

D5- Microsoft Outlook Level 1

A great overview of Outlook that starts with understanding the windows, menus and toolbars. Learn how to send, receive and delete email; the function of the outbox and sent items and how to organize and apply rules to email. Create regular and email addresses including group lists and record journal entries to track contacts over time. Set single appointments and group meetings with the calender and schedule and assign tasks.

D6- Microsoft Outlook Level 2

Covers more advanced features of Outlook including form design. Contact Management. Organizing your contacts, setting up contacts, the general tab, the details, tab, the activities tab. Sending a message to a contact, including a vcard. Writing a letter to a contact. Requesting a meeting with a contact. Tasks and Journal Entries for contacts. History and Details for contacts. The Journal. Add a Journal entry. Journal Entry Time Line feature. Mail Merge. Build your form letter. Mailing labels, mail merge using Outlook. Email mail merge using Outlook. Importing and Exporting Data. Importing into a New Contacts Folder. Export an Outlook COntact File.

D7- Introduction to ACT Contact Management

Learn the basics of this popular contact manager. Add contacts, schedule phone calls, appointments and meetings and easily write and print custom and mail merge letters complete with envelope or label. Set alarms to remind you about critical events and view calendars, easily shifting scheduled activities to new dates and times. Look up individual or group information and develop detailed history so that you can truly follow your contacts in detail over time. Great class for anyone starting out on this popular program.

D8- Quickbooks Level 1

Covers the basic operation of the application and some understanding of Accounting Principles including Chart of Accounts, Balance Sheet and Income Statement. In this class you will setup a New Company and work through Invoicing, Billing, and simple Reporting. Accounts Payable, Accounts Receivable, Vendors, Customers, Lists and Employees are also covered. Great class for the beginning user of Quickbooks.

D9- Quickbooks Level 2

A continuation of techniques learned in level 1 applying greater depth of understanding. You will create a sample Company's accounting system from scratch and go through the Accounts Payable and Accounts receivable cycles. We will also look at the depreciation of expense items.

D10- Quickbooks Level 3

In this class we look at activities for preparing month and quarter end statements and budgets. These include accrued revenue and expenses, expiration of assets and their related expenses, reducing unearned revenues, bank reconciliation and adjustments. We also cover the creation of budgets for revenue and expense accounts, budgeted income statements, specific budgets for assets, liabilities, and equity accounts and a budgeted balance sheet.

D11- Quickbooks Level 4

In this final class of the series we look at end of year activities including an end of period statement, a budgeted versus actual income statement and balance sheet. We also cover graphs to illustrate sales and income expenses, receivables and payables and create reports for sales, purchases, inventory accounts receivable aging and accounts payable aging. Finally we look at the preparation of a Statement of Cash Flows and the creation of supporting reports to help make business decisions.

D12- Filemaker Pro for Windows/Mac Level 1

One of the easiest and most practical database management systems to learn. This class covers database design principles, how to create a file and define field types, generate custom layouts and create simple queries. Learn how to preview and print reports and mailing labels. Great class for anyone just getting started with database. You will enjoy this class.

D13- Filemaker Pro for Windows/Mac Level 2

Move to the next level with Filemaker. Create calculation and summary fields and lookups. Covers more advanced queries including multiple requests and scripting. Design and produce complex layouts including sub summary parts to generate grouping and sub totals. Create buttons and learn how to import and export data. Great class for anyone needing to create sophisticated data management systems.

D15- Microsoft Project Level 2

Introduction to project management, Starting a project, Outlining and Task Relationships, Adding and Assigning Resources, Analyzing the Project, Displaying Project Data, and Sourcing and Filtering Data.

D15- Microsoft Project Level 2

D16- Microsoft Project Level 3

Setting the Plan, Tracking Project Progress, Adjusting the Schedule of Future Tasks, Setting and Displaying an Interim Plan, Adjusting Resource Schedules, Customizing the Microsoft Project Environment, Working with Data in Other Applications, and Working with Resource Pools and Consolidated Projects.

D17- Microsoft Project Level 4