#001088: Access 2007 I
Microsoft Access 2007 is a database management system that assists in the creation of a relational database to satisfy the diverse data-tracking needs of an organization. This first workshop in a three-part series introduces the new Access 2007 interface and explores objects in an existing database. It also demonstrates the design of a new database and the creation of tables and field definitions that will be used for the remainder of the workshop.
#001089: Access 2007 II
Microsoft Access 2007 is a database management system that includes a collection of logically related data that can be organized and accessed quickly. This second workshop in a three-part series covers importing data from various external sources and creating relationships among database objects that will ensure the integrity and accuracy of the data when requesting information. Several types of queries are examined; from a simple selection of a field to complex conditional statements as well as calculations and aggregates.
#001090: Access 2007 III
Access 2007 is a database management system that is used to view and manipulate data in various formats to aid in the decision making process. This third workshop in a three-part series demonstrates the use of forms to enter, edit, or display data from tables or queries and shows how data can be summarized and manipulated by generating various reports. Using data from Access to create MS Word letters and labels, exporting data from Access into Excel and Word, and converting data from different versions of Access are also discussed.
#001667: Access 2010 I
Microsoft Access 2010 is a series of three workshops that covers planning, creating, modifying and managing a database. This first workshop in the series is a four-hour, hands-on workshop that introduces the new Access 2010 interface and explores objects in an existing database. Participants will plan, create, and format tables and field definitions for their own database. Participants will also import data from various external sources including an excel spreadsheet and a word document.
#001668: Access 2010 II
This second workshop in the series is a four-hour, hands-on workshop that builds on the concepts from the first workshop. Participants will create relationships among database objects that will ensure the integrity and accuracy of the data when requesting information. Participants will also create several types of queries with criteria, conditions, and calculations that range from simple to complex.
#001669: Access 2010 III
This third workshop in the series is four-hour, hands-on workshop that builds on the concepts from the two previous workshops. Participants will create forms to enter, and edit information. Participants will create reports to organize and display their information. Participants will also export data to, and convert data from, various external sources including an excel spreadsheet and a word document.
#000183: Calendar I
Calendar is used to enter online appointments, meetings, tasks and notes. Calendar allows users to view an agenda as an individual, group, or a designated user. The first workshop in this two-part series includes logging into the Calendar application, managing your individual agenda calendar, inviting people to meetings, managing online and offline passwords, and setting meeting reminders.
#000051: CFS Creating Requisitions
Creating Requisitions will cover basic navigation skills, creating an online requisition, creating a blanket requisition and modifying a requisition. This class includes canceling and deleting a requisition and submitting it to the approval process.
#000174: CFS Inquiry
The Inquiry class includes viewing your budget and budget transactions online using Web Financials. Also included are viewing requisitions, purchase orders and balances, suppliers, invoices, and payments in CFS.
#001097: Dreamweaver CS3 I
Adobe Dreamweaver CS3 is a Web page authoring program that is offered in a two-day workshop series. Day one covers a variety of topics such as: general webpage terminology, planning a site, the Dreamweaver interface and panel components, defining a local site, inserting and formatting text and images, previewing a page in a browser, creating various types of links, using and formatting tables.
#001098: Dreamweaver CS3 II
Day two covers topics such as: creating additional web pages, creating and using Cascading Style Sheets, creating and using templates, testing a site using the various site management tools, and publishing a site to a remote server.
#001129: Intro to Excel 2007 I
Excel 2007 is a three part series that covers planning, creating and editing a spreadsheet. It also covers entering formulas and functions to perform basic calculations. The second part of the series covers formatting the spreadsheet. This includes visual formatting as well as cell number formatting. The third session covers creating, editing and formatting charts to graphically display data, and much more!
#001130: Intro to Excel 2007 II
Excel 2007 is a three part series that covers planning, creating and editing a spreadsheet. It also covers entering formulas and functions to perform basic calculations. The second part of the series covers formatting the spreadsheet. This includes visual formatting as well as cell number formatting. The third session covers creating, editing and formatting charts to graphically display data, and much more!
#001131: Intro to Excel 2007 III
Excel 2007 is a three part series that covers planning, creating and editing a spreadsheet. It also covers entering formulas and functions to perform basic calculations. The second part of the series covers formatting the spreadsheet. This includes visual formatting as well as cell number formatting. The third session covers creating, editing and formatting charts to graphically display data, and much more!
#001209: Intro to Office 2007
This is a three-hour, hands-on overview that introduces the new interface for Microsoft Office 2007. During this session, the participants will use the ribbon and tabs (which replaces menus and toolbars) to create and edit documents in Word, PowerPoint, Excel, and Access. The overview is designed to help users identify where to find the most commonly used features and highlight some of the additional elements of the software. Outlook and Publisher are NOT included in this workshop.
Prerequisites: None.
#000319: Photoshop CS2
Participants will fix a photo by rotating, sizing, cropping, removing red eye and using an automated quick fix tool. They will save images and optimize them for web viewing. Participants will work with image layers and use them to keep the original image intact while making edits. They will customize edits and enhancements to photos by modifying the shadows and highlights, removing scratches and imperfections, and fixing coloring issues. They will also make artistic enhancements by adding a filter to a selected area of an image, inserting and adding effects to text on an image, and adding a virtual frame effect to an image.
#001289: PowerPoint 2007
PowerPoint 2007 is used to create dynamic presentations that can include text, pictures, clip art, digital media, charts, tables, and SmartArt graphics. This upgraded version has a new Ribbon interface that uses task-oriented tabs to group related commands. PowerPoint's new galleries of themes, styles, layouts, table formats, and effects make it easier to apply consistent formatting throughout your presentation. In class we'll be creating a short presentation that includes several of these options along with text animation and slide transition. We will also use the spellchecker, re-order slides in the presentation, and import slides from another presentation.
#001603: PowerPoint 2010 I
PowerPoint 2010 is used to create dynamic presentations that can include text, digital media, tables, and charts. PowerPoint I is the first class in a two part, 8 hour series. This first four-hour, hands-on workshop introduces the 2010 version of PowerPoint. Participants will create a presentation and apply themes; add, duplicate, delete, and format slides; insert text, pictures, clip art, screenshots, shapes, tables, Excel charts, audio, video; and import slides from another presentation. You are required to attend PowerPoint 2010 I before attending PowerPoint 2010 II.
#001604: PowerPoint 2010 II
PowerPoint II is a four-hour, hands-on workshop and is a continuation of PowerPoint I. It focuses on customizing a presentation. Participants will add slide transitions, animations, and backgrounds; use spell check, different slide views; view various printing options; move and hide slides; and save the presentation in multiple formats such as a show, PDF, kiosk, video, package for CD, and handouts in Word. PowerPoint 2010 I is a pre-requisite for PowerPoint 2010 II.
#000114: Publisher XP 1
Introduction to Publisher 2002 is a two-session class. The first day focuses on creating a publication using the Quick Publication templates provided by Publisher. We will edit a Quick Publication flyer by adding text and content as well as deleting and modifying pictures, tables and text boxes. We will save the publication as a Publisher file and an image file and send it as an email message. We will also cover the mail merge feature!
Who should attend: Users who want to create documents such as newsletters, flyers, or brochures.
Due to the design of this series, it is strongly recommended that you register for both workshops.
#000162: Publisher XP 2
Introduction to Publisher 2002 is a two-session class. On day two, we will create a publication from scratch and design and save a reusable template. We will cover features such as: using master pages, inserting text from a Word document, linking text boxes, creating and using styles and much more!
Who should attend: Users who want to create documents such as newsletters, flyers, or brochures.
Due to the design of this series, it is strongly recommended that you register for both workshops.
#001054: Technology Literacy Guide
This Technology Literacy Guide includes user-friendly, self-paced training materials that address the technology literacy competencies for Maricopa employees. Topics include: Administrative Regulations, Administrative Systems, Electronic Communications, Desktop Management, Desktop Applications, Supervisor Approval Processes.
#000056: Visio
Visio is an easy-to-use graphics application especially suited for creating business graphics. This workshop concentrates on creating flowcharts and organizational charts.
#001290: Word 2007 Creating Forms
This is a three hour, hands-on workshop that demonstrates the features used in creating a form.
Prerequisites: None.
#001165: Word 2007 Document Layout
This is a three-hour, hands-on workshop that introduces the new Word 2007 interface and demonstrates the features used to format and design a document. Most of the formatting elements are stored on the ribbon and tabs, which have replaced the menus and toolbars. Participants will learn where to find the most commonly used features to format and align text. Themes, colors, and style sets will be used to demonstrate the latest formatting choices for text, tables, and images. Page and section breaks will be used to demonstrate how to switch pages from portrait to landscape in the same document. Headers and footers will be used to demonstrate page numbering options.
#001166: Word 2007 Mail Merge
This is a three-hour, hands-on workshop that introduces the new Word 2007 interface and demonstrates the features used to create a mail merge. Participants will learn to import data from an Access database, Excel spreadsheet, or a Word document and merge it to create letters, envelopes, and mailing labels. Rules for adding decision making ability to the mail merge will also be discussed.
#001605: Word 2010 Concepts
This is a three-hour, hands-on, stand-alone workshop that introduces the new Word 2010 interface and demonstrates the basic features used to create a document. There are minor differences between Word 2007 and Word 2010. Participants will open a new and existing document; convert a document to a different version; set up tabs, page margins and orientation; select, cut, copy, paste, and align text. Participants will also apply themes, colors, styles, and other features to format text, tables, and images.
#001608: Word 2010 Creating Forms
This is a three and a half (3.5) hour, hands-on, stand-alone workshop that introduces the Word 2010 interface and demonstrates the features used to design and create a form. There are minor differences between Word 2007 and Word 2010. Participants will plan, create, format, test, distribute, and extract a form. Participants will also customize the Ribbon to enable the controls used to create a form. Participants are required to have basic computer skills (including selecting and formatting text, etc.) before attending this course.
#001606: Word 2010 Document Layout
This is a three-hour, hands-on, stand-alone workshop that introduces the new Word 2010 interface and demonstrates some advanced features used to create professional documents. There are minor differences between Word 2007 and Word 2010. Participants will create page, section, and column breaks; change the page orientation from portrait to landscape in the same document; insert page numbers, headers and footers; add a table of contents, index, and track changes in a document. Participants are required to have basic computer skills (including selecting and formatting text, etc.) before attending this course.
#001607: Word 2010 Mail Merge
This is a three-hour, hands-on, stand-alone workshop that introduces the Word 2010 interface and demonstrates the features used to create a mail merge. There are minor differences between Word 2007 and Word 2010. Participants will merge data from a Word document, an Excel spreadsheet, and an Access database to create letters, envelopes, and mailing labels. Participants are required to have basic computer skills (including selecting and formatting text, etc.) before attending this course.
#001168: Word PowerPoint Overview
This is a 90-minute, hands-on, overview that introduces the new interface for Word and PowerPoint 2007. During this session, the participants will use the ribbon and tabs (which replace menus and toolbars) to format a flyer, edit a report, and design a slide show. The overview is designed to help users identify where to find the most commonly used features and highlight some of the latest features that have been added to this version of the software.
Prerequisites: NONE