ACCESS: Getting Started
• Relationships
• Creating a database
• Working with tables
• Designing select queries
• Field properties
• Working with criteria

ACCESS: Beyond the Basics
• Queries: Total and make tablequery; append, delete and update query
• Working with expressions
• Adding expressions in Access
• Exporting data: Creating a text only file, creating a workbook
• Importing files: Importing text only files, linking to a worksheet

ACCESS: Fine Tuning
• Form development
• Building a form from blank
• Report design window, adding a label object, changing label properties, adding a field, control source property
• Use a wizard to build a form

AUTOMATING YOUR ACCESS DATABASE
• Working with Switchboards
– Creating, command buttons, label buttons,
control tip text
• Creating Macros
• Creating Lookup Fields
• Lookup tables
• Creating Tables through Linking

EXCEL: Getting Started
• Definitions
• Navigating a worksheet
• Some file maintenance in Excel
• Selecting and formatting ranges
• Moving & copying cells
• Inserting and deleting rows & columns
• Text boxes, borders & shading
• Freeze panes, splitting the workbook

EXCEL: Beyond the Basics
• Working with formulas: Relative versus absolute references, references across sheets, external references
• Sheet dynamics: Changing sheet names, moving and grouping sheets, manipulating toolbars, protecting sheets
• Functions: Vertical lookup and others

EXCEL: Fine Tuning
• The nature of MS graph
• Building pie charts
• Building column charts
• Database features: Sorting, Filter with AutoFilter

EXCEL: Advanced
• Macros: recording, running & deleting
• Charting: custom, special effects, pivot tables

WORD: Getting Started
• The parts of the Word screen: Toolbars, status bar and views; file maintenance; nonprinting characters, moving insertion point; inserting, overtyping and deletion; selecting text, copying and formatting
• Text and document level
• Print preview and print
• Working with the rulers
• Setting tabs, text effects

WORD: Beyond the Basics
• Manipulating toolbars
• Creating and applying styles
• Making and using templates
• Adding bullets
• Page and section breaks
• Headers and footers
• Columns: Establishing, snaking, parallel
• Tables
• Using tables to establish parallel columns

WORD: Fine Tuning
• Working with graphic objects
- Adding, moving, sizing & deleting
• Adding clip art and pictures
• Using WordArt & text box
• Mail merge: main document, data source using Access

POWERPOINT: Getting Started
• Terms and definitions
• Auto layouts, adding slides
• Adding and manipulating text objects
• Adding and manipulating shapes, clipart & bullets
• The different views

POWERPOINT: Beyond the Basics
• MS Graph
• Pie Charts, Column charts
• Slide master
• Object linking & embedding

QUICKBOOKS: Getting Started
• Setting up a company
• Working with lists
• Setting up inventory
• Creating invoices
• Processing payments
• Making payments
• Working with bank accounts

QUICKBOOKS: Beyond the Basics
• Using sales tax in QuickBooks
• Using payroll tracking
• Setting up employee payroll information
• Writing a payroll check
•Tracking your tax liabilities
• Paying payroll taxes
• Creating job estimates

QUICKBOOKS: Fine Tuning
• Customizing forms
• Using QuickBooks accounts
• Creating reports
• Creating QuickReports
• Exporting reports to Microsoft Excel
• Creating QuickInsight graphs
• Customizing and printing graphs

Office 2007--What's New?
• New user interface in Office 2007
• How the "ribbon" replaces the menu and toolbars
• Pre-formats, themes and quick styles
• Saving to new file formats, like xml, for more compatibility