Home » Course » MS Access – 2010/2013/2016

MS Access – 2010/2013/2016

ENQUIRE NOW
ENQUIRE NOW
Current Status
Not Enrolled
Price
$380
Get Started
ENQUIRE NOW

Course Status – Accepting applications

Broad Aims Of This Course

This course is designed for all those executives who wants to manage data by using Access database. This course covers essential skills necessary for building successful and efficient databases. The course will teach you the database concepts, create and modify databases and their various objects using Microsoft Office Access. You will also learn to write VBA procedures and build Access applications around the code you add to your databases.

Click the +/- (accordion) symbol below to display relevant details in collapsible content format

This Microsoft Access course has a total duration of 30 hours of Virtual Classroom Training:

Level Total weeks Hours per week Days Timings
Intermediate to Advanced 5 6 Mondays, 
Tuesdays and Wednesdays

7:00-9:00 UAE time

15:00-17:00 UAE time

There are 2 different timings for you to choose to join a batch of your preference. A batch timing once selected by you will be permanent with no option of switching to the other.

  • The language of instruction for this course is English.
  • The Teacher is fluent in English, Hindi, Marathi and Malayalam.
  • The Teacher will communicate with students in English only and all activities including assessments will be conducted in English.

Participants attending this training should be familiar with the basic database concepts.

They need to have a laptop with MS Access 2010 or above installed.

On the completion of the MS Access Course, students will be able to do:

Introduction
  • Introduction to RDBMS
  • Access Database Objects
  • Access Interface

Create Database
  • Create Tables using different Views
  • Table types
  • Data Types
  • Understanding Field Properties
  • Adding Records

Understanding Table relationships
  • Create Relationships
  • One-To-One Relationship
  • One-To-Many Relationship
  • Many-To-Many Relationship
  • Integrity Rules

Query Data
  • Creating a Query
  • Adding Query Criteria
  • Creating Action Queries
  • Creating Parameter Queries
  • Adding Multiple criteria in a query
  • Working with Calculations and Dates
  • Wildcards
  • Calculated Expression
  • Indexing
  • Grouping Data
  • Summarizing Data
  • Creating Multi-Table Queries

Using SQL
  • Understanding Basic SQL
  • Select
  • Delete
  • Update
  • Insert
Query Wizard
  • Duplicate Query Wizard
  • Unmatched Query Wizard
  • Cross tab Queries

Creating Access Forms
  • Working with Controls
  • Types of Bound Forms
  • Using Form Wizard
  • Navigation Form

Presenting Data with Access Reports
  • Creating a report
  • Grouping and Sorting Data
  • Adding Totals
  • Using Report Wizard

VBA fundamentals
  • Objects
  • Collections
  • Properties
  • Methods
  • Events

Programming Fundamentals
  • Variables
  • Data Types
  • Constants
  • Declaring and scoping variables
  • Strings
  • Date
  • Arrays

Loops and Constructs
  • If Then Construct
  • Select Case
  • For Next Loops
  • For Each
  • Do while Loops
  • Do Until Loops

VBA Sub Procedures
  • Declaring Sub Procedure
  • Calling and scoping procedure
  • Executing Sub Procedures
  • Passing arguments to procedures
  • Error handling

Function Procedures
  • Scoping Function Procedures
  • Executing Function Procedures
  • Debugging

Events
  • Types of Events
  • Event Handler Procedures

Accessing Data with VBA
  • Understanding ADO objects
  • Connection object
  • Command Object
  • Record set Object

Different learning material will be used:

  • Live Classroom Training
  • Practice Worksheets
  • Final assessment will be in the last session of the course.
  • Course Completion Certificate’ will be sent to students within 2 weeks of successful completion of the course.
ENQUIRE ABOUT THIS COURSE
BUY NOW
ENQUIRE NOW
ENQUIRE NOW
Previous NCLEX Reviews Next Building yourself for SUCCESS