Private
Training
Technical
Services
Entre
Directory
Tips and
Tricks
New
Location
Entre
Home Page

CLASS DESCRIPTIONS

On-site Training for up to ten people per class is available for $350 per three hour class.
All classes are taught by Laurie Mollin

Click here to email any questions

Click here to Print Outlines of the Classes
All classes are designed for Microsoft Office 2000, 2002 and 2003

(540) 989-6000

Introduction to Access
This class teaches you how to use Access. It is not a programming class. First there will be an overview of how Access works and what all the different components of Access are.  We will set up a database file and create a table and an input form.  You will learn many keyboard shortcuts that make entering records much easier.  We will discuss using Access with the other Office programs and creating tables from existing databases, and how to pull up just records matching specified criteria. If you need to use Access and you do not know what a table, form or query is you need this class.

Access Queries
The heart of Access is queries. If you don't know how to ask for what you want, you can't print a report with just that information. You will learn how to specify selection criteria in a basic query and then how to build more complicated queries with calculations and totals. We will combine information from different tables by linking. We will create a cross-tab query and a subtract query. You will learn how to create action queries to append, update and delete records. One of the most important methods we will go over is how to specify different criteria, for example date ranges, each time you print a report.

Access Reports
Creating reports using Access wizards is a piece of cake as long as you just want a list of all your records and your fields fit perfectly across the page. Unfortunately, this is usually not the case. There are many tricks that make life much easier when you are trying to make your report even legible. I will teach you every trick I've discovered in creating reports. We will go over calculated fields, grouping, sorting and formatting reports. We will create a printed form, a report with gridlines and mailing labels. You will add calculated columns and summary totals to your report. We'll even add graphics to a report.

Advanced Access 
This class starts with how to customize fields for easier data entry and validation. We then cover how to manage indexes and primary keys. We will discuss linking tables and relationships. Then we will go over advanced forms such as creating combo boxes, check boxes and command buttons. We will create subforms and subreports. You will learn how to create some useful macros that you will be able to use in your own applications. Finally we will create a switchboard form to make your database startup with a customized Menu.

Introduction to Excel 
Excel has many fantastic tricks that allow you to create spreadsheets fast and easy. This introductory course will introduce you to all these tricks while making a simple spreadsheet. You will learn everything you absolutely have to know to create formulas to have Excel do the work for you. All the basic formatting commands necessary to make your printed spreadsheet presentable will be covered. After this class you should be able to setup your own spreadsheets with the help of your handout.

Intermediate Excel 
First you create a little larger spreadsheet than in the Intro class with very little typing (but a lot of copying and editing) to review what you learned in Intro and to show you some more tricks. Then you will learn to do some fancier formatting as easily as possible, including making a bar chart. We will go over the database features: Sort, Filter and Subtotals. Probably the most important thing we will cover is using multiple sheets to streamline your work, including how to make a consolidating sheet.

Excel Advanced Features
This class is primarily about taking simple formulas much farther using functions such as ROUND, INT, VLOOKUP, and IF. But we will also go over some advanced concepts such as how, why and when to name cells. Pivot tables are really easy once you are shown how and it's amazing how impressively they summarize your data. Protecting your worksheet, so that others can key in data without destroying your hard work will be covered, as well as how to trouble shoot formula error messages. Linking formulas to save you time and be more accurate will also be taught. Finally, we will record basic macros.

Introduction to Outlook
Outlook can do much more than just enable you to send and receive email messages.  But even if that is all you want to do there are many tricks and tips to make this an easier process.  Managing messages in a business environment can quickly get overwhelming without the tools to sort, flag, delete and move messages to specific folders.  Contacts will collect all kinds of information over and above email addresses.   You can even print your own address book with it.  The Calendar and Tasks views let you organize your schedule and commitments.  You can even automatically have your incoming email messages answered with a message letting everyone know you are not available.  All this and more will be taught in this class.

Advanced Outlook
This class was developed at the request of Entré clients that were changing from other Contact managers to Outlook or just wanted to do more with Outlook than email.  The most often asked question I get asked is how to print mailing labels.  This is covered in the class plus how to print envelopes and form letters.  The next most often asked question is how to send messages to selected contacts without the other contacts seeing who else is getting this message.  We will do this in class as well.  You will also learn how to customize the Contact Input Form and Table Views and set up and use Categories.  We will go over using the Journal to track activity for a contact or just your own activity,  We will also get into the use of Public Folders on a network. 

PowerPoint 
The main reason to use PowerPoint is to create slide presentations. It is a graphic presentation program and can be used for printed presentations such as flyers as well. In this class we go over virtually everything you need to know to create a presentation. This includes setting up a master slide and template with its own color scheme and graphics such as a logo on each slide. We will create every kind of slide you can put in a presentation. We will also go over slide transitions and animation. You should be able to create your own presentation after this class.

Introduction to Word 
This class is designed make you comfortable with Word's menus, buttons and keyboard shortcuts. The fundamentals of creating a document such as: changing margins, line spacing, indenting, justification, page numbering, headers and footers are covered thoroughly, as well as saving and printing documents. In addition enhancing text and block commands are taught. This class will make the new user as productive as possible in a short period of time.

Intermediate Word 
This class is about going beyond the basics and enhancing the look of your documents. We start with setting specific Tabs instead of just using the pre-set Tabs. We will also explore methods to move and copy text. We will find and replace text. You will learn how to make Tables, Lines and Graphics. We will also go over Numbered Lists and Bullet Lists. If you know the basics and want to be more productive this is the class for you.

Advanced Word 
This class focuses on Mail Merge and Automation features, including Forms. We'll create a list of names and addresses and merge this list into a form letter, labels, envelopes, and create a report. We will also go over how to sort and print just selected records. The macros we create will be simple, but designed to help you save time. We will also create a fill in the blanks Form.

Private and individual training is also available for any of the programs listed above and for:
Accounting - A variety of accounting programs including Peachtree 2000, Peachtree Accounting Version 8 , 2002, 2003, 2004, 2005, 2006, 2007 and Business Works.
Database - Custom database creation and training for Microsoft Access.
Spreadsheet - Custom spreadsheet creation and training for Microsoft Excel
Word Processing - Assistance on projects including Mail Merge, Newsletters, and Brochures.
Scanning - Training on how to use Hewlett Packard scanners and the programs that come with them.