ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
Please subscribe my channel for more videos
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.
 Introduction to Microsoft Access 2016
 Understanding first user interface
 Creating first database
 Building first table
 Understanding Field name and datatypes
 Database Field General settings
 Open new and existing date base
 Save As , close, feedback, option
 Quick access toolbar
 Cut, Copy, Paste and office clipboard
 Insert and delete Row
 Change text formatting colour and size
 Understanding Application Parts option
 Discuss difference B/w Table and Table Design
 Working on Lookup wizards
 Working on More Option of Lookup wizards
 Understanding Combo Box option and related fields
 Understanding Lookup General options
 Working on Field Menu
 Add and delete field
 Property and formatting
 View
 Understanding Primary key and its uses
 Understanding Relation Ship B/w Different Fields
 Creating First Form Using Form wizards
 Design Form
 Working on Form, Form Design, and Blank Form
 Navigation and More form
 Working on Form Properties
 Working on Control Tab in form
 Add button in form
 Working On Query in Access
 Design Query
 More Discuss on Query
 Create Form using different Tab
 Create Report with different Options
 Working on Arrange and Format Menu in Report
 Working on External Data and Page setup Menu
 Working on Macro
 Record Macro, Email Macro, and Print Macro
 Create Switchboard
 Add button on switchboard

Microsoft Access 2016 || Creating first Database || Microsoft Access 2016 User Interface | Lesson 02
____________________________________________________________________________________
Visit our website
http://virtualacademy.pk/
Like us on facebook
https://www.facebook.com/joinvaofficial
follow us on twitter
https://www.twitter.com/joinvaofficial