This course introduces you to the functionality of a database. You will create Tables, Forms, Queries and Reports. You will be working with multiple tables and explore the relationship process as well as importing Excel worksheets into Access. We will cover using toolbox objects such as command buttons and drop-down combo boxes. Students should be familiar with Windows, but no database experience is required.

Fee: $240
Course: #70215
Option 1: (Office 07) June 24, 25 & 26, Tues, Wed & Thurs, 8 am - 12 noon, 3 sessions
Option 2: July 21 & 23, Mon & Wed, 8 am - 3 pm, 2 sessions
Option 3: August 19, 21, 26 & 28, Tues & Thurs, 5:30 - 8:30 pm, 4 sessions

Learn to build basic list and group reports that will work with any database. We’ll give you step by step, hands on instruction with grouping report data, building formulas, formatting reports, creating pie charts and distributing your data. Students should have taken our Access Fundamentals course or have equivalent database experience. Book required - approx. $98.

Sessions: 2
Fee: $240
Course: #70611
Date/Time: July 28 & 30, Mon & Wed, 8 am - 3 pm

Now that we’ve covered the basics, we’ll move into more customization with our reports. This intermediate class covers creating running totals, building cross-tabs, adding sub reports, creating drill-downs, SQL statements, charting, reporting on excel data, working with prompts, and enhancing report functionality. Book required - approx. $98.

Sessions: 2
Fee: $240
Course: #70684
Date/Time: Aug 25 & 26, Mon & Tues, 8 am - 3 pm