Opening and closing a database, opening and closing tables, creating and editing tables, primary key, fields (adding, moving, and deleting), records (adding, editing, sorting), working with forms and reports, and creating queries.
Customizing forms, advanced controls (drop down lists and combo boxes), creating subforms, calculations in forms and reports, importing data from outside sources, grouping data in reports, charts, creating a switchboard form using macros and buttons, linking access table with a form letter (mail merge).
Worksheet basics, entering data and text, selecting, editing, and formatting cells, copy, paste, and fill techniques, basic formulas and functions, printing and chart basics.
Large worksheet techniques, sorting, multiple worksheet views, printing options, templates, Wordart, clipart, linking data between sheets, range names, Excel database functions, searching data, PivotTables, and PivotCharts.
Lookup functions, custom templates, basic macros, building scenario sheets, consolidate data, If functions, comments, hyperlinks, importing data from other sources and tracing changes.
Slide preparation and design, bullets, adding and deleting slides, rearrange slides,
AutoContent Wizard, running slide shows, working with slide outline view, printing, ClipArt,
WordArt, create transitions, timings, sounds and animation, text boxes, and delivery.
Working with charts, tables, organizational charts, online presentations compare and merge presentations, creating templates, program buttons, and on road presentation discussion.
Document basics such as creating and navigating documents, selecting, editing, and formatting techniques, inserting symbols, creating flyers, working with tables, printing and saving documents.
Creating a newsletter, clipart, columns, creating and modifying styles, using outlines, text flow options, navigating long documents, creating table of contents and indexes.
Mail Merge, advanced table techniques, Excel Integration, comments, track changes, creating multiple versions of a document/macros/ forms.