crystal (strive4peace) - Microsoft MVP, Access
Remote Training and Programming
Member Since: 2015/11/13
Industry: Consulting
Top Skills:
Tech Certifications:
View All
Sage
Freelancer
Consultant
Connect on Live
Hire

Love empowering people by teaching and helping them develop applications.

More bio
Activity
Points this month41,934
Total points838,566
Questions: 7
Solutions: 563
Articles:
Videos: 5
Courses:
Live: 4
Professional Background
Remote Programming and Training
MS Access Gurus
anywhere
I connect with you and help develop solutions in Access, Excel, Word, PowerPoint, Camtasia, and more.
More
Education
Colorado School of Mines
BSc.
Petroleum Engineering
1977 – 1983
More
Languages
English
Full Professional Proficiency
Norwegian
Elementary Proficiency
Arabic
Elementary Proficiency
Full Biography

Teacher and Developer.  I have been programming and teaching people how to use and build PC applications for 3 decades with my current focus building applications in Access that share with Excel, Word, PowerPoint, Outlook, and other Microsoft Office applications. Create videos with Camtasia and edit audio with GoldWave.  Create layouts with HTML, XAML, and Word style sheets. I teach as we work together, which is one of my favorite things to do -- love empowering others and being appreciated.  Connect to me, let's build it together. You can contact me here on EE, or:

email: crystal@msAccessGurus.com
phone: 303-335-0727

BSc. in Petroleum Engineering and through the years have gotten to know about data in many other areas too.  Like to teach and program and do both at the same time by connecting to you and team-developing together.  Specialize in desktop applications.  Have written hundreds (maybe thousands) of applications in various languages ... BASIC, FORTRAN, Pascal, C, C#  …VBA, the language used by Microsoft Office applications, is my favorite since it is what I know best.

My passions include songwriting and singing, playing piano, gymnastics, diving, bike riding, photography, animals, and children.  I admire creativity in all forms ... art, sculpture, woodwork, metalwork, music, dance, story telling, theater, .... bird nests, beaver dams, ... there is so much beauty everywhere. I even admire the slick talkers who lie through their teeth for being so quit-witted and charming.  Most of all, I place importance on kindness and appreciation.

I have 5 video tutorials on Experts Exchange:

Access:
Create a Query and Grouped Report and Modify Design using Access
https://www.experts-exchange.com/videos/4514/Create-a-Query-and-Grouped-Report-and-Modify-Design-using-Access.html

Polish Reports in Access
https://www.experts-exchange.com/videos/4559/Polish-Reports-in-Access.html

VBA:
1. basic error handling code for VBA (3:48)
http://www.experts-exchange.com/videos/1478/Excel-Error-Handling-Part-1-Basic-Concepts.html

2. Loop through rows of an Excel spreadsheet using VBA (6:00)
http://www.experts-exchange.com/videos/1498/Excel-Error-Handling-Part-2-VBA-to-Copy-Values-Down-to-Blank-Cells-in-an-Excel-Column.html

3. Error Handling Part 3 - Run and Fix Bugs (7:51)
http://www.experts-exchange.com/videos/1518/Excel-Error-Handling-Part-3-Run-and-Fix-Bugs.html

Have authored several books and tools that I freely share with you.  Some of my other free tools are here:

http://msaccessgurus.com/freetips.html 
http://www.rogersaccesslibrary.com/forum/long-crystal_forum71.html 
http://www.accessmvp.com/strive4peace
http://analyzer.codeplex.com/

2 channels on YouTube:

https://www.youtube.com/LearnAccessByCrystal 
https://www.youtube.com/LearnByCrystal

40-lesson video series with quick reference guides and quizzes to get you on the road to becoming a master with Access:
https://www.goskills.com/Course/Access-Basics
- (not free but extremely reasonably priced)

~~~

Microsoft MVP Virtual Conference  -- Access Web Apps, Bing Maps, linking to SQL Azure from Access desktop, Excel workbook, and SSMS (53 minutes)
https://channel9.msdn.com/events/MVP-Virtual-Conference/MVP-Virtual-Conference-Americas-2015/CONS2-Using-Access-and-SharePoint-for-Travel-Expenses-and-Pulling-up-Maps

MVP Tech Talk show on Channel 9 (Microsoft's web-tv station): Free Tools and Resources for Microsoft Access (22 minutes)
https://channel9.msdn.com/Events/MVP-RD-Americas/MVP-Tech-Talk/MVPTTFreeToolsforMicrosoftAccess

I look forward to getting to know others on Experts Exchange.

~ have an awesome day ~ be amazing

More

Level Progress

Current: Level 20
crystal needs 43,434 points to level up.
LVL 21
  • Overall
    20
  • Microsoft Access
    15
  • Microsoft Excel
    10
  • VBA
    9
  • Microsoft Office
    7
  • Office 365
    5
  • Visual Basic Classic
    5
  • Microsoft Word
    4
  • Databases
    4
  • Query Syntax
    3
  • Microsoft SQL Server
    3
  • Microsoft Applications
    3
  • Programming
    2
  • VB Script
    2
  • Microsoft PowerPoint
    2
  • Outlook
    2
  • Windows 10
    2
  • Microsoft Development
    2
  • Office Suites-Other
    2
  • Visual Basic.NET
    2
  • Office / Productivity
    2
  • Spreadsheets
    2
  • Microsoft SQL Server 2008
    2
  • Windows 7
    2
  • Windows OS
    2
  • Microsoft SharePoint
    1
  • Math / Science
    1
  • HTML
    1
  • .NET Programming
    1
  • C#
    1
  • Email Clients
    1
  • Software-Other
    1
  • JavaScript
    1
  • Printers and Scanners
    1
  • Word Processors
    1
  • Email Servers
    1
  • Networking
    1
  • Miscellaneous
    1
  • Mac OS X
    1
  • Web Development
    1
  • Images and Photos
    1
  • Email Software
    1
  • InfoPath
    1
  • Web Browsers
    1
  • C++
    1
  • Proofreading
    1
  • MultiMedia Applications
    1
  • PHP
    1
  • Crystal Reports
    1
  • E-Commerce
    1
  • Search Engine Optimization (SEO)
    1
  • Azure
    1
  • Big Data
    1
  • Java
    1
  • Microsoft Visio
    1
  • Web Languages and Standards
    1
  • Web Services
    1
  • Windows Server 2003
    1
  • Windows Server 2012
    1
  • XML
    1
  • Multimedia Programming
    1
  • Fonts Typography
    1
  • Photos / Graphics Software
    1
  • Project Management
    1
  • Computer Games
    1
  • Web Graphics Software
    1
  • ASP.NET
    1
  • Remote Access
    1
  • AWS
    1
  • Active Directory
    1
  • Broadband
    1
  • Chrome
    1
  • DB Reporting Tools
    1
  • Illustration Software
    1
  • Internet Marketing
    1
  • Microsoft Server OS
    1
  • Powershell
    1
  • Programming Languages-Other
    1
  • Project Management Software
    1
  • Regular Expressions
    1
  • SSRS
    1
  • Telecommunications
    1
  • VPN
    1
  • Visual C++.NET
    1
  • Web Development Software
    1
  • Windows Batch
    1
  • Windows Server 2008
    1
  • jQuery
    1

Profile Validation

Email Verified
Expert Level Achieved
PayPal Connected