MICROSOFT ACCESS – FOUNDATION

MICROSOFT ACCESS – FOUNDATION

Summary

Location

Location

Malaysia

Duration

Duration

1 Day
Format

Format

Public Class

Public Class

Unveiling the Power of Microsoft Access

Are you ready to unlock the incredible potential of Microsoft Access? Dive into our one-day foundation course designed to empower individuals from all levels of expertise. Whether you’re a clerk, manager, or tech enthusiast, this course is tailored to broaden your understanding and practical application of Microsoft Access.

Get Started with Ease

In this engaging program, we begin with the basics. Learn what Microsoft Access is and explore its interface. Discover the art of maneuvering through menus, task panes, toolbars, and more. We’ll guide you through setting up your database, understanding records, and creating tables efficiently.

Master the Essentials

Delve deeper into the database world by creating queries with ease. You’ll become proficient in sorting and filtering data, making your information management seamless. And when it’s time to print, we’ve got you covered, teaching you the nuances of printing database objects like a pro.

Join us for a day of interactive learning, where interactive lectures, PowerPoint presentations, discussions, and practical exercises converge to transform you into a Microsoft Access maestro. Don’t miss this opportunity to elevate your skills and boost your productivity with Microsoft Access.

Course Details

Course: ACF-1; Duration: 1 Day; Instructor-led

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

  • 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, discussion and practical exercise.

Course Objectives

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

  • Understand basic terminology
  • Creating a database from a template
  • Creating a Table
  • Creating a Query with the Wizard
  • Sorting and Filtering Data

Outlines

Lesson 1.1: Starting Out      

  • What is Microsoft Access?
  • What’s New in Access 2003?
  • Basic Terminology
  • Opening Microsoft Access
  • Interface Overview
  • Closing Microsoft Access

Lesson 1.2: Using the Access Interface     

  • Using the Access Menus
  • Using Access Task Panes
  • Using Toolbars
  • Adding, Removing and Moving Toolbars
  • Using the Switchboard
  • Using the Database Window

Lesson 2.1: First Steps46

  • Planning a Database
  • Creating a Blank Database
  • Using Database Objects

Lesson 2.2: Records  

  • What is a Record?
  • Adding Records
  • Editing Records
  • Deleting Records
  • Printing Records

Lesson 2.3: Creating A Table           

  • About Tables
  • Creating a Table in Design View
  • Creating a Table using the Wizard
  • Entering Data into a Table
  • Formatting a Table

Lesson 3.1: Creating Queries          

  • What is a Query?
  • Creating a Query with the Wizard
  • Using Design View to Modify a Query
  • Using Queries

Lesson 3.2: Sorting and Filtering Data

  • Using Find and Replace
  • Sort Ascending or Descending
  • Using Filter by Form
  • Using Filter by Selection
  • Creating a Filter

Lesson 4.1: Printing A Database Object     

  • Using the Print Icon
  • Using Print Preview
  • Using Page Setup

Trainers

Reviews

Interested In

MICROSOFT ACCESS – FOUNDATION

Starting From
RM480
Intake Date
21 MAR 2024
,
24 JUNE 2024
,
23 SEPT 2024
,
16 DEC 2024
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: MICROSOFT ACCESS - FOUNDATION
Duration: 1 Day
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *