Excel VBA Connect with MS Access database

Control MS Access with Excel VBA

• Learn about ADO Library. Active- X data object library in VBA. Why it is required and how to activate this.

• Know about the ado library classes and use it for database connections

• How to set up connection with access if located on server or local machine using excel VBA

• What are recordsets in ms access using excel vba and how to use strings to connect with databases.

• for more database how to plan the things and see the connections strings for different type of databases.

• How to run loops in access tables

• How to use SQL Commands like select statement, update statement ,delete sql syntax and insert syntax to exchange the information back and forth.

• How to edit or change specific record in ms access creating user forms

• What are the cursors and how to work with them.

• What is the Significance of recordset cursor lock type - read-only and optimisticbatch

• A powerful project for you . This will make you super awesome because it is going to give real learning as to how what we have learnt so far can be used in making projects. Let us learn how we can make a break time scheduler for our team wherein they go on break and come back from break -their duration gets recorded and supervisors using this tool can see who is adhering and who is not adhering.