Create Event
Advertisement
Access 2013 Expert Training in  Gold Coast

Access 2013 Expert Training in Gold Coast

Fri Jun 23, 2023

Access 2013 Expert Training in Gold Coast

Time Fri Jun 23 2023 at 09:00 am to 05:00 pm
(GMT+09:30)

For venue details reach us at info@mangates.com, +1 469 666 9332, Gold Coast, Australia

Find Tickets
AUD 599
Advertisement

Access 2013 Expert Training in  Gold Coast, 23 June | Event in Gold Coast | AllEvents.in Access 2013 Expert Training in Gold Coast
Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.

About this Event

Certificate: Course Completion Certificate Language: English

Duration: 1 Day

Course Delivery: Classroom/ Virtual/ On-site Credits: 8

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

Agenda:

Module One: 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 Two: Customizing Apps (II)

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

Module Three: Customizing Apps (III)

  • About User Interface Macros
  • Creating an Embedded Macro
  • Creating a Standalone macro
  • Saving Your App as a Package

Module Four: 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 Five: 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 Six: 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 Seven: Designing Forms

  • Common Formatting Tasks
  • Using Themes
  • Working with Controls
  • Adding Header and Footer Elements
  • Arranging Form Elements
  • Formatting Forms

Module Eight: Advanced Reporting Tasks

  • Using Report Sections
  • Using Conditional Formatting
  • Grouping and Sorting Data
  • Adding Calculated Controls
  • Creating Labels

Module Nine: Advanced Database Tools

  • Using the Database Documenter
  • Analyzing Table Performance
  • Analyzing Database Performance
  • Repairing a Database
  • Compacting a Database

Module Ten: Working with the Access Environment

  • Working with Database Properties
  • Encrypting a Database with a Password
  • Using Save Object As
  • Setting Access Options

Module Eleven: Wrapping Up

  • Words from the Wise
  • Review of Parking Lot

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

Note:

However, catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. Reach us at aW5mbyB8IGFjYWRlbXlmb3Jwcm9zICEgY29t for dates and details of Instructor Led Live Virtual Sessions.

If you would like to get this course customized and delivered exclusively for your group, we have an On-Site Training Option you can reach us at aW5mbyB8IGFjYWRlbXlmb3Jwcm9zICEgY29t for more details about on-site or corporate training.

Offers:

Groups of 3 people 10% Discount

Groups of 5 people 15% Discount

Groups of 10 people 20% Discount


https://cdn-az.allevents.in/events10/banners/d0905d40-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h1280-gmir.jpg
https://cdn-az.allevents.in/events9/banners/d0f11ae0-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h1280-gmir.jpg
https://cdn-az.allevents.in/events3/banners/d1394770-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h405-gmir.jpg
https://cdn-az.allevents.in/events9/banners/d17da370-f9cc-11ed-b09b-716f200eedc8-rimg-w720-h405-gmir.jpg
https://cdn-az.allevents.in/events9/banners/d1b13690-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h405-gmir.jpg
https://cdn-az.allevents.in/events5/banners/d1e258b0-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h405-gmir.jpg
https://cdn-az.allevents.in/events7/banners/d2261870-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h349-gmir.jpg
https://cdn-az.allevents.in/events3/banners/d2966670-f9cc-11ed-b09b-716f200eedc8-rimg-w720-h717-gmir.jpg
https://cdn-az.allevents.in/events9/banners/d2de1dd0-f9cc-11ed-b09b-716f200eedc8-rimg-w720-h718-gmir.jpg
https://cdn-az.allevents.in/events3/banners/d3242780-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h676-gmir.jpg
https://cdn-az.allevents.in/events9/banners/d3715d20-f9cc-11ed-b09b-716f200eedc8-rimg-w720-h720-gmir.jpg
https://cdn-az.allevents.in/events1/banners/d418c0b0-f9cc-11ed-b09b-716f200eedc8-rimg-w720-h708-gmir.jpg
https://cdn-az.allevents.in/events7/banners/d4437a30-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h349-gmir.jpg
https://cdn-az.allevents.in/events6/banners/d4936ef0-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events9/banners/d54273a0-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events3/banners/d63c3cf0-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events5/banners/d6852cd0-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events8/banners/d72898c0-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events5/banners/d7bb14c0-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events2/banners/d7f47440-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events9/banners/d8516150-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events9/banners/d8a044a0-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events4/banners/d8feb850-f9cc-11ed-b09b-716f200eedc8-rimg-w720-h960-gmir.jpg
https://cdn-az.allevents.in/events6/banners/d9710220-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events7/banners/d9d6efe0-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events10/banners/da752bb0-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h960-gmir.jpg
https://cdn-az.allevents.in/events7/banners/db100c20-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events2/banners/db4e2690-f9cc-11ed-b09b-716f200eedc8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events6/banners/dbc886b0-f9cc-11ed-b09b-716f200eedc8-rimg-w720-h405-gmir.jpg
https://cdn-az.allevents.in/events6/banners/dc128800-f9cc-11ed-b09b-716f200eedc8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events5/banners/dc8b1360-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h405-gmir.jpg
https://cdn-az.allevents.in/events6/banners/dcc78020-f9cc-11ed-b09b-716f200eedc8-rimg-w720-h405-gmir.jpg
https://cdn-az.allevents.in/events3/banners/dcf8a240-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h405-gmir.jpg
https://cdn-az.allevents.in/events10/banners/dd584e70-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h405-gmir.jpg
https://cdn-az.allevents.in/events2/banners/de3e8fc0-f9cc-11ed-b09b-716f200eedc8-rimg-w720-h540-gmir.jpg
https://cdn-az.allevents.in/events5/banners/decbb490-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h420-gmir.jpg
https://cdn-az.allevents.in/events2/banners/df7a4410-f9cc-11ed-8b2e-6b33d62d37d8-rimg-w720-h404-gmir.jpg
Youtube Video



Also check out other Workshops in Adelaide, Virtual Events in Adelaide.

Tickets

Tickets for Access 2013 Expert Training in Gold Coast can be booked here.

Get Tickets

Ticket Information Ticket Price
Super Early Bird Fee AUD 599
Early Bird Fee AUD 649
Standard Fee AUD 799
Event Photos
Hosted by
Mangates
About The Host: Mangates Tech Solutions is one of the Leading Education Industry, We Developed a more advanced, applied level of Training programs. We Designed High Quality Training programs and you can expect the same learning Experience, this made us stand out above the competition.
Website Link: https://mangates.com
Are you the host?
Nearby Hotels For venue details reach us at info@mangates.com, +1 469 666 9332, Gold Coast, Australia
Event details from Report a problem ?

Date & Time

Fri Jun 23 2023 at 09:00 am to 05:00 pm
(GMT+09:30)

Location

For venue details reach us at info@mangates.com, +1 469 666 9332, Gold Coast, Australia

Advertisement
Advertisement