Minnetonka Community Education

Create a database from scratch using Access, Microsoft’s relational database management program. Learn how to define a primary key and set attributes of fields to ensure accuracy of data. Build a data entry form. Create reusable queries and queries that perform calculations. Customize reports to summarize data. Learn the basics of setting up relationships between tables.

Work with a database with multiple tables. Import data and fix import errors. Set up table relationships and build a junction table. Create advanced types of queries: Append, Update, Make Table and more. Use the IF function and aggregate functions in queries. Build forms with subforms and reports with grouping levels. Add navigation buttons and search boxes to forms.

Explore pivot tables and charts in depth and build dashboards using the results. You will learn how to set up your data to take full advantage of pivot tables and charts and avoid problems. Learn how to format data, work with more than one field in the values area, pivot fields, add simple and complex calculated fields, create calculated items, build and format a custom dashboard, add slicers and more.

Gain a solid understanding of the basics of Excel, a powerful spreadsheet application. You will learn how to navigate around in Excel; use the Ribbon to issue commands, insert, delete, rearrange and rename worksheets. You’ll also learn to enter data, delete and replace cell entries, work with number and text formatting, cut/copy/paste/move entries, format worksheets and apply borders and fills to cells. By the end of class you will also be able to print, save and close your workbook for easy retrieval.

Expand your Excel skills to work with formulas and functions, modify and copy formulas, and create formulas with the IF function. This hands-on course will help improve your work productivity. You will also learn how to manipulate worksheets, format/hide columns and rows and create/size/move charts.Prerequisite: Excel 2013: Level 1 or basic knowledge of Excel.

Explore the capabilities of this free web based word processing and spreadsheet tool. The benefits of Google Drive include the ability to share and edit in real time with others.

Begin building impressive presentations. Learn how to navigate through PowerPoint, add slides, create bulleted lists, copy text, print, and rearrange slides. Add photos, charts, and SmartArt. Customize slide backgrounds, animate your text and add slide transitions, video and sound.

Learn how to navigate through the Photoshop screens and palettes; how to use tools including selecting, cropping, moving and rotating; and work with layers. This class is for all versions of Adobe Photoshop CS and Adobe Photoshop Elements. The lab has Elements installed, but the steps are virtually identical for both versions. The books contain screenshots (and directions) for both CS and Elements. Students wishing to bring their laptops with CS are welcome. Prerequisite: Windows

Begin working more extensively with photo repair and touch up. Gain more experience working with layers and text as well as the Levels and Clone Stamp tools. This class is for all versions of Adobe Photoshop and Adobe Photoshop Elements. The lab has Elements installed, but the steps are similar for both versions. Students wishing to bring their laptops with CS are welcome. Prerequisite: Photoshop Elements 1

Learn to set up a company, add customer data, vendor information and banking accounts. Create custom invoices, enter and pay bills, setup and use owner’s draw and capital investment accounts, create a budget and profit and loss reports. The course does not include instruction for the online version of QuickBooks.

Learn how to use voice recognition software on your computer and the commands your “new assistant” needs to do its job. Voice recognition is a great way to complete tasks if you don't know how to type or are facing health issues which make it difficult to enter information.

Discover how to use the basic functions of Word to increase productivity. Topics covered include menu bar, margins and orientation, cut, copy, move, paste text, create envelopes, print and more.

Learn to utilize Word’s editing and proofreading tools. We will cover how to create custom tab stops, mailing labels and custom letters. We will also learn how to use bulleted and numbered lists, create and work with tables and more. Prerequisite: Word 2016: Level 1 or basic knowledge of Microsoft Word 2016.