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
  
  Preview
  
  00:05:37
- MS Access 2016 - Create a Simple Database
  
  Preview
  
  00:12:16
- MS Access 2016 - Get Help
  
  Preview
  
  00: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
  
  Preview
  
  00: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.