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

 

  • Jan Sher

    Jan Sher
    AutoCAD Architecture 2017 Complete Training
    95%

  • Muhammad saleem

    Muhammad saleem
    Blogger Complete Advanced Training 2016
    95%

  • Jan Sher

    Jan Sher
    MicroSoft Word 2016 Complete Training
    95%

  • Rimsha Nazeer

    Rimsha Nazeer
    InPage Urdu Typing 2015 Complete Training
    95%

  • Ali Hasnain

    Ali Hasnain
    MicroSoft Excel 2016 Complete Training
    95%

  • Muhammad saleem

    Muhammad saleem
    WordPress 2016 Complete Training
    95%

  • Ali Hasnain

    Ali Hasnain
    MicroSoft Access 2016 Complete Training
    95%

  • Rimsha Nazeer

    Rimsha Nazeer
    MicroSoft PowerPoint 2016 Complete Training
    95%

  • Muhammad Tariq

    Muhammad Tariq
    MicroSoft Excel 2016 Complete Training
    95%

  • Muhammad Tariq

    Muhammad Tariq
    MicroSoft Word 2016 Complete Training
    95%

  • Muhammad Tariq

    Muhammad Tariq
    MicroSoft PowerPoint 2016 Complete Training
    95%

  • Muhammad Haseeb

    Muhammad Haseeb
    InPage Urdu Typing 2015 Complete Training
    95%

  • Majid khan

    Majid khan
    InPage Urdu Typing 2015 Complete Training
    95%

  • Muhammad Abbas

    Muhammad Abbas
    InPage Urdu Typing 2015 Complete Training
    95%

  • Zaintariq

    Zaintariq
    Blogger Complete Advanced Training 2016
    95%

  • Muhammad Abbas

    Muhammad Abbas
    MicroSoft PowerPoint 2016 Complete Training
    95%