Microsoft Access – Forms and Reports

"Unlock the Power of Microsoft Access: Master Forms and Reports for Seamless Data Visualization!"

Join Online training on

Date: 12 / 08 / 2023

Day: Saturday

Duration

1 Days

Time

8am-6pm

rest on 1pm-2pm

Fee

RM 159

• PRE-REQUISITES

Familiarity with the fundamental concepts of Microsoft Access is essential.

• VENUE / PLATFORM

• APPLY NOW

About this programme

Build on your experience of basic databases, simple forms, queries and reports with more advanced Microsoft Access skills.

Explore database administration, advanced form design, packaging, encryption, security and preparation for multiple users. Develop the ability to design forms and more complex reporting solutions for a project.

It is a valuable set of skills and knowledge to be a professional who can create and designed a database for your organisation. 

Learning goals

At the end of the course, you will be able to

• Create control properties to validate and promote quality data entry into a database
• Organize a database for efficiency and performance, and to maintain data integrity by enforcing Table Referential Integrity
• Create advanced queries such as multiple table query, work with Expression & Expression tables, summarizing group of records and use of IIF functions

• Use advanced formatting and controls to improve form presentation. Learn to use subforms
• Use advanced formatting and calculated fields to improve reports.

Course Outline & Module

Access Forms

• Building Data Entry Forms

• Working with Form Data

• Form Controls

• Formatting Options

• Building a Database Switchboard

• Interacting with Queries Through Forms

Access Forms

• Building An Access Report

• Creating Calculated Controls

• Advanced Report Group Options

Who Should Attend Microsoft Access Forms and Reports?

Develop practical skills in Microsoft Access for building efficient data-entry forms and clear, informative reports.

Application Developers

Database Developers

Business Professionals

IT Managers and Team Leaders

Training Packages

Certificate of Completion Provided

Participants will receive a Certificate of Completion on the last day of training.

Personalised Mentorship

Get a knowledgeable mentor who guides your learning and is focused on answering your questions, motivating you and keeping you on track.

Follow Up Training

Participants are entitled to one free follow-up training session, scheduled later to reinforce their learning.