Course Description

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 will 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, Windows 7, Windows 8, Windows 8.1, Windows 10, and 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 30 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.

Course Contents

Getting Started with Microsoft Word

• Introduction to Database
• Introduction to Microsoft Access
• Database management system
• User interface of Microsoft Access
• Quick Access Toolbar
• Access Ribbon
• Access Object Panel
• Open New and Existing database
• Save and Save As
• Close, Feedback and Options
• Questions and Answers

Office Clipboard and Text Formatting

• Cut, Copy and paste
• Office clipboard
• Insert and delete row
• Change text formatting
• Change Text Color and Size
• Questions and Answers

Tables

• Creating New Tables
• Design table in design view
• Understanding Field Name and Datatypes
• Field General Settings
• Entering Record in Tables
• Export Tables
• Table Structuring
• Tips for managing tables
• Primary key and its types
• Setting up Tables for Relationship
• Create one to many relationship
• Create one to one relationship
• Managing data
• Sorting record
• Filtering record
• Subdatasheets
• Using Lookup Wizard
• Combo box and related fields
• Field size and caption properties
• Questions and Answers

Forms

• Form design and setting
• Form Wizard
• Combo Box
• Setting the Tab order
• Using Tab Controls
• Add Sub Form
• Change Text box into a Combo Box
• Navigation button
• Questions and Answers

Queries

• Creating an Access Query
• Select Query
• Using AND Condition in Query
• Using OR Condition in Query
• Sorting data in Query
• Between Operator in Query
• Using Wildcard in query criteria
• Questions and Answers

 Reports

• Report views
• How to create instant Reports
• Step by step Report wizard
• Sorting with reports
• Subtotals in Reports
• Formatting controls
• Applying themes
• Inserting images
• Inserting hyperlinks
• Prepare for prints
• Report formatting
• Questions and Answers

Macros

• Create Macros
• Macro button
• Where condition
• Require data entry macro
• Display message macro
• Questions and Answers

Building Switchboard

• Preview an Access Switchboard
• Start the switchboard manager
• Adding buttons to the switchboard
• Formatting the switchboard
• Modify the switchboard
• Questions and Answers

Project | Create an Advance Database from Start to finish

• Create Complete Project in Microsoft Access
• Questions and Answers

Final Exam and Certification