Over 50 tutoring hours

Kim M.

Lunenburg, MA

$68/hour

Patient and experienced tutor will work at your pace!

5.0 average from 25 ratings
Focused, knowledgeable, patient
— Tracey-lee, Northborough, MA on 10/29/15

Message Kim

Send Kim a message explaining your needs and you will receive a response shortly. Have you already emailed Kim or another tutor? If so, you have an account! Sign in now

 Checking availability…
Please enter the tutor's email address.
Please enter the student's email address.
Please describe how you heard about us.
Replies in 7 hours
Replies in 7 hours

Receive responses from additional tutors

If you select this option, WyzAnt will ask interested tutors to contact you by email if they are able to help. A maximum of five different tutors will email you and none of your personal information, including your email address, will be released.

About Kim

Ready to help you take the next step!

I've been a professional software developer for more than 15 years using a variety of tools including: Microsoft Access, Excel VBA, SQL Server, Visual Basic, C# (both Web and Windows), HTML and JavaScript. My background with these tools is extensive, and I love to pass on my knowledge! I call myself a "data geek" - I love to delve into messy databases and figure out how to wrangle them into shape.

I am a patient and thorough teacher, conducting all tutoring sessions at a pace that makes the student comfortable. If you are new to programming, I'll start with the basic concepts and build from there. If you've got some experience, we can start where you left off and fill in some of the blanks.

Integration between various application is a specialty of mine. I have created dozens of applications that move data back and forth between Access, Excel and SQL Server. I can show you how to set up your Excel document to pull data directly from a SQL or Access database; to automate the creation of PivotTables; to add validation to Access forms; to automatically import data into SQL Server from an Excel file; and more.

What do Access, Excel, HTML and SQL have in common? All of these tools are easy to use, but hard to master! I can tell you about the common pitfalls of these tools and how to avoid them; how to debug your applications; and how to write clean, efficient code that is easy to maintain.

Taking a class? Its easy to get overwhelmed with all of the new material that you're expected to master in a short time. I can review what you've learned in class, creating quick and easy-to-follow demonstrations to help illustrate. If you're struggling with homework assignments, I can help you to understand what's required, plan your strategy, and review your work to make sure you're on target.

I'm happy to answer any questions you have, either via email or online. We can schedule a short session (either online or by phone) to get to know each other and determine a course of action, at no charge and with no commitment. Let's get started!
Ready to help you take the next step!

I've been a professional software developer for more than 15 years using a variety of tools including: Microsoft Access, Excel VBA, Read more

Policies
Cancellation
2 hours notice required
Travel Radius
Travels within 30 miles of Lunenburg, MA 01462
Background Check: Passed

"Focused, knowledgeable, patient"

- Tracey-lee, Northborough, MA on 10/29/15
Business:
Microsoft Excel

Approved subjects are in bold.

Approved subjects

In most cases, tutors gain approval in a subject by passing a proficiency exam. For some subject areas, like music and art, tutors submit written requests to demonstrate their proficiency to potential students. If a tutor is interested but not yet approved in a subject, the subject will appear in non-bold font. Tutors need to be approved in a subject prior to beginning lessons.

ASP.NET

I've developed dozens of apps using ASP.Net, using both C# and Visual Basic. Most apps include a SQL Server backend. I can cover the basics (such as creating variables and compiling your program), intermediate topics (organizing your code into subroutines and functions, debugging your code, passing parameters), and advanced topics (using external DLLs or web services, setting up connections to various data sources, overloading).

If you are looking to understand how to program in ASP.Net, we can start from scratch and build a working program. If you've already got a program started and you're stuck on one aspect, we can do the necessary troubleshooting and debugging to get it working. If you've inherited a messy program (which happens all too often), I can help you dissect it and determine how to move forward with it.

C#

C# is a strong and easy-to-use language... once you get used to it. Its one of the languages that tends to take a lot of shortcuts - which is great when you are typing out the code, but not so great when you are trying to understand it! One of the best techniques for understanding C# is to break a statement down into several different pieces, understand the function of each piece, and then put it back together.

I can explain how to write clean, efficient code that works well and is easy to maintain. We can cover both Web apps and Windows apps, and see how you can use debugging tools to make your life easier.

HTML

HTML is a quick and powerful tool for creating several types of apps, most commonly, web apps. It's easy to learn, and once you've got the hang of it, you'll be creating some amazing web pages in no time!

I can help you understand the basic syntax of HTML, the difference between HTML 4, HTML5 and XHTML, how JavaScript and CSS (Cascading Style Sheets) work with HTML, and how to debug your pages. We can start from scratch to create a brand-new web page, or enhance an existing page.

JavaScript

JavaScript is most commonly used in conjunction with HTML to add functionality to web pages. It's a simple scripting language, which is a good-news/bad-news situation. Because its simple, its pretty easy to get started. But because its simple, its also very easy to make mistakes. And its TERRIBLE about telling you what's wrong!

I've got lots of tools and techniques that we can look at to make your life easier when it comes to JavaScript. We can take a look at how to create JavaScript functions, how to call them from your HTML web page, and how to test and debug them.

Microsoft Access

Microsoft Access - an amazing tool that is easy to use, but difficult to use CORRECTLY! Many people jump in to Access and create a database without understanding database concepts. This often results in a data mess that needs to be cleaned and managed on a regular basis.

I can help you get a handle on your databases, or learn to create them from scratch. We can cover data relationship concepts, tables, queries, forms, reports, macros, and even VBA code (if you're ready for that!). If you've already got a database mess on your hands, I can teach you techniques for finding problems and fixing them, and implementing the appropriate controls in your application to keep them clean.

Microsoft Excel

Excel is one of the most commonly used tools in the business world, and yet most people only use a fraction of its capabilities. If you'd like to dig a little deeper, I can help you find some amazing features in Excel and put them to work for you. We can cover Data Table features, PivotTables, nested formulas, built-in functions, formatting, and more.

If you're started using Excel macros, that process might have given you more questions than answers. We can take a look at the VBA code for the macros you've created, and see how to tweak or enhance them. You may also have found that the Macro Recorder generally writes code that is messy, and often throws in lots of lines of code that aren't really necessary (see all those "scroll" commands... probably not needed). We can look these over and dissect them, talking about what they are doing and how they might do it better. I can show you the debugging tools, which are invaluable.

SQL

SQL, also known as Structured Query Language, is a language that is used to retrieve, add, edit and delete data in a database. It's used in Microsoft SQL Server, Oracle databases, MySQL, Microsoft Access, and many other places. No matter which of these tools you're using, the basic syntax of SQL stays the same. We can look at the commands that are identical across platforms, and also those that are specific to one of these.

If you're new to SQL, the best place to start is with simple Select statements. We can cover those, and then move on to joins, where statements, order by statements, grouping statements, and more. We can also cover the statements that are used to add, edit and delete records (insert, update, and delete, respectively).

In addition, we can cover some of the database administration tasks, such as creating tables, creating indexes, adding users, and more.

Finally, if you're learning SQL Programming, we can look at creating views, stored procedures and functions.

Visual Basic

Visual Basic has been around for a long time, and continues to be a popular tool, in large part because of it's use in VBA (or Visual Basic for Applications). I've worked with VB for several years, both in Microsoft Visual Studio and in the Microsoft Office Suite. I have create both Windows and Web applications with it.

Visual Basic is one of the easier languages to learn, because it is more "English-like" than many languages. We can cover the basics of Visual Basic syntax, the differences between different "flavors" of VB (VB .Net, VBA, VB Script), and how to build robust user-friendly applications with it.

Error Handling and Debugging are important topics to understand, so that your programs will be trusted and well-received by their users. I've found that the best way to learn Visual Basic is in small chunks - discuss a topic, view a demonstration, and then try a small example. During our tutoring sessions, you'll be encouraged to create small procedures that focus on a single task, and then integrate those small pieces to build a complete solution.

Focused, knowledgeable, patient — Kim is a wonderful and thorough instructor. I found her to be patient even when I stopped her to ask questions. She was focused on the task. Things we reviewed were VBA in Excel and Access. I look forward working with Kim to become more experienced in this area. ...

— Tracey-lee, Northborough, MA on 10/29/15

Hourly fee

Standard Hourly Fee: $68.00

Cancellation: 2 hours notice required

Travel policy

Kim will travel within 30 miles of Lunenburg, MA 01462.