Tutorialspoint
Subscription Includes
 05:21:21 of High Quality Videos
 53  Lectures
 Full Lifetime Access
 Certificate on Completion
$ 178   9.99

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.