Microsoft Access 2013 Foundation
Private Class From
RM1100
/day
(2 Days)
COURSE OBJECTIVES

Upon completion of this program, participants should be able to:

  • Understand basic terminology
  • Create a database
  • Create a Table
  • Add and Edit Records
  • Create a Form with the Wizard
  • Understand Bound and Unbound Controls
  • Add Fields, Controls, Images and Logos
  • Create a Query with the Wizard
  • Sort and Filter Data from a Query
AUDIENCE

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who want to know and understand their knowledge and practical uses of Microsoft Access

PREREQUISITES

REQUIRED PREREQUISITES:

Basic knowledge of Windows is essential with the following pre-requisites:

  • Able to maneuver with the mouse – Point, Click, Drag and Double Click
  • Able to configure the desktop
  • Able to use the Control Panel
  • Able to move and re-size Application Windows
  • Able to switch between task applications

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise

  • Getting Started
  • Signing In
  • Creating a Database
  • Database Terminology
  • Saving a Database
  • Opening a Database


  • About Security Warnings
  • About Relationships
  • Searching for Objects
  • Opening Database Objects
  • Changing the Object View
  • Understanding the Types of Views Available
  • Managing Objects


  • Creating a Table
  • Understanding Table Views
  • Adding and Editing Records
  • Searching and Browsing Records
  • Deleting Records
  • Printing Records
  • Selecting Data
  • Changing Column and Row Width and Height
  • Applying Text Formatting
  • Applying Gridlines
  • Changing Fill Colors
  • Checking Your Spelling
  • Creating a Form from an Object
  • Creating a Form with the Wizard
  • Creating a Form from Scratch
  • Understanding Form Views
  • Using a Form


  • Understanding Bound and Unbound Controls
  • Changing the Theme
  • Using the Format Painter
  • Adding Fields
  • Adding Controls
  • Adding Images and Logos


  • Types of Queries
  • Creating a Query with the Wizard
  • Running a Query
  • Understanding Query Views
  • Sorting and Filtering a Query