Microsoft Access Training Course

Microsoft Access Training Course For Beginners

Call Now

Enroll Now

Email Us

Microsoft Access Training Course For Beginners Summary

 

Microsoft Access Training course for beginners is being delivered for 16 Hours over 4 weeks, 8 sessions, 2 sessions per week, 2 hours per session

  • All Published Ticket Prices are in US Dollars.
  • The course will be taught in English language.

Microsoft Access Training Course For Beginners Schedule

 

Please choose from one of the dates in the table below to begin your enrollment :

Dates Weekly Schedule (US Pacific Time)* Price Add to Cart
Dec 4 to Dec 26 Sat/Sun 7:30 AM - 9:30 AM each day $394.00 Add to cart
Dec 6 to Dec 29 Mon/Wed 5:30 PM - 7:30 PM each day $394.00 Add to cart
Dec 7 to Dec 30 Tue/Thu 7:30 AM - 9:30 AM each day $394.00 Add to cart
Jan 8 to Jan 30 Sat/Sun 7:30 AM - 9:30 AM each day $394.00 Add to cart
Jan 10 to Feb 2 Mon/Wed 5:30 PM - 7:30 PM each day $394.00 Add to cart
Jan 11 to Feb 3 Tue/Thu 7:30 AM - 9:30 AM each day $394.00 Add to cart
Feb 5 to Feb 27 Sat/Sun 7:30 AM - 9:30 AM each day $394.00 Add to cart
Feb 7 to Mar 2 Mon/Wed 5:30 PM - 7:30 PM each day $394.00 Add to cart
Feb 8 to Mar 3 Tue/Thu 7:30 AM - 9:30 AM each day $394.00 Add to cart
Mar 14 to Apr 6 Mon/Wed 6:30 PM - 8:30 PM each day $394.00 Add to cart
Mar 15 to Apr 7 Tue/Thu 8:30 AM - 10:30 AM each day $394.00 Add to cart
Mar 19 to Apr 10 Wed/Sun 8:30 AM - 10:30 AM each day $394.00 Add to cart
*click on date/time hyperlink to add your location and find local date/time for first session
Dates and Weekly Schedule (US Pacific Time)* Price
Dec 4 to Dec 26
Sat/Sun 7:30 AM - 9:30 AM each day
$394.00
Enroll
Dec 6 to Dec 29
Mon/Wed 5:30 PM - 7:30 PM each day
$394.00
Enroll
Dec 7 to Dec 30
Tue/Thu 7:30 AM - 9:30 AM each day
$394.00
Enroll
Jan 8 to Jan 30
Sat/Sun 7:30 AM - 9:30 AM each day
$394.00
Enroll
Jan 10 to Feb 2
Mon/Wed 5:30 PM - 7:30 PM each day
$394.00
Enroll
Jan 11 to Feb 3
Tue/Thu 7:30 AM - 9:30 AM each day
$394.00
Enroll
Feb 5 to Feb 27
Sat/Sun 7:30 AM - 9:30 AM each day
$394.00
Enroll
Feb 7 to Mar 2
Mon/Wed 5:30 PM - 7:30 PM each day
$394.00
Enroll
Feb 8 to Mar 3
Tue/Thu 7:30 AM - 9:30 AM each day
$394.00
Enroll
Mar 14 to Apr 6
Mon/Wed 6:30 PM - 8:30 PM each day
$394.00
Enroll
Mar 15 to Apr 7
Tue/Thu 8:30 AM - 10:30 AM each day
$394.00
Enroll
Mar 19 to Apr 10
Wed/Sun 8:30 AM - 10:30 AM each day
$394.00
Enroll
*click on date/time hyperlink to add your location and find local date/time for first session

Course Objectives

 
    • Understand how to design advanced queries, forms and reports
    • Learn how to save all data in one place
    • Learn how Access can work with Other Microsoft Office programs
    • Network and Content Delivery (Route53, VPC and CloudFront)
    • Learn how to extract the information required
    • Knowledge about the structure and advantages of a database.
    • Build a database with a good relational structure.
    • How to create basic to advanced reports and design Access databases.

Features and Benefits

 
    • 16 Hours, 8 sessions, 4 weeks of total Instructor-led and guided training
    • Training material, instructor handouts and access to useful resources on the cloud provided
    • Practical Hands-on Lab exercises provided
    • Actual code and scripts provided
    • Real-life Scenarios

Who should attend ?

 
  • Those aspiring to learn Microsoft Access.

Prerequisites

 
  • Basic Computer skills.

Course Outline

 

1. Database Fundamentals

  • RDBMS concepts
  • Database Design Principles
  • Introduction to MS-Access
  • Creating Database in MS-Access
  • MS-Access Objects - Introductions
  • Tables
  • Forms
  • Queries
  • Reports
  • Macros
  • Modules

2. Database Constraints (Primary Key, Foreign Key) SQL - Structured Query Language

  • SQL Commands
  • Data types

3. Data Definition Language

  • Create Table Command
  • Alter Table Command
  • Drop Table Command

4. Data Manipulation Language

  • Select Command
  • Insert Command
  • Update Command
  • Delete Command

5. Filter Clause (Cont...)

  • WHERE Clause
  • GROUP BY Clause
  • Having Clause
  • Order by Clause

6. Operators

  • Arithmetic Operators
  • Comparison operators
  • Logical Operators

7. Range Operators

    • IN/NOT IN
    • Between

    8. Set Operators

    • Union
    • Union All
    • Intersect

    9. SQL Functions

    • Aggregate Function
    • Date Function
    • String Function

    10. Joins

    • Simple Join
    • Equi Join
    • Non equi Join
    • Self Join
    • Inner Join
    • Outer Join
    • Left Outer Join
    • Right Outer Join

11. Queries

  • Simple Queries
  • Sub queries
  • Nested Queries
  • Correlated Sub Query

12. Search Expressions

  • Like
  • with Nulls

12. Search Expressions

  • FORM Controls
  • TextBox, Combobox, CheckBox, Option Button, ListBox, Labels, Command Buttons etc.
  • Form Events
  • Design Forms
  • Sub Forms
  • SQL commands using in VBA modules
  • Linked Table,
  • Import Text File, Excel File, CSV File
  • Export Data to Excel File, Text File,
  • Connecting to Excel
  • Consolidate Excel Files to Access Database
  • Automation Project

12. Search Expressions

  • Nagios
  • Creating Custom Metrics with CloudWatch

Refund Policy

 
  • 100% refund can be applied if request is initiated 24 hours before the 1st course session.
  • If a class is rescheduled/cancelled by the organizer, registered students will be offered a credit towards any future course or a 100% refund