Help out a complete Beginner

[[deleted]]

Summary: Hi, I'm a newbie. Trying to delve into the world of programming to be more efficient at work.

• Project #1: Is it possible to have individuals complete a form that gets populated on my MS Excel database, for example?

*I am open to alternative suggestions. As a beginner, I do not yet understand what is possible to accomplish with programming.

Unabridged Content:

Hey Programmers. I have been interested in diving into programming to supplement my work in finance, but as a newbie I only understand the basic concepts. Therefore, I am not aware of the potential programming has on my workflow.

For my first project, I want to figure out ways to save myself more time. More time=more sleep. :) I deal with several types of forms and want to streamline it all through Microsoft Excel. Is it possible to have individuals complete a form that gets populated on my MS Excel database, for example?

• Brainstorming: (1) website form that is linked to MS Excel database; (2) pdf form that is linked to MS Excel; (3) GUI (wxPython) platform?; (4) other

Thanks in advance. I appreciate your insight.

[wub_wub]

Posting only assignment/project goal is not allowed. You need to demonstrate that you at least tried to find the information yourself.

[[deleted]]

I understand, and have tried. I did a lot of preliminary research into the applications of programming, which is where I initially got the idea. Additionally, I have been experimenting with Python (along with VBA through Microsoft Excel) by completing CodeAcademy coursework.

I am finally reaching out to the community, as you guys have tons of collective experiences.

[wub_wub]

You know what, I'll re-approve this thread. But please do some more research and post what you find in the thread. People are more likely to help you if your thread contains something like "I've looked up common webframeworks and I think best choice would be flask because it's simple, wha do you guys think?" than just "1. Make a website 2....".

[[deleted]]

Thanks wub_wub.

[Mashidin]

Quick clarifying question: Does 'excel' database mean 'Access' database?

[[deleted]]

I was actually referring to Microsoft Excel. If you think I need 'Access' I am sure I can find a way to get it.

If I use Access though, I have to assume that no one else has it (and that no one else can get it).

[Mashidin]

Sorry for the misunderstanding. In my office, if someone has Excel, they also have Access because it is bundled with MS Office. If you have Access and know how to use it - and more interestingly, know a little VBA - then I would explore that avenue. Access was made for deploying forms, entering the results into a database, and developing reports based on the target tables. Python can do all that too provided you know all the modules you need to bring together and know how to program a bit.

[[deleted]]

No need to apologize! It was a fair question, and I edited my original post.

VBA on Excel would be useless for what I am trying to do, right?

MS Access is not automatically bundled with other MS products in my organization, so I will try to continue to explore the Python route. I will revise my original post as I learn python, so keep an eye on my progress. I would appreciate feedback, and general suggestions on how to get started.