Description

Overview

Course Details

  • 12:54:00 Hours
  • 12 Months Access
  • Presented by highly qualified, industry leading experts

About this Course

Microsoft Access is a relational database software that allows small teams and individuals to easily organize and report on business data. Microsoft Access is a file-based desktop application that enables organizations to manage and leverage data. The relational database also includes tools that allow you to quickly build database-bound forms and reports.

Whether you’re new to Access or an advanced user, Microsoft Access training from iCollege can accelerate your database management skills. Learn the basics, such as how to create a database, navigate the Access application environment or organize data stored within Access tables Or graduate to more advanced skills like form customization, querying and sharing data across applications.

Objectives

  • Create, design and encrypt Access databases
  • Build and work with Access tables, relationships, keys and constraints
  • Query data
  • Manage and design interfaces with Access Forms
  • Produce basic to advanced reports, Automate tasks, procedures, and functions with Macros and VBA
  • Customize Access configuration options
  • Access 2016 has all the functionality and features you’re used to with some added enhancements and the best new features from Office 2016.

Audience

  • This course is for anyone who wants to develop or improve their skills in MS Access.
  • This course is for anyone who wants to become proficient in MS Access.
  • This course is for anyone who has little knowledge or just wants a review because of the 3 levels included, Basic, Intermediate and Advanced.

Prerequisites

  • Navigate through Windows files and folders
  • Work with Windows – minimise, maximise, open and close

Course Outline

Top of Form

Introduction

  • Overview
  • Introduction To Access
  • What Is A Database
  • Database Terminology
  • Database Terminology Part 2
  • Getting Started In Access
  • Access Interface And Navigation
  • Planning And Database Design
  • Planning And Database Design Part 2

CREATING ACCESS TABLES

  • Creating Tables: Manual Data Entry
  • Creating Tables: Importing External Data
  • Creating Tables: Importing External Data Part 2
  • Creating Table Relationships
  • Creating Table Relationships Part 2

CREATING QUERIES FOR TESTING DESIGN

  • Creating Queries For Testing Desgin
  • Creating Queries For Testing Design Part 2
  • Creating Queries For Testing Design Part 3
  • Creating Queries For Testing Design Part 4
  • Creating Queries For Testing Design Part 5

CREATING BASIC FORMS

  • Creating Basic Forms
  • Creating Basic Forms Part 2
  • Creating Basic Forms Part 3
  • Creating Basic Forms Part 4

REPORTING DATA

  • Creating Basic Reports
  • Creating Basic Reports Part 2
  • Creating Basic Reports Part 3
  • Creating Basic Reports Part 4
  • Creating Basic Reports Part 5