MicroSoft Access 2016 Complete Training


Microsoft Access 2016 Complete Basic to Advanced Training

Trainer

Taimur Pervez

Total Lesson

30

Time Duration

09 Hours

Language

Urdu/Hindi

Format

MP4 HD 1080

Contact No

+923215124534

Email Address

info@virtualacademy.pk

 

OVERVIEW:

After completing Microsoft Access 2016 Basic to Advance via Online Video Training Course in Urdu and Hindi. You will be able to navigate, Personalize, working on different Microsoft Access workplace and manage or control the user interface. This Course will not teach you how to build a database from scratch. It is designed for people who plan to use a pre-existing database, most likely in the workplace.

The Course begins with a basic introduction to Access. You will become familiar with the structure of an Access database and learn how to navigate its various windows and the objects contained in it. As the Video training goes on, you will learn how to enter information in several ways. You will also learn how to sort, retrieve, and analyze this information by running queries. After you understand how to use your database, you’ll be introduced to tools that let you modify its structure and appearance.

By the time, you've finished reading this tutorial, you will be able to use a database with confidence. You should also be able to alter it to best suit your needs.

 

INTRODUCTION:

Microsoft Access is a DBMS (also known as Database Management System) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.

Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and database.

 

 

PREREQUISITES:

Before starting this course, you should have a working knowledge of Following:

  • Basic computer
  • Introduction to computer
  • Microsoft word
  • Microsoft PowerPoint

This training is compatible with windows XP, Window 7, Window 8, Window 8.1, Window 10. MAC operating system.

CERTIFICATION:

You are hereby advised to visit www.virtualacademy.pk and get yourself certified in Microsoft Access 2016 Complete Training, furthermore you'll have to meet the following criteria for earning this particular Registered Certification.

  • You will have to complete all 25 lessons through Virtual Academy Online Learning Management System at www.virtualacademy.pk.
  • Every lesson has 3 to 5 quizzes, which you must have to pass with 70% marks.
  • You need to submit your project/assignments on time.
  • After completion of Virtual Academy offered Microsoft Access 2016 lessons via www.virtualacademy.pk Online Learning Management System there will be final exam which comprises of 50 to 100 questions.

After having assessment of your account with www.virtualacademy.pk whether you meet all the above terms and conditions, then we will dispatch your Certificate/Diploma at your given address.

For further queries please read FAQs or you can contact us

Complete Course Outline

Lesson 01

Lesson 02

Lesson 03

  1. Introduction to Microsoft Access 2016

 

  1. Understanding first user interface
  2. Creating first database

 

  1. Building first table
  2. Understanding Field name and datatypes

Lesson 04

Lesson 05

Lesson 06

  1. Database Field General settings

 

  1. Open new and existing date base
  2. Save As , close, feedback, option

 

  1. Quick access toolbar

Lesson 07

Lesson 08

Lesson 09

  1. Cut, Copy, Paste and office clipboard
  2. Insert and delete Row 
  1. Change text formatting colour and size
  1. Understanding Application Parts option

Lesson 10

Lesson 11

Lesson 12

  1. Discuss difference B/w Table and Table Design

 

  1. Working on Lookup wizards

 

  1. Working on More Option of Lookup wizards

Lesson 13

Lesson 14

Lesson 15

  1. Understanding Combo Box option and related fields

 

  1. Understanding Lookup General options

 

  1. Working on Field Menu
  2. Add and delete field
  3. Property and formatting
  4. View

 

Lesson 16

Lesson 17

Lesson 18

  1. Understanding Primary key and its uses

 

  1. Understanding Relation Ship B/w Different Fields

 

  1. Creating First Form Using Form wizards

 

Lesson 19

Lesson 20

Lesson 21

  1. Design Form

 

  1. Working on Form, Form Design, and Blank Form
  2. Navigation and More form

 

  1. Working on Form Properties

 

Lesson 22

Lesson 23

Lesson 24

  1. Working on Control Tab in form
  2. Add button in form

 

  1. Working On Query in Access
  2. Design Query

 

  1. More Discuss on Query

 

Lesson 25

Lesson 26

Lesson 27

  1. Create Form using different Tab

 

  1. Create Report with different Options

 

  1. Working on Arrange and Format Menu in Report

 

Lesson 28

Lesson 29

Lesson 30

  1. Working on External Data and Page setup Menu

 

  1. Working on Macro
  2. Record Macro, Email Macro, and Print Macro

 

  1. Create Switchboard
  2. Add button on switchboard

 

  • Majid khan

    Majid khan
    InPage Urdu Typing 2015 Complete Training
    95%

  • Arshad

    Arshad
    MicroSoft PowerPoint 2016 Complete Training
    95%

  • ADNAN ISHAQ

    ADNAN ISHAQ
    MicroSoft Access 2016 Complete Training
    95%

  • Yameen Nasir Shahzad

    Yameen Nasir Shahzad
    InPage Urdu Typing 2015 Complete Training
    95%

  • ADNAN ISHAQ

    ADNAN ISHAQ
    YouTube & Dailymotion Earning Tips
    95%

  • Rana Abid

    Rana Abid
    InPage Urdu Typing 2015 Complete Training
    95%

  • Safdar Hussain

    Safdar Hussain
    MicroSoft Word 2016 Complete Training
    95%


  • MicroSoft PowerPoint 2016 Complete Training
    95%

  • ALI SHAHBAZ

    ALI SHAHBAZ
    MicroSoft Access 2016 Complete Training
    95%

  • Muhammad  Arshaad

    Muhammad Arshaad
    MicroSoft Word 2016 Complete Training
    95%

  • Mudassar Gulzar

    Mudassar Gulzar
    InPage Urdu Typing 2015 Complete Training
    95%

  • Muhammad Irfan

    Muhammad Irfan
    MicroSoft PowerPoint 2016 Complete Training
    95%

  • Basit ali

    Basit ali
    MicroSoft Word 2016 Complete Training
    95%

  • Abdulrauf

    Abdulrauf
    InPage Urdu Typing 2015 Complete Training
    95%

  • Aneel Kumar

    Aneel Kumar
    Blogger Complete Advanced Training 2016
    95%

  • Unaiza Zafar

    Unaiza Zafar
    MicroSoft PowerPoint 2016 Complete Training
    95%