Office Applications   

Find out how easy it is to put this dynamic relational database management software to work for you. Learn the fundamentals of the Access user interface, along with database basics such as creating, saving, closing and opening an Access database. Learn how to create simple tables, with emphasis on understanding data types, field sizes and field properties. You will also learn how to create simple forms, select queries and reports from the tables you create.

Understanding relationships between objects in an Access database is vital. Learn how to develop and create relationships between tables and how to use these relationships to develop simple and complex queries.

Queries are a way of searching for and compiling data from one or more tables. Learn how to build and run a query by asking detailed questions of your database. Find specific data quickly by filtering criteria (conditions), calculate or summarize data and automate data management tasks, such as reviewing the most current data on a recurring basis.

Learn how to create useful forms to better manage your database. Create forms in design view containing option buttons, check boxes, combo boxes and list boxes. Learn to customize the tab order in forms, add form headers and footers and use Format Painter and AutoFormat to make formatting easy. Also learn how to create a switchboard to manage all your forms.

Spreadsheets are essential in today's workplace. Discover the fundamentals that will help you succeed. Explore the Excel Interface, Distinguish between various mouse pointers, employ efficient worksheet navigation, enter labels/values, edit and format a worksheet and even get an introduction to formulas.

Spreadsheets are essential in today's workplace. Discover the fundamentals that will help you succeed. Explore the Excel Interface, Distinguish between various mouse pointers, employ efficient worksheet navigation, enter labels/values, edit and format a worksheet and even get an introduction to formulas.

Large excel spreadsheets can quickly become difficult to translate. Learn to communicate information visually with the use of Excel Charts. Explore and fine-tune your chart elements with ease. Learn to manage workbooks, exploration of special formatting, advanced page layout and printing features. Also get an introduction to Excel functions to prepare you for Excel III & IV.

Large excel spreadsheets can quickly become difficult to translate. Learn to communicate information visually with the use of Excel Charts. Explore and fine-tune your chart elements with ease. Learn to manage workbooks, exploration of special formatting, advanced page layout and printing features. Also get an introduction to Excel functions to prepare you for Excel III & IV.

Review basic building-block functions and a few critical keyboard shortcuts that will speed up working with Excel data. Perform advanced searching and data retrieval with Lookup Functions, tabulate and sort data with counting and statistical functions, formulate data with text and math functions, and even work with financial data using advanced formulas. Practical examples that will help you transition to using these formulas and functions in real-world scenarios will be provided.

Learn even more advanced way to use Excel Pivot table reports! Find out how to use the PMT Function, Create What-If Data Table, Solve a Problem with Goal Seek, Use Solver to Resolve Problems, Create Lookup Functions, Create PivotTables and PivotCharts, and Use the PivotTable Field List.

Learn even more advanced way to use Excel Pivot table reports! Find out how to use the PMT Function, Create What-If Data Table, Solve a Problem with Goal Seek, Use Solver to Resolve Problems, Create Lookup Functions, Create PivotTables and PivotCharts, and Use the PivotTable Field List.

Learn how to use Microsoft PowerPoint to create impressive slide presentations filled with formatted text, images, video, audio, animation, charts, and hyperlinks. Find out how to save your presentations so you can share them with others over the Web or on CDs.

Learn how to add effects, features and charts in Microsoft PowerPoint to enhance your current presentations. Delve deeper into PowerPoint's rich features by exploring many text options such as adding pictures and charts, using SmartArt, Custom Animations and adding sound/movie clips. We will also learn about slide masters, content slides and action buttons while creating a non-linear presentation.

Learn how to add and edit text; move words from one part of your document to another; work on two or more documents simultaneously; change the size or appearance of text; change margins and tab settings; automatically center, right align, justify, and indent text; run the integrated grammar and spell check; use the thesaurus, and save, retrieve, copy, organize, and more.

From Headers and Footers to timesaving formatting techniques, this course brings a lot to the table. This course explains each of the following features; Creating Hyperlinks, Page Breaks, Indents and Spacing, Margins, Setting Tabs, Formatting Tables, ClipArt, Pictures and Shapes. Whether new to Word or wanting to learn new techniques, gain insight for increased productivity and professional-looking documents with Microsoft Word.

Learn to create date and text filters for viewing information more efficiently. Learn how to use subtotals, a powerful analyzing tool, and more for filling/copying data more efficiently. This class also serves as a formal introduction to formulas and functions, so you will walk away knowing how to create formulas and copy them correctly using relative and absolute referencing. Use statistical functions (Sum, Average, Min and Max) and logical functions (If, And, Or) and paste special options.

Learn to create date and text filters for viewing information more efficiently. Learn how to use subtotals, a powerful analyzing tool, and more for filling/copying data more efficiently. This class also serves as a formal introduction to formulas and functions, so you will walk away knowing how to create formulas and copy them correctly using relative and absolute referencing. Use statistical functions (Sum, Average, Min and Max) and logical functions (If, And, Or) and paste special options.