An intro to Access and Relational databases: Design considerations, Purpose of Relationships, Access Objects & their specific functions
Review of the Access window, User tools for tables and forms, Sorting, Filtering, Exporting and Emailing
Advanced Formatting Options, Format Painter Tool, Themes, Styles and A-ha! tips
Absolute Cell References, If Statements, Janet's Favorite Formulas and Paste Special Applications
Links, Comments and Notes, Hiding and Unhiding Rows/Columns/Sheets, Macros
Automatically format cells based on their values or their value in relation to other cells
File Protection Options, Locking Cells and Protecting Spreadsheets, Data Validation
Managing, Printing and Linking Multiple Worksheets
Inserting, Changing, and Formatting Shapes and Objects in Microsoft Office Applications
Inserting Fields, Options for Different Headers and Footers, and Janet's favorite: Saving YOUR Header or Footer to the Gallery
Topics Include: Merging to Letters, Envelopes, Email and Labels
Understanding the incredible value of Styles, Applying Styles and Themes, Using the Navigation Pane, Creating a Table of Contents (automatically)
Creating and Using a Table in Microsoft Word
Format Tools and Format Painter, Line and Paragraph Spacing, Line Indent Tools, File Name and Path Fields, and LOTS of Keyboard Shortcuts
Techniques and Tools to Improve Focus - Easy to Understand, Easy to Implement
Tools and techniques to help you have Better Meetings
SO MANY Tips & Tools with Desktop, Start Menu, Taskbar, File Explorer. PLUS Pinning, Snapping, Jump Lists & Using Task View
Topics include: Steps to Create, Formatting Text, Using Styles, Inserting and Formatting Pictures and Shapes plus lots of A-ha! tips
Creating an electronic form using Microsoft Excel
Creating an electronic form using Microsoft Word