+918586882849

Get Training Details

Microsoft Access Course

  1. Home
  2. Microsoft Access Course

Microsoft Access Training

Learn Microsoft Access Training Course.

Microsoft Access training course is targeted towards making students familiar with database management that combines relational Microsoft jet data base engine with a graphical user interface and software development tools. It teaches students creation of quick and easy databases, produces adaptable and flexible data base system and produces very user-friendly application through its comprehensive programming language.

About the course: This course provides a clear picture with Microsoft access with hands-on to create and modify new database and their various projects. This course teaches how to handle data with consistency and accuracy. This course explains students how to import or link directly to data stored in other applications and databases.

Prerequisites: what are the requirements for this training

The students must have sufficient knowledge of the basic skills of working with excel to advance excel. They must be familiar with advanced formulas, pivot Tables and other such important functions. Pupil must also have sufficient knowledge of how to validate and standardize table data.

Target students: All working professionals who wish to learn how to create and manage database are the most suitable person for this course. They must possess technical know-how and familiarity with excel. Pupil who wish to learn how to manage data by themselves can also enroll for this course.

microsoft access course  MS Access Course Outline

Introduction to Access

  • Getting familiarize with Access
  • Planning, Designing, Handling Database
  • Play with Database
  • Creating Database and Updating using templates

Using Pivot Table in Access (And Via Excel)

  • Creating Pivot Tables Within Access
  • Using Access Pivot Tables

Using the Navigation Pane

  • Tables and Related Views
  • Navigation Pane Objects
  • Custom Groups

Introducing Access Macros and VBA

  • Just what is a Macro?
  • Macro Review
  • Creating and Editing Macros
  • Enhancing Macros with TempVars
  • Adding Conditions to Macros
  • Introducing Access VBA
  • Adding Conditions to Macros
  • Introducing Access VBA

Validating and Standardising Table Data

  • Setting Default Values
  • Defining Field Validation
  • Requiring a Field to be Completed
  • Adding Date Picker to Date Fields
  • Using Rich Text Formatting (Memo Fields)
  • Table Validation Rules

Advanced Form Design

  • GUI Design
  • Designing a Standardised User Interface Model
  • Working with Form Filters
  • Validating Form Data
  • Cascading Combo Boxes

Setting Table Relationships

  • Locating Orphan Records
  • Cascading Updates and Deletes
  • Join Types

Designing with Layout View

  • A Quick Look at Layout View
  • Creating a Form Using the Quick Form Tool

Introducing Access SQL

  • Commonly used SQL Keywords

Advanced Reports

  • No Data Event
  • Show/Hide Report Sections based on User Selections
  • Add Running Sums to Report Sections
  • Add a Watermark to a Report

Advanced Select Queries

  • Using Left
  • Using Mid
  • Using the LEN Function
  • Using IIF Functions
  • Using LCASE Functions
  • Using TRIM Functions

Reporting Systems

  • Reviewing Methods to Run Reports
  • A Fully Featured Reporting Module

Aggregate Queries

  • Grouping Data
  • Adding Criteria to Aggregate Queries

Preparing the Database for User Access

  • Restricting User Access to Design Elements
  • Converting to ACCDE Format

Cross Tab Queries

  • Creating CrossTab Queries
  • Modifying a CrossTab
Click to Get Training Details
× How can I help you?

    Get Training Details


    What is 6 x 5 ?