Microsoft Access 2016 From Beginner to Advanced

A practical Microsoft Access 2016 tutorial that allows you to learn at your own pace using hands-on lessons.

What you'll learn

Sorting information and running queries
How to use queries
CREATE Database Tables with SQL
Learn Queries, use validations, how to create and print reports
Navigating the Access 2016 interface
Creating tables and relationships
Design forms and generate reports
Get helpful techniques that allow you to link, report, and package your data quickly.

Introduction

This course is dedicated to resolving the complexity question by demonstrating the basics of HOW Access is constructed and why the structure makes sense. You will see demonstrations of many tasks that are easy to do with Access, but difficult or impossible to do with Excel. This is not to say that Excel is not an excellent program. It is a wonderful program and we use it every day, but it is not a database.

Requirements

  • Basic Computer Knowledge
  • No previous knowledge of MS Access is required, given that we will cover the basics
  • Personal Laptop or Flashdrive if you don't have Laptop
  • Desire to learn
  • About This Course

    This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills. Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately. It will provide you with a lot of information on the parts of Access and how they work, the overall objective is to provide you with enough information to decide if Access is right for you and how you might use it.

    Course Outline

  • Getting Started with Access
  • Working with Table Data
  • Querying a Database
  • Using Forms
  • Generating Reports
  • Designing a Relational Database
  • Sharing Data Across Applications
  • Many More
  • Job Outlook

  • Career prospects for people with similar training include Project Managers, Front Desk Officer, Secretary, Team or Project Group, Accountant, Sales and Marketing Team, Managers, CEO, Business Men and Women, IT Officer, Application Developer, Software developer, Software tester or any quality assurance roles.
  • The median salary for entry level for Access jobs in Cameroon is 100,000 FCFA per Month.
  • Course Benefits

  • Lab Project
  • Take Home Exercises
  • Lunch
  • Internship Opportunity
  • Certificate of Completion
  • Who is the target audience?

  • People who are not sure they can create database at a top-quality level
  • Anyone new to the database management role
  • Those who manage task dependencies.
  • Project, Program and Portfolio Managers
  • Graduate Trainee
  • Primary, Secondary School students

  • Apply Now
    TOP