Wednesday, September 22, 2021
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 online workshop provides guidelines for planning an Access database.
In this 2-hour short course you will learn how to add, divide, multiply, and subtract by entering formulas into Excel 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.
Tuesday, September 28, 2021
Join us in a live, online session using OneNote 365 where we will discuss the structure of notebooks, practice putting data into them, and explore the interconnectivity of Microsoft applications with OneNote. This session is aimed for beginner users of OneNote.
This 2-hour online class introduces the Access 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, and action queries.
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.
Wednesday, September 29, 2021
We have many options for scheduling online meetings these days. We will use Outlook for a central place to keep track of several kinds of online meetings and to make sure we have reminders. We will look at recommendations for scheduling with Skype for Business, Zoom and Microsoft Teams.
In this 2-hour online workshop, you will learn how to select data in an Excel worksheet and work with Chart tools to customize the chart type, chart layout, and chart style that best represents the selected data. Once the chart is exactly the way you want it, we will learn how to save it as a template to use again.
Thursday, September 30, 2021
In this 2-hour online class, learn how to create a basic Access report, and explore layout and design view. In design view add controls and set properties for those controls; learn about calculated controls, apply sort & group feature to report data, finish up with graphics (themes and conditional formatting).
Microsoft Teams is a communications tool available through MS Office 365. During this two-hour online workshop, we will learn how to navigate the Teams environment and communicate with others in Teams. We will practice participating in online Teams meetings, and discuss sharing screens and files during meetings. We will create a team and channels.
Tuesday, October 5, 2021
During this two hour-long session, we will go over the basics of the Photoshop interface and some resources on how to continue learning features. Instructor will point out her favorite beginner tutorials and resources. Q & A to follow