Minnetonka Community Education

Getting the tables and relationships set up correctly is critical when designing a database, or modifying and understanding an existing one. Learn about table properties, field formatting, input masks, validation rules, and captions. Primary and foreign keys, and the roles they play in setting up relationships, will also be covered. One-to-one, one-to-many, and many-to-many relationships will be explored, as well as setting up quick entry forms for data input. 

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.

Learn how to plan and create your very own blog and podcast. Through hands-on exercises, you will discover the benefits of using free web tools like Blogger, WordPress, Audacity and YouTube. Click here to register for this online course Do not use the Enroll Now ButtonIf you have any questions or difficulty registering please contact the Program Manager for Adult Programs at 952-401-5055

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, create formulas with the IF and VLookup functions, and get started with pivot tables. This hands-on course will help improve your productivity.You will learn how to manipulate worksheets, format/hide columns and rows, insert subtotals and use Excel’s database tools to manage data. Prerequisite: Excel Level 1 or basic knowledge of Excel.

Learn the fundamentals of web development. You will explore how to use software that creates web pages, as well as learn the basics of HTML and CSS.  Our goals for this course are to understand how to use the software that creates web pages, create a well-structured HTML document, style that document with CSS, and validate that the code is meeting widely accepted standards. In this course, we will learn about the following: What software is used to create web pages How to setup HTML documents and use basic HTML tags How to use CSS to style HTML documents How to comply with web standards and code validation

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 the ins and outs of Microsoft's powerful desktop publishing software. After a general overview of Publisher, we'll create a 4-page newsletter, working with columns, pull quotes, drop caps, graphics, photos, borders, shading, table of contents, and more. Many of these skills can then be applied to flyers, brochures, cards, invitations, certificates, calendars and more. 

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.

Discover how to use the basic functions of Word to increase productivity. Topics covered will 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 mailing labels and custom letters and emails using Mail Merge. We will also learn how to use headers and footers and section breaks, create, modify and format tables, insert columns and rows, apply borders, and more.Prerequisite: Word 2016: Level 1 or basic knowledge of Microsoft Word 2016.