Database
DATABASE CLASSES
D1- Access Level 1, 9am-12pm, $225
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.
Mar 03, Apr 07, May 05, Jun 02, Jul 07, Aug 04, Sep 01, Oct 06, Nov 03, Dec 01
D2- Access Level 2, 9am-12pm, $225
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).
Mar 10, Apr 14, May 12, Jun 09, Jul 14, Aug 11, Sep 08, Oct 13, Nov 10, Dec 08
D3 - Access Queries & Calculations, 9am-12pm, $225
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).
Mar 17, Apr 21, May 19, Jun 16, Jul 21, Aug 18, Sep 15, Oct 20, Nov 17, Dec 15
D4 - Introduction to SQL, 1pm-3pm, $150
Introduces the basic concepts and ideas of Structured Query Language using the Access Database SQL processor.
Mar 17, Apr 21, May 19, Jun 16, Jul 21, Aug 18, Sep 15, Oct 20, Nov 17, Dec 15
D5 - Microsoft Outlook Level 1, 1pm-3pm, $150
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 calendar and schedule and assign tasks.
Mar 03, Apr 07, May 05, Jun 02, Jul 07, Aug 04, Sep 01, Oct 06, Nov 03, Dec 01
D6 - Microsoft Outlook Level 2, 1pm-3pm, $150
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.
Mar 10, Apr 14, May 12, Jun 09, Jul 14, Aug 11, Sep 08, Oct 13, Nov 10, Dec 08
D7 - Filemaker Pro for Windows/Mac Level 1, 2pm-5pm, $225
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.
Mar 05, Apr 02, May 07, Jun 04, Jul 02, Aug 06, Sep 03, Oct 01, Nov 05, Dec 03
D8 - Filemaker Pro for Windows/Mac Level 2, 2pm-5pm, $225
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.
Mar 12, Apr 09, May 14, Jun 11, Jul 09, Aug 13, Sep 10, Oct 08, Nov 12, Dec 10
D9 - Microsoft Project Level 1, 9am-1pm, $225
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.
Call or email For Schedule - 415.497.8463, info@bactrain.com
D10 - Microsoft Project Level 2, 9am-1pm, $225
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.
Call or email For Schedule - 415.497.8463, info@bactrain.com