HK$4,874.48 – HK$6,358.34

Access 2013 Expert 1 Day Training in Hong Kong

Actions and Detail Panel

From HK$4,874.48

Event Information

Share this event

Date and time

Location

Location

Regus - Hong Kong Regus 100 QRC

100 Queen's Road Central, 6th, 12th & 15th Floors, Central

Hong Kong, HKI 999077

Hong Kong

View Map

Refund policy

Refund policy

Refunds up to 7 days before event

Event description
Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.

About this event

Course Overview:

This workshop is designed to teach you a deeper understanding of Access 2013 in a practical way. This workshop is designed for the advanced users of Access 2013. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

This workshop is meant to provide a safe learning environment where they can practice and learn Access 2013 Expert functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose―enable users to create data-centric web applications. Taking the time to develop a deep understanding of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.

Target Audience:

Anybody who is interested in learning Access 2013 Expert Skills

Learning Objectives:

After completing this course, Individuals will be able to demonstrate their understanding of:

  • Customizing Apps
  • Working with Validation Rules and Messages
  • Working with Macros
  • Advanced Query Tasks
  • Designing Forms
  • Advanced Reporting Tasks
  • Advanced Database Tools
  • Working with the Access Environment

Prerequisites:

None

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)

eBook download and activation instructions

Course Agenda:

Module 01: Customizing Apps (I)

  • Creating a Custom App from Scratch
  • Adding a Template Table Adding a Blank Table
  • Importing Access 2010 Tables
  • Module One: Review Questions

Module 02: Customizing Apps (II)

  • About Custom Actions
  • Adding a Custom Action
  • Editing a Custom Action
  • Deleting a Custom Action
  • Module Two: Review Questions

Module 03: Customizing Apps (III)

  • About User Interface Macros
  • Creating an Embedded Macro
  • Creating a Standalone macro
  • Saving Your App as a Package
  • Module Three: Review Questions

Module 04: Working with Validation Rules and Messages

  • Creating a Field Validation Rule
  • Creating a Field Validation Message
  • Creating a Validation Rule
  • Creating a Validation Message
  • Testing Validation Rules
  • Module Four: Review Questions

Module 05: Working with Macros

  • Creating a Before Change Event
  • Working with the Macro Tools Design Tab
  • Working with the Action Catalog
  • Creating an After Event
  • Creating a Named Macro
  • Renaming or Deleting Macros
  • Module Five: Review Questions

Module 06: Advanced Query Tasks

  • Using Query Design View
  • Creating Ad Hoc Relationships
  • Creating an Update Query
  • Creating a Parameter Query
  • Comparing Two Tables by Using a Join
  • Module Six: Review Questions

Module 07: Designing Forms

  • Common Formatting Tasks
  • Using Themes
  • Working with Controls
  • Adding Header and Footer Elements
  • Arranging Form Elements
  • Formatting Forms
  • Module Seven: Review Questions

Module 08: Advanced Reporting Tasks

  • Using Report Sections
  • Using Conditional Formatting
  • Grouping and Sorting Data
  • Adding Calculated Controls
  • Creating Labels
  • Module Eight: Review questions

Module 09: Advanced Database Tools

  • Using the Database Documenter
  • Analyzing Table Performance
  • Analyzing Database Performance
  • Repairing a Database
  • Compacting a Database
  • Module Nine: Review Questions

Module 10: Working with the Access Environment

  • Working with Database Properties
  • Encrypting a Database with a Password
  • Using Save Object As
  • Setting Access Options
  • Module Ten: Review Questions

Module 11: Wrapping Up

  • Words from the Wise
  • Review of Parking Lot
Share with friends

Date and time

Location

Regus - Hong Kong Regus 100 QRC

100 Queen's Road Central, 6th, 12th & 15th Floors, Central

Hong Kong, HKI 999077

Hong Kong

View Map

Refund policy

Refunds up to 7 days before event

{ _('Organizer Image')}

Organizer Mangates

Organizer of Access 2013 Expert 1 Day Training in Hong Kong

Click here to subscribe to our text messages.

Who we are

Mangates is one of the Leading Competency developers, Mangates has developed a proven foundation for building specialized training programs. No matter which Mangates training division you are working with, you can expect the same high-quality training experience and expertise that makes Mangates stand out above the competition.

All of our instructors are recognized experts in their fields with hands-on experience on the topics they teach. We combine proven adult educational training methods with leading-edge industry expertise to provide you an exceptional training experience. Every instructor must meet rigorous standards with the proven background in their given field of expertise. It is the difference that our customers covet and participant appreciates at the completion of the course.

What we do

We deliver training solutions to Corporate, Government Agencies, Public sectors, Multinational organizations and Private Individuals. Our Primary focus is to train in a wide range of areas from IT Technical, Personal Development, Human Resources and Management Courses to Project, Program and IT Service Management.

We have most experienced trainers in the Industry. Our Trainers are highly skilled in their subject areas and are uniquely positioned to provide participants with deep industry experience. They are motivated to transfer knowledge through practical support post and pre-training to provide participants with additional support outside the classroom.

 

 

https://www.youtube.com/watch?v=ca-9iJ4zw0Q

 

Save This Event

Event Saved