Create a custom form in Access

 A customized data entry form not only encourages accuracy for data entry, but it looks better and can provide more functionality with push buttons to print a record, add a record, etc. A logo can be incorporated into the design. Many of the features are quickly done so the video doesn’t run TOO long – it can be a bit tricky in the beginning as you have to observe the shape of the mouse when doing certain actions.

Using the “stack” function in design view is critical when moving fields around the sheet. Take it slow and you’ll do great. It is not an instant function when customizing.

Advertisements

Definition of Success

80% of success is being on time.  (Woody Allen)

Create a table in Excel

Excel tables are relatively simple to create yet can provide powerful methods of analyzing data. Filter data, get statistics, obtain totals, and format the table in minutes.   This example has been used in classes to demonstrate its many features.

Elements 2018 – remove a photo bomb (and more)

Photoshop Elements 2018 has about the same features…and then some! of the Photoshop of not so long ago.  Best thing….you can OWN it…not rent…in a few months you’ll be ahead of the game.  Retouch a photo using layers, quick selection tool, cloning, healing brush, and a few extra features so you can turn a photo with improper exposure or delete someone (or something) who “bombed” your photo.

Adjust exposure in photo using layers in Photoshop or Elements

Done in Creative Cloud, the skills apply to newer versions of Elements. Using layers and the quick selection tool, a backlit photo’s over and under exposure is fixed so it has a natural look.

The quick selection tool becomes much easier with practice.

Fall 2018 Continuing Ed classes

Classes starting this fall include many topics including:
click here for full schedule

To work with your schedules, sessions are offered both evenings and afternoons

A summary of classes offered:

• Adobe software including
  • Photoshop Elements (Stamford)
  • Photoshop in Adobe Creative Cloud (Yonkers library)
  • InDesign (Yonkers library)
• Social Media including methods on protecting your privacy.
• Create a facebook page for your business or nonprofit
• MS Office – Excel, Word, PowerPoint, with special classes on Excel pivot tables and charts
  Students can now bring their own fully charged laptops to hands-on sessions. Classes are taught on PCs, instructor is familiar with Mac. 
• Buying and selling on eBay
• Android and iPhone/iPad
• Optimizing your Windows 10 computer

Looking forward to seeing you starting in September!

 

 

 

 

 

Import text from Word into PowerPoint Slides

Import slide from Word outline to PowerPoint

If you set up a Word file correctly with styles (heading 1, 2, 3), the file will import fairly nicely into a PowerPoint.  Much faster than copy/pasting umpteen times, a few shortcuts on getting fonts/colors to match is included.

Most instructions do not include the details that are reviewed – it does not always go in perfectly.

Excel 2016 – create a forecast with goal seek

Creating and planning a forecast on nearly any product or service is often accurate guess work as you’re looking at previous/current conditions, future trends. Unfortunately as we don’t have a crystal ball, we don’t really know what the future may bring! (kind of like being a weatherman).

Now you’ll be prepared when you go on Shark Tank with your next big greatest invention!

This video demonstrates goal seek, very basic formulas including absolute references in addition to fine tuning its appearance and moving/hiding data.