MS Access Macros Series 4

MS Access Macros Series 4

• This series is for those students who want to automate their access tasks by learning the in built access macros

• Basic -intermediate and Advance level Macros explained in detail

• How to use message boxes and input boxes with practical situations

• Use of dynamic IF conditions using "AND" "OR" operators with else if

• How to user IF macros and when and why we need multiple IFs so we can tackle multiple condtions.

• Know the data import and export from outer applications like ms excel, text files and databases like ms access itself.

• Learn about Auto-Keys and Auto Exec macros - their use

• How to run queries, open tables and open forms

• How to call one macro from other. How we can create a single macro which performs many actions in one go

• How to define variables and use them in access macros.

• Know about set temp vars and set property tasks

• How to convert inbuilt macro to VBA Code .

• Your questions time to time is attended and given the resolution.

• Project for you - how to open the second form from inside the first form but on opening the form, its controls should be locked.

• How to use DLOOKUP function in your projects and how it can lookup the IDs and validate the login information, if right user is logging in or not.

• Copy object and delete the objects

• How to set Filters

Powerful Pre defined access Macros

Url: View Details

What you will learn

• Students will learn so many essential access macros used in MIS which do not need any VBA.
• These in built macros can automate your day to day work.
• How to open form object or table or query object

Rating: 3.9

Level: All Levels

Duration: 4.5 hours

Instructor: ajay parmar