MS Access 2016 Online Training
Created by Akshay Magre, Last Updated 05-Sep-2019, Language:English
MS Access 2016 Online Training
Simply Easy Learning
Created by Akshay Magre, Last Updated 05-Sep-2019, Language:English
Description
A relational database application such as Microsoft Access 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. It can be use it as a personal data management tool, or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Audience
This course is designed for students who wish to learn the basic operations of the Microsoft Access who want to become productive in the shortest possible time. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications. It is aimed at users who already have basic knowledge of spreadsheets and who handles data management for smooth business operations.
Course Content
-
MS Access 2016 Basics
4 Lectures 00:24:44-
MS Access 2016 - Course Overview
00:04:23 -
MS Access 2016 - Orientation
Preview00:05:37 -
MS Access 2016 - Create a Simple Database
Preview00:12:16 -
MS Access 2016 - Get Help
Preview00:02:28
-
-
Working With Table Data
4 Lectures 00:31:10-
MS Access 2016 - Create a Table
00:11:52 -
MS Access 2016 - Modify Table Data
00:07:01 -
MS Access 2016 - Sort and Filter Records
00:07:29 -
MS Access 2016 - Create Lookups
00:04:48
-
-
Designing Forms
3 Lectures 00:23:00-
MS Access 2016 - Create a Form
00:06:43 -
MS Access 2016 - Modify The Design of Form
00:09:18 -
MS Access 2016 - View and Edit Data In Form
00:06:59
-
-
Querying a Database
3 Lectures 00:18:22-
MS Access 2016 - Join Data From Different Tables In Query
00:06:34 -
MS Access 2016 - Sort and Filter Data In Query
00:07:31 -
MS Access 2016 - Perform Calculations In Query
00:04:17
-
-
Generating Reports
4 Lectures 00:22:54-
MS Access 2016 - Create a Report
00:05:31 -
MS Access 2016 - Add Controls To Report
00:04:49 -
MS Access 2016 - Enhance Appearance of Report
00:07:21 -
MS Access 2016 - Prepare Report For Print
00:05:13
-
-
Designing Relational Database
2 Lectures 00:20:41-
MS Access 2016 - Relational Database Design
00:12:19 -
MS Access 2016 - Create Table Relationships
00:08:22
-
-
Creating Advanced Queries
4 Lectures 00:19:37-
MS Access 2016 - Create Parameter Queries
00:04:01 -
MS Access 2016 - Create Action Queries
00:05:00 -
MS Access 2016 - Create Unmatched and Duplicate Queries
00:06:47 -
MS Access 2016 - Summarize Data
00:03:49
-
-
Sharing Data Across Applications
4 Lectures 00:18:59-
MS Access 2016 - Import Data Into Access
00:04:52 -
MS Access 2016 - Export Data to Text File Formats
00:04:17 -
MS Access 2016 - Export Access Data to Excel
00:02:44 -
MS Access 2016 - Create Mail Merge
00:07:06
-
-
MS Access Advanced
3 Lectures 00:19:35-
MS Access 2016 - Data Normalization
Preview00:07:35 -
MS Access 2016 - Create Junction Table
00:05:18 -
MS Access 2016 - Improve Table Structure
00:06:42
-
-
Joining Tables
5 Lectures 00:26:33-
MS Access 2016 - Create Query Joins
00:04:41 -
MS Access 2016 - Join Tables That Have No Common Fields
00:07:07 -
MS Access 2016 - Relate Data Within Table
00:06:13 -
MS Access 2016 - Work With Subdatasheets
00:05:11 -
MS Access 2016 - Create Subqueries
00:03:21
-
-
Advanced Reporting
5 Lectures 00:25:30-
MS Access 2016 - Organize Report Information
00:04:49 -
MS Access 2016 - Format Reports
00:06:17 -
MS Access 2016 - Include Control Formatting In Report
00:06:58 -
MS Access 2016 - Add Calculated Field To Report
00:03:09 -
MS Access 2016 - Add Subreport To Existing Report
00:04:17
-
-
Implementing Advanced Form Design
5 Lectures 00:27:45-
MS Access 2016 - Add Controls to Forms
00:05:53 -
MS Access 2016 - Create Subforms
00:04:19 -
MS Access 2016 - Organize Information With Tab Pages
00:05:03 -
MS Access 2016 - Enhance Navigation Of Forms
00:06:19 -
MS Access 2016 - Apply Conditional Formatting
00:06:11
-
-
Using Data Validation
2 Lectures 00:16:50-
MS Access 2016 - Field and Record Validation
00:08:27 -
MS Access 2016 - Form Validation
00:08:23
-
-
Test Course
2 Lectures 00:08:51-
MS Access 2016 - Create a Macro
00:04:03 -
MS Access 2016 - Create an Event-Driven Data Macro
00:04:48
-
-
Managing Switchboards
3 Lectures 00:16:50-
MS Access 2016 - Create a Database Switchboard
00:09:28 -
MS Access 2016 - Modify Database Switchboard
00:05:08 -
MS Access 2016 - Set Startup Options
00:02:14
-

Akshay Magre
MS Office Expert
Akshay Magre is a professional trainer for Microsoft Office Suite with a robust experience of 5 years in Project & Database Management. His expertise lies in MS Access, MS Project, MS Excel, MS Visio, VBA, Dashboard, PowerPoint, Word, Power BI Lync, Skype for Business, FastStone, etc. Akshay has completed his Bachelor Degree in Engineering from Pune University and Diploma in Banking & Finance from NIIT. He is a visiting faculty for Advance Excel 2013 at a B-School in Pune and Mumbai.