Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Access VBA - Create your own Databse applications
Rating: 4.6 out of 5(56 ratings)
287 students

Microsoft Access VBA - Create your own Databse applications

Learn VBA to automate repetitive tasks in Microsoft Access and to create state of the art database applications.
Created byQaisar Ali
Last updated 1/2024
English

What you'll learn

  • Create subroutines and functions.
  • How to create fully automated and animated dashboards.
  • Automate import and export of data.
  • Creating complex forms and reports and securing your database application.
  • How to use Dialog Boxes in MS Access.
  • Automate tasks with Action Queries.
  • Generate reports and share through MS Outlook with one click.

Course content

1 section • 21 lectures • 6h 29m total length

  • Visual Basic for Applications and Advanced MS Access3:41
  • MS Access Objects, methods and properties3:04
  • Creating VBA Program16:16

    Please download attached data file and import data in tables.

  • VBA Branching Constructs12:08
  • Option Group and Option Buttons23:34
  • Option Group and Option Buttons29:50
  • SELECT CASE statement27:39
  • Creating a function in VBA27:12
  • Sequence of statements to execute7:12
  • Microsoft Access Event Model10:47
  • How to scroll data in a form21:23
  • Dialog Boxes7:55
  • Import data from Excel files18:43
  • Import all sheets from Excel workbook12:13
  • Import all Excel files from a folder13:01
  • Action Queries3:39
  • Append Query - A small project20:03
  • Update Query - A small project43:29
  • Delete Query - A small project46:21
  • Google Maps - A small project16:06
  • Pack up your application25:39

Requirements

  • Before you enrol in this course, please make sure that you know how to use Microsoft Access.

Description

When you know Visual Basic for Applications [VBA],  you can create macros to automate repetitive tasks which will save you a lot of time and boredom of doing the same thing over and over again. If you know how to use VBA in Microsoft Access, you are on top of all Access users because you know how to create state of the art database solutions. By learning Access VBA, you can:

  1. Manage smaller to medium size databases.

  2. Create you own defined functions.

  3. Manipulate data using advanced features of various objects of MS Access.

  4. Create a portable procedure to reuse as and when required.

  5. Animate data to get rid of non value added activities.

  6. Communicate with other applications and platforms.

Topics and theories covered in this course include reasons for using VBA in Access, good coding habits, using variables, constants and data types, error handling, debugging code, using procedures, subroutines vs. functions, conversion, date, math, string, format and is functions, input and message boxes, logical programming commands, arrays, objects, and classes and instantiation. This course will help learners of any level to get the most out of the Visual Basic for Applications (VBA) environment. Starting with the development environment and working through various aspects of VBA, you will learn the tools and techniques needed to build custom solutions using Microsoft Access.

Who this course is for:

  • Anyone who want to learn advanced features of MS Access to create state of the art database applications.

Report abuse