Technology Services Calendar
Tuesday, July 2, 2019
A properly designed database makes it easier to work with up-to-date, accurate information. Investing the time required to learn the principles of good relational database design ensures that you will end up with a database that meets your needs and can easily accommodate change. This new workshop provides guidelines for planning an Access database.
Monday, July 8, 2019
In this 2-hour workshop, participants will learn how to create and open InDesign documents, navigate the user interface, modify a document, import graphics, and manipulate basic text and text frames.
Tuesday, July 9, 2019
InDesign is a desktop publishing program that combines incredible power and flexibility with a surprisingly easy-to-use interface -- for creating or editing everything from simple posters and brochures to multi-chapter books. We will do the basics in this 6 hour class.
Wednesday, July 10, 2019
In this 6-hour course, you will import and export data into Excel 2016, work with conditional formatting, and learn about macros. Additional topics will include summarizing data using subtotals and data validation; and analyzing data using Goal Seek and Solver along with what if scenarios. Prerequisite: Completion of Excel 2016 Level 1 or equivalent knowledge
Extend your InDesign skills even further by learning to use InDesign's more advanced features effectively. We'll work more deeply with styles. You'll use clipping paths to reveal only part of an image, create type outlines, and create Bezier paths. We'll also import layered files, merge data into documents and create a book with table of contents and references.
Tuesday, July 16, 2019
Wednesday, July 17, 2019
This 6-hour course introduces the basics of Adobe Lightroom. Participants will work on the organization and management of photos, learning the Lightroom environment, managing images and workflow, reviewing images, sorting and organizing images as well as managing an image catalog.
Thursday, July 18, 2019
In this 3-hour course learn how to create and work with Access forms. Create a new form using the form wizard and explore layout and design view. Add and modify form controls including a calculated control and lookup control. Learn about control properties, form properties and setting tab order. Create a subform and learn about switchboard and navigation forms.
Lightroom Level 2 is the second course in Lightroom, utilizing the Develop module, to concentrate on making image corrections in a non-destructive manner. Topics include: Develop module basics, Image adjustment basics, working with color, fixing common image problems like straightening and cropping, as well as more advanced topics like creating snapshots and panoramas.
Friday, July 19, 2019
In this 2-hour workshop, participants will access, organize, and share creative assets for use in your Adobe desktop and mobile apps. We will practice using Adobe’s CC Libraries in applications as well as using the Web interface to load frequently used assets, such as logos, wordmarks and colors. We will explore sharing and collaborating with colleagues.
Monday, July 22, 2019
In this 2-hour short course you will learn how to comfortably move around in the Excel 2016 environment. Additional topics will include entering text and values in a worksheet, basic formatting, printing and using Help.
Tuesday, July 23, 2019
This 3-hour class introduces the query object. Topics include working in design view; creating a simple query by adding and removing fields and adding criterion. We will create multi-table queries; calculated fields and set field properties; explore a totals query, parameter query, action queries, find duplicates query, unmatched records query and basic SQL query.
In this 2-hour workshop, participants will learn how to create and open Illustrator documents, navigate the user interface, use vector shapes to create a logo that looks good on screen and in print. No prior knowledge of Illustrator is required.
Attendees will become familiar with the Outlook 2016 calendar interface (including the enhanced Ribbon tools). You will also learn how to schedule and edit an appointment; work with calendar labels and tasks displayed on the Calendar. We will schedule meetings with the Scheduling Assistant and practice scheduling a conference room.
This six-hour course is intended for Mac users who want to learn basic Word 2016 skills such as creating, editing, and formatting documents; working with tabular text; and employing a variety of techniques for improving the appearance and accuracy of document pages. Finally, we will learn about printing documents.
Wish you had a smarter, more efficient way to arrange your Outlook 2016 email and more? In this two-hour workshop, you will learn how to use the conversation view; how to insert a screenshot into a message; sorting messages; advanced searching techniques, including filters; working with folders; using flags, color categories, and rules.
Wednesday, July 24, 2019
In this 2-hour workshop, participants will learn the basics of using the drawing tools in Adobe Illustrator CC, including how to use the Pencil and Curvature tools, how to edit paths. Then we will look at layers, including how to create, edit, and organize content. We will also learn the basics of transforming and editing artwork in Adobe Illustrator CC.
Thursday, July 25, 2019
In this 2-hour short course you will learn how to add, divide, multiply, and subtract by entering formulas into Excel 2016 worksheets. Other topics will include an exploration of just a few of the hundreds of functions available in Excel. We will learn how to find a specific function, as well as how to get help while entering arguments.
In this 2-hour workshop participants will learn how to use Photoshop to do basic photo correction, use selection tools, manipulate, save, and store images. No prior knowledge of Photoshop is required.
Monday, July 29, 2019
Tuesday, July 30, 2019
This 6 hour course will prepare you to use the most common basic features of Adobe Photoshop CC.
Wednesday, July 31, 2019
In this 2-hour workshop we will explore the whole set of features for managing information in tables in Excel 2016. These features make all the typical tabular manipulations—sorting, filtering, analyzing, and formatting, easier than ever.
Thursday, August 1, 2019
In this short course you will learn how to use some of the data analysis features and tools in Excel 2016. Topics will include learning the basics of PivotTables; using subtotals in a list of data; setting up data validation rules; using Goal Seek, Solver, Scenarios and more.