Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[GET] Udemy - MS Office Accessing a Database from VBA
09-06-2015, 04:02 PM
Post: #1
Video Udemy - MS Office Accessing a Database from VBA
[Image: 4c8e7a32d284e449a8d4a1c995dd3516.jpg]
Udemy - MS Office: Accessing a Database from VBA
MP4 | Video: 1280x720 | 53 kbps | 44 KHz | Duration: 2 Hours | 674 MB
Genre: eLearning | Language: English



Learn how to use a database backend with VBA in Excel, Access or any MS Office product.

This course is exactly what it says in the title.

When you're doing some computer programming in one of the MS Office products, you'll be using VBA and you might need to connect to a database. This course will explain the simple aspects when it comes to getting some data in or out of a database and then we progress into some more advanced elements.

The course is not designed for a total computer nerdy, geeky type of person. It is for someone who is learning to programme in VBA.

You might be an accountant, a data analyst or even a project manager who wants to automate part of their working environment. At some point you'll need your to get data in or out of a database from the MS Excel, MS Word or MS Access system.

This course is relevant to all the different products in the MS Office suit, they all mostly work the same when it comes down to the VBA accessing a database.

What are the requirements

Student will need to know how to open the VBA window on their copy of any MS Office product.
Students will need to have a copy of MS Office on their computer (but not Office 365).
Students will need to have access to a database backend, it could be either MS Access, MySQL, PostGreSQL, Oracle or MS SQL.
What am I going to get from this course

Over 24 lectures and 1.5 hours of content!
Connect to a database from VBA code.
Optimise their use of the Database
Handle and process large volumes of data in Recordsets
Communicate directly with the database through SQL
What is the target audience

People getting started with VBA programming in MS Office, who want to connect to a database backend.




Register with us

Hey Guest, you need to contact me? - Feel free to PM me
The forum would be a dead place unless users post stuff on it, whatcha waiting for!?


Random User : montsa007, this nulled script has rats inside it!!
montsa007 - You get what you pay for mate Undecided
Visit this user's website Find all posts by this user
Quote this message in a reply
 Thanks given by: tubebuddy


Post Reply 


Messages In This Thread
Udemy - MS Office Accessing a Database from VBA - montsa007 - 09-06-2015 04:02 PM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)