Microsoft® Access

Back

EXCEL YOURSELF IN USING MICROSOFT® ACCESS

Be a Microsoft certified MS Access user with this 2-day training program.

 

Today Millions of organizations around the globe use MS Access to manage their escalating need of data management. It works as an ideal solution to develop a database helps you to organize, alter, store and retrieve data effectively and efficiently. This course is necessary for executives who are familiar with Microsoft Excel and who aim at improving their skills of working with database, analysing data, creating forms and reports.

Vinsys call

Interested?
contact us now

I want training for
I agree to the Terms & Conditions.

WHY VINSYS?

Vinsys is one of the top Global Gold Learning Partner

 

Facilitators conducted 500+ Training Programs every month.
  •  
We have a panel of expert trainers with 20+ yrs. of industrial as well as training experience.
  •  
Till date, we have trained 55,000+ Professionals across industries and across the globe.
  •  
Based on our past success statistics, 96% of our participants crack the exam efficiently Along with classroom training we also provide practice lab and question banks prepared by reputed SMEs.
  •  
We also provide virtual training with the help of 24x7 online lab facility.
  •  
Our outstanding instructors discuss real-life case studies to give our participants a complete hold over the subject.
  •  
Vinsys meettrainer

Mr. Amit Andre
Know More

This course is advisable to all executives and managers who have been working on Microsoft Excel and are familiar with Access. It allows you to improve your working skills and get upgrade to Access from Microsoft Excel, which has few limitations.

We ensure you that this course will empower with the following skills;
  1. Designing Table by using different types of data.
  2. Creating relationship between tables.
  3. Importing & exporting data from another database.
  4. Creating MIS reports by using Query.
  5. Analyzing data by using filter/adv filter.
  6. Generating professional Forms
  7. Designing front end using Forms
  8. Generating professional Reports
  1. INTRODUCTION TO MICROSOFT ACCESS
    • What Is A Database/Rdbms
    • What Is Microsoft Access 2010?
    • Creating New Database Using The Database Window
    • All Types Of Objects In A Database
  2. DESIGNING TABLE STRUCTURE
    • Planning For Table Structure
    • Creating New Table
    • Saving A Table Structure
    • Modifying A Table Structure
    • Modifying A Table Design
    • Defining A Primary Key
  3. MORE ABOUT TABLES
    • Data Types
    • Defining And Setting Data Entry Rules
    • Defining Input Mask
  4. DEFINING TABLE RELATIONSHIP
    • Defining Relationship Between Tables
    • Testing Referential Integrity And Primary Keys
  5. MANAGING DATA IN A TABLE
    • Opening A Table
    • Adding Data To A Table
    • Inserting A Record
    • Editing A Record
    • About Navigation And Editing Keys
    • Selecting Records And Fields
    • Deleting Records
    • Moving Columns In A Datasheet
    • Sorting And Searching For Individual And Group Records
    • Different Types Of Filters
      • By Form
      • By Selection
      • Excluding Selection
      • Advance Filter
    • Finding And Replacing Specific Data
    • Freeze And Unfreeze Columns
    • Resizing Columns In A Datasheet
  6. INTRODUCTION TO QUERIES
    • About Query?
    • Selecting A Table For A Query
    • Specifying Fields To For Query
    • Selecting Record By Using A Single Criteria
    • Selecting Record By Using A Multiple Criteria
    • Modifying The Query
    • Querying By Using Wild Cards
    • Sorting By Two Fields
    • Querying Multiple Tables
  7. MODIFYING JOIN PROPERTY
    • Inner And Outer Joins
    • Inner Join
    • Outer Join – Left And Right
  8. SHARING AND MANAGING DATA
    • Importing Data From External Database Through Linking
    • Importing Data From External Database Without Linking
    • Working With Text Data
  9. USING ADVANCE QUERIES
    • Creating Cross-Tab Queries
    • Creating Action Queries
    • Creating A Calculated Field
    • Creating An Iif Function
    • Creating Summary Calculation
    • Creating A Parameter Query
      • Modifying An Existing Select Query To Accept Parameters
      • Using Wildcards In A Parameter Query
    • Running The Query
  10. CUSTOMISING FORMS
    • Creating A Customised Form
    • Modifying A Form
    • Selecting, Moving Objects
    • Modifying The Appearance Of A Form
  11. BUILDING A CUSTOMIZED REPORT
    • Modifying Reports
    • Creating Summary Reports

Microsoft® Access is a versatile tool that helps to organize complex relational databases. It is one of the handy tools for functional accounting and invoice systems. Plus, it is a cost-effective solution to organize your data. If you buy Microsoft Office Professional suite, it comes along with Microsoft Access. So we advise you not to keep your Access unused when you can create miracles with the help of it. Learn it and improve your managing skills.

Below are key benefits of learning MS Access;
  1. Its Versatile
  2. Its Cost-effective
  3. And its supportive

Frequently asked questions about this course.

1. What are required prerequisites of doing this course?
Participants attending this training should be familiar with the Excel operations, such as simple calculations, filter and advance filter etc.
Vinsys Logo
Close X
Don't have an account?
Sign up Now
Create your Vinsys Account
I agree to the Terms & Conditions.
Already a member
Log in
Forgot Password
To reset your password, enter your registered email address and we will send you new password.
Don't have an account?
Sign up Now

Pune
+ 91 - 20 - 67444700

Hyderabad
+91 - 40 - 65344752 / 23114305

Bangalore
+91 - 80 - 41550745

Noida
+91 - 120 - 4283251 / 52/53/54/55/56

   
Follow Us! Vinsys Facebook Vinsys Twitter Vinsys Youtube Vinsys Linkedin Vinsys Google plus
Vinsys earth Australia China India Kenya Malaysia Oman Singapore Tanzania UAE USA

About Vinsys

Vinsys, a globally acclaimed individual and corporate training provider, has a legacy of empowering professionals with knowledge since 15+ years. Till date we have enlightened and trained 600,000+ professionals around the world. Today, we have spread our wings across the globe and have footprints in Australia, China, India, Kenya, Malaysia, Oman, Singapore, Tanzania, UAE and USA. We are renowned players in conducting corporate training and open house workshops in Information Technology, IT Service Management, IT Governance, IT Infrastructure Library, Project Management, Behavioral and Management Solutions; and Foreign Languages for enterprises and governments worldwide.

Disclaimer

PMBOK®, Project Management Institute® PMI®, Certified Associate in Project Management (CAPM)®, Project Management Professional (PMP)®, Program Management Professional (PgMP)®, Portfolio Management Professional (PfMP)®, PMI Agile Certified Practitioner (PMI-ACP)®, PMI Professional in Business Analysis (PMI-PBA)®, PMI Risk Management Professional (PMI-RMP)®, PMI Scheduling Professional (PMI-SP)® are the Registered Marks of the Project Management Institute, Inc.

Copyright © 2017 Vinsys All Rights Reserved.

Terms & Conditions Privacy Policy