Microsoft Access 2013 Foundation

Quorse - Your Training Wholesaler

  • Enjoy discounts up to 60% off!
  • Chat with us Live to get a Quotation to see it for yourself!
  • All courses are HDRF Claimable

Private Class from

1350/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

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


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


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


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


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


Trainers