Microsoft Access 2016 Foundation | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Microsoft Access 2016 Foundation

Location

Format What’s this?
Starting From
RM 99.00
  1. 1 Days
  1. HRDF SBL Claimable
  2. Lunch & refreshment provided
  3. Certificate of Attendance available

All of our private classes are customized to your organization's needs.


Click on the button below to send us your details and you will be contacted shortly.

  1. 1 Days

Microsoft Access 2016 Foundation

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

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

COURSE OBJECTIVES

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

• Create simple Access database

• Creating Table

• Creating Forms

• Creating Reports


Expand All

Modules

Module 1: Getting Started with Access

Topic A: Orientation to Microsoft Access

• Access Files
• Opening Database
• The Access 2016 Application Window
• Tables
• Forms and View
• Queries
• Reports
• The Ribbon Interface

Module 2: Create a Table

Topic A: Create a Table

• Table Creation Option

• Importing Tables form other Databases

• Creating Tables with Templates

• Table Views

• Data Types

• Inserting Fields

• Quick Start Fields

• Deleting Fields

• Calendar for Picking Dates

• The Lookup Wizard

• The Table Properties Dialog Box


Topic B: Modify a Table and Fields

• Renaming a Table

• Changing Fields Captions

• Changing Field Sizes

• Configuring Fields to Auto Increment

• Setting the Default Value for a field


Module 3: Creating Form

Topic A: Create a Simple Access Database

• Methods to Create a Form

• Form Object Views

• Form Sections

• Modifying Existing Forms

• Saving Forms

• Deleting Forms


Module 4: Creating Report

Topic A: Create a Report

• Report Creation Tools

• Report Wizard

• Saving a Report

• Modifying an Existing Report

• Deleting a Report


Jarina Muhamad Ismail

Jarina Muhamad Ismail

Since 2005, Jarina is involved in delivering learning programmes for Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-2013), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.
Read More

Sylvia Sharon Anthony

Sylvia Sharon Anthony

She began her career as a Corporate Trainer and her personal areas of expertise are wide; encompassing Database and Graphic applications. In addition to that; she also specializes in corporate coaching for government, multi-national companies to local SMEs.

Sylvia has acquired immense knowledge and skill in the training field. Since becoming a trainer, her work has involved design, delivery and developing training programmers. In her 16 years of experience in the training arena she has delivered and customized training programmers specifically to tailor for organization's unique training needs and to maximize the participant's learning outcomes.

As a trainer, Sylvia constantly strives to improve herself and learn new methods and skills. She is passionate about building new programs that meet the upcoming challenges of the IT industry. She is currently developing a customized Excel programme which will emphasize on the advanced features of Microsoft Excel i.e. Mastering Charts, Functions and Pivot Tables.

Read More

Course Reviews

No Remarks

0

0 Ratings