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.

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.

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

Begin building impressive presentations. Learn how to navigate through PowerPoint, add slides, create bulleted lists, copy text, print, rearrange slides and more. By the end of this class you will be able to create your own presentation.

Take your presentations to the next level. Learn to add graphics, customize slide backgrounds, animate your text and add sound effects. Insert graphs, charts and SmartArt, change your slide transitions and more. Prerequisite: PowerPoint 2016 Level 1 or a basic knowledge of PowerPoint

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.

Delve into the flashier aspects of website design. Work with forms and form data, add work with images, add pages, customize navigation links, and embed a video or music. Prerequisite: Website Design and Creation for Beginners: Level 1.

Learn how to create and maintain a professional-looking website using HTML and CSS. Discussion will include how to use text, graphics, borders, styles and hyperlinks; low-cost web hosts; uploading and downloading pages; and registering a domain name.Prerequisite: Windows and Internet basics.

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.