IT 003 – Microsoft Access Training, 27 & 28 February, 2019

IT 003 – Microsoft Access Training, 27 & 28 February, 2019

Category:
IT/ HOT/ Public Programs/ February 2019/
RM 1,490.00 RM 1,390.00
6 Reviews
download

RM 1,490.00 RM 1,390.00

INTRODUCTION

Microsoft Access provides a wealth of powerful tools to assist you in building, organizing and sharing databases so that your targeted users can work smarter, faster and more accurately. Access gives you the capability to quickly analyze details, uncover critical relationship, and share the information throughout your organization via customized forms and reports. Just two-day of high-impact training takes you well beyond the basics and into the advanced capabilities of this essential business tool.

Objective

  • Understand the relational database concept.
  • Advanced data manipulation and filtering using queries.
  • Design forms with multiple Sub-form.
  • Design reports with multiple Sub-report.
  • Use macro to control the data and system flows.
  • Design quality database for end users.

Methodology

  • Hands-on
  • Exercise
  • Case Study
  • Test
  • Brain-Storming Session

CURRICULUM

This content is restricted to members only. Please log in to view more details

Day One

  • Creating multiple tables.
  • Refining tables with hyperlink controls, indexes and properties.
  • Data Validation.
  • Understanding the default value used.

  • Creating relationships.
  • One-to-one relationships.
  • One-to-Many relationships.
  • Referential Integrity.
  • Advanced link and table joins.

  • Queries in multiple tables.
  • Using formulas in a query.
  • Using funcitions in a query.
  • Grouping records.
  • Append Query.
  • Delete Query.
  • Update Query.

  • Creating main form.
  • Creating Sub-form.
  • Creating multiple Sub-form.
  • Using Tab Control.
  • Using Page Control.
  • Form properties.
  • Datasheet View Form.
  • Using formulas and functions in a form.

Day Two

  • Using queries in a report
  • Creating main report
  • Creating Sub-report
  • Creating multiple Sub-Report
  • Page Number Control
  • Using Running Number
  • Customizing report title by end users
  • Reprot Grouping
  • Report Sorting

  • Defining macro as an individual
  • Defining macro as a group
  • Activating macro
  • Adding actions to macros
  • Addidng arguments to macros
  • Attaching a macro to controls or forms
  • Setting conditional expressions to a macro

  • Creating main menu
  • Hiding design tools from end users
  • Splitting databases

Reviews

Average Rating

0
RM 1,490.00 RM 1,390.00
0 Ratings

Detailed Rating

Stars 5
0
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0

  • Keep up the good work. Excellent approach on the module segregation to make easier for the students to retrace their steps – Faten Che Ros (QSR BRANDS)

  • Good style of teaching, good examples – Alias Ismail (CCM)

  • Thank you for the good effort in deliver the knowledge and technique – Amira (MARDI)

  • Good and knowledgeable trainer – Jamilah Hani (QSR BRAND)

  • Penceramah beri arahan & maklumat yang lengkap – Sharuddin (BERNAS)

  • Good training & trainer – Sharifah Syazwani (NAFAS)

Add a review