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 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

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.