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

Microsoft Access 2016 Intermediate

Location

Format What’s this?
Starting From
RM 400.00
  1. 1 Days
  1. HRDF SBL Claimable
  2. Lunch & refreshment provided
  3. Certificate of Attendance available
  1. 1 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.

Microsoft Access 2016 Intermediate

AUDIENCE

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

PREREQUISITES

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

• Have attended Microsoft Access – Foundation Level; OR

• Able to switch between task applications

• Understand basic Access terminology

• Able to create a database

• Able to create a Table

• Add and Edit Records


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 table relationships

• Querying a Database

• Generating Reports


Expand All

Modules

Module 1: Designing a Relational Database

Topic A: Relational Database Design

• Relational Database
• The Relational Database Design Process
• The Statement of Purpose
• Exiting Data
• Guidelines for Determining Fields
• Business Rules
• Guidelines for Grouping Fields into Tables
• Primary Keys
• Table Relationships

Topic B: Create Table Relationship
• The Relationships window
• Referential Integrity
• Guidelines for Enforcing Referential Integrity
• The Edit Relationship Dialog Box
• Join Lines
• Relationship Report

Module 2: Querying a Database

Topic A: Join Data from Different Tables in a Query

• Query Views

• The Simple Query Wizard

• Types of Queries

• The Run Command

• Query Design

• Saving and Deleting

• Renaming Queries


Topic B: Sort and Filter Data in a Query

• Query Criteria

• Comparison Operators

• Logical Operators

• Sorting Query Results

• Grouping Query Results

• Formatting Query Fields

• The Zoom Dialog Box



Topic C: Performing Calculation in a Query

• Arithmetic Operators

• Adding Calculated Fields

• Adding Conditional Logic


Module 3: Generating Reports

Topic A: Add Controls to a Report

• Report Sections

• Adding Controls

• Modifying Control Properties

• Managing Labels

• Inserting Images


Topic B: Enhance the Appearance of a Report

• Galleries

• Themes


Topic C: Prepare a Report for Print

• Adding a Header or Footer

• Inserting Page Number

• Page Setup Options

• The Print Preview Tab


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

Kua Su-Ann

Kua Su-Ann

Su-Ann has been in the IT training industry for the 20 years and has trained thousands of people on the use of Microsoft Office. As Microsoft Office application is her area of specialization, she is an expert in all versions of the software and is capable of teaching at the basic, intermediate and advanced level. She has provided training to a variety of people: bankers, IT Personnel, young and old office workers, managers, senior managers, directors and corporate C-level executives. Su-Ann is the trainer of choice for many of our Blue Chip clients. Besides training, she has also been deeply involved in courseware development. In addition to developing generic courseware on Microsoft Office Applications, she has developed customized courseware to meet the unique requirements of the clients.


Read More

Course Reviews

No Remarks

0

0 Ratings