Skip to content
Offers IT In-house Corporate Training, Power BI Virtual Training
facebook
TRAINSPIRE IT Training
Call Support (02) 8294-3699; +639171453126
Email Support info@trainspireit.com; transpireinfo@gmail.com
Location 2nd Floor 489 Shaw Boulevard Mandaluyong City
  • Home
  • About Us
  • Course Outline
    • Data Analytics
      • Data Analytics Using Excel
    • Microsoft
      • MS Advanced Excel 2016
      • MS PROJECT 2016
      • MS Excel VBA
      • MS ACCESS 2016 -BASIC
      • MS POWER BI
    • Business Intelligence
      • MS POWER BI TRAINING
    • Web Development
      • Fundamentals Of HTML5 & CSS3
      • JavaScript
      • Building webpage with PHP and MySQL I
      • PHP and MySQL II
  • List of Training
    • Microsoft Technology Training
    • Programming and DBMS
    • Graphics Design
    • Web Development
    • Networks And Server Administration
  • Public Schedule
  • Gallery
  • Contact Us

Microsoft Access 2016 -Basic

Home > Courses > Microsoft Access 2016 -Basic

Microsoft Access 2016 -Basic

Posted on February 18, 2019February 18, 2019 by admin
0

Course Details

This course discusses the new Access interface and explores various database components, including tables, queries, forms, and reports. You will learn to create and modify new databases and their various objects. You will learn how to improve queries, forms, and reports.

Prerequisites

Basic Microsoft Office Excel

Target Audience

This course is intended for information workers who want to learn beginning-level Access skills 

Course Outline

Lesson 1: Getting Started with Microsoft Access

  • What is a database?
  • What is Microsoft Access?
  • Planning the database
  • Launching Microsoft Access

Lesson 2: The Access Workspace

  • The Access Application Window   
  • The Database Window
  • The Access Database Objects

Lesson 3: Managing Files

  • Creating a New File
  • Opening an Existing File
  • Renaming a Database
  • Closing a Database and Quitting MS Access

Lesson 4: Working with Tables

  • Terms used in Tables
  • Understanding Table Properties
  • Guidelines for Naming Fields
  • Ways to Create Tables
  • Working with Datasheet
  • Working with data in a table
  • Sorting and Filtering

Lesson 5: Introduction to Queries

  • Types of Queries
  • Creating Simple Queries
  • Creating a query in Design View
  • Finding Duplicates Query

Lesson 6: Introduction to Forms

  • Ways to Create Simple Forms
  • Creating forms

Lesson 7: Introduction To Reports

  • Ways to Create a Report
  • Creating Reports
  • Printing Reports

Please follow & like us :)

Facebook
Facebook
YouTube
YouTube
LinkedIn

Please follow & like us :)

Facebook
Facebook
YouTube
YouTube
LinkedIn

Trainspire IT Training Services

We provide IT corporate  training to businesses of both small to large from programmers to developers .  We also extend our services to individual professionals and enthusiasts who want to develop themselves with technology skill sets of their choice.

Contact Information
2nd Floor 489 Shaw Boulevard Mandaluyong City
0917-145-3126
trainspireinfo@gmail.com

Popular IT Training

  • Microsoft Advanced Excel 2016
  • Fundamentals Of HTML5 & CSS3
  • MS Excel VBA
  • Microsoft Power BI
  • Data Analytics Using Excel
  • Microsoft Project 2016
| WordPress Theme: Enlighten by Accesspress Themes