Advanced Microsoft Access 2016 Course - Online Course

by Jagranjosh

Advanced Microsoft Access 2016 Course - Online Course

Join the Advance Access 2016 course from edu CBA and learn advance functions in Access and learn to store and modify data more effectively. You will learn how to build relational databases, customize ...View more

Specification

  • Language: English
  • Category: Office Productivity
  • Product Type: Online Course
Product Description

Join the Advance Access 2016 course from edu CBA and learn advance functions in Access and learn to store and modify data more effectively. You will learn how to build relational databases, customize data according to the requirements of analysis, various specialty or action queries, ways to minimize data entry errors by building buttons in forms, applications of access, automating data using macros.

 

The tutorials will help you learn about;

How to create a table using application parts and some of the field properties on the table tools ribbon

Use specialty query such as the Make table query, Update query, Delete query, Crosstab query, Union Query and Statistical Query

Designing forms wherein we will learn about various form controls, Input Boxes, Record Navigation, Adding Buttons, Setting the tab order, Multiple forms and Split forms

In reports we would see how to Report structure in design view, adding group, adding fields from other tables, adding totals and sub totals, Conditional formatting and data bars and Create mailing labels

We also see how to work with macros wherein we understand Creating a Macro, attaching macros to objects and Using data macros

Finally, we look at the other application in access wherein we would learn about Publishing in HTML or XML, sharing via email, using data analysis tools, Encrypting the database and Splitting the database.

 

Advanced Microsoft Access 2016 Course Objectives:

Over 30 lectures and 3 hours of content!

Learn create tables using application parts, working with specialty queries, designing forms, creating and designing reports, working with macros, other applications in access

Discover how advanced databases work

Master Microsoft Access 2016

Discover how to effectively link to other data sources.

 

Target Audience for Advanced Microsoft Access 2016 Course

Students, MBA’s, BBA’s, Gradates & Post- graduates.

Working Professionals from any business domain.

Entrepreneurs, Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker

Anyone interested in more powerful features and functions of Microsoft Access 2016

 

What are the Pre-Requisites of Advanced Microsoft Access 2016 Course?

Passion to learn and apply Microsoft Access

A computer with internet to view training material

Basic knowledge of using Microsoft access

You May Also Be Interested In
  • Rs. 999
  • Rs. 299
  • (70% Off)

Promo Code SAVE25

Use promocode SAVE25 to get upto 25% discount on offer price Minimum Order value - Rs 50/-. Offer is valid for all Jagran Josh products.

Best Sellers

Advanced Microsoft Access 2016 Course - Online Course
Advanced Microsoft Access 2016 Course - Online Course

Join the Advance Access 2016 course from edu CBA and learn advance functions in Access and learn to store and modify data more effectively. You will learn how to build relational databases, customi

Promo Code SAVE25

Use promocode SAVE25 to get upto 25% discount on offer price Minimum Order value - Rs 50/-. Offer is valid for all Jagran Josh products.

Specification
  • Language: English
  • Category: Office Productivity
  • Product Type: Online Course
Product Description

Join the Advance Access 2016 course from edu CBA and learn advance functions in Access and learn to store and modify data more effectively. You will learn how to build relational databases, customize data according to the requirements of analysis, various specialty or action queries, ways to minimiz ... Read More