What you will learn
- At the end of course you will be able to create a simple database in Access from Scratch.
- Master Microsoft Access from Beginner to Advanced.
- Fully Understand tables, Queries, reports and forms.
- Manage Large sets of Data in Microsoft Access Relational Design.
- Present Dynamic Reports.
- Build and Efficient Database Table Design.
- Build Dynamic Access Database.
- Create a multi-page invoice.
- And much more.
| Course Outline |
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
MUHAMMAD SAQIB IQBAL
Microsoft Access 2016 Complete Training: Question: Will this course covers VBA, SQL and Macros?...
Replyplease check the course outline...
NUMAN AHMAD
Buat Acha samjaya ap na sir class ma teacher ki bikul samaj NAI ayti you are great...
divya
Well explained....it solved my problem many thanks!!...
Muhammad Ali butt
Thank you sir for great knowledge , Wednesday ko mera paper he first acees ka thank you mujhy bilkul clear hogaya ab...
Muhammad shafiq
Sar Kitne Acche Se Samjhaya Hai Aapane Love You...